Re: dblink: give search_path
| От | Rene Romero Benavides |
|---|---|
| Тема | Re: dblink: give search_path |
| Дата | |
| Msg-id | CANaGW0-Za-7Z8+U0b5zK7Weik_+Dzv1-c5Y3dCJUfcNSsp2T=w@mail.gmail.com обсуждение исходный текст |
| Ответ на | dblink: give search_path (Thiemo Kellner <thiemo@gelassene-pferde.biz>) |
| Ответы |
Re: dblink: give search_path
|
| Список | pgsql-general |
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 <thiemo@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=0x8F70EFD2D972CB EF
------------------------------------------------------------ ----
This message was sent using IMP, the Internet Messaging Program.
В списке pgsql-general по дате отправления: