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