Re: Status of tablespaces

hi

Dnia wto 28. stycznia 2003 16:19, Tom Lane napisał:
>
> Well, what I envision is only a cleaner reimplementation of the
> existing LOCATION facility: the DBA will be able to designate certain
> directories as tablespaces and then assign individual tables, indexes,
> etc to particular tablespaces.  Presumably, the DBA places each
> tablespace directory on a different disk (otherwise there's not much
> point in the exercise), and then the arrangement lets him control what
> lives where.
>

Does this mean (in long term) ability to:

CREATE SCHEMA xyz
   DEFAULT TABLESPACE ts_data
   INDEX TABLESPACE ts_index;
(to define place for created objects)

or

ALTER TABLE tab1 TABLESPACE ts_data1;
(to change location of datafile for 'tab1')

?

--

Mariusz Czulada
Sekcja Utrzymania Systemów Informacyjnych,
Pion Technologii i Bezpieczenstwa
TP Internet Sp. z o. o.

----------------------------------------------------------

Windows 98 is like a gun - unless it's loaded, it's harmless.