> > I think that when SERIAL is used, the sequence should be tied > > inextricably to the table which created it, and it should be hidden from > > use for other purposes (perhaps similar to the way a toast table is). If > > you *want* to use a sequence across several tables, then you don't use > > SERIAL, you create a sequence. > > Agreed. Maybe an extra column in pg_attribute or something?
Since no other sequence will depend on a column, I could base it on that. ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
