Tom Lane wrote: > "Mendola Gaetano" <[EMAIL PROTECTED]> writes: > > 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. > > Try vacuuming pg_database (you can do this from any database, > it need not be the one that is having the problem).
Tom, why was a VACUUM FULL required? -- Bruce Momjian | http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend