[rt-devel] [WARNING] Postgres Users should not follow UPGRADE

[Autrijus Tang]

?b 五, 2003-11-07 10:15, Jesse Vincent ?g?D?G
> Is now available. COntains a number of fixes and some minor new
> features. See the UPGRADING file for instructions about database
> updates.

WARNING TO ALL POSTGRES USERS!

This line in UPGRADING:
  UPDATE  groups SET instance = instance::text::int where btrim(instance) <> '';

has completely wrecked our Postgres RT installation, by clearing out the
"Instance" field in the Groups table.

I think Jesse means:
  UPDATE  groups SET instance = instance1::text::int where btrim(instance) <> '';

but I'm not sure.

Moreover, we did not have a timely backup available.

Do not let it happen to you!

Thanks,
/Autrijus/
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 187 bytes
Desc: =?UTF-8?Q?=E9=80=99=E6=98=AF=E6=95=B8=E4=BD=8D=E5=8A=A0=E7=B0=BD?=
	=?UTF-8?Q?=E7=9A=84=E9=83=B5?= =?UTF-8?Q?=E4=BB=B6?=
Url : http://pallas.eruditorum.org/pipermail/rt-devel/attachments/20031107/764505d5/attachment.pgp