Skip site navigation (1) Skip section navigation (2)

Re: large object oid value not showing up in pgAdmin

From: "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk>
To: "Julie May" <julie(at)ccorb(dot)com>, <pgadmin-support(at)postgresql(dot)org>
Subject: Re: large object oid value not showing up in pgAdmin
Date: 2003-04-22 18:27:10
Message-ID: 03AF4E498C591348A42FC93DEA9661B8259FD1@mail.vale-housing.co.uk (view raw or flat)
Thread:
Lists: 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(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>
	

Responses

pgadmin-support by date

Next:From: Julie MayDate: 2003-04-22 20:53:55
Subject: Re: large object oid value not showing up in pgAdmin
Previous:From: Dave PageDate: 2003-04-22 18:15:58
Subject: Re: BUG

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group