Richard Dockery wrote:
I am interested in Postgres training but there doesn't appear to be
much of it out there for resources. Can anyone point me in a good
direction?
Googling for postgresql+training should give you enough choices.
Alternatively, go to
Hi,
What an earth I am doing wrong? I am trying to delete about 6500 rows and
I am the only user connected to the database and it just sits there and
does nothing?
rahaks=# select count(*) from tilikartta where yritys=18231413;
count
---
6347
(1 row)
rahaks=# explain delete from
Hi,
What an earth I am doing wrong? I am trying to delete about 6500 rows and
I am the only user connected to the database and it just sits there and
does nothing?
Jun 9 10:02:44 pihsi postgres[31547]: [25] LOG: query: begin;
Jun 9 10:02:44 pihsi postgres[31547]: [26] LOG: duration: 0.000181
On Mandrake, I launched the script creer-base under the user postgres, I had an error
message :
you need to use createlang to load the language into the database.
When I've run the command under the user postgres :
createlang -d auth pltcl
I had an error message :
createlang: could not
Hello, List,
I recently stumbled across a problem that I can't really get across.
We have a database cluster (PG 7.4.2) that was initialized as follows:
$ pg_controldata /data/dir
pg_control version number:72
Catalog version number: 200310211
Database
On Wed, 2004-06-09 at 02:16, Mauri Sahlberg wrote:
Hi,
What an earth I am doing wrong? I am trying to delete about 6500 rows and
I am the only user connected to the database and it just sits there and
does nothing?
Jun 9 10:02:44 pihsi postgres[31547]: [25] LOG: query: begin;
Jun 9
Scott Marlowe [EMAIL PROTECTED] writes:
On Wed, 2004-06-09 at 02:16, Mauri Sahlberg wrote:
It just took about three quarters of a hour to delete 6500 rows!
Do you have any foreign key references that are of mismatched types
involved?
Specifically, what other tables reference this one? Are
We have a database that we manage through Webmin and today, the entires for
the databases dissappeared from webmin. Going in through psql we could see
our data in tables still intact, and have a copy of the directory structure.
Is thier anyway to extract data and reconstruct a new database? We
Title: PostgreSQL 7.4.2 on SunOS 4.1.4
Hi,
Back in December 2002, Warren Spencer asked this question:
I'm attempting to install PostgreSQL on a SunOS 4.1.4 box. So far,
I've tried various combinations of gcc 2.95.1,.2,.3, PostgreSQL 7.1.3,
7.0.3, 7.3. In some cases, gcc won't build.
Jie Liang wrote:
Does 7.3* support this? Can you tell me a bit more about it, please?
Hash aggregate..?
I had a similar problem after upgrade to 7.4.2,
Try:
SET enable_hashagg = false;
Before you execute that SELECT stmt
If you don't want disable it in postgresql.conf
Jie Liang
On Wed, 9 Jun 2004, Mauri Sahlberg wrote:
rahaks=# begin foo
rahaks-# ;
ERROR: parser: parse error at or near foo at character 7
rahaks=# begin;
BEGIN
rahaks=# set constraints all deferred;
SET CONSTRAINTS
In addition to the other messages, the above only defers deferrable
constraints.
Curtis Klumas [EMAIL PROTECTED] writes:
We have a database that we manage through Webmin and today, the entires for
the databases dissappeared from webmin. Going in through psql we could see
our data in tables still intact, and have a copy of the directory structure.
Is thier anyway to extract
Hi!
I have very important question about performance of PostgreSQL Database. How
it will work with:
- about 300 insert operation per day,
- about 100 selects per day,
- about 100 still connected users?
What hardware platform shall I use for such big database (RAM, No. of CPUs,
Hard discs
Can you post your errors?
Andrew
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Curtis Klumas
Sent: Tuesday, June 08, 2004 8:09 PM
To: [EMAIL PROTECTED]
Cc: Jonathan Yee
Subject: Re: [ADMIN] Corrupted or deleted pg_tables
We have a database that we
Hi,
pg_dump can be used to dump an entire database, or just a single
table. Is there a way to make a consistent dump of more than one
table, but less than all of the tables in the database? Doing a bunch
of single-table pg_dumps isn't really an option, because some tables
may change during the
Grega Bremec [EMAIL PROTECTED] writes:
Collate order for those databases, however, needs to be different.
If you need multiple LC_COLLATE settings then you have to run multiple
postmasters. There is no other solution today, nor likely to be one in
the near future.
Also, running several
On Wed, Jun 09, 2004 at 12:33:03PM +0200, Grega Bremec wrote:
Collate order for those databases, however, needs to be different. Obviously,
[...]
Is it possible to do either of these things that could solve this problem
adequately:
- somehow manage to make one postmaster run on top
Cook, Tom [EMAIL PROTECTED] writes:
ERROR: syntax error at line 3467: unexpected token syntax error
This line number seems to be from postgres.bki, and it appears to be
one short of where the error actually arises - inserting a blank line
at line 3468 moves the error to line 3468.
Hmm, both
On Wed, 2004-06-09 at 08:34, Milosz Miecznik wrote:
Hi!
I have very important question about performance of PostgreSQL Database. How
it will work with:
- about 300 insert operation per day,
- about 100 selects per day,
- about 100 still connected users?
What hardware platform
On Wed, 2004-06-09 at 08:09, David F. Skoll wrote:
Hi,
pg_dump can be used to dump an entire database, or just a single
table. Is there a way to make a consistent dump of more than one
table, but less than all of the tables in the database? Doing a bunch
of single-table pg_dumps isn't
On Wed, 9 Jun 2004, Scott Marlowe wrote:
If you put the application's data into a specific schema, then you can
dump just that schema with the -n switch...
Thanks. That's a solution for 7.4, but some of our installed base
(especially the older ones with large DB's that cause the problem) are
On Wed, 2004-06-09 at 10:43, David F. Skoll wrote:
On Wed, 9 Jun 2004, Scott Marlowe wrote:
If you put the application's data into a specific schema, then you can
dump just that schema with the -n switch...
Thanks. That's a solution for 7.4, but some of our installed base
(especially
Title: RE: [GENERAL] Help in finding the error
I'm on 7.4.2. I did some more testing and ended up dropping and recreating the table with all the constraints, etc. in the definition and tried my inserts, INSERT...SELECT..., and it worked just fine. I probably had something else set that I
Scott Marlowe wrote:
On Wed, 2004-06-09 at 10:43, David F. Skoll wrote:
On Wed, 9 Jun 2004, Scott Marlowe wrote:
If you put the application's data into a specific schema, then you can
dump just that schema with the -n switch...
Thanks. That's a solution for 7.4, but some of our
David F. Skoll [EMAIL PROTECTED] writes:
pg_dump can be used to dump an entire database, or just a single
table. Is there a way to make a consistent dump of more than one
table, but less than all of the tables in the database?
This has been discussed before, and I think we had agreed that the
Tom Lane wrote:
David F. Skoll [EMAIL PROTECTED] writes:
pg_dump can be used to dump an entire database, or just a single
table. Is there a way to make a consistent dump of more than one
table, but less than all of the tables in the database?
This has been discussed before, and I think
26 matches
Mail list logo