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