Re: Generate user/group sysids from a sequence?

Tom Lane wrote:
> Bruce Momjian <pgman@candle.pha.pa.us> writes:
> > The reason I was being cautious is to handle cases where people are
> > poking in pg_shadow directly.
> 
> If they're poking pg_shadow directly, I think it's up to them to avoid
> or cope with sysid conflicts (the unique indexes on the table will
> prevent the worst errors).  ISTM it is sufficient for CREATE USER
> to not cause conflicts when used as documented.

OK.  Do we have many people left upgrading from pg_dump's that COPY into
pg_shadow?

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
359-1001+  If your life is a hard drive,     |  13 Roberts Road +  Christ can be your backup.        |  Newtown Square,
Pennsylvania19073