Commit6a9e09c

committed

Add missing casts in information schema

From: Clément Prévost <prevostclement@gmail.com>

1 parent2b8fd4f commit6a9e09cCopy full SHA for 6a9e09c

File tree

-5

lines changed

-5

lines changed

Lines changed: 5 additions & 5 deletions

Original file line number	Diff line number	Diff line change
`@@ -2742,9 +2742,9 @@ CREATE VIEW _pg_foreign_table_columns AS`
`2742`	`2742`	`*/`
`2743`	`2743`	`CREATEVIEWcolumn_optionsAS`
`2744`	`2744`	`SELECT CAST(current_database()AS sql_identifier)AS table_catalog,`
`2745`		`-c.nspnameAS table_schema,`
`2746`		`-c.relnameAS table_name,`
`2747`		`-c.attnameAS column_name,`
	`2745`	`+CAST(c.nspnameAS sql_identifier)AS table_schema,`
	`2746`	`+CAST(c.relnameAS sql_identifier)AS table_name,`
	`2747`	`+CAST(c.attnameAS sql_identifier)AS column_name,`
`2748`	`2748`	`CAST((pg_options_to_table(c.attfdwoptions)).option_nameAS sql_identifier)AS option_name,`
`2749`	`2749`	`CAST((pg_options_to_table(c.attfdwoptions)).option_valueAS character_data)AS option_value`
`2750`	`2750`	`FROM _pg_foreign_table_columns c;`
`@@ -2849,8 +2849,8 @@ GRANT SELECT ON foreign_servers TO PUBLIC;`
`2849`	`2849`	`CREATEVIEW_pg_foreign_tablesAS`
`2850`	`2850`	`SELECT`
`2851`	`2851`	`CAST(current_database()AS sql_identifier)AS foreign_table_catalog,`
`2852`		`-n.nspnameAS foreign_table_schema,`
`2853`		`-c.relnameAS foreign_table_name,`
	`2852`	`+CAST(n.nspnameAS sql_identifier)AS foreign_table_schema,`
	`2853`	`+CAST(c.relnameAS sql_identifier)AS foreign_table_name,`
`2854`	`2854`	`t.ftoptionsAS ftoptions,`
`2855`	`2855`	`CAST(current_database()AS sql_identifier)AS foreign_server_catalog,`
`2856`	`2856`	`CAST(srvnameAS sql_identifier)AS foreign_server_name,`

Comments

(0)