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 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'
-------- snip ----------
I verified that this is still an issue on 8.3 CVS head.
However, I admit that I'm not sure why "group by cast(null as
numeric)" is useful. However, it actually works in the DB and fails in
pg_dump, so either it is valid and should be handled by pg_dump, or it
is invalid and should not be accepted in the first place.
Thank you!
Martin
[1] https://bugs.launchpad.net/bugs/177382
--=20
Martin Pitt http://www.piware.de
Ubuntu Developer http://www.ubuntu.com
Debian Developer http://www.debian.org