Re: Insert (or update) to a partitioned table returns 0 rows updated - Mailing list pgsql-jdbc

From Kris Jurka
Subject Re: Insert (or update) to a partitioned table returns 0 rows updated
Date
Msg-id Pine.BSO.4.64.0705211220190.2299@leary.csoft.net
Whole thread Raw
In response to Insert (or update) to a partitioned table returns 0 rows updated  (Vincent Lasmarias <vlasmarias@guardianmms.com>)
List 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

pgsql-jdbc by date:

Previous
From: Kris Jurka
Date:
Subject: Re: JDBC and composite types
Next
From: Luca Ferrari
Date:
Subject: question about AbstractJdbc2Statement