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

2005-01-13 Thread laurie . burrow
I have a view definition that creates a view on both Postgres 7 and Postgres 8. The view definition works OK in that it does not return an error and the resulting view seems to operate correctly on both versions of Postgres. However Pgadmin 1.2.0 works fine with the Postgres 7 database containin

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