Re: pgsql/src/backend/commands sequence.c - Mailing list pgsql-committers

From Tom Lane
Subject Re: pgsql/src/backend/commands sequence.c
Date
Msg-id 1201.1010781858@sss.pgh.pa.us
Whole thread Raw
In response to Re: pgsql/src/backend/commands sequence.c  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: pgsql/src/backend/commands sequence.c  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-committers
Bruce Momjian <pgman@candle.pha.pa.us> writes:
> Oh.  Is that good?  If we set the sequence xid as frozen, how do we
> rollback a sequence creation?

If we roll back a sequence creation, the whole table goes away.
Conversely, even if we commit, no one can see the sequence until they
can see the pg_class entry for it.  Thus, it doesn't matter what's in
the tuple.

            regards, tom lane

pgsql-committers by date:

Previous
From: momjian@postgresql.org
Date:
Subject: pgsql/ oc/src/sgml/ref/pg_upgrade.sgml rc/bin/ ...
Next
From: Bruce Momjian
Date:
Subject: Re: pgsql/src/backend/commands sequence.c