Commit9b5140f

committed

Correct representation of foreign tables in information schema

tables.table_type is supposed to be 'FOREIGN' rather than 'FOREIGNTABLE' according to the SQL standard.

1 parent3cda10f commit9b5140fCopy full SHA for 9b5140f

File tree

-2

lines changed

-2

lines changed

Lines changed: 1 addition & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -5456,7 +5456,7 @@ ORDER BY c.ordinal_position;`
`5456`	`5456`	`<entry>`
`5457`	`5457`	`Type of the table: <literal>BASE TABLE</literal> for a`
`5458`	`5458`	`persistent base table (the normal table type),`
`5459`		`- <literal>VIEW</literal> for a view, <literal>FOREIGN TABLE</literal>`
	`5459`	`+ <literal>VIEW</literal> for a view, <literal>FOREIGN</literal>`
`5460`	`5460`	`for a foreign table, or`
`5461`	`5461`	`<literal>LOCAL TEMPORARY</literal> for a temporary table`
`5462`	`5462`	`</entry>`

Lines changed: 1 addition & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -1914,7 +1914,7 @@ CREATE VIEW tables AS`
`1914`	`1914`	`CASE WHENnc.oid= pg_my_temp_schema() THEN'LOCAL TEMPORARY'`
`1915`	`1915`	`WHENc.relkindIN ('r','p') THEN'BASE TABLE'`
`1916`	`1916`	`WHENc.relkind='v' THEN'VIEW'`
`1917`		`- WHENc.relkind='f' THEN'FOREIGN TABLE'`
	`1917`	`+ WHENc.relkind='f' THEN'FOREIGN'`
`1918`	`1918`	`ELSEnull END`
`1919`	`1919`	`AS character_data)AS table_type,`
`1920`	`1920`

Comments

(0)