Re: sessionVariables=FOREIGN_KEY_CHECKS=0 - Mailing list pgsql-jdbc

From Dave Cramer
Subject Re: sessionVariables=FOREIGN_KEY_CHECKS=0
Date
Msg-id 02ECFD52-6819-4776-8E41-59C7693C66BF@fastcrypt.com
Whole thread Raw
In response to sessionVariables=FOREIGN_KEY_CHECKS=0  ("Badawy, Mohamed" <Mohamed.Badawy@ams-europe.com>)
List pgsql-jdbc

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

 



pgsql-jdbc by date:

Previous
From: "Badawy, Mohamed"
Date:
Subject: sessionVariables=FOREIGN_KEY_CHECKS=0
Next
From: Ingmar Lötzsch
Date:
Subject: Re: IN clause with PreparedStatement