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