Re: [SQL] pg_dump and sequences

2002-07-24 Thread Achilleus Mantzios
On Wed, 24 Jul 2002, Tom Lane wrote: > Achilleus Mantzios <[EMAIL PROTECTED]> writes: > >> It seems that pg_dump -t "tablename" dumps correctly the sequence of a > >> table's column,when the column is named after "id". > > > I meant "when ONLY" the column is named after "id", > > Yeah, you're

Re: [SQL] pg_dump and sequences

2002-07-24 Thread Tom Lane
Achilleus Mantzios <[EMAIL PROTECTED]> writes: >> It seems that pg_dump -t "tablename" dumps correctly the sequence of a >> table's column,when the column is named after "id". > I meant "when ONLY" the column is named after "id", Yeah, you're right. I'm hoping to see a better answer in 7.3, bu

Re: [SQL] pg_dump and sequences

2002-07-23 Thread Achilleus Mantzios
On Tue, 23 Jul 2002, Achilleus Mantzios wrote: Just a correction > Hi, i am using postgreSQL 7.2.1 on a redhat 7.2 (kernel > 2.4.9-31,glibc-2.2.4-24). > > It seems that pg_dump -t "tablename" dumps correctly the sequence of a > table's column,when the column is named after "id". >

[SQL] pg_dump and sequences

2002-07-23 Thread Achilleus Mantzios
Hi, i am using postgreSQL 7.2.1 on a redhat 7.2 (kernel 2.4.9-31,glibc-2.2.4-24). It seems that pg_dump -t "tablename" dumps correctly the sequence of a table's column,when the column is named after "id". For example, dynacom=# CREATE TABLE foo2 (fid serial NOT NULL UNIQUE PRIMARY KEY,id ser