Patrick Welche <[EMAIL PROTECTED]> 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_tablespace WHERE 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 ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq