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
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
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
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
> 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
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
