Re: [BUGS] Possible problem with pg_get_viewdef on Postgres V8.0.0 rc4

2005-01-13 Thread Tom Lane
[EMAIL PROTECTED] writes: > Tom Lane wrote: >> Could we see a full example? The view definition is of little use when >> you didn't provide the definitions of the tables it references. >Mea Culpa! >The view references prd, and rspper tables whose defintions are shown >below. OK, I f

Re: [BUGS] Possible problem with pg_get_viewdef on Postgres V8.0.0 rc4

2005-01-13 Thread laurie . burrow
Tom Lane wrote: > Could we see a full example? The view definition is of little use when > you didn't provide the definitions of the tables it references. Mea Culpa! The view references prd, and rspper tables whose defintions are shown below. I've included the gennme table as it i

Re: [BUGS] Possible problem with pg_get_viewdef on Postgres V8.0.0 rc4

2005-01-13 Thread Tom Lane
[EMAIL PROTECTED] writes: > The cause of the pgadmin failure appears to be a call to > pg_get_viewdef(c.oid, true) used by pgadmin to populate its view display. > This function applied to my view works correctly on Postgres 7 but > generates the error Bogus Varno: 3 > in Postgres 8. Could we see a