Re: One solution for Packages in Postgre - Mailing list pgsql-general

From Dimitri Fontaine
Subject Re: One solution for Packages in Postgre
Date
Msg-id 87pr42rj39.fsf@hi-media-techno.com
Whole thread Raw
In response to One solution for Packages in Postgre  (venkatrao.b@tcs.com)
List pgsql-general
venkatrao.b@tcs.com writes:
> I am new to Postgre. We are migrating an oracle db to postgre. In
> oracle we have used so many packages.  As per my understanding, there
> is no oracle package like functionality in postgre. I was just trying
> to find some way to migrate ocale packages to postgre.

This has been discussed already in the past, see the archives. In short,
Oracle Packages are not something the PostgreSQL community intend to
offer directly, even if we have some plans to provide better tools for
managing what we have and call "extensions".

The following shows the current state of the design, the code is yet to
be written, and that could happen this very year (it obviously missed
9.0).

  http://wiki.postgresql.org/wiki/ExtensionPackaging

You will note that this document refers to C-coded extensions, but is
compatible with an extension not containing one of those. It could well
be that the feature you're missing is offered by this design.

Regards,
--
dim

pgsql-general by date:

Previous
From: Yeb Havinga
Date:
Subject: Re: Trying to add a type modifier to user created type
Next
From: venkatrao.b@tcs.com
Date:
Subject: Re: One solution for Packages in Postgre