Re: BUG #10207: Simple select query returns duplicate row - Critical issue

From: David G Johnston <david(dot)g(dot)johnston(at)gmail(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #10207: Simple select query returns duplicate row - Critical issue
Date: 2014-05-03 22:32:43
Message-ID: 1399156363820-5802319.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The fact that two executions of a query can return the same data is not
anything like what your subject describes. Now, if a single execution
returned a duplicate row (based on a PK) then what you said would be true.

If you need definite order you need to sort on a primary key - or something
equivalent.

David J.

--
View this message in context: http://postgresql.1045698.n5.nabble.com/BUG-10207-Simple-select-query-returns-duplicate-row-Critical-issue-tp5802310p5802319.html
Sent from the PostgreSQL - bugs mailing list archive at Nabble.com.

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message soobia.arshad 2014-05-05 08:04:58 BUG #10223: Linking postgresql 64 bit to sql server 64 bit
Previous Message Tom Lane 2014-05-03 17:31:50 Re: BUG #10207: Simple select query returns duplicate row - Critical issue