Re: Possible problem with pg_get_viewdef on Postgres V8.0.0 rc4 - Mailing list pgsql-bugs

From Tom Lane
Subject Re: Possible problem with pg_get_viewdef on Postgres V8.0.0 rc4
Date
Msg-id 9386.1105631339@sss.pgh.pa.us
Whole thread Raw
In response to Possible problem with pg_get_viewdef on Postgres V8.0.0 rc4  (laurie.burrow@powerconv.alstom.com)
List pgsql-bugs
laurie.burrow@powerconv.alstom.com 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 full example?  The view definition is of little use when
you didn't provide the definitions of the tables it references.

            regards, tom lane

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: rc4 and rc3, some deleted, but still needed text in the
Next
From: "Magnus Hagander"
Date:
Subject: Re: rc4 and rc3, some deleted, but still needed text in the