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 ---------- > 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 > > -- > Martin Pitt http://www.piware.de > Ubuntu Developer http://www.ubuntu.com > Debian Developer http://www.debian.org -- End of PGP section, PGP failed! -- Bruce Momjian <[EMAIL PROTECTED]> http://momjian.us EnterpriseDB http://postgres.enterprisedb.com + If your life is a hard drive, Christ can be your backup. + -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://mail.postgresql.org/mj/mj_wwwusr?domain=postgresql.org&extra=pgsql-bugs
