8.0.0beta1 small inconsistency in pg_aggregate listing
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 - coelho@cri.ensmp.fr
Fabien COELHO <coelho@cri.ensmp.fr> writes:
Maybe something wrong with the regproc type?
regprocout doesn't schema-qualify if the function name is unique without
it.
Of course, the function name isn't necessarily unique *with* it, either,
but regproc can't do anything about that. Cast to regprocedure if you
want to see a more helpful display of the function.
regards, tom lane
Maybe something wrong with the regproc type?
regprocout doesn't schema-qualify if the function name is unique without
it.
Ok. Maybe too clever, as I couldn't guess by looking at it.
Of course, the function name isn't necessarily unique *with* it, either,
but regproc can't do anything about that. Cast to regprocedure if you
want to see a more helpful display of the function.
Much better indeed.
Thanks a lot for the light. Have a nice day.
--
Fabien Coelho - coelho@cri.ensmp.fr