Re: Efficient Insert statement for one record into multiple - Mailing list pgsql-jdbc

From Albe Laurenz
Subject Re: Efficient Insert statement for one record into multiple
Date
Msg-id 52EF20B2E3209443BC37736D00C3C1380BF08124@EXADV1.host.magwien.gv.at
Whole thread Raw
Responses Re: Efficient Insert statement for one record into multiple
List pgsql-jdbc
>> If I got you right I cannot link this two insert statements together.
>> So I need two times to open a prepared statement and execute it.
>> Would I need to do this in a transaction or is it safe to do this
>> without it?
>
> It's safe to do it without a transaction, what you have to make sure
> is that you do it with the same connection object.

Safe as far as currval() is concerned, yes, but then the second
INSERT could fail while the first INSERT is committed, right?

Yours,
Laurenz Albe

pgsql-jdbc by date:

Previous
From: "Albe Laurenz"
Date:
Subject: Re: Efficient Insert statement for one record into multiple
Next
From: Roland Walter
Date:
Subject: Re: Efficient Insert statement for one record into multiple