Laurent ROCHE <[EMAIL PROTECTED]> 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
--
>
Cc : Andreas Kretschmer <[EMAIL PROTECTED]>; 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
On Oct 18, 2007, at 1:02 PM, Andreas Kretschmer wrote:
Laurent ROCHE <[EMAIL PROTECTED]> schrieb:
Then when I drop tab_b, the SEQUENCE tab_b_colb1_seq is not
dropped, however
when I drop tab_a, the SEQUENCE tab_a_cola1_seq is dropped too !
I am using PG 8.1 and ALTER SEQUENCE ... OWNED BY
Alvaro Herrera <[EMAIL PROTECTED]> writes:
> 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.
Actually, I
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 Herrerahttp://www.C
é le : Jeudi, 18 Octobre 2007, 20h02mn 47s
Objet : Re: [GENERAL] pg_dump SERIAL and SEQUENCE
Laurent ROCHE <[EMAIL PROTECTED]> schrieb:
> Then when I drop tab_b, the SEQUENCE tab_b_colb1_seq is not dropped,
however
> when I drop tab_a, the SEQUENCE tab_a_cola1_seq is dropped too !
&
Laurent ROCHE <[EMAIL PROTECTED]> schrieb:
> Then when I drop tab_b, the SEQUENCE tab_b_colb1_seq is not dropped, however
> when I drop tab_a, the SEQUENCE tab_a_cola1_seq is dropped too !
> I am using PG 8.1 and ALTER SEQUENCE ... OWNED BY does not exist ! ! !
Read this message: <[EMAIL PROTE
