Re: Problems with pg_dump ?

Alexandr Popov <alexandr(dot)popov(at)nexui(dot)md> writes:
> CREATE OR REPLACE VIEW v1 AS SELECT DISTINCT a,b, -1 AS d, -1 AS e FROM t1;

> After this i dump database with pg_dump and have following output.

> CREATE VIEW v1 AS
> SELECT DISTINCT t1.a, t1.b, -1 AS d, -1 AS e FROM t1 ORDER BY t1.a, t1.b, -1::integer, -1::integer;

Sigh ... this is a bug in my patch of a few months ago:
http://archives.postgresql.org/pgsql-committers/2008-01/msg00081.php
It needs to be parenthesizing those constants, because as-is the ::
binds more tightly than the -, and "-(1::integer)" is a run-time
negation, not a simple constant.

regards, tom lane