| From: | Jerry Sievers <jerry(at)jerrysievers(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Perhaps silly question about empty search_path |
| Date: | 2007-10-21 00:46:47 |
| Message-ID: | m3d4v9guq0.fsf@mama.jerrysievers.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Jerry Sievers <jerry(at)jerrysievers(dot)com> writes:
> Hello;
>
> To begin with, I'm not certain how useful it would be... that said; it
> seems odd that a role or DB can have it's config search_path set to
> empty string but you can't explicitly set it that way.
Ugh!
Sorry. I forgot to see if set_config('search_path', '', true/false) does
the trick and it does.
Well, anyway... I got stuck on it since accomplishing what I had
intended wasn't straight forward :-)
Thanks
--
-------------------------------------------------------------------------------
Jerry Sievers 732 365-2844 (work) Production Database Administrator
305 321-1144 (mobil WWW E-Commerce Consultant
| From | Date | Subject | |
|---|---|---|---|
| Next Message | M. van Egmond | 2007-10-21 01:08:52 | Inheritance foreign key unexpected behaviour |
| Previous Message | Jerry Sievers | 2007-10-21 00:19:32 | Perhaps silly question about empty search_path |