pg_lo_import meet error
Dear my friends.... I am using postgres 7.2.x and SuSE 9.1. I created a column with datatype bytea. The name of the column is emoicon I did like this: kv=# insert into salesreport (salesid, custid, emoicon) values('13', '4531', lo_import('/localhome/patrixlinux/arsip/proyek/qt/kv/client/images/1.png')); ERROR: column "emoicon" is of type bytea but expression is of type oid HINT: You will need to rewrite or cast the expression. kv=# kv=# insert into salesreport (salesid, custid, emoicon) values('13', '4531', pg_lo_import('/localhome/patrixlinux/arsip/proyek/qt/kv/client/images/1.png')); ERROR: function pg_lo_import("unknown") does not exist HINT: No function matches the given name and argument types. You may need to add explicit type casts. kv=# but comes error. What is my mistake? Please tell me.... Thank you very much in advance. _______________________________ Do you Yahoo!? Win 1 of 4,000 free domain names from Yahoo! Enter now. http://promotions.yahoo.com/goldrush
participants (1)
-
Prabu Subroto