Re: Generate user/group sysids from a sequence?

Tom Lane wrote:
> Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)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(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073