Re: Tablespace patch review - Mailing list pgsql-patches

From Andreas Pflug
Subject Re: Tablespace patch review
Date
Msg-id 40D37259.3030000@pse-consulting.de
Whole thread Raw
In response to Re: Tablespace patch review  (Gavin Sherry <swm@linuxworld.com.au>)
List pgsql-patches
Gavin Sherry wrote:

>I would debate that.
>
>Firstly, tablespaces aren't supported on windows yet.
>
Just a matter of time. And I'm talking of win32 workstations connecting
to *ix servers too.

> Secondly, I'd think
>that Unix users would be fine with a command line tool, especially one
>that can connect to a remote host.
>
>For those not used to command line tools, I can imagine extensions to
>pgadmin or phppgadmin.
>
>
>

:-) :-) :-)

Unfortunately, us admin tool programmers can't practice witchcraft, so
we need a pgsql function for that...
Certainly, we could iterate all known databases making a one-time
connection (if allowed to connect, what about template0?), retrieving
tablespace dependencies, and close again. As debated above, that's quite
costly, especially if more sophisticated authentication mechanisms are used.


Regards,
Andreas



pgsql-patches by date:

Previous
From: Tom Lane
Date:
Subject: Re: Nested transactions
Next
From: Tom Lane
Date:
Subject: Re: Tablespace patch review