> Kovacs Zoltan <kovacsz@pc10.radnoti-szeged.sulinet.hu> writes:
> >> Is it possible that 1060 and 1092 have the same usesysid in pg_shadow?
>
> > Hmmm. That was the problem. Thanks! By the way, could you please define a
> > unique constraint on column 'usesysid' in future in PostgreSQL?
>
> Yup, there should be one (and one on usename, too). Not sure why it's
> been overlooked so far.
TODO item has:
* Add unique indexes to pg_shadow.usename and pg_shadow.usesysid
I overlooked it long ago because there is no cache lookup on that
column.
-- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610)
853-3000+ If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill,
Pennsylvania19026