From: | Gunnar Rønning <gunnar(at)polygnosis(dot)com> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | Bill Studenmund <wrstuden(at)netbsd(dot)org>, pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: schema support, was Package support for Postgres |
Date: | 2001-10-19 14:54:18 |
Message-ID: | m2bsj3k7dx.fsf@smaug.polygnosis.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
* Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)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(at)polygnosis(dot)com
Senior Consultant, Polygnosis AS, http://www.polygnosis.com/
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2001-10-19 14:57:44 | Re: Is there no "DESCRIBE <TABLE>;" on PGSQL? help!!! |
Previous Message | Tom Lane | 2001-10-19 14:47:46 | Re: schema support, was Package support for Postgres |