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 <[email protected]> wrote: > From: Tom Lane <[email protected]> > Subject: Re: [GENERAL] select DISTINCT not ordering the returned rows > To: "Ioana Danes" <[email protected]> > Cc: "PostgreSQL General" <[email protected]> > Received: Wednesday, March 2, 2011, 3:44 PM > Ioana Danes <[email protected]> > 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 ([email protected]) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general > -- Sent via pgsql-general mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
