Forum OpenACS Development: Response to Overview of InterBase's limitations

Collapse
Posted by Sebastian Skracic on
  • Adding referential constraints only possible in single-user mode

    Yes, unfortunately, it's true. You cannot

    ALTER TABLE my_table ADD/DROP CONSTRAINT ... REFERENCES other_table
    
    while there's someone else accessing your database. You'll receive friendly "Statement failed, SQLCODE = -607 unsuccessful metadata update -object OTHER_TABLE is in use". This is still true for 6.0.