On Wed, Jan 6, 2010 at 8:36 PM, Scott Marlowe <scott.marlowe@xxxxxxxxx> wrote: >. A >> serial foreign key would be nonsensical since foreign keys should be >> be generating their own values. > > Pretty sure the OP was talking about referencing a bigserial from a > foreign key, which makes perfect sense for certain types of mappings. > FKs don't generate their own values, they reference values in a PK or > unique field somewhere else really. Good catch. :) I've been sticking my foot in my mouth all day with typos like this. -- Regards, Richard Broersma Jr. Visit the Los Angeles PostgreSQL Users Group (LAPUG) http://pugs.postgresql.org/lapug -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general