I totally agree with you and the problem is gonna be fixed. I just needed a temporary solution until the patch goes out.
Thank you, Ioana --- On Wed, 3/2/11, Tom Lane <t...@sss.pgh.pa.us> wrote: > From: Tom Lane <t...@sss.pgh.pa.us> > Subject: Re: [GENERAL] select DISTINCT not ordering the returned rows > To: "Ioana Danes" <ioanasoftw...@yahoo.ca> > Cc: "PostgreSQL General" <pgsql-general@postgresql.org> > Received: Wednesday, March 2, 2011, 3:44 PM > Ioana Danes <ioanasoftw...@yahoo.ca> > writes: > > I upgraded postgres from 8.3 to 9.0.3 and I have an > issue with the order of the returned rows. > > Your application is simply broken if it assumes that > DISTINCT results in > ordering the rows. The only thing that guarantees > that is an ORDER BY. > > You could probably work around it for the short term by > unsetting > enable_hashagg, but you really ought to fix the query > instead. > > > regards, tom lane > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general > -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
