> I believe the spec just demands USAGE on the underlying function for > the TRANSLATE case, and I don't see why it should be different for > CONVERT. (In principle, if we didn't use a C-only API, you could > just call the underlying function directly; so there's little point > in having protection restrictions different from that case.)
Ok, so: (1) a CONVERSION can only be dropped by the superuser or its owner. (2) a grant syntax for CONVERSION is: GRANT USAGE ON CONVERSION <conversion_name> to {<user_name> | GROUP <group_name> | PUBLIC} [, ...] -- Tatsuo Ishii ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster