insert data into partitioned tables via Java application

From: cap20 <ravivarma20(at)yahoo(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: insert data into partitioned tables via Java application
Date: 2008-06-18 00:53:28
Message-ID: 17957653.post@talk.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc


I am trying to do an insert data into EDB partitioned tables via front end
application (Java) but the application failing to do an insert. The problem
I identified is since the insert happening into partitioned tables in the
background when you do an insert into base table, so the insert returning
returning Zero rows affected message back to application. So it is failing,
is there any work-around for this.

Any help will be greatly appreciated.

Thanks,
Cap20.
--
View this message in context: http://www.nabble.com/insert-data-into-partitioned-tables-via-Java-application-tp17957653p17957653.html
Sent from the PostgreSQL - jdbc mailing list archive at Nabble.com.

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Craig Ringer 2008-06-18 07:40:39 Re: insert data into partitioned tables via Java application
Previous Message John T. Dow 2008-06-13 21:56:24 Re: Populating large tables with occasional bad values