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-0003K6-Sk@gothos.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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
------
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(-)
From | Date | Subject | |
---|---|---|---|
Next Message | Guillaume Lelarge | 2012-03-07 14:09:00 | pgAdmin III commit: Another wxWidgets 2.9 assert |
Previous Message | Dave Page | 2012-03-06 09:14:09 | Re: Database designer |