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.
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 |