Hi all, I'm running a Postgres 7.3.3 and I had the necessity to rename a DB, I did this by updating the pg_database table. If I perform psql -l I'm able to see that is reported the correct name ( I guess because a select on pg_database table is performed ) but if I try to connect to the DB after the renaming I obtain the error:
psql: FATAL: Database "new_name" does not exist in the system catalog. however trying after a while ( without do nothing ) I'm able to connect to "new_name" database, is like the names of database are cached somewhere and this cache expire after a while. Any idea ? Regards Gaetano Mendola ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
