From:
Markus Wanner <markus(at)bluegap(dot)ch>
To:
Hannu Krosing <hannu(at)2ndQuadrant(dot)com>
Cc:
Noah Misch <noah(at)leadboat(dot)com>,
Andres Freund <andres(at)anarazel(dot)de>, pgsql-hackers(at)postgresql(dot)org
Subject:
Re: Re: logical changeset generation v3 - comparison to
Postgres-R change set format
Date:
2013-01-14 09:03:48
Message-ID:
50F3C9F4.6050200@bluegap.ch (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 09:04 PM, Hannu Krosing wrote:
> I'd just start with what send() and recv() on each type produces
> now using GCC on 64bit Intel and move towards adjusting others
> to match. For a period anything else would still be allowed, but
> be "non-standard"
Intel being little endian seems like a bad choice to me, given that
send/recv kind of implies network byte ordering. I'd rather not tie this
to any particular processor architecture at all (at least not solely on
the ground that it's the most common one at the time).
I have no strong opinion on "sameness" of NULLs and could also imagine
that to throw some kind of invalid operation error. Based on the ground
that neither is a value and it's unclear what send() method to use at all.
FWIW, trying to determine the length of a sent NULL gives an interesting
result that I don't currently understand.
> psql (9.2.2)
> Type "help" for help.
>
> postgres=# SELECT length(int4send(NULL));
> length
> --------
>
> (1 row)
>
> postgres=# SELECT length(float4send(NULL));
> length
> --------
>
> (1 row)
>
> postgres=# SELECT length(textsend(NULL));
> length
> --------
>
> (1 row)
>
> postgres=# SELECT length(textsend(NULL) || '\000'::bytea);
> length
> --------
>
> (1 row)
Regards
Markus Wanner
In response to
pgsql-hackers by date
Next :From: Dean RasheedDate: 2013-01-14 09:29:56
Subject : Thinking about WITH CHECK OPTION for views
Previous :From : Hannu KrosingDate : 2013-01-14 08:51:01
Subject : Re: Re: logical changeset generation v3 - comparison to
Postgres-R change set format