On 2/23/20 1:06 AM, Andrus wrote:
> Hi!
>
>> What does the log_error_verbosity setting in postgresql.conf show?
>
> It is not set. postgresql.conf contains it default value from installation:
>
> #log_error_verbosity = default # terse, default, or verbose messages
>
> I changed it to
>
> log_error_verbosity = verbose
>
> but problem persists.
>
> postgres log file contains
>
> 2020-02-23 09:02:27.646 GMT [11252] ERROR: 23503: insert or update on
> table "rid" violates foreign key constraint "rid_yhik_fkey"
> 2020-02-23 09:02:27.646 GMT [11252] DETAIL: Key (yhik)=(xx ) is not
> present in table "mootyhik".
> 2020-02-23 09:02:27.646 GMT [11252] LOCATION: ri_ReportViolation,
> d:\pginstaller_12.auto\postgres.windows-x64\src\backend\utils\adt\ri_triggers.c:2474
>
> 2020-02-23 09:02:27.646 GMT [11252] STATEMENT: insert into rid
> (dokumnr, yhik) values (2065, 'xx')
>
>
> but application shows only
>
> ERROR: insert or update on table "rid" violates foreign key constraint
> "rid_yhik_fkey"
I don't have an answer for you. There maybe someone else on this list
that could help, though I think your best bet would be to ask the
question again on the pgsql-odbc list.
>
> Andrus.
--
Adrian Klaver
adrian.klaver@aklaver.com
