Re: BUG #14351: Upsert not working in case of partitioned tables

On Mon, Oct 03, 2016 at 02:21:00PM +0000, ing.marco.colombo@gmail.com wrote:
> The following bug has been logged on the website:
>
> Bug reference:      14351
> Logged by:          Marco Colombo
> Email address:      ing.marco.colombo@gmail.com
> PostgreSQL version: 9.5.4
> Operating system:   CentOS 7.2
> Description:
>
> Hi, I'm trying to use a upsert query on a partitioned table.
>
> While same
> query/data import works from a standard table, this does not work in case
> table is partioned. I see no mention anywhere that a partitioned table does
> not support upsert queries.
> Error is:
>
> ERROR:  duplicate key value violates unique constraint
> "dh_1_p_20160904_pkey"
> DETAIL:  Key (id, ts, did, pid)=(2742, 2016-09-01 17:00:00, 1, 0) already
> exists.
> CONTEXT:  SQL statement "insert into partitions.dh_1_p_20160904 values
> (new.*)"
> PL/pgSQL function dh_1_trg_ins() line 12 at SQL statement

What is the PL/pgsql function, and how are you calling it?

In future, you could help get your problem addressed much more easily
by sending a complete self-contained example reproducing the problem.
If you can't do that, the bare minimum you need to send is the code
that caused the problem and the error it produced.

Best,
David.
--
David Fetter <david(at)fetter(dot)org> http://fetter.org/
Phone: +1 415 235 3778  AIM: dfetter666  Yahoo!: dfetter
Skype: davidfetter      XMPP: david(dot)fetter(at)gmail(dot)com

Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate