Displaying 1 result from an estimated 1 matches for "measurepoint_background".
2006 Mar 02
1
PostgreSQL function in an insert statement
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 inser...