Peter Eisentraut <peter_e(at)gmx(dot)net> writes:
> It seems that the proposed standard's sequence generators have a
> number of syntactical and semantic differences from ours
Yeah, there are some differences, but overall I think the spec-defined
behavior is remarkably similar to what we currently implement.
> [spec defines different syntax to ] set the current value, define
> "serial" columns
Can you point me to where in the standard these are defined? (I looked
briefly but couldn't find it.)
> [SQL 200x] sequences are apparently not allowed to contain holes.
This passage suggests to me that sequences can contain holes (4.22,
Changes to the current base value of a sequence generator are
not controlled by SQL-transactions; therefore, commits and
rollbacks of SQL-transactions have no effect on the base value
of a sequence generator.
Neil Conway <neilc(at)samurai(dot)com> || PGP Key ID: DB3C29FC
In response to
pgsql-patches by date
|Next:||From: Bruce Momjian||Date: 2002-09-30 22:42:40|
|Subject: Re: tweak CREATE SEQUENCE grammar|
|Previous:||From: Peter Eisentraut||Date: 2002-09-30 21:42:57|
|Subject: Re: AIX compilation problems (was Re: Proposal ...)|