Postgres Pro
Downloads
Home   >   mailing lists

Thread: setting contrib lo visible to all schemas

setting contrib lo visible to all schemas

From
Teddy Limousin
Date:
hello I`m trying to restore a database that uses contrib type lo. The database uses one schema where the relations are created
before restoring the schema I execute the command

psql -d dbname -f path-to-contrib/lo.sql

after this I restore the schema and then the data of the database

the problems comes up when trying to make an update to the database schema from a delphi application
the table has a column of type lo and when trying to update the table I got the error saying
that lo type does not exist.

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

thanks in advanced

--
Teddy L.

Re: setting contrib lo visible to all schemas

From
Tom Lane
Date:
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

Re: setting contrib lo visible to all schemas

From
Teddy Limousin
Date:
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

2010/5/20 Tom Lane <tgl@sss.pgh.pa.us>
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



--
Teddy Limousin

Re: setting contrib lo visible to all schemas

From
Gurjeet Singh
Date:
On Thu, May 20, 2010 at 11:16 AM, Teddy Limousin <mongaru007@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 <tgl@sss.pgh.pa.us>

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



--
Teddy Limousin



--
gurjeet.singh
@ EnterpriseDB - The Enterprise Postgres Company
http://www.enterprisedb.com

singh.gurjeet@{ gmail | yahoo }.com
Twitter/Skype: singh_gurjeet

Mail sent from my BlackLaptop device