diff options
| author | Tom Lane <tgl@sss.pgh.pa.us> | 2010-01-02 21:28:46 +0000 |
|---|---|---|
| committer | Tom Lane <tgl@sss.pgh.pa.us> | 2010-01-02 21:28:46 +0000 |
| commit | 96c40c6e4b79da504c5855f1e3a0ce7e1a1a559c (patch) | |
| tree | 7bfb305fea3c90c0d557859c51379ca3441b31ae | |
| parent | e15d53e7a419dcff49e108c78c8f70be6b18598b (diff) | |
| download | postgresql-96c40c6e4b79da504c5855f1e3a0ce7e1a1a559c.tar.gz postgresql-96c40c6e4b79da504c5855f1e3a0ce7e1a1a559c.zip | |
Add missing schema-qualification in tab completion query.
| -rw-r--r-- | src/bin/psql/tab-complete.c | 8 |
1 files changed, 4 insertions, 4 deletions
diff --git a/src/bin/psql/tab-complete.c b/src/bin/psql/tab-complete.c index b529b70e2c2..70b798d2f64 100644 --- a/src/bin/psql/tab-complete.c +++ b/src/bin/psql/tab-complete.c @@ -3,7 +3,7 @@ * * Copyright (c) 2000-2010, PostgreSQL Global Development Group * - * $PostgreSQL: pgsql/src/bin/psql/tab-complete.c,v 1.189 2010/01/02 16:58:00 momjian Exp $ + * $PostgreSQL: pgsql/src/bin/psql/tab-complete.c,v 1.190 2010/01/02 21:28:46 tgl Exp $ */ /*---------------------------------------------------------------------- @@ -387,7 +387,7 @@ static const SchemaQuery Query_for_list_of_views = { #define Query_for_list_of_template_databases \ "SELECT pg_catalog.quote_ident(datname) FROM pg_catalog.pg_database "\ -" WHERE substring(pg_catalog.quote_ident(datname),1,%d)='%s' and datistemplate IS TRUE" +" WHERE substring(pg_catalog.quote_ident(datname),1,%d)='%s' AND datistemplate" #define Query_for_list_of_databases \ "SELECT pg_catalog.quote_ident(datname) FROM pg_catalog.pg_database "\ @@ -404,9 +404,9 @@ static const SchemaQuery Query_for_list_of_views = { #define Query_for_list_of_languages \ "SELECT pg_catalog.quote_ident(lanname) "\ -" FROM pg_language "\ +" FROM pg_catalog.pg_language "\ " WHERE lanname != 'internal' "\ -" AND substring(pg_catalog.quote_ident(lanname),1,%d)='%s' " +" AND substring(pg_catalog.quote_ident(lanname),1,%d)='%s'" #define Query_for_list_of_schemas \ "SELECT pg_catalog.quote_ident(nspname) FROM pg_catalog.pg_namespace "\ |