What about setting the search path at the user level? ALTER ROLE act SET search_path = act,logger;
Best. 2018-04-11 1:44 GMT-05:00 Thiemo Kellner <thi...@gelassene-pferde.biz>: > Hi all > > I try to execute a function not in the Schema I connect to with dblink. Is > there way to tell dblink to set search_path in a specific way? I have not > found a solution in the documentation. I tried with the set search_path > definition in the function declarations to no avail. > > Function Schema: logger > Database: act > User: act > User Default Schema: act > > Kind regards > > Thiemo > > -- > Öffentlicher PGP-Schlüssel: http://pgp.mit.edu/pks/lookup? > op=get&search=0x8F70EFD2D972CBEF > > ---------------------------------------------------------------- > This message was sent using IMP, the Internet Messaging Program. > > -- El genio es 1% inspiración y 99% transpiración. Thomas Alva Edison http://pglearn.blogspot.mx/
