Re: Tablespace patch review - Mailing list pgsql-patches

From Tom Lane
Subject Re: Tablespace patch review
Date
Msg-id 4476.1087600435@sss.pgh.pa.us
Whole thread Raw
In response to Re: Tablespace patch review  (Andreas Pflug <pgadmin@pse-consulting.de>)
Responses Re: Tablespace patch review  (Andreas Pflug <pgadmin@pse-consulting.de>)
List pgsql-patches
Andreas Pflug <pgadmin@pse-consulting.de> writes:
> IMHO checking objects in a tablespace is a routine administrative task,
> so it should be supported natively by the server without need of
> contribs.

I strongly disagree.  Dropping a tablespace is not a routine activity,
and we don't have to have submillisecond response to operations that
are only needed when your first attempt to drop one fails.

As for the authentication-is-expensive issue, what of it?  You *should*
have to authenticate yourself in order to look inside another person's
database.  The sort of cross-database inspection being proposed here
would be a big security hole in many people's view.

> And for win user acceptance, a command line tool won't be
> sufficient either.

This does not deserve a response.

            regards, tom lane

pgsql-patches by date:

Previous
From: Andreas Pflug
Date:
Subject: Re: Tablespace patch review
Next
From: Oliver Jowett
Date:
Subject: Re: Nested transactions