| From: | Richard Huxton <dev(at)archonet(dot)com> |
|---|---|
| To: | Csaba Nagy <nagy(at)ecircle-ag(dot)com> |
| Cc: | "ON(dot)KG" <skyer(at)on(dot)kg>, Postgres general mailing list <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: duplicate key violates unique constraint |
| Date: | 2005-06-13 16:03:33 |
| Message-ID: | 42ADAE55.2070704@archonet.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-sql |
Csaba Nagy wrote:
> That would work indeed. Bit I guess the savepoint solution will be the
> simplest and fastest if the OP has or can install 8.0 version.
I'd say so. Otherwise you'll just sit on the lock, and then still have
to deal with an error later anyway when the lock times out.
--
Richard Huxton
Archonet Ltd
| From | Date | Subject | |
|---|---|---|---|
| Next Message | marcelo Cortez | 2005-06-13 16:15:51 | md5 autentication error |
| Previous Message | Csaba Nagy | 2005-06-13 15:58:52 | Re: duplicate key violates unique constraint |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | ON.KG | 2005-06-13 16:22:39 | duplicate key violates unique constraint |
| Previous Message | Csaba Nagy | 2005-06-13 15:58:52 | Re: duplicate key violates unique constraint |