pgAdmin III commit: Make sure that queries use LIKE with _ escaped - Mailing list pgadmin-hackers

From Guillaume Lelarge
Subject pgAdmin III commit: Make sure that queries use LIKE with _ escaped
Date
Msg-id E1S51I3-0003K6-Sk@gothos.postgresql.org
Whole thread Raw
List 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
------
master

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

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


pgadmin-hackers by date:

Previous
From: Guillaume Lelarge
Date:
Subject: pgAdmin III commit: Fix enabling the OK button of the view dialog
Next
From: Guillaume Lelarge
Date:
Subject: pgAdmin III commit: Another wxWidgets 2.9 assert