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

Re: BUG #4222: ERROR: cache lookup failed for relation

From: "Heikki Linnakangas" <heikki(at)enterprisedb(dot)com>
To: "Parag Goyal" <paragosho(at)gmail(dot)com>
Cc: <saurav(dot)kumar(at)barco(dot)com>,"PostgreSQL Bugs" <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: BUG #4222: ERROR: cache lookup failed for relation
Date: 2008-06-06 05:49:38
Message-ID: 4848CFF2.5060606@enterprisedb.com (view raw or flat)
Thread:
Lists: pgsql-bugs
(please keep the mailing list CC'd)

Parag Goyal wrote:
> As i told earlier some how i got stuck ,so  i was dropping the
> database but "eventregistration" table was not deleted due to "ERROR: Cache
> lookup failed for relation " .
> but after ward i check with defferent queries (select,insert also) on same
> table "eventregistration" , but these queries also were giving same error
> "ERROR: Cache lookup failed for relation".
> moreover as per your suggestion i tried to drop database"postgres" (because
> my appliction using default database "postgres" only) using postgresAdmin
> tool  but this is also not possible and returning back the message
> "maintenance database can't be dropped". Now I think, i have only option
> left  with me reinstall the postgres again on my system.

Ah, I see, pgAdmin doesn't let you drop "postgres" database. You could 
still recreate it from the command line with psql:

psql template1 -c "DROP DATABASE postgres"
psql template1 -c "CREATE DATABASE postgres"

-- 
   Heikki Linnakangas
   EnterpriseDB   http://www.enterprisedb.com

In response to

pgsql-bugs by date

Next:From: gildas primeDate: 2008-06-06 08:26:01
Subject: Re: BUG #4108: PgInstaller Update modify install paths in Registry
Previous:From: Gregory StarkDate: 2008-06-05 23:50:18
Subject: Re: BUG #4198: The bugreport form has an encoding problem

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