Re: type "xxxxxxx" does not exist

From: Micky Hulse <mickyhulse(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: type "xxxxxxx" does not exist
Date: 2017-05-19 21:25:19
Message-ID: CAKzdcNmXrU03jrKstTXTq1DhFNjLmJPcJ39_3bqZ9NxsfKqMww@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, May 19, 2017 at 2:09 PM, Micky Hulse <mickyhulse(at)gmail(dot)com> wrote:
>> If you find that the type isn't in the public schema, try setting your
>> schema search path so that the function can locate it, e.g.:
>> SET search_path TO foo, public;

Awesome, that worked!

SET search_path TO myschema, public;

Thanks to everyone for the help!!!!! I really appreciate it. :)

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Paul Jungwirth 2017-05-19 21:43:25 Re: type "xxxxxxx" does not exist
Previous Message Micky Hulse 2017-05-19 21:21:42 Re: type "xxxxxxx" does not exist