[GENERAL] pg_dump cross-version support

[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.
 
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 ?
 
Any hint is 
welcome!
 
A.
 
NB: I expect this 
issue is fairly common for people who, like me, run their development server on 
Windows (ie. v 8+) and have their application hosted at a provider who keeps 
delaying its upgrade from v7 to v8...
 
_
Alain BAUDHUIN
[EMAIL PROTECTED]
 

[GENERAL] substitute for array functions in postgresql v7.3 ?

[Alain BAUDHUIN]

Title: Message



Hello!
 
Does anybody know 
whether ther is a substitue for the array_to_string function available from 
v7.4, that would allow a query equivalent to this one to run on 
v7.3:
 
select 
array_to_string(array[1,2,3]);    (ok from 
v7.4)
 
Having a 7.3 
substitute for select array[1,2,3]  would already be a good 
starting point...
 
Thanks in advance 
 for any hint,
Alain
 
_
Alain BAUDHUIN
[EMAIL PROTECTED]