Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Efficient Insert statement for one record into multiple
- From: "Albe Laurenz" <all(at)adv(dot)magwien(dot)gv(dot)at>
- To: "Dave Cramer *EXTERN*" <pg(at)fastcrypt(dot)com>, "Peter Neu" <peter(dot)neu(at)gmx(dot)net>
- Cc: <pgsql-jdbc(at)postgresql(dot)org>
- Subject: Re: Efficient Insert statement for one record into multiple
- Date: Mon, 18 Dec 2006 16:36:11 +0100
>> 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
- Follow-Ups:
- Re: Efficient Insert statement for one record into multiple
- From: Roland Walter
- Re: Efficient Insert statement for one record into multiple
- Prev by Date: Re: Efficient Insert statement for one record into multiple
- Next by Date: Re: Efficient Insert statement for one record into multiple
- Previous by thread: Re: Efficient Insert statement for one record into multiple
- Next by thread: Re: Efficient Insert statement for one record into multiple
- Indexes: