large object oid value not showing up in pgAdmin

From: "Julie May" <julie(at)ccorb(dot)com>
To: <pgadmin-support(at)postgresql(dot)org>
Subject: large object oid value not showing up in pgAdmin
Date: 2003-04-21 21:39:57
Message-ID: 00df01c3084e$8db422d0$a1d2a8c0@impsu.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

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>

Browse pgadmin-support by date

  From Date Subject
Next Message Mendola Gaetano 2003-04-22 13:29:41 BUG
Previous Message Michael Judd 2003-04-21 14:33:37 Re: Error Message