Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search for
  Advanced Search

someone working to add merge?


  • From: Jaime Casanova <systemguards(at)gmail(dot)com>
  • To: PG Hackers <pgsql-hackers(at)postgresql(dot)org>
  • Subject: someone working to add merge?
  • Date: Fri, 11 Nov 2005 09:03:19 -0500
  • Message-id: <c2d9e70e0511110603q1799d811u6e4564be516b10ce(at)mail(dot)gmail(dot)com>

Hi,


there is someone working in add the MERGE statement?

i don't find much about what a good implementation of merge must have...

i think what it needs to do is something like:

- try to lock the rows for update
    - if the lock cannot be immediatly acquire ask why
    - if the rows are already locked, wait and try again?
    - if no rows were found try de insert part
    - if there was any other error, abort
    - else update

so i suppose we can reuse many of the code breaking the merge in 3
pieces... for now they are just thougths, i will think more in this
and try to implement it...

comments? ideas? suggestions?

--
regards,
Jaime Casanova
(DBA: DataBase Aniquilator ;)



Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group