Re: escape string syntax and pg_dumpall

Patrick Welche <prlw1@newn.cam.ac.uk> writes:
> I just ran pg_dumpall from today's CVS against a 14 April server - I got:
> pg_dumpall: query failed: ERROR:  type "e" does not exist
> pg_dumpall: query was: SELECT spcname, pg_catalog.pg_get_userbyid(spcowner) AS spcowner, spclocation, spcacl FROM
pg_catalog.pg_tablespaceWHERE spcname NOT LIKE E'pg\_%'
 

> That comes from v1.62 of pg_dumpall.c :

>     res = executeQuery(conn, "SELECT spcname, "
>                      "pg_catalog.pg_get_userbyid(spcowner) AS spcowner, "
>                        "spclocation, spcacl "
>                        "FROM pg_catalog.pg_tablespace "
>                        "WHERE spcname NOT LIKE E'pg\\_%'");

This query needs to be version-dependent, Bruce ...
        regards, tom lane