(1) The docs claim that pg_get_viewdef() returns the "CREATE VIEW
command for view", but that is clearly not the case:
postgres=# create view v1 as select 1;
CREATE VIEW
postgres=# select pg_get_viewdef('v1'::regclass::oid);
pg_get_viewdef
----------------
SELECT 1;
(1 row)
Should we change the documentation, or the implementation of
pg_get_viewdef()?
(2) pg_get_indexdef() and pg_get_triggerdef() don't include a
terminating semi-colon, but pg_get_ruledef() does (as does the SELECT
statement returned by pg_get_viewdef()). Is there a good reason for this
inconsistency?
-Neil
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
