Re: Re: What needs to be done? - Mailing list pgsql-jdbc

From Bruce Momjian
Subject Re: Re: What needs to be done?
Date
Msg-id 200108031549.f73Fnc427186@candle.pha.pa.us
Whole thread Raw
In response to Re: What needs to be done?  (Barry Lind <barry@xythos.com>)
List pgsql-jdbc
> If people feel that backwards compatibiliy is important I would suggest
> it be done in the following way:
>
> A new connection parameter named 'compatible' be defined whose default
> value is 7.2 (i.e new functionality).  But you could set compatible=7.1
> to revert back to the old functionality.  (This is how Oracle deals with
> similar issues in its code base).  This parameter could then be set
> either in the JDBC URL (i.e.
> jdbc:postgresql://localhost:5432:template1?compatible=7.1) or passed
> explicily in the connect() method.

GUC seems to be the way to control these things.  It can be set in
postgresql.conf and via a SET command.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

pgsql-jdbc by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Patch to improve commit time performance and a few other things
Next
From: Barry Lind
Date:
Subject: Re: Memory Leak / Prepared Statement