RE: AW: Big 7.1 open items

From: "Hiroshi Inoue" <Inoue(at)tpf(dot)co(dot)jp>
To: "Zeugswetter Andreas SB" <ZeugswetterA(at)wien(dot)spardat(dot)at>
Cc: "PostgreSQL-development" <pgsql-hackers(at)postgresql(dot)org>
Subject: RE: AW: Big 7.1 open items
Date: 2000-06-29 08:21:57
Message-ID: 000101bfe1a3$172b5d60$2801007e@tpf.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

> -----Original Message-----
> From: pgsql-hackers-owner(at)hub(dot)org [mailto:pgsql-hackers-owner(at)hub(dot)org]On
> Behalf Of Zeugswetter Andreas SB
>
> > > > AFAIK,schema is independent from user in SQL92.
> > > > So default_tablespace_per_user doesn't necessarily imply
> > > > default_tablespace_per_schema.
> > >
> > > Well, sombody must be interpreting this wrong, because
> > > in Informix and Oracle the schema corresponds to the owner
> > > and they say they conform to ansi in this regard.
> >
> > Is there really a schema:user=1:1 limitation in SQL-92 ?
> > Though both SQL-86 and SQL-89 had the limitation
> > SQL-92 removed it AFAIK.
>
> As I said in another posting a user does not need to exist
> for each schema. The dba can create objects under any
> schema name.
>

Sorry for my poor understanding.
What I meant was that SQL92 allows the following.

schema owner
---------------------------
schema1 user1
schema2 user1
schema3 user2
schema4 user3
schema5 user3
schema6 user3

Is my understaning same as yours ?

Regards.

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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Peter Mount 2000-06-29 08:45:34 RE: AW: Big 7.1 open items
Previous Message Zeugswetter Andreas SB 2000-06-29 08:00:06 AW: AW: Big 7.1 open items