RE: [HACKERS] [hackers]development suggestion needed

> -----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