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