On Sun, Mar 22, 2009 at 11:54 AM, Andrew Gierth
<andrew@tao11.riddles.org.uk> wrote:
> - want to be able to do INSTALL PACKAGE foo; without needing to
> mess with .sql files. This might default to looking for
> $libdir/foo.so, or there might be a mechanism to register packages
> globally or locally.
>
> - want to be able to do INSTALL PACKAGE foo VERSION 1; and get
> the version 1 API rather than whatever the latest is.
>
> - want to be able to do INSTALL PACKAGE foo SCHEMA bar; rather
> than having to edit some .sql file.
>
> - want to be able to do DROP PACKAGE foo;
>
> - want pg_dump to not output the definitions of any objects that
> belong to a package, but instead to output an INSTALL PACKAGE foo
> VERSION n SCHEMA x;
I think using PACKAGE is a bad idea as it'll confuse people used to
Oracle. MODULE perhaps?
--
Dave Page
EnterpriseDB UK: http://www.enterprisedb.com