Re: Making serial survive pg_dump - Mailing list pgsql-hackers

From Christopher Kings-Lynne
Subject Re: Making serial survive pg_dump
Date
Msg-id GNELIHDDFBOCMGBFGEFOGEMCCCAA.chriskl@familyhealth.com.au
Whole thread Raw
In response to Re: Making serial survive pg_dump  (Joe Conway <mail@joeconway.com>)
List pgsql-hackers
> 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?

Chris



pgsql-hackers by date:

Previous
From: Joe Conway
Date:
Subject: Re: Making serial survive pg_dump
Next
From: Bruce Momjian
Date:
Subject: Re: Default privileges for new databases (was Re: Can't import