Re: schema support, was Package support for Postgres - Mailing list pgsql-hackers

From Gunnar Rønning
Subject Re: schema support, was Package support for Postgres
Date
Msg-id m2bsj3k7dx.fsf@smaug.polygnosis.com
Whole thread Raw
In response to Re: schema support, was Package support for Postgres  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: schema support, was Package support for Postgres
List pgsql-hackers
* Tom Lane <tgl@sss.pgh.pa.us> wrote:
|
| > resources as well that should not conflict with other packages, like temp
| > tables or such. It then seems to me that using schemas can solve everything 
| > that packages do and more ?
| 
| Yeah.  I am wondering whether we couldn't support Oracle-style packages
| as a thin layer of syntactic sugar on top of schemas.  I am concerned
| about the prospect that "foo.bar" might mean either "object bar in
| schema foo" or "object bar in package foo".

Agreed, and in Sybase you may declare a procedure in a schema(or 
database which is the Sybase term). If you want it global you declare it
in the "master" schema. 

-- 
Gunnar Rønning - gunnar@polygnosis.com
Senior Consultant, Polygnosis AS, http://www.polygnosis.com/


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: schema support, was Package support for Postgres
Next
From: Oleg Bartunov
Date:
Subject: permissions problem at hub.org !