* Fabrízio de Royes Mello (fabriziome...@gmail.com) wrote: > On Wed, Jun 18, 2014 at 9:00 AM, Stephen Frost <sfr...@snowman.net> wrote: > > Not sure about that specific syntax (don't we have SET options now?) but > > I do like the general idea. > > Maybe something like that: > > CREATE TABLESPACE spcname LOCATION '/foo/bar' WITH (only_temp_relations = > true);
Yeah, that's more along the lines of what I was thinking. > Have in mind you must take care if you use ALTER TABLESPACE spcname SET > (...) to guarantee that exists only temp objects stored in the target > tablespace, and if exists a regular object you must throw an exception. > > Makes sense? Yes. I'd definitely like to see an ALTER TABLESPACE option, with an ERROR that lists out all of the non-temporary objects which are found (and lists any other databases which have objects in those tablespaces..). That would allow administrators who have existing notionally temporary-only tablespaces to go clean things up to make them actually temporary-only. Thanks, Stephen
signature.asc
Description: Digital signature