pgadmin Bogus Varno: 3

From: laurie(dot)burrow(at)powerconv(dot)alstom(dot)com
To: pgadmin-support(at)postgresql(dot)org
Subject: pgadmin Bogus Varno: 3
Date: 2005-01-11 10:23:37
Message-ID: OF8647D3AE.7C5D099C-ON80256F85.006293EF-80256F86.0039358B@transport.alstom.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

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 Postgres v7 that is working well with all
versions of pgadmin.

I have backed up the Postgres 7 database data schema as plain text and
restored it on the Postgres 8 server. There were no restore errors. However
when I try to view the database using Pgadmin I get error Bogus Varno: 3.
Visually the Pgadmin display tree is showing everything down to the views,
but no views are being shown. The views can be seen in psql although I
haven't tried to look at all 55 views. Some views have rules. I tried the
same using various combinations of data schema and data compressed and
plain. They all give the same results.

In the Pgadmin log (set to log debug) the last few lines with the error are
...
...
2005-01-11 09:57:43 INFO : Creating a pgType object
2005-01-11 09:57:43 INFO : Destroying pgSet object
2005-01-11 09:57:43 INFO : Creating a pgCollection object
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_class c
LEFT OUTER JOIN pg_description des ON (des.objoid=c.oid and
des.objsubid=0)
WHERE ((c.relhasrules AND (EXISTS (
SELECT r.rulename FROM pg_rewrite r
WHERE ((r.ev_class = c.oid)
AND (bpchar(r.ev_type) = '1'::bpchar)) ))) OR (c.relkind
= 'v'::char))
AND relnamespace = 2200::oid
ORDER BY relname
2005-01-11 09:57:43 ERROR : ERROR: bogus varno: 3

2005-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 a named recipient, please notify the
sender immediately and do not disclose the contents to another person, use
it for any purpose or store or copy the information in any medium.

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Andreas Pflug 2005-01-11 22:30:29 Re: I fixed a couple compile errors, but not all,
Previous Message Shea Martin 2005-01-11 00:20:19 I fixed a couple compile errors, but not all, help...