Shawn Gennaria wrote:
> OK, I'm looking at
> www.postgresql.org/docs/9.4/interactive/plpgsql-control-structures.html#PLPGSQL-EXCEPTION-DIAGNOSTICS-VALUES
> which I completely missed before. This sounds like my answer, but it's not
> returning anything when I try to extract the COLUMN_NAME.
As far as I recall, COLUMN_NAME is new in 9.4. If you're trying with an
earlier version, you can't get that info other than by parsing the error
message string.
--
Álvaro Herrera http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services