From bf3c5856818a88b963748402f4f7e0274fe3859d Mon Sep 17 00:00:00 2001 From: Peter Eisentraut Date: Fri, 15 Jul 2011 21:11:14 +0300 Subject: [PATCH] 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. --- doc/src/sgml/information_schema.sgml | 7 +------ src/backend/catalog/information_schema.sql | 5 +---- 2 files changed, 2 insertions(+), 10 deletions(-) diff --git a/doc/src/sgml/information_schema.sgml b/doc/src/sgml/information_schema.sgml index 4b3712e60f..5d29d412d2 100644 --- a/doc/src/sgml/information_schema.sgml +++ b/doc/src/sgml/information_schema.sgml @@ -5416,12 +5416,7 @@ ORDER BY c.ordinal_position; commit_action character_data - - If the table is a temporary table, then - PRESERVE, else null. (The SQL standard - defines other commit actions for temporary tables, which are - not supported by PostgreSQL.) - + Not yet implemented diff --git a/src/backend/catalog/information_schema.sql b/src/backend/catalog/information_schema.sql index 8cf00acaa8..80cd091ec8 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) -- 2.40.0