Skip site navigation (1) Skip section navigation (2)

RE: AW: Big 7.1 open items

From: Peter Mount <petermount(at)it(dot)maidstone(dot)gov(dot)uk>
To: "'Hiroshi Inoue'" <Inoue(at)tpf(dot)co(dot)jp>, 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:45:34
Message-ID: 1B3D5E532D18D311861A00600865478CF1AFCE@exchange1.nt.maidstone.gov.uk (view raw or flat)
Thread:
Lists: pgsql-hackers
The SQL7 way is the schema is the username, with the exception of "dba" -
it's used as a "global" schema.

--
Peter Mount
Enterprise Support
Maidstone Borough Council
Any views stated are my own, and not those of Maidstone Borough Council


-----Original Message-----
From: Hiroshi Inoue [mailto:Inoue(at)tpf(dot)co(dot)jp]
Sent: Thursday, June 29, 2000 9:22 AM
To: Zeugswetter Andreas SB
Cc: PostgreSQL-development
Subject: RE: AW: [HACKERS] Big 7.1 open items


> -----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 

pgsql-hackers by date

Next:From: Karel ZakDate: 2000-06-29 09:39:07
Subject: Re: Misc. consequences of backend memory management changes
Previous:From: Hiroshi InoueDate: 2000-06-29 08:21:57
Subject: RE: AW: Big 7.1 open items

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group