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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: laurie(dot)burrow(at)powerconv(dot)alstom(dot)com
Cc: "pgsql-bugs(at)postgresql(dot)org" <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: Possible problem with pg_get_viewdef on Postgres V8.0.0 rc4
Date: 2005-01-13 15:48:59
Message-ID: 9386.1105631339@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

laurie(dot)burrow(at)powerconv(dot)alstom(dot)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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Alexander Rodrguez 2005-01-13 17:10:30 BUG #1395: Connection
Previous Message Tom Lane 2005-01-13 15:25:56 Re: rc4 and rc3, some deleted, but still needed text in the