My problems were in 9.1 (64) 4.10 release. It only happened in my large DB (but several times), I couldn't replicate in Concomp.
From: [email protected] [mailto:[email protected]] On Behalf Of Bill Downall Sent: Wednesday, May 02, 2012 1:45 PM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Constraint troubleshooting? Kenny, I'll reconfirm: all tables with the broken PK's-without-reference were tables that had been altered. The database continued to "work", but performance was sometimes poor. And I am pretty sure that all of the alterations had been done in R:BASE 8.0 Turbo. I do not believe I have ever seen this in 9.1, certainly not in the past 8 to 12 months. Bill On Wed, May 2, 2012 at 2:20 PM, Kenny Camp <[email protected]> wrote: I experienced this issue several times recently and in my case it was caused by altering a table. I'm having trouble figuring out why this is happening in order to demonstrate to others, but to avoid the problem, whenever I plan to alter tables I unload structure and data separately, then cut the structure file into two pieces. One to build all the tables and a second to add constraints (and the other stuff below the first create index statement).
