From: | PG Bug reporting form <noreply(at)postgresql(dot)org> |
---|---|
To: | pgsql-bugs(at)lists(dot)postgresql(dot)org |
Cc: | dirkjan(at)ochtman(dot)nl |
Subject: | BUG #15666: Seemingly incorrect error reporting/logging for violation of non-null constraint |
Date: | 2019-03-04 09:55:31 |
Message-ID: | 15666-ead8afdaca9e8cc4@postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
The following bug has been logged on the website:
Bug reference: 15666
Logged by: Dirkjan Ochtman
Email address: dirkjan(at)ochtman(dot)nl
PostgreSQL version: 11.2
Operating system: Linux
Description:
I'm modifying the data model for the application I work on, and in the
process of doing so, I'm seeing this error:
db | 2019-03-04 09:48:54.485 UTC [198] ERROR: null value in column
"accountid" violates not-null constraint
db | 2019-03-04 09:48:54.485 UTC [198] DETAIL: Failing row contains
(14, 138962.38, 0, null, 13).
db | 2019-03-04 09:48:54.485 UTC [198] STATEMENT: insert into
JournalEntryRecord (accountId, amount, journalEntryId, type, id) values ($1,
$2, $3, $4, $5)
This is very confusing to me because the tuple from the "Failing row"
message clearly has the `null` in fourth position, but the error message
reports that the column "accountid" (or "accountId" -- but I understand
column names are casefolded) is the problem, which should ostensibly be the
first value from the failing row tuple (if that tuple is ordered the same
way as the statement suggests).
From | Date | Subject | |
---|---|---|---|
Next Message | Derek Hans | 2019-03-04 13:57:48 | Re: BUG #15662: Row update in foreign partition does not move row based on partition key |
Previous Message | PG Bug reporting form | 2019-03-04 09:55:06 | BUG #15665: ERROR: could not load library "/usr/pgsql-11/lib/oracle_fdw.so" |