| From: | Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> |
|---|---|
| To: | "Thomas F(dot) O'Connell" <tfo(at)sitening(dot)com> |
| Cc: | Cristian Prieto <cristian(at)clickdiario(dot)com>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Insert Ignore or something similar... |
| Date: | 2005-09-06 03:51:42 |
| Message-ID: | 20050906035142.GD22392@surnet.cl |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Mon, Sep 05, 2005 at 10:35:49PM -0500, Thomas F. O'Connell wrote:
> I don't think any such behavior exists in PostgreSQL, and based on a
> reading of the behavior in MySQL, I can't imagine it ever existing
> considering the preference of PostgreSQL developers for correct (and
> sane) behavior. INSERT IGNORE seems like a foot-cannon...
What is it supposed to do? If ignoring errors is the behavior Cristian
wants, it's possible to do with savepoints (or PL/pgSQL exceptions).
--
Alvaro Herrera -- Valdivia, Chile Architect, www.EnterpriseDB.com
"People get annoyed when you try to debug them." (Larry Wall)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Thomas F. O'Connell | 2005-09-06 04:01:01 | Re: Insert Ignore or something similar... |
| Previous Message | Thomas F. O'Connell | 2005-09-06 03:35:49 | Re: Insert Ignore or something similar... |