Re: [BUGS] pg_dump produces invalid SQL for "group by cast(null as numeric)"

2008-03-06 Thread Bruce Momjian
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

Re: [BUGS] pg_dump produces invalid SQL for "group by cast(null as numeric)"

2008-01-05 Thread Tom Lane
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

[BUGS] pg_dump produces invalid SQL for "group by cast(null as numeric)"

2008-01-05 Thread Martin Pitt
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