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

pgAdmin III commit: Make sure that queries use LIKE with _ escaped

From: Guillaume Lelarge <guillaume(at)lelarge(dot)info>
To: pgadmin-hackers(at)postgresql(dot)org
Subject: pgAdmin III commit: Make sure that queries use LIKE with _ escaped
Date: 2012-03-06 20:47:23
Message-ID: E1S51I3-0003K9-Te@gothos.postgresql.org (view raw or flat)
Thread:
Lists: pgadmin-hackers
Make sure that queries use LIKE with _ escaped

For example:

SELECT nspname
FROM pg_namespace
WHERE nspname NOT LIKE 'pg_%'
  AND nspname != 'information_schema'
ORDER BY nspname

will get every schema whose name isn't information_schema and doesn't begin
with pg (the _ character is a joker character when used with LIKE, meaning
"replace-me-with-one-character-whatever-it-is").

So, we need to escape the underscore to get rid of its special meaning.

Branch
------
REL-1_14_0_PATCHES

Details
-------
http://git.postgresql.org/gitweb?p=pgadmin3.git;a=commitdiff;h=58c82680abf7ee6e4279b84efe1d2b6aa49b41b3

Modified Files
--------------
CHANGELOG                   |    5 +++--
pgadmin/dlg/dlgFunction.cpp |    2 +-
2 files changed, 4 insertions(+), 3 deletions(-)

pgadmin-hackers by date

Next:From: Guillaume LelargeDate: 2012-03-07 14:09:00
Subject: pgAdmin III commit: Another wxWidgets 2.9 assert
Previous:From: Dave PageDate: 2012-03-06 09:14:09
Subject: Re: Database designer

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