Re: Problem with memory in C function

[Diogo Biazus <diogo@ikono.com.br>]

Tom Lane wrote:

Diogo Biazus <diogo@ikono.com.br> writes:
  

Am I doing something wrong?
    

You forgot to set up the length word that's required for a bytea value
(or any other variable-length datatype).  The system is taking the first
four bytes of the file data as the datum length.
  

Thanks, now I've got it working.
I've done a bytea_import function, that works like lo_import, but you put it into a insert statement:

insert into table_name (field_name) values (bytea_import('/path_to_file_on_server'));

Does anyone think it could be useful in the /contrib?

My Regards,

-- 
Diogo Biazus
diogo@ikono.com.br
http://www.ikono.com.br