Re: Weird SQL Problem - Mailing list pgsql-novice

From Josh Berkus
Subject Re: Weird SQL Problem
Date
Msg-id 200509071722.01588.josh@agliodbs.com
Whole thread Raw
In response to Weird SQL Problem  (<operationsengineer1@yahoo.com>)
List pgsql-novice
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

pgsql-novice by date:

Previous
From: Josh Berkus
Date:
Subject: Re: Get a list of columns for a table
Next
From: Tom Lane
Date:
Subject: Re: MVCC handling of updates