There is a known 4.5++ bug with custom messages on constraints. Basically, don't do it. If you have any constraints with custom messages, drop the constraints and recreate them without messages. Here is how I would approach the fix:
Copy the database for safety ALTER TABLE POL DROP CONSTRAINT #32 for all the bad ones. RELOAD POL2 ALTER TABLE POL ADD PRIMARY KEY (colName) [EMAIL PROTECTED] wrote: > >Hi: > >Can somebody give me some direction solving an index problem? �I expect to >work on this over the week-end. �A reload does not seem �to work. > >Ran autochk on a 4.5++ database and received messages on several tables as >follows: > >"Examining �table POL > �"Index: � � � ppdate > �"Primary Key #32 > � �"A Pramary [sic] Key was found in a table not known to have a Primary Key > � � �"An index entry contains invalid columns > � �"A foreign key is referencing the wrong table" > >All messages are referencing primary key #32. > >Any advice appreciated. �Many thanks. > >Paul Hill > >================================================ >TO SEE MESSAGE POSTING GUIDELINES: >Send a plain text email to [EMAIL PROTECTED] >In the message body, put just two words: INTRO rbase-l >================================================ >TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] >In the message body, put just two words: UNSUBSCRIBE rbase-l >================================================ >TO SEARCH ARCHIVES: >http://www.mail-archive.com/rbase-l%40sonetmail.com/ > -- Albert Berry Full Time Consultant to PSD Solutions 350 West Hubbard, Suite 210 Chicago, IL 60610 312-828-9253 Ext. 32 __________________________________________________________________ The NEW Netscape 7.0 browser is now available. Upgrade now! http://channels.netscape.com/ns/browsers/download.jsp Get your own FREE, personal Netscape Mail account today at http://webmail.netscape.com/ ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/
