On 10/04/11 10:59 AM, J.V. wrote:
Maybe I do not want to drop, so is there a way to simply disable all globally (not drop) & then enable all globally?
IF there was such a method (I don't think there is), to reenable the constraints would require going through every single row of every single table and verify the constraints are valid prior to enabling them. this would require global locks on each table so they didn't get updated between the time said validation starts and when the constraint is actually enabled to prevent any possibility of inconsistency from creeping in.
*OUCH* -- john r pierce N 37, W 122 santa cruz ca mid-left coast -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general