diff options
| author | Peter Eisentraut <peter_e@gmx.net> | 2011-07-15 21:11:14 +0300 |
|---|---|---|
| committer | Peter Eisentraut <peter_e@gmx.net> | 2011-07-15 21:11:14 +0300 |
| commit | bf3c5856818a88b963748402f4f7e0274fe3859d (patch) | |
| tree | 21f0f43fdf5e4ef031dd79d0a7b4f82d02bb7cae /src | |
| parent | c1129a14e192755e001ba7899d4a9ca216e4ec3c (diff) | |
| download | postgresql-bf3c5856818a88b963748402f4f7e0274fe3859d.tar.gz postgresql-bf3c5856818a88b963748402f4f7e0274fe3859d.zip | |
Set information_schema.tables.commit_action to null
The commit action of temporary tables is currently not cataloged, so
we can't easily show it. The previous value was outdated from before
we had different commit actions.
Diffstat (limited to 'src')
| -rw-r--r-- | src/backend/catalog/information_schema.sql | 5 |
1 files changed, 1 insertions, 4 deletions
diff --git a/src/backend/catalog/information_schema.sql b/src/backend/catalog/information_schema.sql index 8cf00acaa81..80cd091ec87 100644 --- a/src/backend/catalog/information_schema.sql +++ b/src/backend/catalog/information_schema.sql @@ -1862,10 +1862,7 @@ CREATE VIEW tables AS THEN 'YES' ELSE 'NO' END AS yes_or_no) AS is_insertable_into, CAST(CASE WHEN t.typname IS NOT NULL THEN 'YES' ELSE 'NO' END AS yes_or_no) AS is_typed, - CAST( - CASE WHEN nc.oid = pg_my_temp_schema() THEN 'PRESERVE' -- FIXME - ELSE null END - AS character_data) AS commit_action + CAST(null AS character_data) AS commit_action FROM pg_namespace nc JOIN pg_class c ON (nc.oid = c.relnamespace) LEFT JOIN (pg_type t JOIN pg_namespace nt ON (t.typnamespace = nt.oid)) ON (c.reloftype = t.oid) |