Re: system info functions

> -----Original Message-----
> From: pgsql-hackers-owner(at)postgresql(dot)org
> [mailto:pgsql-hackers-owner(at)postgresql(dot)org] On Behalf Of Neil Conway
> Sent: 04 July 2006 05:53
> To: pgsql-hackers(at)postgresql(dot)org
> Subject: [HACKERS] system info functions
>
> (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()?

Documentation, unless we want to break apps that use the function.

Regards, Dave.