Hi there,
I wont insert a picture in a PostgrSQL-DB via the function lo_import.
Therfore I modify the value of an ‘oid’ column.
@measurepoint = Measurepoint.new(params[:measurepoint])
@measurepoint.measurepoint_background =
“lo_import(’#{@params[‘measurepoint’][‘measurepoint_background’]’)”
@measurepoint.save
The result is an error like this:
PGError: ERROR: invalid input syntax for type oid:
because the function is quotet in the values of the insert statement.
‘lo_import(‘picture’)’
^ ^
These quotes are responsible for a wrong interpretation from the
database,
because a function in quotes is not a function, its a string.
Is it possible to give the modified insert statement without quotes to
the
insert statement.
Thank you for a solution and please apologize my bad english.
–
Torsten Senf