Re: [SQL] function source code not returning from inside a pgsql function. - Mailing list pgsql-sql

Hello,

I have a function in a punlic schema and in psql when I do:

 pg_get_functiondef(oid) from pg_proc where proname = 'xtm_doc_ref';

I get a result.

When I do the same in a function:

CREATE OR REPLACE FUNCTION tm.alter_tbl(

p_id integer,

p_type character varying,

p_lang character varying)

    RETURNS void

 And I call the function with :

TM=# select alter_tbl('xtm_2_fr_nl_doc');

NOTICE:  input parameters result in xtm_2_fr_nl_doc

NOTICE:   probleem

 alter_tbl

-----------

(1 row)

 The source code is not fetched.

the function the public schema is a template for another function that I want to create in the TM schema.

I suppose this has something to do with pgsql nit having acces to public schema ? 

Is  there something that can be done about it ?