[EMAIL PROTECTED] wrote:
> AFAICT the function is objecting to the scalar select.
The original query definition causing the Pgadmin problem was:
CREATE OR REPLACE VIEW full_product_view AS
SELECT slimprdmgrrspperid AS _prd_slimprdmgrrspperid_,
( SELECT (rspper.lstnme::text || ' '::text) || rspp
[EMAIL PROTECTED] wrote
>> SELECT c.oid, c.relname, pg_get_userbyid(c.relowner)
>> AS viewowner, c.relacl, description, pg_get_viewdef(c.oid, true) AS
>> definition
>> FROM pg_class c
>> LEFT OUTER JOIN pg_description des ON (des.objoid=c.oid and
>> des.objsubid=0)
>> WHERE ((c.relhasrules AN
Andreas,
Here are the results of my tests
Test 1
---
This query run interactively gives ERROR: bogus varno: 3
SELECT c.oid, c.relname, pg_get_userbyid(c.relowner) AS viewowner,
c.relacl, description, pg_get_viewdef(c.oid, true) AS definition
FROM pg_class c
LEFT OUTER JOIN pg_descri
005-01-11 09:57:45 STATUS : Retrieving Schema details... (4.33 secs)
I am not sure what other information would be useful . Any help would be
most welcome.
Laurie Burrow
:.
CONFIDENTIALITY : This e-mail and any attachments are confidential and
may be privileged. If you are not
RROR: syntax error at or near ")" at character
273.
There seems to be an error caused by the reverse engineering adding the
extra bracketting on the left join clauses. If the extra brackets are
deleted the SQLis executed correctly.
Any suggestions?
Great work pgadmin, reall
