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>
- Cc: "Roland Walter *EXTERN*" <roland(dot)walter(dot)rwa(at)gmx(dot)net>, "Peter Neu" <peter(dot)neu(at)gmx(dot)net>, <pgsql-jdbc(at)postgresql(dot)org>
- Subject: Re: Efficient Insert statement for one record into multiple
- Date: Mon, 18 Dec 2006 16:06:03 +0100
>> This is _bad_.
> No, this works
Oops, indeed.
>> What if somebody did a nextval("primary_A") between the insert into A
>> and the insert into B?
> as long as you use currval then it works as advertised
Sorry, I didn't realize that currval returns the last value retrieved
_in this session_.
YOurs,
Laurenz Albe
- 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: