On Wed, Jun 28, 2000 at 02:07:33PM +0200, Zeugswetter Andreas SB wrote:
> > 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.
To quote from the SQL92 standard for CERATE SCHEMA:
<schema definition> ::=
CREATE SCHEMA <schema name clause>
[ <schema character set specification> ]
[ <schema element>... ]
<schema name clause> ::=
| AUTHORIZATION <schema authorization identifier>
| <schema name> AUTHORIZATION <schema authorization identifier>
1) If <schema name> is not specified, then a <schema name> equal to
<schema authorization identifier> is implicit.
2) If AUTHORIZATION <schema authorization identifier> is not speci-
a) If the <schema definition> is contained in a <module> that
has a <module authorization identifier> specified, then an
<authorization identifier> equal to that <module authoriza-
tion identifier> is implicit for the <schema definition>.
b) Otherwise, an <authorization identifier> equal to the SQL-
session <authorization identifier> is implicit.
So, we see that the SQL92 default fora schema is the session username.
> In both, a user can access other schemas or switch to another
> schema, so in that sense you could say that the schema is
> independent of users.
Not only in a sense, it is in fact.
> This will definitely be a problem because of our current nested dot
> interpretation towards functions taking one opaque or _class_type
Right. If we're going to support SQL92 dot notation (which I think we
should) we'll either need to lose the function notion completely, or
come up with some really clever hack about applying them in order.
Ross J. Reedstrom, Ph.D., <reedstrm(at)rice(dot)edu>
NSBRI Research Scientist/Programmer
Computer and Information Technology Institute
Rice University, 6100 S. Main St., Houston, TX 77005
In response to
pgsql-hackers by date
|Next:||From: Tom Lane||Date: 2000-06-28 17:04:27|
|Subject: Misc. consequences of backend memory management changes|
|Previous:||From: Karel Zak||Date: 2000-06-28 16:49:47|
|Subject: Re: MySQL has gone GPL|