On Thu, May 20, 2010 at 11:16 AM, Teddy Limousin <mongaru...@gmail.com>wrote:
> thanks tom, aparently your rigth in the sql dump file there are some > set search_path changes > I tried the set search_path command and use the same query that generate > the error and it works on my pgadmin editor. > > My question is how can I set the search_path for all users or all > conections > so my application will find the lo type. > You can use the ALTER DATABASE dbname SET search_path = ... or can do it for individual user as: ALTR USER uname SET search_path = ... > > thanks > > 2010/5/20 Tom Lane <t...@sss.pgh.pa.us> > > Teddy Limousin <mongaru...@gmail.com> writes: >> > I guess this is because when executing the sql command to install lo, it >> > makes it visible from the public schema only >> > not from the schema I`m using. So my question is how can I make lo type >> to >> > be visible from all schemas >> >> > by visible I mean accesible: not need to use for example public.lo to >> define >> > a field of type lo >> >> It sounds like you removed the public schema from your search_path >> setting. Don't do that ... >> >> regards, tom lane >> > > > > -- > Teddy Limousin > -- gurjeet.singh @ EnterpriseDB - The Enterprise Postgres Company http://www.enterprisedb.com singh.gurj...@{ gmail | yahoo }.com Twitter/Skype: singh_gurjeet Mail sent from my BlackLaptop device
