pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Solution! (was: Re: Linux (Debian Woody)...)
3+ messages / 3 participants
[nested] [flat]

* Solution! (was: Re: Linux (Debian Woody)...)
@ 2004-02-27 17:13  Phillip R. aka Qbert <Qbert@t-online.de>
  0 siblings, 2 replies; 3+ messages in thread

From: Qbert@t-online.de @ 2004-02-27 17:13 UTC (permalink / raw)
  To: pgsql-admin

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?
Anybody from the documentation team here?

Phillip



^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: Solution! (was: Re: Linux (Debian Woody)...)
@ 2004-02-27 17:25  Peter Eisentraut <peter_e@gmx.net>
  parent: Phillip R. aka Qbert <Qbert@t-online.de>
  1 sibling, 0 replies; 3+ messages in thread

From: Peter Eisentraut @ 2004-02-27 17:25 UTC (permalink / raw)
  To: Qbert@t-online.de; pgsql-admin

Phillip R. aka Qbert wrote:
> 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?

It is.  Read the "Notes" section on this page:

http://www.postgresql.org/docs/7.4/static/sql-dropdatabase.html




^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: Solution! (was: Re: Linux (Debian Woody)...)
@ 2004-06-09 00:07  Stephan Szabo <sszabo@megazone.bigpanda.com>
  parent: Phillip R. aka Qbert <Qbert@t-online.de>
  1 sibling, 0 replies; 3+ messages in thread

From: Stephan Szabo @ 2004-06-09 00:07 UTC (permalink / raw)
  To: Phillip R. aka Qbert <Qbert@t-online.de>; +Cc: pgsql-admin


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."



^ permalink  raw  reply  [nested|flat] 3+ messages in thread


end of thread, other threads:[~2004-06-09 00:07 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-02-27 17:13 Solution! (was: Re: Linux (Debian Woody)...) Phillip R. aka Qbert <Qbert@t-online.de>
2004-02-27 17:25 ` Peter Eisentraut <peter_e@gmx.net>
2004-06-09 00:07 ` Stephan Szabo <sszabo@megazone.bigpanda.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox