RE: [HACKERS] [hackers]development suggestion needed

> -----Original Message-----
> From: owner-pgsql-hackers(at)postgreSQL(dot)org
> [mailto:owner-pgsql-hackers(at)postgreSQL(dot)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 prefer
create 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(at)tpf(dot)co(dot)jp