Created attachment 56164 [details] screen shot of query designer Test system: Ubuntu 11.04 AMD64, Gnome, PostGres 8.4 (localhost), 9.1 (remote) Open an ODB connecting to the psql server. Create new query in designer view Select a field Select Functions - empty list. The query parser is recognizing the functions; create a query in text view, but NOT using SQLdirect [tested simple stuff, sum, count, avg] and it runs correctly, if switched back to design view the funtions are displayed correctly in the desinger view and are not removed when saved - so it appears to be the drop down control w/empty list as the culprit here. In the screen shot the test query was entered as: SELECT COUNT( * ) FROM "public"."Master" AS "Master" WHERE "birthState" IN ( 'CA', 'NC' ) Then switched back to design view, you can see it picks up the count function. Added another column just to show what the function drop list displays.
Just had a go and noticed: if I chose as Field, tablename.*, rather than tablename.fieldname, Count appears in the Function list. (I should be allowed to count(tablename.fieldname) too...)
Reproduced in 3.4 and 3.5. Seems to be PostgreSQL-SDBC specific.
I do not know if this can help, but the same behaviour can be reproduced when using the jdbc connection on postgres.
(In reply to comment #3) > I do not know if this can help, but the same behaviour can be reproduced when > using the jdbc connection on postgres. Oh, thanks for that information.
Fixed in master (3.6) and 3.5.1 with PostgreSQL-SDBC driver. Not fixed with JDBC driver.