Re: ERROR: Relation "pg_relcheck" does not exist

Hi Dave,

The log includes the following entries:

2003-06-16 12:20:03 - SQL (template1): SELECT oid, *,
pg_encoding_to_char(encoding) AS encodingname, pg_get_userbyid(datdba)
AS datowner FROM pg_database ORDER BY datname

2003-06-16 12:20:03 - SQL (mb): SELECT objoid, objsubid, description
FROM pg_description

2003-06-16 12:20:03 - SQL (mb_mdb_v2): SELECT objoid, objsubid,
description FROM pg_description

2003-06-16 12:20:05 - SQL (mb_mdb_v2): SELECT * FROM pg_class WHERE
relname = 'pgadmin_rclog'

2003-06-16 12:20:06 - SQL (mb_mdb_v2): SELECT now() AS ts, oid, relname,
pg_get_userbyid(relowner) as tableowner, relacl, relhasoids FROM
pg_class WHERE ((relkind = 'r') OR (relkind = 's')) ORDER BY relname

2003-06-16 12:20:09 - SQL (mb_mdb_v2): SELECT count(*) AS rows FROM
"adresse"

2003-06-16 12:20:09 - SQL (mb_mdb_v2): SELECT c.relname FROM pg_class c,
pg_inherits i WHERE c.oid = i.inhparent AND i.inhrelid = 2863967 ORDER
BY inhseqno

2003-06-16 12:20:09 - SQL (mb_mdb_v2): SELECT 0::oid AS oid, a.attname,
a.attnum, t.typname, CASE WHEN ((a.attlen = -1) AND ((a.atttypmod)::int4
= (-1)::int4)) THEN (0)::int4 ELSE CASE WHEN a.attlen = -1 THEN CASE
WHEN ((t.typname = 'bpchar') OR (t.typname = 'char') OR (t.typname =
'varchar')) THEN (a.atttypmod -4)::int4 ELSE (a.atttypmod)::int4 END
ELSE (a.attlen)::int4 END END AS length, a.attnotnull, (SELECT adsrc
FROM pg_attrdef d WHERE d.adrelid = a.attrelid AND d.adnum = a.attnum)
AS default, (SELECT indisprimary FROM pg_index i, pg_class ic,
pg_attribute ia WHERE i.indrelid = a.attrelid AND i.indexrelid = ic.oid
AND ic.oid = ia.attrelid AND ia.attname = a.attname LIMIT 1) AS
primarykey FROM pg_attribute a, pg_type t WHERE a.atttypid = t.oid AND
attrelid = 2863967 ORDER BY attnum

2003-06-16 12:20:09 - SQL (mb_mdb_v2): SELECT now() AS ts, i.oid,
i.relname, x.indisunique, x.indisprimary, pg_get_indexdef(i.oid) AS
definition FROM pg_index x, pg_class i WHERE i.oid = x.indexrelid AND
indrelid = 2863967 ORDER BY relname

2003-06-16 12:20:09 - SQL (mb_mdb_v2): SELECT attname FROM pg_attribute
WHERE attrelid = 2863973 ORDER BY attnum

2003-06-16 12:20:09 - SQL (mb_mdb_v2): SELECT rcname, rcsrc FROM
pg_relcheck WHERE rcrelid = 2863967 ORDER BY rcname

2003-06-16 12:20:09 -
*******************************************************************

2003-06-16 12:20:09 - Error

2003-06-16 12:20:09 -
*******************************************************************

2003-06-16 12:20:09 - Error in pgAdmin II:frmMain.tvTable: -2147467259 -
Error while executing the query;

ERROR: Relation "pg_relcheck" does not exist

2003-06-16 12:20:09 - Windows Version: Windows XP v5.1 build 2600
Service Pack 1

2003-06-16 12:20:09 - pgSchema Version: 1.2.0

2003-06-16 12:20:09 - MDAC Version: 2.7

2003-06-16 12:20:09 - DBMS Version: 07.01.0009 PostgreSQL 7.3.2 on
i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.3 20030226 (prerelease)
(SuSE Linux)

2003-06-16 12:20:09 - Connection String (Master Connection):
Provider=MSDASQL.1;Extended
Properties="DRIVER={PostgreSQL};DATABASE=template1;SERVER=tanne;PORT=543
2;UID=postgres;PWD=********;READONLY=0;PROTOCOL=6.4;FAKEOIDINDEX=0;SHOWO
IDCOLUMN=0;ROWVERSIONING=0;SHOWSYSTEMTABLES=0;CONNSETTINGS=;FETCH=100;SO
CKET=4096;UNKNOWNSIZES=0;MAXVARCHARSIZE=254;MAXLONGVARCHARSIZE=65536;DEB
UG=0;COMMLOG=0;OPTIMIZER=1;KSQO=1;USEDECLAREFETCH=0;TEXTASLONGVARCHAR=1;
UNKNOWNSASLONGVARCHAR=1;BOOLSASCHAR=1;PARSE=0;CANCELASFREESTMT=0;EXTRASY
STABLEPREFIXES=dd_"

Thanks for any help,

Christian

-----Ursprüngliche Nachricht-----
Von: Dave Page [mailto:dpage(at)vale-housing(dot)co(dot)uk]
Gesendet: Montag, 16. Juni 2003 12:11
An: Christian Brosig; pgadmin-support(at)postgresql(dot)org
Betreff: RE: [pgadmin-support] ERROR: Relation "pg_relcheck" does not
exist

Hi Christian,

That's an odd one - can you please send me a Full Debug logfile showing
the error occuring? Log settings are under Tools -> Options.

Thanks, Dave.

-----Original Message-----
From: Christian Brosig [mailto:Brosig(at)dataconsult(dot)de]
Sent: 16 June 2003 10:35
To: pgadmin-support(at)postgresql(dot)org
Subject: [pgadmin-support] ERROR: Relation "pg_relcheck" does not exist

Hi,

I use postgres now for about 1 Year and i am really happy with postgres
(7.2).

I use Linux as database server and pgAdmin as frontent.

Last week I set up a new server. Included in the new linux distribution
is also a newer version of postgres (7.3.2)

I used pg_dump to export a database from the old server and to import it
to the new one.

Now there seems to be a problem.

If I click on a table (using pgAdmin) there is a pop up with then
following error message:

An error occurred in pgAdmin II: frmMain.tvTable

Description. Error while executing the query

ERROR: Relation “pg_relcheck” does not exist

What is the reason? What must I do?

I hope anyone could help me.

(Please reply also directly to Brosig(at)dataconsult(dot)de)

Thanks.

Christian Brosig