| From: | Dave Cramer <pg(at)fastcrypt(dot)com> |
|---|---|
| To: | "Badawy, Mohamed" <Mohamed(dot)Badawy(at)ams-europe(dot)com> |
| Cc: | <pgsql-jdbc(at)postgresql(dot)org> |
| Subject: | Re: sessionVariables=FOREIGN_KEY_CHECKS=0 |
| Date: | 2007-07-19 10:01:23 |
| Message-ID: | 02ECFD52-6819-4776-8E41-59C7693C66BF@fastcrypt.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
>
>
>
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ingmar Lötzsch | 2007-07-19 10:04:31 | Re: IN clause with PreparedStatement |
| Previous Message | Badawy, Mohamed | 2007-07-19 09:46:00 | sessionVariables=FOREIGN_KEY_CHECKS=0 |