OID or lo
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