setting contrib lo visible to all schemas

From: Teddy Limousin <mongaru007(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: setting contrib lo visible to all schemas
Date: 2010-05-20 13:49:53
Message-ID: AANLkTinyZpeEdoQrVai3a3LC9lgahX4xXnlP0vt12BPe@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Giancarlo Boaron 2010-05-20 14:05:13 Some undefined function errors
Previous Message Tom Lane 2010-05-20 13:38:34 Re: Connection lost