#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jan 2014
    Posts
    1
    Rep Power
    0

    How to disable constraints in a db in version 9.3


    Hi,
    What is the way to disable all constraints of a database tables in version 9.3 ?
  2. #2
  3. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Oct 2013
    Posts
    158
    Rep Power
    11
    You cannot disable constraints (that would defeat their purpose), but you can change the point at which they are enforced:

    http://www.postgresql.org/docs/9.3/static/sql-set-constraints.html

IMN logo majestic logo threadwatch logo seochat tools logo