Re: Re : [GENERAL] pg_dump SERIAL and SEQUENCE

2007-10-18 Thread Alvaro Herrera
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

Re: Re : [GENERAL] pg_dump SERIAL and SEQUENCE

2007-10-18 Thread Tom Lane
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 bet the

Re : Re : [GENERAL] pg_dump SERIAL and SEQUENCE

2007-10-18 Thread Laurent ROCHE
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 does not generate code with SERIAL

Re: Re : Re : [GENERAL] pg_dump SERIAL and SEQUENCE

2007-10-18 Thread Douglas McNaught
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