Re: Calling functions with table-based-type parametars

Поиск
Список
Период
Сортировка
От Mario Splivalo
Тема Re: Calling functions with table-based-type parametars
Дата
Msg-id 1172579823.11691.19.camel@localhost.localdomain
обсуждение исходный текст
Ответ на Re: Calling functions with table-based-type parametars  (Mario Splivalo <mario.splivalo@mobart.hr>)
Список 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


В списке pgsql-jdbc по дате отправления:

Предыдущее
От: Mario Splivalo
Дата:
Сообщение: Re: Calling functions with table-based-type parametars
Следующее
От: Nelson Arape
Дата:
Сообщение: Re: Minor performance improvements