Search Postgresql Archives

Re: Errors using JDBC batchUpdate with plpgsql function

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Sun, May 3, 2015 at 2:33 PM, Nanker Phelge <n.phelge01@xxxxxxxxx> wrote:
inner ex 2 =A result was returned when none was expected.


​I don't know what is or is not allowed by JDBC but it is reasonable to assume that you cannot create batches of SELECT statements.  The intent of batching is to repeatedly execute the same INSERT​ statement multiple times while using different values for parameters.

I would suggest probably writing INSERT onto a temporary table and then writing a plpgsql function that would then process said temporary table.

David J.


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux