(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"
In response to
pgsql-bugs by date
|Next:||From: gildas prime||Date: 2008-06-06 08:26:01|
|Subject: Re: BUG #4108: PgInstaller Update modify install paths in Registry|
|Previous:||From: Gregory Stark||Date: 2008-06-05 23:50:18|
|Subject: Re: BUG #4198: The bugreport form has an encoding problem|