I've installed it and it works. Thanks a lot. On Saturday 12 April 2008 01:01:06 Tom Lane wrote: > Marc Cousin <[EMAIL PROTECTED]> writes: > > I'm having a strange problem : I created a view in a database, and I > > cannot restore it after a pg_dump. ... > > ERROR: for SELECT DISTINCT, ORDER BY expressions must appear in select > > list > > You need this patch: > > http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/adt/arrayf >uncs.c?r1=1.140&r2=1.140.2.1 > > I found that this problem was introduced in 8.2, which may explain why > you'd not seen it before, if you were previously using an older release. > > regards, tom lane
-- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
