Re: setting contrib lo visible to all schemas - Mailing list pgsql-general

From Tom Lane
Subject Re: setting contrib lo visible to all schemas
Date
Msg-id 3663.1274364976@sss.pgh.pa.us
Whole thread Raw
In response to setting contrib lo visible to all schemas  (Teddy Limousin <mongaru007@gmail.com>)
Responses Re: setting contrib lo visible to all schemas  (Teddy Limousin <mongaru007@gmail.com>)
List pgsql-general
Teddy Limousin <mongaru007@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

pgsql-general by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: default ordering of query result - are they always guarantee
Next
From: Peter Hunsberger
Date:
Subject: Re: How to lose transaction history (xmin values, WAL, etc.)?