X-Original-To: pgsql-admin-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id DE7769FB2DF for ; Sat, 9 Sep 2006 08:07:35 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 03093-09 for ; Sat, 9 Sep 2006 08:07:26 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from py-out-1112.google.com (py-out-1112.google.com [64.233.166.180]) by postgresql.org (Postfix) with ESMTP id 850BD9FB25A for ; Sat, 9 Sep 2006 08:07:26 -0300 (ADT) Received: by py-out-1112.google.com with SMTP id d80so1211768pyd for ; Sat, 09 Sep 2006 04:07:24 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:mime-version:content-type; b=K0mEwtbzIlB8s3bJMGT0jhd/c+VbisLRJU4aT71oNdzltWB0t9n/ythoU3aGmypSNaz79EkzeCQ+KsRM+LcjXNZR2skrdkCrgsv2xasX8LfAfIpaXIp0lqcltRmfBVNelkHOkNvYOTZN6xqtXx8KRe9UqZql4D/FsPTTAo8+2v4= Received: by 10.65.114.11 with SMTP id r11mr2858111qbm; Sat, 09 Sep 2006 04:07:24 -0700 (PDT) Received: by 10.65.192.4 with HTTP; Sat, 9 Sep 2006 04:07:24 -0700 (PDT) Message-ID: <3650d0d50609090407j237bb710h9bde1675c773925d@mail.gmail.com> Date: Sat, 9 Sep 2006 16:37:24 +0530 From: "Purusothaman A" To: pgsql-general@postgresql.org, pgsql-admin@postgresql.org, "Shilpa Mohidekar" Subject: Problem with lo_export() and lo_import() from remote machine. MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_121070_23674909.1157800044552" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=2.03 tagged_above=0 required=5 tests=AWL, DNS_FROM_RFC_ABUSE, HTML_10_20, HTML_MESSAGE, SPF_PASS X-Spam-Level: ** X-Archive-Number: 200609/73 X-Sequence-Number: 22987 ------=_Part_121070_23674909.1157800044552 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline Hi all, I have problem while using "lo_export()" and "lo_import()" from remote system. eg: **** select lo_export(img_file, 'E:\\temp\\1001.jpg') from master where emp_id = '1001'; insert into master(img_file) values(lo_import('E:\\temp\\1001.jpg')) where emp_id = '1001'; Here column "img_file" is OID data type. The above query works, if I enter from PostgreSQL server machine. But the same query fails, if I enter from any other client machine in my LAN. All other queries work well from remote machine, which do not deal OID data type column. any suggestions would be appreciated. :) Purusothaman A ------=_Part_121070_23674909.1157800044552 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline Hi all,

I have problem while using "lo_export()" and "lo_import()" from remote system.

eg:
****
select lo_export(img_file, 'E:\\temp\\1001.jpg') from master where emp_id = '1001';
insert into master(img_file) values(lo_import('E:\\temp\\1001.jpg')) where emp_id = '1001';

Here column "img_file" is OID data type.

The above query works, if I enter from PostgreSQL server machine.
But the same query fails, if I enter from any other client machine in my LAN.

All other queries work well from remote machine, which do not deal OID data type column.

any suggestions would be appreciated.

:)
Purusothaman A


------=_Part_121070_23674909.1157800044552--