Let's say I have following stored procedure:
create or replace function foo()
returns table(id integer, name text)
language plpgsql
as $func$
begin
select id, name
from white_house;
end
$func$
The foo function is located in my_schema schema (which is different that
the default one - public). The same applies to the white_house table. By
adding some info (inputSchema = 'my_schema') to gradle config I generated
classes from this schema and I can call the schema with:
Routines.foo()
but I'm getting error that, the table does not exists.
org.postgresql.util.PSQLException: ERROR: relation "white_house" does not
exist
Where: PL/pgSQL function my_schema.foo() line 4 at OPEN
I tried to add:
configuration.set(new Settings().withRenderSchema(true));
but it also failed.
Is there any possibility to add the "my_schema" schema prefixes at runtime to
the tables inside this foo() function without changing the function? I'm using
jOOQ 3.8.5.
--
You received this message because you are subscribed to the Google Groups "jOOQ
User Group" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
