diff options
| author | Tom Lane <tgl@sss.pgh.pa.us> | 2011-02-14 16:07:00 -0500 |
|---|---|---|
| committer | Tom Lane <tgl@sss.pgh.pa.us> | 2011-02-14 19:22:36 -0500 |
| commit | 555353c0c59ada35ae59c8a76186e98d123fa8b3 (patch) | |
| tree | 690e922f60f2faeca8a05a8372f834215f449078 /src/bin/psql/tab-complete.c | |
| parent | cee103da14f470d29c47827b810da44cdab2a0d2 (diff) | |
Rearrange extension-related views as per recent discussion.
The original design of pg_available_extensions did not consider the
possibility of version-specific control files. Split it into two views:
pg_available_extensions shows information that is generic about an
extension, while pg_available_extension_versions shows all available
versions together with information that could be version-dependent.
Also, add an SRF pg_extension_update_paths() to assist in checking that
a collection of update scripts provide sane update path sequences.
Diffstat (limited to 'src/bin/psql/tab-complete.c')
| -rw-r--r-- | src/bin/psql/tab-complete.c | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/src/bin/psql/tab-complete.c b/src/bin/psql/tab-complete.c index 119ac1b3768..70aa3fa81e6 100644 --- a/src/bin/psql/tab-complete.c +++ b/src/bin/psql/tab-complete.c @@ -586,7 +586,7 @@ static const SchemaQuery Query_for_list_of_views = { #define Query_for_list_of_available_extensions \ " SELECT pg_catalog.quote_ident(name) "\ " FROM pg_catalog.pg_available_extensions "\ -" WHERE substring(pg_catalog.quote_ident(name),1,%d)='%s' AND installed IS NULL" +" WHERE substring(pg_catalog.quote_ident(name),1,%d)='%s' AND installed_version IS NULL" /* * This is a list of all "things" in Pgsql, which can show up after CREATE or |