On Jul 4, 2006, at 3:35 AM, Dave Page wrote:
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Neil Conway
Sent: 04 July 2006 05:53
To: pgsql-hackers@postgresql.org
Subject: [HACKERS] system info functions
(1) The docs claim that pg_get_viewdef() returns
"Dave Page" writes:
>> [mailto:[EMAIL PROTECTED] On Behalf Of Neil Conway
>> Should we change the documentation, or the implementation of
>> pg_get_viewdef()?
> Documentation, unless we want to break apps that use the function.
... such as pg_dump.
regards, tom lane
---
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of Neil Conway
> Sent: 04 July 2006 05:53
> To: pgsql-hackers@postgresql.org
> Subject: [HACKERS] system info functions
>
> (1) The docs claim that pg_get_viewdef() returns th
(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 th