RE: Big 7.1 open items

> -----Original Message-----
> From: Tom Lane [mailto:tgl(at)sss(dot)pgh(dot)pa(dot)us]
>
> Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> writes:
> > Agreed. Seems we have several issues:
>
> > filename contents
> > tablespace implementation
> > tablespace directory layout
> > tablespace commands and syntax
>

[snip]

>
> Comments? Anything else that we do have consensus on?
>

Before the details of tablespace implementation,

1) How to change(extend) the syntax of CREATE TABLE
We only add table(data)space name with some
keyword ? i.e Do we consider tablespace as an
abstraction ?

To confirm our mutual understanding.

2) Is tablespace defined per PostgreSQL's database ?
3) Is default tablespace defined per database/user or
for all ?

AFAIK in Oracle,2) global, 3) per user.

Regards.

Hiroshi Inoue
Inoue(at)tpf(dot)co(dot)jp