Re: [ADMIN] {ADMIN} Re: pg_dump potential bug

2001-03-30 Thread Peter Eisentraut
Thomas Sattler writes: > Forgive me if I'm wrong about this, but doesn't the SQL Standard > prohibit duplicate rows in a table, unique index or not? You're wrong about this, and you're forgiven. ;-) -- Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e/

[ADMIN] {ADMIN} Re: pg_dump potential bug

2001-03-30 Thread Thomas Sattler
> Thanks for the help, in fact that is Exactly what is wrong. The pg_shadow > table has duplicated entries in it, I think I'm going to create a unique > index on it. Forgive me if I'm wrong about this, but doesn't the SQL Standard prohibit duplicate rows in a table, unique index or not? --

[ADMIN] Re: pg_dump potential bug

2001-03-30 Thread Marcin Kowalski
Hi Thanks for the help, in fact that is Exactly what is wrong. The pg_shadow table has duplicated entries in it, I think I'm going to create a unique index on it. BTW I've migrated the entrie database to PG7.1RC1, running quite a big search on the database basically involving a huge amount of

[ADMIN] Re: pg_dump potential bug

2001-03-30 Thread Marcin Kowalski
Hi I would have expected this problem to have been brought up long ago with people doing database backups and restores. Anyway below are the details I am running PostgreSQL v 7.0.3 (upgraded yesterday from 7.0.2) on SuSE 6.3 with 2.2.17(SMP) kernel with S/W raid patch. The actual database is