Re: [HACKERS] INSERT...ON DUPLICATE KEY LOCK FOR UPDATE

2013-12-21 Thread Peter Geoghegan
On Fri, Dec 20, 2013 at 1:12 PM, Heikki Linnakangas hlinnakan...@vmware.com wrote: There are probably other ways to make that general idea work though. I didn't follow this thread carefully, but is the idea that there would be many promise tuples live at any one time, or only one? Because if

Re: [HACKERS] make_interval ??

2013-12-21 Thread Pavel Stehule
Hello here is patch postgres=# select make_interval(years := 1, months := 6); make_interval --- 1 year 6 mons (1 row) postgres=# select make_interval(weeks := 3); make_interval --- 21 days (1 row) postgres=# select make_interval(days := 10); make_interval

[HACKERS] ISN extension bug?

2013-12-21 Thread Fabien COELHO
Hello devs, ISTM that there is an issue on the ISMN type: sh psql psql (9.3.2) Type help for help. # CREATE EXTENTION isn; # SELECT ISMN 'M123456782'; M-1234-5678-5 *** The 2 is changed to 5 in the display... # SELECT ISMN 'M123456785'; ERROR: invalid check digit for ISMN number:

Re: [HACKERS] shared memory message queues

2013-12-21 Thread Andres Freund
On 2013-12-20 22:04:05 +0100, Andres Freund wrote: Hi, On 2013-12-18 15:23:23 -0500, Robert Haas wrote: It sounds like most people who have looked at this stuff are broadly happy with it, so I'd like to push on toward commit soon, but it'd be helpful, Andres, if you could review the

Re: [HACKERS] [PATCH] Negative Transition Aggregate Functions (WIP)

2013-12-21 Thread David Rowley
On Tue, Dec 17, 2013 at 10:51 PM, David Rowley dgrowle...@gmail.com wrote: On Mon, Dec 16, 2013 at 9:36 PM, Hannu Krosing ha...@2ndquadrant.comwrote: On 12/16/2013 08:39 AM, David Rowley wrote: Any other ideas or +1's for any of the existing ones? +1, inverse good :) In the attached

Re: [HACKERS] [PATCH] Negative Transition Aggregate Functions (WIP)

2013-12-21 Thread Erik Rijkers
On Sat, December 21, 2013 10:53, David Rowley wrote: [inverse_transition_functions_v1.1.patch.gz ] Hi, I know, $subject says WIP, but I assumed it's supposed to compile, so I tried to get this to run on linux (Centos 5.0). gcc 4.8.2, with ./configure

Re: [HACKERS] [PATCH] Negative Transition Aggregate Functions (WIP)

2013-12-21 Thread David Rowley
On Sat, Dec 21, 2013 at 11:47 PM, Erik Rijkers e...@xs4all.nl wrote: On Sat, December 21, 2013 10:53, David Rowley wrote: [inverse_transition_functions_v1.1.patch.gz ] Hi, I know, $subject says WIP, but I assumed it's supposed to compile, so I tried to get this to run on linux (Centos

Re: [HACKERS] [PATCH] Negative Transition Aggregate Functions (WIP)

2013-12-21 Thread David Rowley
On Sun, Dec 22, 2013 at 12:12 AM, David Rowley dgrowle...@gmail.com wrote: On Sat, Dec 21, 2013 at 11:47 PM, Erik Rijkers e...@xs4all.nl wrote: On Sat, December 21, 2013 10:53, David Rowley wrote: [inverse_transition_functions_v1.1.patch.gz ] Hi, I know, $subject says WIP, but I

Re: [HACKERS] [PATCH] Negative Transition Aggregate Functions (WIP)

2013-12-21 Thread Erik Rijkers
On Sat, December 21, 2013 12:38, David Rowley wrote: [ inverse_transition_functions_v1.2.patch.gz ] Please find attached an updated patch which should remove the duplicate OID problem you saw. That fixes it, thanks There is 1 of 141 failed tests: window ... FAILED but

Re: [HACKERS] [PATCH] Negative Transition Aggregate Functions (WIP)

2013-12-21 Thread David Rowley
On Sun, Dec 22, 2013 at 12:49 AM, Erik Rijkers e...@xs4all.nl wrote: On Sat, December 21, 2013 12:38, David Rowley wrote: [ inverse_transition_functions_v1.2.patch.gz ] Please find attached an updated patch which should remove the duplicate OID problem you saw. That fixes it, thanks

Re: [HACKERS] [PATCH] Negative Transition Aggregate Functions (WIP)

2013-12-21 Thread Erik Rijkers
On Sat, December 21, 2013 12:52, David Rowley wrote: On Sun, Dec 22, 2013 at 12:49 AM, Erik Rijkers e...@xs4all.nl wrote: On Sat, December 21, 2013 12:38, David Rowley wrote: [ inverse_transition_functions_v1.2.patch.gz ] Please find attached an updated patch which should remove the

Re: [HACKERS] [PATCH] Negative Transition Aggregate Functions (WIP)

2013-12-21 Thread David Rowley
On Sun, Dec 22, 2013 at 1:01 AM, Erik Rijkers e...@xs4all.nl wrote: On Sat, December 21, 2013 12:52, David Rowley wrote: On Sun, Dec 22, 2013 at 12:49 AM, Erik Rijkers e...@xs4all.nl wrote: On Sat, December 21, 2013 12:38, David Rowley wrote: [ inverse_transition_functions_v1.2.patch.gz

Re: [HACKERS] shared memory message queues

2013-12-21 Thread Peter Eisentraut
This patch didn't make it out of the 2013-11 commit fest. You should move it to the next commit fest (probably with an updated patch) before January 15th. -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription:

Re: [HACKERS] Race condition in b-tree page deletion

2013-12-21 Thread Peter Eisentraut
This patch didn't make it out of the 2013-11 commit fest. You should move it to the next commit fest (probably with an updated patch) before January 15th, if it is not resolved before then. -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your

Re: [HACKERS] Wait free LW_SHARED acquisition - v0.2

2013-12-21 Thread Peter Eisentraut
This patch didn't make it out of the 2013-11 commit fest. You should move it to the next commit fest (probably with an updated patch) before January 15th. -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription:

Re: [HACKERS] better atomics - v0.2

2013-12-21 Thread Peter Eisentraut
This patch didn't make it out of the 2013-11 commit fest. You should move it to the next commit fest (probably with an updated patch) before January 15th. -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription:

Re: [HACKERS] ECPG FETCH readahead, was: Re: ECPG fixes

2013-12-21 Thread Peter Eisentraut
This patch didn't make it out of the 2013-11 commit fest. You should move it to the next commit fest (probably with an updated patch) before January 15th. -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription:

Re: [HACKERS] [COMMITTERS] pgsql: Upgrade to Autoconf 2.69

2013-12-21 Thread Peter Eisentraut
On Fri, 2013-12-20 at 10:54 -0300, Alvaro Herrera wrote: I don't see how can the pg_upgrade check fail in this way but not the regular regression test. This patch includes the following hunk to pg_config.h.in: +/* Enable large inode numbers on Mac OS X 10.5. */ +#ifndef

[HACKERS] pg_upgrade: make the locale comparison more tolerant

2013-12-21 Thread Pavel Raiskup
Hello pg-hackers! I tried to look at the problem resulting in changes mentioned here: http://www.postgresql.org/message-id/20121002155857.ge30...@momjian.us If the system locale is changed e.g. from en_US.utf8 to en_US.utf-8 before upgrading the data stack for newer server, pg_upgrade fails. It

Re: [HACKERS] SQL objects UNITs

2013-12-21 Thread Stephen Frost
* Andrew Dunstan (and...@dunslane.net) wrote: That having been said, having a flag we can set to dump the extension contents normally rather than just dumping a CREATE EXTENSION statement seems completely reasonable to me. ALTER EXTENSION foo SET (dump_members = true/false); It's even got

Re: [HACKERS] SQL objects UNITs

2013-12-21 Thread Dimitri Fontaine
Stephen Frost sfr...@snowman.net writes: That said, I'm starting to wonder about a few different options that might be handy- having the extension be dumpable (or maybe an option to pg_dump to dump them from the DB, or not), and perhaps an option to have the version # included in the dump

Re: [HACKERS] SQL objects UNITs

2013-12-21 Thread Stephen Frost
Dimitri, * Dimitri Fontaine (dimi...@2ndquadrant.fr) wrote: Stephen Frost sfr...@snowman.net writes: That said, I'm starting to wonder about a few different options that might be handy- having the extension be dumpable (or maybe an option to pg_dump to dump them from the DB, or not), and

Re: [HACKERS] WITHIN GROUP patch

2013-12-21 Thread Tom Lane
[ still hacking away at this patch ] Andrew Gierth and...@tao11.riddles.org.uk writes: Tom == Tom Lane t...@sss.pgh.pa.us writes: Tom Not wanting to consider the sort args when there's more than one Tom doesn't square with forcing them to be considered when there's Tom just one. It's the

Re: [HACKERS] SQL objects UNITs

2013-12-21 Thread Robert Haas
On Sat, Dec 21, 2013 at 12:10 PM, Dimitri Fontaine dimi...@2ndquadrant.fr wrote: Stephen Frost sfr...@snowman.net writes: That said, I'm starting to wonder about a few different options that might be handy- having the extension be dumpable (or maybe an option to pg_dump to dump them from the

Re: [HACKERS] SQL objects UNITs

2013-12-21 Thread Tom Lane
Robert Haas robertmh...@gmail.com writes: On Sat, Dec 21, 2013 at 12:10 PM, Dimitri Fontaine dimi...@2ndquadrant.fr wrote: Stephen Frost sfr...@snowman.net writes: That said, I'm starting to wonder about a few different options that might be handy- having the extension be dumpable (or maybe