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
http://techdocs.postgresql.org/com
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 tilikartt
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 co
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 cl
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;
> Ju
"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
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 tri
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 bu
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
const
"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
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 c
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 manag
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 d
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 pos
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
"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.
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 platfo
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'
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
> (espe
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 di
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 inst
"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 th
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,
26 matches
Mail list logo
