"Sam O'Connor" <[EMAIL PROTECTED]> writes:
> If I create a view like this:
> CREATE VIEW v AS
> SELECT i FROM a
> UNION
> SELECT DISTINCT i FROM b
> It functions as expected but it causes pg_dump to produce
> bad output. "ORDER BY b.i" is added to the view definition.
This appears to be fixed al
If I create a view like this:
CREATE VIEW v AS
SELECT i FROM a
UNION
SELECT DISTINCT i FROM b
It functions as expected but it causes pg_dump to produce
bad output. "ORDER BY b.i" is added to the view definition.
On restore this causes:
ERROR: ORDER BY on a UNION/INTERSECT/EXCEPT result must be o
