Movatterモバイル変換


[0]ホーム

URL:


Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

Sign up
Appearance settings

Commitbf3c585

Browse files
committed
Set information_schema.tables.commit_action to null
The commit action of temporary tables is currently not cataloged, sowe can't easily show it. The previous value was outdated from beforewe had different commit actions.
1 parentc1129a1 commitbf3c585

File tree

2 files changed

+2
-10
lines changed

2 files changed

+2
-10
lines changed

‎doc/src/sgml/information_schema.sgml

Lines changed: 1 addition & 6 deletions
Original file line numberDiff line numberDiff line change
@@ -5416,12 +5416,7 @@ ORDER BY c.ordinal_position;
54165416
<row>
54175417
<entry><literal>commit_action</literal></entry>
54185418
<entry><type>character_data</type></entry>
5419-
<entry>
5420-
If the table is a temporary table, then
5421-
<literal>PRESERVE</literal>, else null. (The SQL standard
5422-
defines other commit actions for temporary tables, which are
5423-
not supported by <productname>PostgreSQL</>.)
5424-
</entry>
5419+
<entry>Not yet implemented</entry>
54255420
</row>
54265421
</tbody>
54275422
</tgroup>

‎src/backend/catalog/information_schema.sql

Lines changed: 1 addition & 4 deletions
Original file line numberDiff line numberDiff line change
@@ -1862,10 +1862,7 @@ CREATE VIEW tables AS
18621862
THEN'YES' ELSE'NO' ENDAS yes_or_no)AS is_insertable_into,
18631863

18641864
CAST(CASE WHENt.typnameIS NOT NULL THEN'YES' ELSE'NO' ENDAS yes_or_no)AS is_typed,
1865-
CAST(
1866-
CASE WHENnc.oid= pg_my_temp_schema() THEN'PRESERVE'-- FIXME
1867-
ELSEnull END
1868-
AS character_data)AS commit_action
1865+
CAST(nullAS character_data)AS commit_action
18691866

18701867
FROM pg_namespace ncJOIN pg_class cON (nc.oid=c.relnamespace)
18711868
LEFT JOIN (pg_type tJOIN pg_namespace ntON (t.typnamespace=nt.oid))ON (c.reloftype=t.oid)

0 commit comments

Comments
 (0)

[8]ページ先頭

©2009-2025 Movatter.jp