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
This option disables the use of dollar quoting for function bodies, and
forces them to be quoted using SQL standard string syntax.



---------------------------(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

Reply via email to