Re: collab-qa: udd/sql/debvercmp.sql (Was: UDD and DEHS)
Adeodato Simó schrieb am Saturday, den 07. March 2009:
Hi,
> * 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.
Good news: since DSA requested the package it is already accepted in lenny
bpo regardless of the NEW queue.
Alex
Reply to: