Well PSQL respects search_path but given your objections before and the fact
that this would be a change I was suggesting that on PG_OBJECT an option be
given to set/getTypeSchema() This way if not set it functions as it does
now. No change to current usaage BUT if it is set in the PGOBECT then it
would be respected.
I think this provides a way of handling the case which PSQL does and doesn't
break backwards compatibility.
On Wed, Jun 2, 2010 at 6:03 AM, Kris Jurka <books(at)ejurka(dot)com> wrote:
> On Tue, 1 Jun 2010, Jason Tesser wrote:
> Right in my case my schema changes as each organization has a separate
>> I would love to be able to set the schema with the typeName. Why couldn't
>> that be a seperate attribute in Java setLookupSchema and if not set
>> as it does now. Wouldn't this handle both cases.
> I'm not sure where you are suggesting that this attribute would live. Are
> you suggesting we should have a PGConnection method setSearchPath(String)
> that would set the search path on the server side and make the driver aware
> of the change? Are you suggesting that PGObject should have a
> getTypeSchema()? Can you clarify your suggestion?
> Kris Jurka
In response to
pgsql-jdbc by date
|Next:||From: Manohar Bhattarai||Date: 2010-06-02 13:40:15|
|Subject: Re: Not able to connect to postgresql database|
|Previous:||From: Kris Jurka||Date: 2010-06-02 10:03:30|
|Subject: Re: Found a Bug in latest Driver (I THINK) and pg 8.4|