Skip site navigation (1) Skip section navigation (2)


From: "Claude Chaloux" <claude(dot)chaloux(at)abovesecurity(dot)com>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: DEFERABLE vs. NOT DEFERABLE constraints
Date: 2007-07-24 18:15:53
Message-ID: 296BA253DC260F4092A342475EECCD2730E0C3@asdc003.abovesecurite.lan (view raw, whole thread or download thread mbox)
Lists: pgsql-novice


I will be switching from PostgreSQL 7.4 to 8.2 operationally. So far, the transition goes smoothly but one thing is giving me headache when trying to make some pieces of code work on my newer version of PSQL, especially the code of one very simple function. 


Basically, the function inserts a row in a table (in the database I'm testing with) that has a reference (foreign key set) to another table. Under 7.4, I have no problem inserting the rows in the two tables even when inserting in the table which column is being referenced first. On 8.2 however, I get an error message "constraint violation". 


I know that the later version does things well/better but I don't get it - the 2 documentations (7.4 & 8.2) say the same thing about DEFERABLE and NOT DEFERABLE on a table's constraint. Also, I'm pretty sure that all the settings in Postgres.conf are the same on the 2 databases but I might be missing something... 


Was there a bug in 7.4 that was allowing my old code to work or is there a switch somewhere I'm missing?

Thanks for all your help, regards!


Claude Chaloux

Analyste "Q&A / R&D" Analyst


Above Sécurity Montréal ( <> )

--> 1919 boul. Lionel-Bertrand suite 203, Boisbriand, Qc, J7H 1N8          

450.430.8166 ext: 2115 

claude(dot)chaloux(at)abovesecurite(dot)com <mailto:claude(dot)chaloux(at)abovesecurite(dot)com> 



pgsql-novice by date

Next:From: Stephan SzaboDate: 2007-07-24 19:12:46
Subject: Re: DEFERABLE vs. NOT DEFERABLE constraints
Previous:From: Tom LaneDate: 2007-07-24 14:33:29
Subject: Re: How to optimize insert statements ?

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group