Re: How to determine offending column for insert exceptions

Поиск
Список
Период
Сортировка
От Shawn Gennaria
Тема Re: How to determine offending column for insert exceptions
Дата
Msg-id CADx9qBnUOV964nhA=s2XZnpsrc=nJWx-rS4QUXjp1aHLKNDbpA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: How to determine offending column for insert exceptions  (Alvaro Herrera <alvherre@2ndquadrant.com>)
Ответы Re: How to determine offending column for insert exceptions
Re: How to determine offending column for insert exceptions
Список pgsql-sql
<div dir="ltr">Glad to hear it's here just in time.  I am using 9.4, though, so I wish I could figure out why it's
returningNULL when I use it.  And the error message string doesn't contain any column name to parse in my output.<br
/></div><divclass="gmail_extra"><br /><div class="gmail_quote">On Tue, Apr 21, 2015 at 12:46 PM, Alvaro Herrera <span
dir="ltr"><<ahref="mailto:alvherre@2ndquadrant.com" target="_blank">alvherre@2ndquadrant.com</a>></span>
wrote:<br/><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><span
class="">ShawnGennaria wrote:<br /> > OK, I'm looking at<br /> > <a
href="http://www.postgresql.org/docs/9.4/interactive/plpgsql-control-structures.html#PLPGSQL-EXCEPTION-DIAGNOSTICS-VALUES"
target="_blank">www.postgresql.org/docs/9.4/interactive/plpgsql-control-structures.html#PLPGSQL-EXCEPTION-DIAGNOSTICS-VALUES</a><br
/>> which I completely missed before.  This sounds like my answer, but it's not<br /> > returning anything when I
tryto extract the COLUMN_NAME.<br /><br /></span>As far as I recall, COLUMN_NAME is new in 9.4.  If you're trying with
an<br/> earlier version, you can't get that info other than by parsing the error<br /> message string.<br /><span
class="HOEnZb"><fontcolor="#888888"><br /><br /> --<br /> Álvaro Herrera                <a
href="http://www.2ndQuadrant.com/"target="_blank">http://www.2ndQuadrant.com/</a><br /> PostgreSQL Development, 24x7
Support,Remote DBA, Training & Services<br /></font></span></blockquote></div><br /></div> 

В списке pgsql-sql по дате отправления:

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: How to determine offending column for insert exceptions
Следующее
От: "David G. Johnston"
Дата:
Сообщение: Re: How to determine offending column for insert exceptions