Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

		 

		 

pgadmin-support by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group