On Wed, May 02, 2012 at 12:59:58PM +0000, stu...@stuartbishop.net wrote: > The following bug has been logged on the website: > > Bug reference: 6624 > Logged by: Stuart Bishop > Email address: stu...@stuartbishop.net > PostgreSQL version: 9.1.3 > Operating system: Ununtu > Description: > > psql tab completion can emit WARNING messages if escape_string_warning is > set to true. The trigger seems to be an identifier containing a single > backslash. > > # CREATE SEQUENCE "\foo"; > CREATE SEQUENCE > # \ds "\
I am unable to reproduce this failure on my copy of 9.1.3. Have you perhaps changed any server settings? --------------------------------------------------------------------------- > > (at this point, hit <TAB> to trigger completion) > > # drop sequence "\WARNING: nonstandard use of \\ in a string literal > LINE 1: ... substring(pg_catalog.quote_ident(c.relname),1,2)='"\\' AND ... > ^ > HINT: Use the escape string syntax for backslashes, e.g., E'\\'. > WARNING: nonstandard use of \\ in a string literal > LINE 3: ...ing(pg_catalog.quote_ident(n.nspname) || '.',1,2)='"\\' AND ... > ^ > HINT: Use the escape string syntax for backslashes, e.g., E'\\'. > WARNING: nonstandard use of \\ in a string literal > LINE 3: ...alog.quote_ident(nspname) || '.',1,2) = substring('"\\',1,pg... > ^ > HINT: Use the escape string syntax for backslashes, e.g., E'\\'. > WARNING: nonstandard use of \\ in a string literal > LINE 5: ... || '.' || pg_catalog.quote_ident(c.relname),1,2)='"\\' AND ... > ^ > HINT: Use the escape string syntax for backslashes, e.g., E'\\'. > WARNING: nonstandard use of \\ in a string literal > LINE 5: ...og.quote_ident(n.nspname) || '.',1,2) = substring('"\\',1,pg... > ^ > HINT: Use the escape string syntax for backslashes, e.g., E'\\'. > WARNING: nonstandard use of \\ in a string literal > LINE 5: ...alog.quote_ident(nspname) || '.',1,2) = substring('"\\',1,pg... > ^ > HINT: Use the escape string syntax for backslashes, e.g., E'\\'. > foo" ; > > > > -- > Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-bugs -- Bruce Momjian <br...@momjian.us> http://momjian.us EnterpriseDB http://enterprisedb.com + It's impossible for everything to be true. + -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs