Re: pg_dump and sequences

From: Achilleus Mantzios <achill(at)matrix(dot)gatewaynet(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: pg_dump and sequences
Date: 2002-07-24 10:56:51
Message-ID: Pine.LNX.4.44.0207241352410.23519-100000@matrix.gatewaynet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On Wed, 24 Jul 2002, Tom Lane wrote:

> Achilleus Mantzios <achill(at)matrix(dot)gatewaynet(dot)com> 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, but
> right now it's a horrible kluge ...

No harm done!

>
> regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)
>

--
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

Browse pgsql-sql by date

  From Date Subject
Next Message daq 2002-07-24 11:50:20 pg_restore vs. indexes
Previous Message Ian Cass 2002-07-24 08:57:03 Re: FATAL 1