Typos in RT3.0.7 UPGRADING

Two typos in the Postgres section of the UPGRADING file of rt-3.0.7

The line:
UPDATE groups SET instance = instance1::text::int where btrim(instance) <> ‘’
Should be:
UPDATE groups SET instance = instance1::text::int where btrim(instance1) <> ‘’;

Note the instance1 in the btrim call and the semicolon on the end.
This seems to have the desired effect of changing the type of the
instance field from text to integer.

Ted Cabeen http://www.pobox.com/~secabeen ted@impulse.net
Check Website or Keyserver for PGP/GPG Key BA0349D2 secabeen@pobox.com
“I have taken all knowledge to be my province.” -F. Bacon secabeen@cabeen.org
“Human kind cannot bear very much reality.”-T.S.Eliot cabeen@netcom.com

Fixed. 3.0.7_01 released. thanks.On Mon, Nov 17, 2003 at 05:22:44PM -0800, Ted Cabeen wrote:

Two typos in the Postgres section of the UPGRADING file of rt-3.0.7

The line:
UPDATE groups SET instance = instance1::text::int where btrim(instance) <> ‘’
Should be:
UPDATE groups SET instance = instance1::text::int where btrim(instance1) <> ‘’;

Note the instance1 in the btrim call and the semicolon on the end.
This seems to have the desired effect of changing the type of the
instance field from text to integer.


Ted Cabeen http://www.pobox.com/~secabeen ted@impulse.net
Check Website or Keyserver for PGP/GPG Key BA0349D2 secabeen@pobox.com
“I have taken all knowledge to be my province.” -F. Bacon secabeen@cabeen.org
“Human kind cannot bear very much reality.”-T.S.Eliot cabeen@netcom.com


rt-users mailing list
rt-users@lists.fsck.com
http://lists.fsck.com/mailman/listinfo/rt-users

Have you read the FAQ? The RT FAQ Manager lives at http://fsck.com/rtfm

Request Tracker... So much more than a help desk — Best Practical Solutions – Trouble Ticketing. Free.