Re: JDBC executeUpdate returns 0 for table partitioning rule insertion

From: Dave Cramer <pg(at)fastcrypt(dot)com>
To: Tea Yu <teayu1(at)gmail(dot)com>
Cc: <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: JDBC executeUpdate returns 0 for table partitioning rule insertion
Date: 2005-12-06 12:54:19
Message-ID: 10B643D1-6EFF-44BF-A677-61BFFA06EEFE@fastcrypt.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Tea,

Does the data actually go in the partitioned table, and if so can you
send us a test case.

The driver is just reporting the result code from the backend so ???

Dave
On 6-Dec-05, at 5:45 AM, Tea Yu wrote:

> Hi there,
>
> The scenario is quite simple - insert into a partitioned table in
> which a
> rule forwards the insertion into an inherited partition
> (Postgresql 8.1)
>
> However, JDBC returns 0 during Statement.executeUpdate(sql). It
> behaves
> normally when partition rule is removed.
>
> It applies to the following driver builds:
> 8.1 Build 404 (all JDBC ver)
> 8.2 dev Bulid 500 (all JDBC ver)
>
> Any clues? Thanks much!
>
> Tea
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster
>

In response to

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Dave Cramer 2005-12-06 12:55:22 Re: bug with 8.X level 4 driver?
Previous Message Dave Cramer 2005-12-06 12:52:54 Re: Problem with 8.1 driver