OID or lo

From: "Cristian Custodio" <crstian(at)terra(dot)com(dot)br>
To: <pgsql-general(at)postgresql(dot)org>
Subject: OID or lo
Date: 2003-02-27 11:13:59
Message-ID: 002a01c2de51$54a482e0$fb01a8c0@ttcristian
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


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(at)libertyrms(dot)info>
To: <pgsql-general(at)postgresql(dot)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(at)libertyrms(dot)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(at)postgresql(dot)org so that your
message can get through to the mailing list cleanly

Browse pgsql-general by date

  From Date Subject
Next Message Roberto de Amorim 2003-02-27 12:25:17 Function example returning more then 1 value
Previous Message Andreas Rust 2003-02-27 11:10:46 Re: 7.4?