FYI, this was fixed in 8.3.0; not sure you got the report of the fix.
---
Martin Pitt wrote:
-- Start of PGP signed section.
> Hi PostgreSQL developers,
>
> in [1], a user reported a failure of pg_dump:
>
> snip
Martin Pitt <[EMAIL PROTECTED]> writes:
> create view bar as select count(*) from foo group by cast(null as numeric);
> 3. pg_dump the database to a text file. The file contains
>'CREATE VIEW bar AS
>SELECT count(*) AS count FROM foo GROUP BY 2;'
Actually, this seems to be provoking
Hi PostgreSQL developers,
in [1], a user reported a failure of pg_dump:
snip --
1. Create an empty database.
2. Connect to the database and create these views:
create view foo as select 3;
create view bar as select count(*) from foo group by cast(null as numeric);
3. pg_dump t