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

From: Vincent Lasmarias <vlasmarias(at)guardianmms(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Insert (or update) to a partitioned table returns 0 rows updated
Date: 2007-05-17 22:33:13
Message-ID: 228537.48279.qm@web411.biz.mail.mud.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

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?

Thanks,
Vince

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Marcin Gala 2007-05-19 11:23:35 JDBC and composite types
Previous Message Geert Verhaag 2007-05-15 13:31:25 Re: JDBC and ClassNotFoundException