What does the DEFERRABLE INITIALLY DEFERRED constraint option do in PostgreSQL?

Advanced SQL Developer Hard

Advanced SQL Developer — Hard

What does the DEFERRABLE INITIALLY DEFERRED constraint option do in PostgreSQL?

Key points

  • DEFERRABLE INITIALLY DEFERRED delays checking until transaction end
  • Helps maintain consistency across multiple statements
  • Ensures constraints are validated at the end of the transaction

Ready to go further?

Start full exam Practice more questions

Related questions