OE,
> what am i missing here? why is pgsql trying to find
> the column? rework_notes is varchar and i've done
> inserts for similarnote setups right and left with no
> problem.
At a guess, rework_notes isn't being quoted properly. That's the error
you'd get if you tried to:
SET rework_notes = aaaaaaaaaaaaaaaaa
instead of
SET rework_notes = 'aaaaaaaaaaaaaaaaaa'
--
--Josh
Josh Berkus
Aglio Database Solutions
San Francisco