Re : Re : pg_dump SERIAL and SEQUENCE

From: Laurent ROCHE <laurent_roche(at)yahoo(dot)com>
To: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re : Re : pg_dump SERIAL and SEQUENCE
Date: 2007-10-18 21:16:36
Message-ID: 391495.63942.qm@web34411.mail.mud.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Not good because in that case pg_dump will generate code that can not run in 8.1 ... like :
ALTER SEQUENCE ... OWNED BY

Have fun,
L(at)u
The Computing Froggy

----- Message d'origine ----
De : Alvaro Herrera <alvherre(at)commandprompt(dot)com>
À : Laurent ROCHE <laurent_roche(at)yahoo(dot)com>
Cc : Andreas Kretschmer <akretschmer(at)spamfence(dot)net>; pgsql-general(at)postgresql(dot)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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Karsten Hilbert 2007-10-18 21:20:12 Re: XMIN semantic at peril ?
Previous Message Brian Wipf 2007-10-18 21:15:04 Re: Determining oldest WAL for Archiving PITR Standby - SOLVED