Re: [GENERAL] UUID index unused

2014-11-09 Thread Kevin Wooten
This affirmation that it indeed does work set me straight. I inadvertently made a previously immutable UUID function volatile; it was providing the UUIDs in the query. > On Nov 9, 2014, at 2:12 PM, Tom Lane wrote: > > Kevin Wooten writes: >> I am assuming I am crazy and mi

[GENERAL] UUID index unused

2014-11-09 Thread Kevin Wooten
I am assuming I am crazy and missing something completely obvious but I cannot get postgres (9.3.5) to use an index on a UUID, ever. The main table has a natural composite key (2 uuids and a timestamp) with which it always uses the timestamp as the index condition and filters on the UUIDs. Th

Re: [JDBC] [GENERAL] Creating an index alters the results returned

2014-01-03 Thread Kevin Wooten
Regardless of type used… the driver and server should agree on the results. On Jan 3, 2014, at 6:06 PM, Scott Marlowe wrote: > On Fri, Jan 3, 2014 at 5:55 PM, Adrian Klaver wrote: > >> Only thing I can think of is the JDBC driver and Postgres have a difference >> of opinion on the precision of

Re: [GENERAL] Scrolling/Updating Cursors

2013-11-22 Thread Kevin Wooten
> On 11/22/2013 2:27 PM, Kevin Wooten wrote: >> On Nov 19, 2013, at 6:33 PM, Kevin Wooten wrote: >> >>> My apologies for posting what is almost certainly somewhat of a repeat >>> question but I have searched and attempted everything I can think of and >&g

Re: [GENERAL] Scrolling/Updating Cursors

2013-11-22 Thread Kevin Wooten
On Nov 19, 2013, at 6:33 PM, Kevin Wooten wrote: > My apologies for posting what is almost certainly somewhat of a repeat > question but I have searched and attempted everything I can think of and > cannot figure it out myself. > > The basic question is… Is it possible to g

[GENERAL] Scrolling/Updating Cursors

2013-11-19 Thread Kevin Wooten
My apologies for posting what is almost certainly somewhat of a repeat question but I have searched and attempted everything I can think of and cannot figure it out myself. The basic question is… Is it possible to get a scrollable cursor that, within a transaction, can insert/update/delete rows