| From: | Thiemo Kellner <thiemo(at)gelassene-pferde(dot)biz> |
|---|---|
| To: | pgsql-general <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Subject: | dblink: give search_path |
| Date: | 2018-04-11 06:44:17 |
| Message-ID: | 20180411084417.11492xo2gdx9zni8@www.gelassene-pferde.biz |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Thiemo Kellner | 2018-04-11 06:51:32 | psql variable to plpgsql? |
| Previous Message | Michael Paquier | 2018-04-11 03:37:50 | Re: difference between checkpoint_segments and wal_keep_segments in postgres configuration file |