Corrupted TRG file?
am 21.12.2010 18:41:53 von Jerry Schwartz------=_NextPart_000_009D_01CBA10C.72F48CA0
Content-Type: text/plain;
charset="utf-8"
Content-Transfer-Encoding: quoted-printable
Version 5.1.31 Community (Win32)
=20
I created a trigger named TC_Products_Date_Trigger on the table =
TC_Products.
=20
I typed in=20
=20
SHOW CREATE TRIGGER tc_products_date_trigger;
=20
and this came back at me:
=20
ERROR 1602 (HY000): Corrupted TRG file for table =
`subtable_usa`.`tc_products`
=20
I almost jumped out of my skin. Then I typed in
=20
SHOW CREATE TRIGGER TC_Products_Date_Trigger;
=20
and that worked just fine. I didnâ=99t find any bug reports that =
seemed relevant, but I canâ=99t believe Iâ=99m first one to =
stumble on this.
=20
Regards,
=20
Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
=20
860.674.8796 / FAX: 860.674.8341
E-mail:
Web site:
=20
------=_NextPart_000_009D_01CBA10C.72F48CA0--