Re: Bug in postgres 9.6.2?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: greigwise <greigwise(at)comcast(dot)net>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Bug in postgres 9.6.2?
Date: 2017-07-20 20:37:02
Message-ID: 14521.1500583022@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

greigwise <greigwise(at)comcast(dot)net> writes:
> So, I have this query with nothing non-deterministic in it, yet I can run it
> multiple times and get different results in postgres 9.6.2:
> ...
> Is it possible that this is a bug in 9.6.2 that was fixed in 9.6.3?

Hard to tell without more information than this --- which I realize you
may not be able to get if the 9.6.2 instance is now gone. If it isn't,
it'd be interesting to compare EXPLAIN ANALYZE results, for starters.
I will say that I don't see anything in the 9.6.3 release notes that
looks like it would result in making a nondeterministic query result
deterministic.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message greigwise 2017-07-20 21:45:30 Re: Bug in postgres 9.6.2?
Previous Message Leonardo M. Ramé 2017-07-20 20:07:22 Re: Streaming Replication archive_command is really needed?