Postgres Pro
Downloads
Home   >   mailing lists

Thread: sessionVariables=FOREIGN_KEY_CHECKS=0

sessionVariables=FOREIGN_KEY_CHECKS=0

From
"Badawy, Mohamed"
Date:

Hi All

 

 

Am working in a project & want to migrate our work from mysql to postgress we used dbunit to test & when we used to get the connection the url was like this

 

jdbc:mysql://localhost:3306/testDB?sessionVariables=FOREIGN_KEY_CHECKS=0

 

but the forigen key checks is not working with postgres. Any idea ???

 

thnx for any reply

 

 

Best Regards,,,

 

Mohamed Badawy

 

Re: sessionVariables=FOREIGN_KEY_CHECKS=0

From
Dave Cramer
Date:

On 19-Jul-07, at 5:46 AM, Badawy, Mohamed wrote:

Hi All

 

 

Am working in a project & want to migrate our work from mysql to postgress we used dbunit to test & when we used to get the connection the url was like this

 

jdbc:mysql://localhost:3306/testDB?sessionVariables=FOREIGN_KEY_CHECKS=0

 

but the forigen key checks is not working with postgres. Any idea ???


Yes, you can't disable them like that in postgresql, you'd have to drop the referential checks in sql first.

 

thnx for any reply

 

 

Best Regards,,,

 

Mohamed Badawy