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

From Rod Taylor
Subject Re: Oracle Style packages on postgres
Date
Msg-id 1115840476.725.36.camel@home
Whole thread Raw
In response to Re: Oracle Style packages on postgres  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Oracle Style packages on postgres  (Rod Taylor <pg@rbt.ca>)
Re: Oracle Style packages on postgres  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
> 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
as well:

CREATE DATABASE mydb;
\c mydb

CREATE CATALOG foo;
CREATE SCHEMA foo.bar
CREATE TABLE foo.bar.baz (bif serial);
-- 



pgsql-hackers by date:

Previous
From: Simon Riggs
Date:
Subject: Re: Cost of XLogInsert CRC calculations
Next
From: Rod Taylor
Date:
Subject: Re: Oracle Style packages on postgres