| From: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
|---|---|
| To: | Paul Jungwirth <pj(at)illuminatedcomputing(dot)com> |
| Cc: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>, Micky Hulse <mickyhulse(at)gmail(dot)com> |
| Subject: | Re: type "xxxxxxx" does not exist |
| Date: | 2017-05-19 21:49:29 |
| Message-ID: | CAKFQuwb_Ng-+5D0RB=fd4_=mA4iK0n1n5bacYdXAr=pu5Q1VRQ@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Fri, May 19, 2017 at 2:43 PM, Paul Jungwirth <pj(at)illuminatedcomputing(dot)com
> wrote:
> On 05/19/2017 02:25 PM, Micky Hulse wrote:
>
>> Awesome, that worked!
>>
>> SET search_path TO myschema, public;
>>
>> Thanks to everyone for the help!!!!! I really appreciate it. :)
>>
>
> Glad you figured it out! Setting the seach_path is often a good thing to
> put in your ~/.psqlrc so you don't run into the same problem next time.
If going for out-of-sight, out-of-mind solutions, and I have superuser
access to the database, I'd much rather "ALTER DATABASE db SET search_path
TO 'all known schemas';"
The psqlrc file feels to disconnected for me.
David J.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Adrian Klaver | 2017-05-19 22:02:08 | Re: type "xxxxxxx" does not exist |
| Previous Message | Paul Jungwirth | 2017-05-19 21:43:25 | Re: type "xxxxxxx" does not exist |