| 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: | Whole Thread | Raw Message | 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
| 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 |