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