Disabling constraints in PostgreSQL?
Posted on 2006-07-11
We are converting a data import application from Oracle to PostgreSQL and are having some issues with functionality in Oracle that's missing in PostgreSQL.
In Oracle, we do the following simple bit to disable constraints: ALTER TABLE $table DISABLE CONSTRAINT $constraint
But in PostgreSQL, we can find no functional equivalent.
You can drop constraints and re-add them of course, but this is very inefficient.