Re: Oracle Style packages on postgres - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Oracle Style packages on postgres
Date
Msg-id 18980.1115844592@sss.pgh.pa.us
Whole thread Raw
In response to Re: Oracle Style packages on postgres  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: Oracle Style packages on postgres  ("Jim C. Nasby" <decibel@decibel.org>)
List pgsql-hackers
Bruce Momjian <pgman@candle.pha.pa.us> writes:
> How is a catalog different from a schema?

In the spec there's a hard-wired difference: catalogs contain schemas,
schemas don't contain other schemas.  The idea at hand here is to make
our namespaces serve both purposes.  (I knew there was a good reason
not to use the word "schema" for namespaces ;-))  The spec behavior
would be met by using exactly two levels of namespace, but there
wouldn't be anything stopping people from using more, except that their
queries wouldn't look like spec-compatible queries.

There are a number of issues that would have to be solved to make this
actually work, but on first glance it seems like a possibly attractive
idea.

Besides, I can't wait to hear the moans from the newsysviews crew when
the implications of this sink in ;-) ;-)
        regards, tom lane


pgsql-hackers by date:

Previous
From: Andrew Sullivan
Date:
Subject: Re: Server instrumentation for 8.1
Next
From: "Jim C. Nasby"
Date:
Subject: Re: Server instrumentation for 8.1