[EMAIL PROTECTED] wrote:
[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 A
[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
Please stay on the list!
[EMAIL PROTECTED] wrote:
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 definitio
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
[EMAIL PROTECTED] wrote:
I am using Pgadmin Version 1.2.0 (Nov 29 2004) as shipped with Postgres
2005-01-11 09:57:43 QUERY : Set query (localhost:5433): 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_cl
I am using Pgadmin Version 1.2.0 (Nov 29 2004) as shipped with Postgres
8.0.0 rc4 running on Windows 2000 Desktop. I have two versions of Postgres
running on Windows 2000 server. One version is Postgres 7.4.2 on cygwin,
the other is Postgres 8.0.0.rc4 native windows.
I have a large database on Pos
