Re: ERROR Inserting into partition - Mailing list pgsql-admin

From David G. Johnston
Subject Re: ERROR Inserting into partition
Date
Msg-id CAKFQuwbOfs-vtxODz9o8_mHWOu2=kfYjL17NUTO7pp6C+Wo1kQ@mail.gmail.com
Whole thread Raw
In response to ERROR Inserting into partition  (Sbob <sbob@quadratum-braccas.com>)
List pgsql-admin

INSERT INTO part_schema.cust_info_5
( cust_last_name)
SELECT l_name from public.global_addr WHERE l_name = 'NELL';
ERROR:  new row for relation "cust_info_5" violates partition constraint
DETAIL:  Failing row containd (null, null, null, null, null, 'NELL',
null, null, null, null, null,null).


Your to: address for this email is so confusing...and this really isn't either a performance issue (meaning speed, not failure to perform at all) or admin issue (general advice for running the server).  It seems like a bug report, though one missing the most critical piece of information, the version.

David J.

pgsql-admin by date:

Previous
From: Sbob
Date:
Subject: ERROR Inserting into partition
Next
From: "David G. Johnston"
Date:
Subject: Re: ERROR Inserting into partition