Commitaffcb43

committed

Avoid use of E'', and thereby creating an unnecessary version-dependency,

by using LIKE...ESCAPE instead. Per suggestion by andrew@supernews.

1 parentfdd8446 commitaffcb43Copy full SHA for affcb43

File tree

-3

lines changed

-3

lines changed

Lines changed: 3 additions & 3 deletions

Original file line number	Diff line number	Diff line change
`@@ -6,7 +6,7 @@`
`6`	`6`	`* Portions Copyright (c) 1994, Regents of the University of California`
`7`	`7`	`*`
`8`	`8`	`*`
`9`		`- * $PostgreSQL: pgsql/src/bin/pg_dump/pg_dumpall.c,v 1.63 2005/07/08 16:51:30 tgl Exp $`
	`9`	`+ * $PostgreSQL: pgsql/src/bin/pg_dump/pg_dumpall.c,v 1.64 2005/07/18 19:12:09 tgl Exp $`
`10`	`10`	`*`
`11`	`11`	`*-------------------------------------------------------------------------`
`12`	`12`	`*/`
`@@ -543,10 +543,10 @@ dumpTablespaces(PGconn *conn)`
`543`	`543`	`* pg_xxx)`
`544`	`544`	`*/`
`545`	`545`	`res=executeQuery(conn,"SELECT spcname, "`
`546`		`-"pg_catalog.pg_get_userbyid(spcowner) AS spcowner, "`
	`546`	`+"pg_catalog.pg_get_userbyid(spcowner) AS spcowner, "`
`547`	`547`	`"spclocation, spcacl "`
`548`	`548`	`"FROM pg_catalog.pg_tablespace "`
`549`		`-"WHERE spcname NOT LIKEE'pg\\_%'");`
	`549`	`+"WHERE spcname NOT LIKE 'pg!_%' ESCAPE '!'");`
`550`	`550`
`551`	`551`	`if (PQntuples(res)>0)`
`552`	`552`	`printf("--\n-- Tablespaces\n--\n\n");`

Comments

(0)