From:
Andrew Dunstan <andrew(at)dunslane(dot)net>
To:
Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
Cc:
Stephen Frost <sfrost(at)snowman(dot)net>,
Robert Haas <robertmhaas(at)gmail(dot)com>,
Simon Riggs <simon(at)2ndquadrant(dot)com>, Greg Smith <greg(at)2ndquadrant(dot)com>,
Marko Tiikkaja <marko(dot)tiikkaja(at)cs(dot)helsinki(dot)fi>,
Boxuan Zhai <bxzhai2010(at)gmail(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject:
Re: Re: new patch of MERGE (merge_204) & a question about
duplicated ctid
Date:
2011-01-03 16:06:15
Message-ID:
4D21F3F7.4000001@dunslane.net (view raw or flat )
Thread:
2010-12-04 13:27:52 from Boxuan Zhai <bxzhai2010(at)gmail(dot)com>
2010-12-05 14:12:09 from David Fetter <david(at)fetter(dot)org>
2010-12-05 18:12:57 from Greg Smith <greg(at)2ndquadrant(dot)com>
2010-12-06 13:17:46 from Boxuan Zhai <bxzhai2010(at)gmail(dot)com>
2010-12-07 17:53:49 from "Erik Rijkers" <er(at)xs4all(dot)nl>
2010-12-29 11:51:42 from Greg Smith <greg(at)2ndquadrant(dot)com>
2010-12-29 12:14:32 from Greg Smith <greg(at)2ndquadrant(dot)com>
2010-12-29 12:43:55 from Marko Tiikkaja <marko(dot)tiikkaja(at)cs(dot)helsinki(dot)fi>
2010-12-30 02:39:38 from Greg Smith <greg(at)2ndquadrant(dot)com>
2010-12-30 02:45:31 from Marko Tiikkaja <marko(dot)tiikkaja(at)cs(dot)helsinki(dot)fi>
2010-12-30 04:17:09 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-12-30 07:02:51 from Greg Smith <greg(at)2ndquadrant(dot)com>
2010-12-30 11:46:58 from Marko Tiikkaja <marko(dot)tiikkaja(at)cs(dot)helsinki(dot)fi>
2011-01-03 06:53:58 from Greg Smith <greg(at)2ndquadrant(dot)com>
2011-01-03 09:37:56 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2011-01-03 13:12:10 from Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
2011-01-03 13:35:53 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2011-01-03 14:57:27 from Robert Haas <robertmhaas(at)gmail(dot)com>
2011-01-03 15:56:27 from Stephen Frost <sfrost(at)snowman(dot)net>
2011-01-03 15:58:44 from Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
2011-01-03 16:02:26 from Robert Haas <robertmhaas(at)gmail(dot)com>
2011-01-03 16:08:51 from Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
2011-01-03 16:21:15 from Robert Haas <robertmhaas(at)gmail(dot)com>
2011-01-03 16:36:25 from Florian Pflug <fgp(at)phlo(dot)org>
2011-01-03 17:09:32 from Robert Haas <robertmhaas(at)gmail(dot)com>
2011-01-03 16:29:19 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2011-01-03 16:35:18 from Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
2011-01-03 16:49:23 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2011-01-03 17:01:00 from Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
2011-01-03 17:48:57 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2011-01-03 17:50:39 from Robert Haas <robertmhaas(at)gmail(dot)com>
2011-01-03 18:18:57 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
2011-01-03 18:34:57 from Robert Haas <robertmhaas(at)gmail(dot)com>
2011-01-03 19:01:20 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
2011-01-03 19:11:23 from Robert Haas <robertmhaas(at)gmail(dot)com>
2011-01-04 10:11:59 from Greg Smith <greg(at)2ndquadrant(dot)com>
2011-01-03 16:06:15 from Andrew Dunstan <andrew(at)dunslane(dot)net>
2011-01-04 09:44:32 from Greg Smith <greg(at)2ndquadrant(dot)com>
2011-01-04 16:27:08 from David Fetter <david(at)fetter(dot)org>
2011-01-04 17:02:54 from Marko Tiikkaja <marko(dot)tiikkaja(at)cs(dot)helsinki(dot)fi>
2011-01-04 17:09:45 from David Fetter <david(at)fetter(dot)org>
2011-01-05 02:27:10 from Greg Smith <greg(at)2ndquadrant(dot)com>
2011-01-05 07:09:57 from David Fetter <david(at)fetter(dot)org>
2011-01-18 18:21:18 from Greg Smith <greg(at)2ndquadrant(dot)com>
2010-12-30 14:35:38 from Andrew Dunstan <andrew(at)dunslane(dot)net>
Lists:
pgsql-hackers
On 01/03/2011 10:58 AM, Heikki Linnakangas wrote:
>>
>> In general, I also thought/expected to have some kind of UPSERT type
>> capability with our initial MERGE support, even if it requires a big
>> lock and won't operate concurrently, etc.
>
>
> You can of course LOCK TABLE as a work-around, if that's what you want.
I think we need to state this in large red letters in the docs, if
that's the requirement.
cheers
andrew
In response to
pgsql-hackers by date
Next :From: Heikki LinnakangasDate: 2011-01-03 16:08:51Subject : Re: Re: new patch of MERGE (merge_204) & a question about
duplicated ctidPrevious :From : Robert HaasDate : 2011-01-03 16:02:26Subject : Re: Re: new patch of MERGE (merge_204) & a question about
duplicated ctid
