(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 -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
