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).**** > >
