Re: Insert (or update) to a partitioned table returns 0 rows updated

From: Kris Jurka <books(at)ejurka(dot)com>
To: Vincent Lasmarias <vlasmarias(at)guardianmms(dot)com>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Insert (or update) to a partitioned table returns 0 rows updated
Date: 2007-05-21 16:27:48
Message-ID: Pine.BSO.4.64.0705211220190.2299@leary.csoft.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

On Thu, 17 May 2007, Vincent Lasmarias wrote:

> When I insert to (or update) the master table of
> partitioned tables, the method's returning 0 (which
> indicates that 0 rows are updated). I then checked the
> DB and verified that it actually did successfully
> insert one entry. My guess for this behavior is that
> it's because the updated table is the child table and
> not the master table. Is that expected?
>

Yes. See http://www.postgresql.org/docs/8.2/static/rules-status.html

Kris Jurka

In response to

Browse pgsql-jdbc by date

  From Date Subject
Next Message Luca Ferrari 2007-05-24 06:24:48 question about AbstractJdbc2Statement
Previous Message Kris Jurka 2007-05-21 15:35:11 Re: JDBC and composite types