Postgres Pro
Downloads
Home   >   mailing lists

Re: dblink: give search_path - Mailing list pgsql-general

From Rene Romero Benavides
Subject Re: dblink: give search_path
Date
Msg-id CANaGW0-Za-7Z8+U0b5zK7Weik_+Dzv1-c5Y3dCJUfcNSsp2T=w@mail.gmail.com
Whole thread Raw
In response to dblink: give search_path  (Thiemo Kellner <thiemo@gelassene-pferde.biz>)
Responses Re: dblink: give search_path
List pgsql-general
Tree view
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=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/

pgsql-general by date:

Previous
From: Andres Freund
Date:
Subject: Re: ERROR: found multixact from before relminmxid
Next
From: Thomas Poty
Date:
Subject: Re: Barman versus pgBackRest