Re: using aggregate function from other schema

Hi Mark,

> I was able to fix the
> problem by granting execute not just on the function but also on the
> TYPE (string_agg_type) to a non-owner.

thanks for your help, I fixed it this way. I didn't realise so far that it's possible (and necessary) to grant execute privileges on types... Anyway, this also fixed similar poblems I had with pipelined functions which return also custom types.

Thomas Received on Wed Dec 08 2004 - 12:42:09 CST