Tom Lane wrote:
> Joe Conway <mail@joeconway.com> writes:
> > One thing I wondered about here -- is it still possible to use a
> > sequence, which is autogenerated by a SERIAL column, as the default
> > value for another table?
>
> Sure, same as before.
>
> > If so, does this create another dependency to
> > prevent dropping the sequence, and hence the original (creating) table also?
>
> As the code stands, no. The other table's default would look like
> nextval('first_table_col_seq')
> and the dependency deducer only sees nextval() and a string constant
> in this.
>
> Someday I'd like to see us support the Oracle-ish syntax
> first_table_col_seq.nextval
> which would expose the sequence reference in a way that allows the
> system to understand it during static examination of a query.
OK, so creator tracks it, and referencers, even in DEFAULT, don't. Good
to know and probably something we need to point out in the release
notes.
-- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610)
853-3000+ If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill,
Pennsylvania19026