Skip site navigation (1) Skip section navigation (2)

BUG #6624: Tab completion of identifier containing single backslashtriggers warnings

From: stuart(at)stuartbishop(dot)net
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #6624: Tab completion of identifier containing single backslashtriggers warnings
Date: 2012-05-02 12:59:58
Message-ID: E1SPZ9y-0003PX-Qz@wrigleys.postgresql.org (view raw or flat)
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

pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group