Re: pg_dump and sequences - Mailing list pgsql-sql

From Achilleus Mantzios
Subject Re: pg_dump and sequences
Date
Msg-id Pine.LNX.4.44.0207231131150.21717-100000@matrix.gatewaynet.com
Whole thread Raw
In response to pg_dump and sequences  (Achilleus Mantzios <achill@matrix.gatewaynet.com>)
Responses Re: pg_dump and sequences
List pgsql-sql
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".
>                 ^^^^

I meant "when ONLY" the column is named after "id",
whereas it does not dump the sequence when the column is
named after something different than "id".

-- 
Achilleus Mantzios
S/W Engineer
IT dept
Dynacom Tankers Mngmt
Nikis 4, Glyfada
Athens 16610
Greece
tel:    +30-10-8981112
fax:    +30-10-8981877
email:  achill@matrix.gatewaynet.com       mantzios@softlab.ece.ntua.gr



pgsql-sql by date:

Previous
From: Achilleus Mantzios
Date:
Subject: pg_dump and sequences
Next
From: Daryl Herzmann
Date:
Subject: Queries not using Index