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

Re: connection variables problem

From: Kris Jurka <books(at)ejurka(dot)com>
To: "Badawy, Mohamed" <Mohamed(dot)Badawy(at)ams-europe(dot)com>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: connection variables problem
Date: 2007-05-04 16:16:00
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-jdbc

On Wed, 2 May 2007, Badawy, Mohamed wrote:

> Am working using maven framework I want to connect to the DB with no
> foreign key checking in mysql I use to write (Connection jdbcConnection
> = DriverManager.getConnection(
> "jdbc:postgresql://localhost:5432/post?sessionVariables=FOREIGN_KEY_CHEC
> KS=0", "aaa", "aaa");)
> I want the corresponding to in postgresql

Postgresql does not offer a similar feature and I see no reason that it 
should.  Why would you possibly want to disable your foreign keys? 
Perhaps you should be using deferred foreign keys instead?

Kris Jurka

In response to


pgsql-jdbc by date

Next:From: Kris JurkaDate: 2007-05-04 16:19:12
Subject: Re: error: unterminated dollar-quoted string with 8.2-505.jdbc3.jar?
Previous:From: B. JordanDate: 2007-05-04 16:07:48
Subject: error: unterminated dollar-quoted string with 8.2-505.jdbc3.jar?

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