Re: large object oid value not showing up in pgAdmin

Поиск
Список
Период
Сортировка
От Dave Page
Тема Re: large object oid value not showing up in pgAdmin
Дата
Msg-id 03AF4E498C591348A42FC93DEA9661B8259FD1@mail.vale-housing.co.uk
обсуждение исходный текст
Ответ на large object oid value not showing up in pgAdmin  ("Julie May" <julie@ccorb.com>)
Список pgadmin-support
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@ccorb.com]
Sent: 21 April 2003 22:40
To: pgadmin-support@postgresql.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>
Вложения

В списке pgadmin-support по дате отправления:

Предыдущее
От: "Dave Page"
Дата:
Сообщение: Re: BUG
Следующее
От: "Julie May"
Дата:
Сообщение: Re: large object oid value not showing up in pgAdmin