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/