Re: large object oid value not showing up in pgAdmin

MessagepgAdmin isn't affecting our ability to sync, we are just having the same problem with pgAdmin as we were with syncing. When I try to unlink the blob I get an error message because it doesn't recognize the oid value for the blob, instead it sees the /?|. I have spent most of the day reading about blobs, the lo datatype, and oids. I am now thoroughly confused and frustrated :(

From the contrib/lo directory I ran makefile and ran the lo.sql file. This installed the lo type and some lo functions. However the oid does not show up in the lo column only the binary data. Plus the lo_manage function seems to cause pgAdmin to crash. I found one reference for this when I searched google. Hiroshi advised including the patch lo.diff in December of 2001. However, it also appears that the latest version of lo.c is supposed to fix this error. So I wasn't sure if I should add the patch (and where or how to add the patch) or if it was already included in the latest version (1.12).

When I use lo_import with an oid column it seems to import the blob and show the oid of the blob but then I am not sure how to manage the blob so it does not leave unreferenced files behind or cause pgAdmin to crash.

I'm cross posting this with the Novice list in case it is a more appropriate question for that list.

Wouldn't life be easier if Novices would quit trying to do advanced things with PostgreSql!?!

Julie
----- Original Message -----
From: Dave Page
To: Julie May ; pgadmin-support(at)postgresql(dot)org
Sent: Tuesday, April 22, 2003 12:27 PM
Subject: Re: [pgadmin-support] large object oid value not showing up in pgAdmin

Hi Julie,

I don't have any blobs to hand to play with, however, I believe pgAdmin is displaying the oid as binary data. This is all done by Microsoft code, so there is little I can do about it in pgAdmin. How is pgAdmin affecting your ability to sync your mobile database?

Regards, Dave.
-----Original Message-----
From: Julie May [mailto:julie(at)ccorb(dot)com]
Sent: 21 April 2003 22:40
To: pgadmin-support(at)postgresql(dot)org
Subject: [pgadmin-support] large object oid value not showing up in pgAdmin

Hi,

I have a column of type lo (for large object). When I query the database using psql I get the oid for the large object. However, when I run the same query in pgAdmin I get a ?/ instead of the oid value. Any ideas what is going wrong? This is also affecting our ability to sync our data with our mobile data base.

Thanks for any help or insight you can give.

Julie

<query and results from psql>

mobile=# select rec_no, map from scouting;
rec_no | map
--------+---------
1002 | 1143540
1003 | 1143542
1004 | 1143549
(3 rows)

mobile=#

</query and results from psql>

<query and results from pgAdmin>

</query and results from pgAdmin>