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