Re: setting contrib lo visible to all schemas
| От | Teddy Limousin |
|---|---|
| Тема | Re: setting contrib lo visible to all schemas |
| Дата | |
| Msg-id | AANLkTimdYwpIt-nnFh6D07O1JM6YGt_Lt5Qz2efM1sXB@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: setting contrib lo visible to all schemas (Tom Lane <tgl@sss.pgh.pa.us>) |
| Ответы |
Re: setting contrib lo visible to all schemas
|
| Список | pgsql-general |
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.
thanks
--
Teddy Limousin
2010/5/20 Tom Lane <tgl@sss.pgh.pa.us>
Teddy Limousin <mongaru007@gmail.com> writes:It sounds like you removed the public schema from your search_path
> 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
setting. Don't do that ...
regards, tom lane
--
Teddy Limousin
В списке pgsql-general по дате отправления: