I've noticed a minor inconsistency when listing pg_aggregate in
current 8.0.0beta1 version.

psql> SELECT aggfnoid FROM pg_aggregate;

4 functions are not schema qualified:
 count
 bool_and
 bool_or
 every

although all others are shown with a schema name:
 pg_catalog.avg
 pg_catalog.sum
 pg_catalog.max
 pg_catalog.min
 ...

However psql \da show all of them in pg_catalog, as expected.

I cannot see the difference in the initialization script to explain that.
Maybe something wrong with the regproc type?

-- 
Fabien Coelho - [EMAIL PROTECTED]

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

Reply via email to