pg_dump: ALTER SEQUENCE ... OWNED in 8.1

From: Laurent ROCHE <laurent_roche(at)yahoo(dot)com>
To: pgadmin-support(at)postgresql(dot)org
Subject: pg_dump: ALTER SEQUENCE ... OWNED in 8.1
Date: 2007-06-18 16:50:13
Message-ID: 599644.24476.qm@web34402.mail.mud.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

Hi All,

I have a table with a sequence.
When I backup the table I get the following code (among other things):
...
ALTER SEQUENCE documents_doc_id_seq OWNED BY documents.doc_id;
...

However my server is PG 8.1 and this is 8.2 syntax.
I understand pgAdmin runs a standard pg_dump but I would expect it to run a version compatible with my server ! ? !


Cheers,
L(at)u
The Computing Froggy

_____________________________________________________________________________
Ne gardez plus qu'une seule adresse mail ! Copiez vos mails vers Yahoo! Mail

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Raymond O'Donnell 2007-06-18 17:49:50 Re: pg_dump: ALTER SEQUENCE ... OWNED in 8.1
Previous Message Dave Page 2007-06-18 08:00:37 Re: Problem editing tables (geom columns)