|
4 | 4 | * |
5 | 5 | * Copyright (c) 2003-2009, PostgreSQL Global Development Group |
6 | 6 | * |
7 | | - * $PostgreSQL: pgsql/src/backend/catalog/information_schema.sql,v 1.48 2009/01/01 17:23:37 momjian Exp $ |
| 7 | + * $PostgreSQL: pgsql/src/backend/catalog/information_schema.sql,v 1.49 2009/01/14 21:12:09 petere Exp $ |
8 | 8 | */ |
9 | 9 |
|
10 | 10 | /* |
@@ -655,6 +655,9 @@ CREATE VIEW columns AS |
655 | 655 | CAST(nullAS character_data)AS generation_expression, |
656 | 656 |
|
657 | 657 | CAST(CASE WHENc.relkind='r' |
| 658 | +OR (c.relkind='v' |
| 659 | +AND EXISTS (SELECT1FROM pg_rewriteWHERE ev_class=c.oidAND ev_type='2'AND is_instead) |
| 660 | +AND EXISTS (SELECT1FROM pg_rewriteWHERE ev_class=c.oidAND ev_type='4'AND is_instead)) |
658 | 661 | THEN'YES' ELSE'NO' ENDAS character_data)AS is_updatable |
659 | 662 |
|
660 | 663 | FROM (pg_attribute aLEFT JOIN pg_attrdef adON attrelid= adrelidAND attnum= adnum), |
@@ -1882,7 +1885,10 @@ CREATE VIEW tables AS |
1882 | 1885 | CAST(nullAS sql_identifier)AS user_defined_type_name, |
1883 | 1886 |
|
1884 | 1887 | CAST(CASE WHENc.relkind='r' |
| 1888 | +OR (c.relkind='v' |
| 1889 | +AND EXISTS (SELECT1FROM pg_rewriteWHERE ev_class=c.oidAND ev_type='3'AND is_instead)) |
1885 | 1890 | THEN'YES' ELSE'NO' ENDAS character_data)AS is_insertable_into, |
| 1891 | + |
1886 | 1892 | CAST('NO'AS character_data)AS is_typed, |
1887 | 1893 | CAST( |
1888 | 1894 | CASE WHENnc.oid= pg_my_temp_schema() THEN'PRESERVE'-- FIXME |
|