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