Re: [HACKERS] SQL objects UNITs

2013-12-21 Thread Tom Lane
Robert Haas writes: > On Sat, Dec 21, 2013 at 12:10 PM, Dimitri Fontaine > wrote: >> Stephen Frost 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

Re: [HACKERS] SQL objects UNITs

2013-12-21 Thread Robert Haas
On Sat, Dec 21, 2013 at 12:10 PM, Dimitri Fontaine wrote: > Stephen Frost 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 op

Re: [HACKERS] WITHIN GROUP patch

2013-12-21 Thread Tom Lane
[ still hacking away at this patch ] Andrew Gierth writes: > "Tom" == Tom Lane 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 same aggregate after all, > This log

Re: [HACKERS] SQL objects UNITs

2013-12-21 Thread Stephen Frost
Dimitri, * Dimitri Fontaine (dimi...@2ndquadrant.fr) wrote: > Stephen Frost 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

Re: [HACKERS] SQL objects UNITs

2013-12-21 Thread Dimitri Fontaine
Stephen Frost 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 (or an > option t

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); > > > >

[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] [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 _DARWIN_USE_6

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: http://www.postgresql.org/mailp

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: http://www.postgresql.org/mailp

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: http://www.postgresql.org/mailp

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 subscripti

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: http://www.postgresql.org/mailp

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 wrote: > On Sat, December 21, 2013 12:52, David Rowley wrote: > > On Sun, Dec 22, 2013 at 12:49 AM, Erik Rijkers wrote: > > > >> On Sat, December 21, 2013 12:38, David Rowley wrote: > >> > [ inverse_transition_functions_v1.2.patch.gz ] > >> > Please

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 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 >

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 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 > > The

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 b

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 wrote: > On Sat, Dec 21, 2013 at 11:47 PM, Erik Rijkers 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

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 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 5.0).

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 --prefix=/home/aardvark/pg_stuff/pg_i

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 wrote: > On Mon, Dec 16, 2013 at 9:36 PM, Hannu Krosing wrote: > >> 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 patch I've renamed nega

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

[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] 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 --

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 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 >> there's only