RE: Big 7.1 open items - Mailing list pgsql-hackers

From Hiroshi Inoue
Subject RE: Big 7.1 open items
Date
Msg-id EKEJJICOHDIEMGPNIFIJIEDDCCAA.Inoue@tpf.co.jp
Whole thread Raw
In response to Re: Big 7.1 open items  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses RE: Big 7.1 open items
List pgsql-hackers
> -----Original Message-----
> From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
> 
> Bruce Momjian <pgman@candle.pha.pa.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
considertablespace 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@tpf.co.jp 


pgsql-hackers by date:

Previous
From: Brook Milligan
Date:
Subject: table permissions and referential integrity
Next
From: The Hermit Hacker
Date:
Subject: Re: OK, OK, Hiroshi's right: use a seperately-generated filename