I just saw a post indicating that PostgreSQL Foreign Keys and Constraints are actually managed via triggers, therefore instead of doing a DROP TABLE CASCADE I could just disable triggers.
Those two things don't produce the same end result...
If so it 'feels' like there may be dangerous side effects, any thoughts on any cautions and gotcha's to this approach?
Why did you add constraints/foreign keys in the first place?