pg_dump produces invalid SQL

[KM]

Binary package hint: postgresql-8.2

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 the database to a text file. The file contains

   'CREATE VIEW bar AS
       SELECT count(*) AS count FROM foo GROUP BY 2;'

4. Drop view bar from the database.

5. Run the CREATE VIEW bar..; statement from the text file.

6. The statement fails with

   'ERROR: GROUP BY position 2 is not in select list'

[Martin Pitt (pitti)]

Confirmed on 8.3RC1.

[Martin Pitt (pitti)]

Forwarded to <email address hidden>, you are in CC: in case upstream has more specific questions. Thank you!

[Martin Pitt (pitti)]

This was fixed in 8.3.0 final, thus it is fixed in Hardy.