Re: Calling functions with table-based-type parametars - Mailing list pgsql-jdbc

On Tue, 2007-02-27 at 13:24 +0100, Mario Splivalo wrote:

> As it turns out, it was permissions problem. I created the table and the
> function as the database owner. But, there is user set up for
> tomcat/jdbc, and all data manipulation is done trough psql functions.
> Now, that user has GRANT EXECUTE ON f1(t1) TO jdbcuser;

I forgot to GRANT USAGE on schema public for jdbcuser. Now it's ok.

    Mike