| From: | Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au> |
|---|---|
| To: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
| Cc: | elein <elein(at)varlena(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Adding MERGE to the TODO list (resend with subject) |
| Date: | 2004-05-09 01:50:00 |
| Message-ID: | 409D8E48.3070805@familyhealth.com.au |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-hackers pgsql-sql |
> What does the MERGE command do? I have never heard of it, so I doubt
> someone is working on it.
It is basically the SQL standard version of MySQL's REPLACE syntax. It
does an update-else-insert set. However, the trick is that it uses some
sort of next key locking to ensure that it cannot fail. Something that
is impossible to do in PostgreSQL at the moment. Nested transactions
will help, however.
Chris
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alvaro Herrera | 2004-05-09 03:54:05 | Re: Adding MERGE to the TODO list (resend with subject) |
| Previous Message | wespvp | 2004-05-09 00:07:43 | Slow network retrieves |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alvaro Herrera | 2004-05-09 03:54:05 | Re: Adding MERGE to the TODO list (resend with subject) |
| Previous Message | Christopher Kings-Lynne | 2004-05-09 01:45:12 | Re: Comments on all system objects |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alvaro Herrera | 2004-05-09 03:54:05 | Re: Adding MERGE to the TODO list (resend with subject) |
| Previous Message | elein | 2004-05-08 23:19:05 | Re: Adding MERGE to the TODO list (resend with subject) |