Re: [pgadmin-support] ERROR: Relation "pg_relcheck" does not exist

[Dave Page]

Title: Message

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:[EMAIL PROTECTED] Sent: 16 June 2003 11:25 To: Dave Page; [EMAIL PROTECTED] 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:[EMAIL PROTECTED] Gesendet: Montag, 16. Juni 2003 12:11 An: Christian Brosig; [EMAIL PROTECTED] 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:[EMAIL PROTECTED] Sent: 16 June 2003 10:35 To: [EMAIL PROTECTED] 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 [EMAIL PROTECTED])   Thanks.   Christian Brosig