I have a foreign key constraint that I created to reference the primary key of another table:<BR><BR><pre class="ip-ubbcode-code-pre">constraint geneassay_fk foreign ...

I assume you want to delete referential data without worrying about deleting it in just the right order to preserve references in intermediate steps. I wouldn't drop and add a foreign key just to ...