Search Postgresql Archives

Problem with lo_export() and lo_import() from remote machine.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux