Re: Calling functions with table-based-type parametars

From: Mario Splivalo <mario(dot)splivalo(at)mobart(dot)hr>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Calling functions with table-based-type parametars
Date: 2007-02-27 12:37:03
Message-ID: 1172579823.11691.19.camel@localhost.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-jdbc by date

  From Date Subject
Next Message Nelson Arape 2007-02-27 13:42:04 Re: Minor performance improvements
Previous Message Mario Splivalo 2007-02-27 12:24:18 Re: Calling functions with table-based-type parametars