Re: auto-increment column

Hi,

2011-10-04 14:05 keltezéssel, Robert Buckley írta:
> Thanks for the replies,
>
> I have one question regarding this comment...
>
> "You also need to add a DEFAULT expression and optionally
> make the sequence owned by the column:"
>
> What difference does it make if a table "owns" a sequence of not?...does this contraint
> the use of the sequence to ONLY that one table?
>
> The sequence will only be used to auto-increment the id column in order to have an
> automatic primary key. Could I then somehow use the sequence for all tables which need this?
>
> yours,
>
> Rob

please, don't use top-posting. It messes up the order of the messages.

The sequenced that is OWNED BY a column can of course be used
by other columns in other tables. You can specify nextval('same sequence')
for any number of columns' default value.

Best regards,
Zoltán Böszörményi

--
----------------------------------
Zoltán Böszörményi
Cybertec Schönig & Schönig GmbH
Gröhrmühlgasse 26
A-2700 Wiener Neustadt, Austria
Web: http://www.postgresql-support.de
http://www.postgresql.at/