pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedSolution! (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>
2004-02-27 17:25 ` Re: Solution! (was: Re: Linux (Debian Woody)...) Peter Eisentraut <peter_e@gmx.net>
2004-06-09 00:07 ` Re: Solution! (was: Re: Linux (Debian Woody)...) Stephan Szabo <sszabo@megazone.bigpanda.com>
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: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>
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-02-27 17:13 Solution! (was: Re: Linux (Debian Woody)...) Phillip R. aka Qbert <Qbert@t-online.de>
@ 2004-06-09 00:07 ` Stephan Szabo <sszabo@megazone.bigpanda.com>
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