Thread: Re : Re : pg_dump SERIAL and SEQUENCE
Not good because in that case pg_dump will generate code that can not run in 8.1 ... like :
Have fun,
L@u
The Computing Froggy
ALTER SEQUENCE ... OWNED BY
L@u
The Computing Froggy
----- Message d'origine ----
De : Alvaro Herrera <alvherre@commandprompt.com>
À : Laurent ROCHE <laurent_roche@yahoo.com>
Cc : Andreas Kretschmer <akretschmer@spamfence.net>; pgsql-general@postgresql.org
Envoyé le : Jeudi, 18 Octobre 2007, 20h33mn 15s
Objet : Re: Re : [GENERAL] pg_dump SERIAL and SEQUENCE
Laurent ROCHE wrote:
> Yep, of course but what's the situation for people using 8.1 and
> pg_dump that does not generate code with SERIAL ?
They grab 8.2's pg_dump and connect with it to their 8.1 server, to
generate a dump that does.
--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
De : Alvaro Herrera <alvherre@commandprompt.com>
À : Laurent ROCHE <laurent_roche@yahoo.com>
Cc : Andreas Kretschmer <akretschmer@spamfence.net>; pgsql-general@postgresql.org
Envoyé le : Jeudi, 18 Octobre 2007, 20h33mn 15s
Objet : Re: Re : [GENERAL] pg_dump SERIAL and SEQUENCE
Laurent ROCHE wrote:
> Yep, of course but what's the situation for people using 8.1 and
> pg_dump that does not generate code with SERIAL ?
They grab 8.2's pg_dump and connect with it to their 8.1 server, to
generate a dump that does.
--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
Ne gardez plus qu'une seule adresse mail ! Copiez vos mails vers Yahoo! Mail
Laurent ROCHE <laurent_roche@yahoo.com> writes: > Not good because in that case pg_dump will generate code that can not run in > 8.1 ... like : > > ALTER SEQUENCE ... OWNED BY Dumps produced by version X of pg_dump have never been guaranteed to load into earlier versions. -Doug