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.