From: | Zeugswetter Andreas SB <ZeugswetterA(at)wien(dot)spardat(dot)at> |
---|---|
To: | "'Hiroshi Inoue'" <Inoue(at)tpf(dot)co(dot)jp> |
Cc: | PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
Subject: | AW: AW: Big 7.1 open items |
Date: | 2000-06-29 08:00:06 |
Message-ID: | 219F68D65015D011A8E000006F8590C605BA59AA@sdexcsrv1.f000.d0188.sd.spardat.at |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
> > > 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.
Andreas
From | Date | Subject | |
---|---|---|---|
Next Message | Hiroshi Inoue | 2000-06-29 08:21:57 | RE: AW: Big 7.1 open items |
Previous Message | Zeugswetter Andreas SB | 2000-06-29 07:44:33 | AW: AW: Big 7.1 open items |