Fabien COELHO said: > > > My tests suggest that a feature of pg_restore is that it is only > expected to work with its own server. Indeed, it generates some new > syntax, such as $$ quoting, which is not compatible with older servers. > This fact does not seem to appear in the documentation. >
Wrong. It does appear in the documentation, and it can also be disabled. http://developer.postgresql.org/docs/postgres/app-pgdump.html says: -X disable-dollar-quoting --disable-dollar-quoting This option disables the use of dollar quoting for function bodies, and forces them to be quoted using SQL standard string syntax. cheers andrew ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match