Re: ERROR: Relation "pg_relcheck" does not exist - Mailing list pgadmin-support

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=5432;UID=postgres;PWD=********;READONLY=0;PROTOCOL=6.4;FAKEOIDINDEX=0;SHOWOIDCOLUMN=0;ROWVERSIONING=0;SHOWSYSTEMTABLES=0;CONNSETTINGS=;FETCH=100;SOCKET=4096;UNKNOWNSIZES=0;MAXVARCHARSIZE=254;MAXLONGVARCHARSIZE=65536;DEBUG=0;COMMLOG=0;OPTIMIZER=1;KSQO=1;USEDECLAREFETCH=0;TEXTASLONGVARCHAR=1;UNKNOWNSASLONGVARCHAR=1;BOOLSASCHAR=1;PARSE=0;CANCELASFREESTMT=0;EXTRASYSTABLEPREFIXES=dd_"

Thanks for any help,

Christian

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

-----Original Message-----
From: Christian Brosig [mailto:Brosig@dataconsult.de]
Sent: 16 June 2003 10:35
To: pgadmin-support@postgresql.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@dataconsult.de)

 

Thanks.

 

Christian Brosig