[72deluxe]

How does dropping the existing table and recreating it affect FKs pointing to the table that is being dropped??

Do the FK relationships get destroyed??

[kcolford]

You gotta redo the foreign key constraints in the same transaction that you rebuild the table

[72deluxe]

Oh so specify the FKs from table B to A (if we were dropping and rebuilding A) in a begin/end transaction block?

Thank you

[gwbas1c]

In my case foreign keys were enforced in the application business logic. The schema was extremely simple.