> -----Original Message-----
> From: owner-pgsql-hackers@postgreSQL.org
> [mailto:owner-pgsql-hackers@postgreSQL.org]On Behalf Of Tatsuo Ishii
>
>
> BTW, it would be nice to add a "table space" concept to the create
> table statement.
>
> -- reserve a table space named 'foo' which is physically located under
> -- /pg/myspace. Only PostgreSQL super user can execute this command
> -- to avoid security risks.
> create table space foo as '/pg/myspace';
>
> -- create table t1 under /pg/myspace
> create table t1 (i int) with table space 'foo';
> --
I agree with Tatsuo though I prefercreate table t1 (i int) tablespace foo;
.
Isn't it preferable to encapsulate the table location and storage type ?
At first,a tablespace would only correspond to a directory and it won't
be so difficult to implment. But we would gain a lot with the feature.
In the future,the tablespace may be changed to mean real(??)
tablespace.
Regards.
Hiroshi Inoue
Inoue@tpf.co.jp