* Roger Leigh [Tue, 03 Mar 2009 00:38:11 +0000]: > So, in summary: > - DUMP YOUR DATABASE FIRST in case something screws up!! > - build and install debversion.so > - install the debversion type in your database using debversion.sql > - verify it's working as shown above > - alter your version columns type from text to debversion using > ALTER TABLE t ALTER COLUMN x TYPE debversion; > - if the column isn't already indexed, you might want to create > an index on it for speeding up SELECTs
> While the package is currently in sbuild.git, for use by > wanna-build, it's a completely independent thing, so it > would probably be best if I put this code in a separate > git repo since it's going to be used by quite a few > databases at this point. Just to keep this list posted in case somebody is reading along, Roger has split the PostgreSQL debversion code into a separate repository [1], and has created packages which are in NEW at the moment [2], and which should be available for lenny-backports as well soon. I think the UDD guys are on top of this, but after the packages are in bpo, DSA can easily make the type available in any debian.org PostgreSQL database (and you can of course use it for your databases in other places ;-). Thanks, Roger! [1]: http://git.debian.org/?p=buildd-tools/postgresql-debversion.git;a=summary [2]: http://ftp-master.debian.org/new/postgresql-debversion_1.0.0-1.html -- Adeodato Simó dato at net.com.org.es Debian Developer adeodato at debian.org Listening to: Alanis Morissette - Surrendering -- To UNSUBSCRIBE, email to debian-qa-requ...@lists.debian.org with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org
