[Date Prev][Date Next] [Thread Prev][Thread Next] [Date Index] [Thread Index]

Changes to the 'debversion' PostgreSQL data type



Hi,

This is just a heads up on upcoming changes to the debversion type.
You might want to update the dak and w-b schemas for it.  With
PostgreSQL >= 9.1, database extensions such as debversion may be
installed and removed using CREATE|DROP EXTENSION and upgraded
with ALTER EXTENSION.  This functionality is added in the
postgresql-9.1-debversion package; earlier versions are unaffected.

The dak and w-b schemas create the debversion type using the
debversion.sql script.  This will create all the types and
index functions and operators etc.  This is now obsoleted in
favour of using proper extension support.  You can upgrade to
using extensions by doing:

  CREATE EXTENSION debversion FROM unpackaged;

after which all the debversion bits are controlled by the
extension facility; you can then use ALTER|DROP extension for
upgrading (ALTER EXTENSION debversion UPGRADE) and removal,
respectively.

The existing debversion.sql will continue to exist for wheezy
(it'll just be a wrapper around CREATE_EXTENSION though).  The
same applies to uninstall_debversion.sql, which will just
wrap DROP EXTENSION debversion CASCADE.


Online docs at:
http://www.pgxn.org/dist/debversion/


I guess that these changes won't need to be made immediately--I
just wanted to mention it as something to consider when upgrading
to PostgreSQL 9.1.


Regards,
Roger

-- 
  .''`.  Roger Leigh
 : :' :  Debian GNU/Linux             http://people.debian.org/~rleigh/
 `. `'   Printing on GNU/Linux?       http://gutenprint.sourceforge.net/
   `-    GPG Public Key: 0x25BFB848   Please GPG sign your mail.

Attachment: signature.asc
Description: Digital signature


Reply to: