From:
Hannu Krosing <hannu(at)2ndQuadrant(dot)com>
To:
Noah Misch <noah(at)leadboat(dot)com>
Cc:
Markus Wanner <markus(at)bluegap(dot)ch>, Andres Freund <andres(at)anarazel(dot)de>,
pgsql-hackers(at)postgresql(dot)org
Subject:
Re: logical changeset generation v3 - comparison to Postgres-R change
set format
Date:
2013-01-13 11:30:41
Message-ID:
50F29AE1.1070109@2ndQuadrant.com (view raw or flat )
Thread:
2012-11-15 00:27:46 from andres(at)anarazel(dot)de (Andres Freund)
2012-11-15 01:17:01 from Andres Freund <andres(at)2ndquadrant(dot)com>
2012-11-15 01:17:02 from Andres Freund <andres(at)2ndquadrant(dot)com>
2012-11-15 14:22:56 from Heikki Linnakangas <hlinnakangas(at)vmware(dot)com>
2012-11-15 14:47:35 from Andres Freund <andres(at)2ndquadrant(dot)com>
2012-11-15 14:50:37 from Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
2012-11-15 15:12:14 from Andres Freund <andres(at)2ndquadrant(dot)com>
2012-11-15 15:19:06 from Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
2012-11-15 15:55:34 from Heikki Linnakangas <hlinnakangas(at)vmware(dot)com>
2012-11-15 16:23:34 from Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
2012-11-15 21:12:30 from Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
2012-11-26 19:13:33 from Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
2012-12-09 19:15:32 from Andres Freund <andres(at)2ndquadrant(dot)com>
2012-12-10 20:22:21 from Heikki Linnakangas <hlinnakangas(at)vmware(dot)com>
2012-12-10 20:23:08 from Heikki Linnakangas <hlinnakangas(at)vmware(dot)com>
2012-12-11 13:55:35 from Heikki Linnakangas <hlinnakangas(at)vmware(dot)com>
2012-12-11 13:56:38 from Heikki Linnakangas <hlinnakangas(at)vmware(dot)com>
2012-12-11 14:44:39 from Andres Freund <andres(at)2ndquadrant(dot)com>
2012-12-11 15:43:12 from Andres Freund <andres(at)2ndquadrant(dot)com>
2012-12-11 15:44:36 from Andres Freund <andres(at)2ndquadrant(dot)com>
2012-12-11 20:10:32 from Robert Haas <robertmhaas(at)gmail(dot)com>
2012-12-11 22:05:32 from Dimitri Fontaine <dimitri(at)2ndQuadrant(dot)fr>
2012-12-11 22:24:08 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2012-12-11 22:51:25 from Dimitri Fontaine <dimitri(at)2ndQuadrant(dot)fr>
2012-12-11 22:52:09 from Peter Geoghegan <peter(at)2ndquadrant(dot)com>
2012-12-11 22:58:06 from Dimitri Fontaine <dimitri(at)2ndQuadrant(dot)fr>
2012-12-11 23:58:25 from Andres Freund <andres(at)2ndquadrant(dot)com>
2012-12-11 19:11:58 from Andres Freund <andres(at)2ndquadrant(dot)com>
2012-12-13 09:31:39 from Heikki Linnakangas <hlinnakangas(at)vmware(dot)com>
2012-12-13 15:44:43 from Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
2012-11-15 01:17:03 from Andres Freund <andres(at)2ndquadrant(dot)com>
2012-11-15 16:31:55 from Peter Eisentraut <peter_e(at)gmx(dot)net>
2012-11-15 16:45:16 from Andres Freund <andres(at)2ndquadrant(dot)com>
2012-12-06 16:13:52 from Andres Freund <andres(at)2ndquadrant(dot)com>
2012-11-15 17:06:23 from Jeff Janes <jeff(dot)janes(at)gmail(dot)com>
2012-11-15 17:13:06 from Andres Freund <andres(at)2ndquadrant(dot)com>
2012-11-21 22:57:14 from Jeff Janes <jeff(dot)janes(at)gmail(dot)com>
2012-11-21 23:10:31 from Andres Freund <andres(at)2ndquadrant(dot)com>
2012-11-15 01:17:04 from Andres Freund <andres(at)2ndquadrant(dot)com>
2012-11-15 01:17:05 from Andres Freund <andres(at)2ndquadrant(dot)com>
2012-11-16 04:44:45 from Michael Paquier <michael(dot)paquier(at)gmail(dot)com>
2012-11-16 10:58:04 from Andres Freund <andres(at)2ndquadrant(dot)com>
2012-11-17 10:14:06 from Michael Paquier <michael(dot)paquier(at)gmail(dot)com>
2012-11-18 16:18:35 from Andres Freund <andres(at)2ndquadrant(dot)com>
2012-11-15 01:17:06 from Andres Freund <andres(at)2ndquadrant(dot)com>
2012-11-15 01:17:07 from Andres Freund <andres(at)2ndquadrant(dot)com>
2012-11-15 01:17:08 from Andres Freund <andres(at)2ndquadrant(dot)com>
2012-11-15 12:07:23 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2012-11-15 12:28:58 from Andres Freund <andres(at)2ndquadrant(dot)com>
2012-12-02 19:55:09 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2012-11-15 01:17:09 from Andres Freund <andres(at)2ndquadrant(dot)com>
2012-11-17 04:27:33 from Steve Singer <steve(at)ssinger(dot)info>
2012-11-15 01:17:10 from Andres Freund <andres(at)2ndquadrant(dot)com>
2012-11-15 01:17:11 from Andres Freund <andres(at)2ndquadrant(dot)com>
2012-12-03 02:52:08 from Steve Singer <steve(at)ssinger(dot)info>
2012-12-03 12:22:12 from Andres Freund <andres(at)2ndquadrant(dot)com>
2012-12-03 12:42:00 from Andres Freund <andres(at)2ndquadrant(dot)com>
2012-12-03 14:35:55 from Steve Singer <steve(at)ssinger(dot)info>
2012-12-03 14:48:10 from Andres Freund <andres(at)2ndquadrant(dot)com>
2012-12-03 14:56:20 from Steve Singer <steve(at)ssinger(dot)info>
2012-11-15 01:17:12 from Andres Freund <andres(at)2ndquadrant(dot)com>
2012-11-15 01:17:13 from Andres Freund <andres(at)2ndquadrant(dot)com>
2012-11-19 06:46:31 from Michael Paquier <michael(dot)paquier(at)gmail(dot)com>
2012-11-15 01:17:14 from Andres Freund <andres(at)2ndquadrant(dot)com>
2012-11-15 01:26:53 from Andres Freund <andres(at)2ndquadrant(dot)com>
2012-12-09 19:14:50 from Andres Freund <andres(at)2ndquadrant(dot)com>
2012-12-13 00:05:41 from Peter Geoghegan <peter(at)2ndquadrant(dot)com>
2012-12-13 17:29:00 from Andres Freund <andres(at)2ndquadrant(dot)com>
2012-12-13 20:03:44 from Andres Freund <andres(at)2ndquadrant(dot)com>
2012-12-13 22:29:06 from Robert Haas <robertmhaas(at)gmail(dot)com>
2012-12-13 22:37:11 from Andres Freund <andres(at)2ndquadrant(dot)com>
2012-12-13 23:35:00 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2012-12-14 11:46:22 from Andres Freund <andres(at)2ndquadrant(dot)com>
2012-12-14 19:01:30 from Robert Haas <robertmhaas(at)gmail(dot)com>
2012-12-15 00:19:26 from Andres Freund <andres(at)2ndquadrant(dot)com>
2012-12-16 14:55:41 from Andres Freund <andres(at)2ndquadrant(dot)com>
2012-12-18 20:20:56 from Robert Haas <robertmhaas(at)gmail(dot)com>
2012-12-18 22:25:05 from "anarazel(at)anarazel(dot)de" <andres(at)anarazel(dot)de>
2012-12-19 00:56:18 from Robert Haas <robertmhaas(at)gmail(dot)com>
2012-12-19 00:59:10 from Andres Freund <andres(at)2ndquadrant(dot)com>
2012-12-19 02:04:01 from Robert Haas <robertmhaas(at)gmail(dot)com>
2012-12-14 03:40:36 from Michael Paquier <michael(dot)paquier(at)gmail(dot)com>
2012-12-16 16:44:04 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2012-12-16 17:02:35 from Andres Freund <andres(at)2ndquadrant(dot)com>
2012-11-15 01:42:50 from Andres Freund <andres(at)2ndquadrant(dot)com>
2012-11-15 02:08:48 from Josh Berkus <josh(at)agliodbs(dot)com>
2012-11-15 04:08:26 from Michael Paquier <michael(dot)paquier(at)gmail(dot)com>
2012-11-15 09:34:45 from Andres Freund <andres(at)anarazel(dot)de>
2012-11-16 04:34:47 from Michael Paquier <michael(dot)paquier(at)gmail(dot)com>
2012-11-16 08:16:34 from Andrea Suisani <sickpig(at)opinioni(dot)net>
2012-11-19 00:31:13 from Michael Paquier <michael(dot)paquier(at)gmail(dot)com>
2012-11-16 13:46:39 from Markus Wanner <markus(at)bluegap(dot)ch>
2012-11-16 14:05:32 from Andres Freund <andres(at)2ndquadrant(dot)com>
2012-11-17 09:05:48 from Markus Wanner <markus(at)bluegap(dot)ch>
2012-11-16 14:14:32 from Andres Freund <andres(at)2ndquadrant(dot)com>
2012-11-17 09:22:40 from Markus Wanner <markus(at)bluegap(dot)ch>
2012-11-17 13:30:27 from Hannu Krosing <hannu(at)2ndQuadrant(dot)com>
2012-11-17 14:00:10 from Markus Wanner <markus(at)bluegap(dot)ch>
2012-11-17 14:40:49 from Hannu Krosing <hannu(at)2ndQuadrant(dot)com>
2012-11-17 17:41:39 from Markus Wanner <markus(at)bluegap(dot)ch>
2013-01-13 00:28:51 from Noah Misch <noah(at)leadboat(dot)com>
2013-01-13 10:49:27 from Hannu Krosing <hannu(at)2ndQuadrant(dot)com>
2013-01-13 11:30:41 from Hannu Krosing <hannu(at)2ndQuadrant(dot)com>
2013-01-13 17:44:44 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2013-01-13 18:02:47 from Andres Freund <andres(at)2ndquadrant(dot)com>
2013-01-13 18:02:46 from Markus Wanner <markus(at)bluegap(dot)ch>
2013-01-13 20:04:31 from Hannu Krosing <hannu(at)2ndQuadrant(dot)com>
2013-01-14 09:03:48 from Markus Wanner <markus(at)bluegap(dot)ch>
2013-01-13 20:06:21 from Dimitri Fontaine <dimitri(at)2ndQuadrant(dot)fr>
2013-01-14 08:51:01 from Hannu Krosing <hannu(at)2ndQuadrant(dot)com>
2013-01-13 20:46:54 from Hannu Krosing <hannu(at)2ndQuadrant(dot)com>
2012-11-17 14:57:39 from Hannu Krosing <hannu(at)2ndQuadrant(dot)com>
2012-11-18 03:50:35 from Steve Singer <steve(at)ssinger(dot)info>
2012-11-18 16:07:37 from Andres Freund <andres(at)2ndquadrant(dot)com>
2012-11-20 00:50:32 from Steve Singer <steve(at)ssinger(dot)info>
2012-11-20 11:44:32 from Andres Freund <andres(at)2ndquadrant(dot)com>
2012-11-19 07:28:55 from Michael Paquier <michael(dot)paquier(at)gmail(dot)com>
2012-11-19 08:50:30 from Andres Freund <andres(at)2ndquadrant(dot)com>
2012-11-20 00:30:40 from Michael Paquier <michael(dot)paquier(at)gmail(dot)com>
2012-11-20 11:22:05 from Andres Freund <andres(at)2ndquadrant(dot)com>
2012-11-21 05:57:08 from Michael Paquier <michael(dot)paquier(at)gmail(dot)com>
2012-11-21 07:31:14 from Andres Freund <andres(at)2ndquadrant(dot)com>
2012-11-21 07:34:43 from Michael Paquier <michael(dot)paquier(at)gmail(dot)com>
2012-11-21 07:34:42 from Andres Freund <andres(at)2ndquadrant(dot)com>
2012-11-21 09:35:34 from Michael Paquier <michael(dot)paquier(at)gmail(dot)com>
2012-11-21 23:25:55 from Andres Freund <andres(at)2ndquadrant(dot)com>
2012-11-22 00:13:30 from Michael Paquier <michael(dot)paquier(at)gmail(dot)com>
2012-11-22 00:48:51 from Andres Freund <andres(at)2ndquadrant(dot)com>
2012-11-21 06:28:30 from Michael Paquier <michael(dot)paquier(at)gmail(dot)com>
2012-11-21 07:30:00 from Andres Freund <andres(at)2ndquadrant(dot)com>
2012-11-21 07:47:11 from Michael Paquier <michael(dot)paquier(at)gmail(dot)com>
2012-11-21 07:58:53 from Andres Freund <andres(at)2ndquadrant(dot)com>
2012-12-10 14:43:29 from Andres Freund <andres(at)2ndquadrant(dot)com>
Lists:
pgsql-hackers
On 01/13/2013 10:49 AM, Hannu Krosing wrote:
> On 01/13/2013 12:28 AM, Noah Misch wrote:
>> [Catching up on old threads.]
>>
>> On Sat, Nov 17, 2012 at 03:40:49PM +0100, Hannu Krosing wrote:
>>> On 11/17/2012 03:00 PM, Markus Wanner wrote:
>>>> On 11/17/2012 02:30 PM, Hannu Krosing wrote:
>>>>> Is it possible to replicate UPDATEs and DELETEs without a primary
>>>>> key in
>>>>> PostgreSQL-R
>>>> No. There must be some way to logically identify the tuple.
>>> It can be done as selecting on _all_ attributes and updating/deleting
>>> just the first matching row
>>>
>>> create cursor ...
>>> select from t ... where t.* = (....)
>>> fetch one ...
>>> delete where current of ...
>>>
>>> This is on distant (round 3 or 4) roadmap for this work, just was
>>> interested
>>> if you had found any better way of doing this :)
>> That only works if every attribute's type has a notion of equality
>> ("xml" does
>> not). The equality operator may have a name other than "=", and an
>> operator
>> named "=" may exist with semantics other than equality ("box" is
>> affected).
>> Code attempting this replication strategy should select an equality
>> operator
>> the way typcache.c does so.
> Does this hint that postgreSQL also needs an sameness operator
> ( "is" or "===" in same languages).
>
> Or does "IS NOT DISTINCT FROM" already work even for types without
> comparison operator ?
Just checked - it does not, it still looks for "=" operator so it is
just equality-with-nulls
How do people feel about adding a real sameness operator ?
Hannu
>
> --------------
> Hannu
>
>
In response to
Responses
pgsql-hackers by date
Next :From: Dimitri FontaineDate: 2013-01-13 15:44:51Subject : Re: ToDo: log plans of cancelled queriesPrevious :From : Hannu KrosingDate : 2013-01-13 10:49:27Subject : Re: logical changeset generation v3 - comparison to Postgres-R change
set format
