Re: FW: [GENERAL] Re: [ADMIN] Cannot retrieve images inserted through VB and odbc, after a table reorganization.

Thanks, Hiroshi. We were able to resolve the issue.

After we generated the MyLog we found in the log that the problem was that the odbc user did not have permission to
accessthe large object. Apparently in Postgres 8.4 and lower, all large objects in pg_largeobject were created without
anyowner. When we upgraded the database to 9.1, all large objects were allocated the superuser "postgres" as owner.
Henceodbc applications could not retrieve stored images. Newly inserted images could be retrieved, presumably because
theywere created with the odbc user as owner.
 

So, we ran a grant select, update command on all the large objects in pg_largeobjects and thereafter were able to
retrieveall stored images through the odbc application.
 

Alanoly Andrews
Invera Inc
Tel: (514) 935-8170, ext 2328


-----Original Message-----
From: Inoue, Hiroshi [mailto:inoue@tpf.co.jp]
Sent: Tuesday, September 09, 2014 8:06 PM
To: Alanoly Andrews
Cc: 'pgsql-odbc@postgresql.org'; 'Adrian Klaver'
Subject: Re: [ODBC] FW: [GENERAL] Re: [ADMIN] Cannot retrieve images inserted through VB and odbc, after a table
reorganization.

Hi Alanoly,

(2014/09/10 0:26), Alanoly Andrews wrote:
> Hi Hiroshi,
>
> Thanks for the response. I see a "mylog" file in the C:\ directory on the PC. But it is a one-liner which says
"detachingprocess". Apart from that I don't see any other log file apart from the one which I posted earlier and which
wasa file that we directed the "tracing" option in ODBC to write to. Can you let me know how to produce the Mylog file
andI shall try it it out.
 
>
> Thanks.

Please turn on the "MyLog (C:\\mylog_xxxx.log)" DataSource option using
  DataSource Administrator
or
  add debug=1; to your connection string.

regards,
Hiroshi Inoue

--
I am using the free version of SPAMfighter.
SPAMfighter has removed 12514 of my spam emails to date.
Get the free SPAMfighter here: http://www.spamfighter.com/len

Do you have a slow PC? Try a Free scan
http://www.spamfighter.com/SLOW-PCfighter?cid=sigen

________________________________

If you no longer wish to receive any of our emails, click on
UNSUBSCRIBE.<mailto:unsubscribe@invera.com?subject=***Unsubscribe***>This e-mail may be privileged and/or confidential,
andthe sender does not waive any related rights and obligations. Any distribution, use or copying of this e-mail or the
informationit contains by other than an intended recipient is unauthorized. If you received this e-mail in error,
pleaseadvise me (by return e-mail or otherwise) immediately.
 

Si vous ne désirez plus recevoir de nos courriels, veuillez appuyer sur
DÉSABONNEMENT.<mailto:unsubscribe@invera.com?subject=***Unsubscribe***>Ce courriel est confidentiel et protégé.
L'expéditeurne renonce pas aux droits et obligations qui s'y rapportent. Toute diffusion, utilisation ou copie de ce
messageou des renseignements qu'il contient par une personne autre que le (les) destinataire(s) désigné(s) est
interdite.Si vous recevez ce courriel par erreur, veuillez m'en aviser immédiatement, par retour de courriel ou par un
autremoyen.