On Fri, 27 Feb 2004, Phillip R. aka Qbert wrote: > Am Mittwoch, 25. Februar 2004 16:49 schrieb Phillip R. aka Qbert: > >... > > I figured it's a user problem, so I thought it might be a good idea > > to drop my test-db elefant-data, and try to create a new one, this > > time making shure it'd be with the user it was intendend for - > > phillip. > > > > It was then that I found out that I couldn't either create a new or > > drop an existing database, no matter which user was logged in via > > psql. > > I found out the following: > It's not possible to delete a database when logged on to the database > server via psql. > > Shouldn't this be documented somewhere?
7.4s interactive docs for DROP DATABASE has a statement in the description, "Also, it cannot be executed while you or anyone else are connected to the target database." ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
