Re: Oracle Style packages on postgres

From: Rod Taylor <pg(at)rbt(dot)ca>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Dave Held <dave(dot)held(at)arraysg(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Oracle Style packages on postgres
Date: 2005-05-11 19:46:19
Message-ID: 1115840779.725.38.camel@home
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Wed, 2005-05-11 at 15:41 -0400, Rod Taylor wrote:
> > There are some nontrivial issues to be thought about here, like under
> > what conditions "CREATE SCHEMA foo" ought to create a top-level schema
> > versus creating a schema under some other schema that we are pretending
> > is the active "catalog". But it seems on first glance like something
> > could be worked out.
>
> Just go the extra info and call the top level catalogs in the commands

Extra inch, not info.

> as well:
>
> CREATE DATABASE mydb;
> \c mydb
>
> CREATE CATALOG foo;
> CREATE SCHEMA foo.bar
> CREATE TABLE foo.bar.baz (bif serial);
--

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2005-05-11 19:56:27 Re: Oracle Style packages on postgres
Previous Message Rod Taylor 2005-05-11 19:41:16 Re: Oracle Style packages on postgres