dipti shah escribió: > For your reference I did something like this: > > 1. Create Function foo1 .... (this is without SECURITY DEFINER where I am > using SET ROLE to current user). > > 2. Create Function foo2 with SECURITY DEFINER ... > spi_exe_query("select foo1()"); ==> Here it throws the error. Shouldn't it be the other way around? The normal function calls the security-definer one. -- Alvaro Herrera http://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general