Silence with_deferred_fk_checks() warning on PostgreSQL 9.4
authorDagfinn Ilmari Mannsåker <ilmari@ilmari.org>
Sat, 18 Oct 2014 17:31:43 +0000 (18:31 +0100)
committerDagfinn Ilmari Mannsåker <ilmari@ilmari.org>
Sat, 18 Oct 2014 17:45:20 +0000 (18:45 +0100)
commit2131aa2eac548e0b10325b97c10d22a61fffd9c9
tree21e19f53f88581c849a9258adaf694fa7257e105
parent1af6b9688df2a5474d08c04419518cb3cb8656d9
Silence with_deferred_fk_checks() warning on PostgreSQL 9.4

SET CONSTRAINTS can only be used in transaction blocks, and 9.4 warns
about this, so make sure we issue 'SET CONSTRAINTS ALL IMMEDIATE' before
committing the transaction.

Also fix it for Informix, which uses the same syntax and has the same
restriction.
Changes
lib/DBIx/Class/Storage/DBI/Informix.pm
lib/DBIx/Class/Storage/DBI/Pg.pm
t/72pg.t