Re: collab-qa: udd/sql/debvercmp.sql (Was: UDD and DEHS)
* 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
Reply to: