I'm using PG 7.3.1, and Delphi 5 and ODBC 7.02.00.05
There are two users and two schemas authorization for each one user.
When I create the type lo with a schema it appear like a TBLOBField.
When I create the type lo with another schema it appear like a TStringField.
To create the type lo I used the script at contrib/lo/lo.sql.
In first I change the line search_path = public to search_path = totall
(TBLOBField)
and ran the script with user totall.
In second I change the line search_path = public to search_path = work50
(TStringField)
and ran the script again with user work50.
How can I fix this problem?
Please,
Cristian
----- Original Message -----
From: "Andrew Sullivan" <andrew@libertyrms.info>
To: <pgsql-general@postgresql.org>
Sent: Wednesday, February 26, 2003 1:21 PM
Subject: Re: [GENERAL] OID or lo
On Tue, Feb 25, 2003 at 09:24:49PM -0300, Cristian Custodio wrote:
> Hi,
>
> Does anybody would know say me, what is the real difference between
> OID and lo.
They're different things. "OID" stands for (roughly) Object
IDentifier. Many objects (potentially every row) in the database
have an OID. "lo" stands for Large Object; these types of database
objects are manipulated using the lo interface. See the user's
guide for more.
A
--
----
Andrew Sullivan 204-4141 Yonge Street
Liberty RMS Toronto, Ontario Canada
<andrew@libertyrms.info> M2P 2A8
+1 416 646 3304 x110
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly