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/
> 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?
--
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
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