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

(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