Re: Generate user/group sysids from a sequence? - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Generate user/group sysids from a sequence?
Date
Msg-id 12627.1042821749@sss.pgh.pa.us
Whole thread Raw
In response to Re: Generate user/group sysids from a sequence?  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: Generate user/group sysids from a sequence?  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-hackers
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.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Generate user/group sysids from a sequence?
Next
From: Bruce Momjian
Date:
Subject: Re: Generate user/group sysids from a sequence?