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

2011-06-04 Thread Tom Lane
"Dylan Adams" 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 -- Sent via pgsql-bugs mailin

[BUGS] BUG #6049: Can't load dumped view with VALUES and ORDER BY

2011-06-02 Thread Dylan Adams
The following bug has been logged online: Bug reference: 6049 Logged by: Dylan Adams Email address: dad...@bybaxter.com PostgreSQL version: 8.4.4 Operating system: Linux (Fedora 12) Description:Can't load dumped view with VALUES and ORDER BY Details: If you create a