On 3/19/25 04:24, Cosimo Simeone wrote:
> Hi!
> I'd need help understanding what i am doing wrong...
>
> Where am I:
> =# \c
> psql (15.8 (Homebrew), server 14.15 (Debian 14.15-1.pgdg120+1))
> You are now connected to database "postgres" as user "postgres".
>
> Init:
> =# create role my_user;
> =# create schema my_schema;
> =# create function my_schema.my_func(p1 text) returns integer as $
> $select 1::integer;$$ language sql;
See:
https://www.postgresql.org/docs/current/sql-createfunction.html#:~:text=execute%20privilege%20is%20granted%20to%20PUBLIC
--
Joe Conway
PostgreSQL Contributors Team
RDS Open Source Databases
Amazon Web Services: https://aws.amazon.com
