> At 22:12 20/06/00 -0700, Don Baccus wrote:
> >At 11:22 AM 6/21/00 +1000, Philip J. Warner wrote:
> >
> >>It may be worth considering leaving the CREATE TABLE statement alone.
> >>Dec/RDB uses a new statement entirely to define where a table goes...
> >
> >It's worth considering, but on the other hand Oracle users greatly
> >outnumber Compaq/RDB users these days...
>
> It's actually Oracle/Rdb, but I call it Dec/Rdb to distinguish it from
> 'Oracle/Oracle'. It was acquired by Oracle, supposedly because Oracle
> wanted their optimizer, management and tuning tools (although that was only
> hearsay). They *say* that they plan to merge the two products.
>
> What I was trying to suggest was that the CREATE TABLE statement will get
> very overloaded, and it might be worth avoiding having to support two
> storage management syntaxes if/when it becomes desirable to create a
> 'storage' statement of some kind.
>
Seems adding tablespace to CREATE TABLE/INDEX/DATABASE is pretty simple.
Doing it as a separate command seems cumbersome.
-- Bruce Momjian | http://www.op.net/~candle pgman@candle.pha.pa.us | (610)
853-3000+ If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill,
Pennsylvania19026