| From: | Roland Walter <roland(dot)walter(dot)rwa(at)gmx(dot)net> |
|---|---|
| To: | Albe Laurenz <all(at)adv(dot)magwien(dot)gv(dot)at> |
| Cc: | Dave Cramer *EXTERN* <pg(at)fastcrypt(dot)com>, 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: | 2006-12-18 16:22:37 |
| Message-ID: | 4586C04D.5070008@gmx.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-jdbc |
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Albe Laurenz wrote:
>>> 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?
Yes, but as I said, it depends of the application if you do the two
insertions in one transaction.
Regards,
Roland.
- --
Dipl.-Phys. Roland Walter
mailto: roland (dot) walter (dot) rwa (at) gmx (dot) net
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.2 (GNU/Linux)
Comment: Using GnuPG with SUSE - http://enigmail.mozdev.org
iD8DBQFFhsBMxoOEAkary1ERAlp2AJ97Sw/pKIPr7Lm4QPKBYg1wD4oQZwCdG/0r
xmvivi1ApSuI8viTpcKbIS0=
=A8ZT
-----END PGP SIGNATURE-----
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Edoardo Ceccarelli | 2006-12-18 17:57:23 | pg_clog |
| Previous Message | Albe Laurenz | 2006-12-18 15:36:11 | Re: Efficient Insert statement for one record into multiple |