Alexander Farber <[EMAIL PROTECTED]> writes: > Hello, > > I've created a user and a database both wrongly named "phpbb". > After that I have renamed both to "punbb" using "ALTER DATABASE" > and "ALTER USER". Now everything works fine, except I always > have to specify the database when connecting (both using psql or > the PQconnectdb() from my C-program): > > h754814:afarber {103} psql -U punbb > psql: FATAL: database "phpbb" does not exist
psql uses your Unix username as the default database if you don't specify one. -Doug ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match