Horton

Re: escape string syntax and pg_dumpall

Tom Lane <tgl@sss.pgh.pa.us>

View thread View on postgr.es
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Patrick Welche <prlw1@newn.cam.ac.uk>
Cc: pgsql-hackers@postgresql.org, Bruce Momjian <pgman@candle.pha.pa.us>
Date: 2005-07-18T17:25:28Z
Lists: pgsql-hackers 
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_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