Re: [GENERAL] pg_dump cross-version support

2006-03-19 Thread Peter Eisentraut
Alain BAUDHUIN wrote: > I'm surprised, though not to find any pg_dump switch to produce a > v7.x compatible dump. Did I look at the wrong place ? Does anybody > know about the right way to dump a database in a cross-version > compatible form ? Downgrades are generally not supported. You may be ab

[GENERAL] pg_dump cross-version support

2006-03-18 Thread Alain BAUDHUIN
Title: Message Hello!   I need to load a pgsql 8.1 database dump (SQL format) into a pgsql 7.3 server (through phpPgAdmin). This does not work, since many v8 instructions are not recognised by v7.3 (e.g. SET default_table_space, function pg_get_serial_sequence,...) which is not unexpected.