Re: BUG #6049: Can't load dumped view with VALUES and ORDER BY

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Dylan Adams" <dadams(at)bybaxter(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #6049: Can't load dumped view with VALUES and ORDER BY
Date: 2011-06-04 19:50:00
Message-ID: 2760.1307217000@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

"Dylan Adams" <dadams(at)bybaxter(dot)com> writes:
> If you create a view based on a VALUES statement with an ORDER BY clause,
> the SQL produced by pg_dump can't be loaded back into the database.

I've applied a patch for this. Thanks for the report!

regards, tom lane

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2011-06-04 21:24:22 Re: BUG #6051: wCTE query fail with wrong error text on a table with rules
Previous Message dinesh 2011-06-04 07:09:27 BUG #6052: ADD COLUMN - ERROR: tables can have at most 1600 columns