Re: ERROR: Relation "pg_relcheck" does not exist

From: "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk>
To: "Christian Brosig" <Brosig(at)dataconsult(dot)de>, <pgadmin-support(at)postgresql(dot)org>
Subject: Re: ERROR: Relation "pg_relcheck" does not exist
Date: 2003-06-16 10:34:16
Message-ID: 03AF4E498C591348A42FC93DEA9661B844B078@mail.vale-housing.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

Wow, that is odd. It seems to be running the 7.2 query on your 7.3 database (this is 7.3.x isn't it?). What comes out of psql on the server if you run:

SELECT version();

(exactly, don't change any dot's of commas or anything)

Regards, Dave.

-----Original Message-----
From: Christian Brosig [mailto:Brosig(at)dataconsult(dot)de]
Sent: 16 June 2003 11:25
To: Dave Page; pgadmin-support(at)postgresql(dot)org
Subject: AW: [pgadmin-support] 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=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(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

Browse pgadmin-support by date

  From Date Subject
Next Message Marcel de Vries 2003-06-16 11:50:41 Error Message
Previous Message Christian Brosig 2003-06-16 10:25:07 Re: ERROR: Relation "pg_relcheck" does not exist