Bug with dump/restore when using UNION and ORDER BY in views - Mailing list pgsql-sql

From Kristian Eide
Subject Bug with dump/restore when using UNION and ORDER BY in views
Date
Msg-id 036501c23b32$5c5149f0$6b97f181@speed
Whole thread Raw
Responses Re: Bug with dump/restore when using UNION and ORDER BY in views
List pgsql-sql
There seems to be a bug when dumping a view which is a UNION of selects, one
of which has an ORDER BY. A pair of paranthesises around the select is
missing, and this cause a subsequent restore to fail. This is quite annoying
as the backup file must be manually edited before it can be restored, and I
would really appreciate a solution in a future version of Postgre.

This problem is still present in 7.2.1.

Example:

CREATE TABLE t (id INT);
CREATE VIEW v AS (SELECT id FROM t AS t1 ORDER BY id) UNION SELECT id FROM t
AS t2;

After a dump it looks like this:

CREATE VIEW "v" as SELECT t1.id FROM t t1 ORDER BY t1.id UNION SELECT t2.id
FROM t t2;

Which is not accepted by postgre.


Regards,

Kristian




pgsql-sql by date:

Previous
From: "Kristian Eide"
Date:
Subject: VACUUM not doing its job?
Next
From: Ken Corey
Date:
Subject: Re: VACUUM not doing its job?