BUG #6624: Tab completion of identifier containing single backslash triggers warnings

From: stuart(at)stuartbishop(dot)net
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #6624: Tab completion of identifier containing single backslash triggers warnings
Date: 2012-05-02 12:59:58
Message-ID: E1SPZ9y-0003PX-Qz@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 6624
Logged by: Stuart Bishop
Email address: stuart(at)stuartbishop(dot)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 "\

(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" ;

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Matteo Beccati 2012-05-02 17:08:18 Re: Errors on CREATE TABLE IF NOT EXISTS
Previous Message Alvaro Herrera 2012-05-01 19:36:24 Re: Errors on CREATE TABLE IF NOT EXISTS