| From: | "Thiemo Kellner, NHC Barhufpflege" <thiemo(dot)kellner(at)gelassene-pferde(dot)biz> |
|---|---|
| To: | pgsql-general <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: dblink: give search_path |
| Date: | 2018-04-11 09:37:58 |
| Message-ID: | 20180411113758.197355wz0ezzxxoo@www.gelassene-pferde.biz |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Zitat von Rene Romero Benavides <rene(dot)romero(dot)b(at)gmail(dot)com>:
> What about setting the search path at the user level?
> ALTER ROLE act SET search_path = act,logger;
>
> Best.
Thanks for the inspiration. Maybe it is best to create a dedicated
user for logging anyway...
--
Ö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 | Raghavendra Rao J S V | 2018-04-11 10:00:10 | Re: Planning to change autovacuum_vacuum_scale_factor value to zero. Please suggest me if any negative impact. |
| Previous Message | Thiemo Kellner, NHC Barhufpflege | 2018-04-11 09:36:28 | Re: psql variable to plpgsql? |