Re: pg_dump and sequences

From: Achilleus Mantzios <achill(at)matrix(dot)gatewaynet(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: pg_dump and sequences
Date: 2002-07-23 08:33:25
Message-ID: Pine.LNX.4.44.0207231131150.21717-100000@matrix.gatewaynet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)matrix(dot)gatewaynet(dot)com
mantzios(at)softlab(dot)ece(dot)ntua(dot)gr

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Gaetano Mendola 2002-07-23 12:56:28 Re: Queries not using Index
Previous Message Achilleus Mantzios 2002-07-23 08:27:32 pg_dump and sequences