Re: [HACKERS] [PATCH] Remove useless USE_PGXS support in contrib

2013-06-14 Thread Craig Ringer
On 06/13/2013 11:16 AM, Peter Eisentraut wrote: > This has served no purpose except to > > 1. take up space > 2. confuse users > 3. produce broken external extension modules that take contrib as an example > 4. break builds of PostgreSQL when users try to fix 3. by exporting USE_PGXS Weak -1 from

Re: [HACKERS] [PATCH] Add transforms feature

2013-06-14 Thread Craig Ringer
On 06/14/2013 11:11 AM, Peter Eisentraut wrote: > A transform is an SQL object that supplies to functions for converting > between data types and procedural languages. For example, a transform > could arrange that hstore is converted to an appropriate hash or > dictionary object in PL/Perl or PL/P

Re: [HACKERS] MD5 aggregate

2013-06-14 Thread Craig Ringer
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 06/14/2013 09:40 PM, Stephen Frost wrote: > Where I'd take this is actually in a completely different direction.. > I'd like the aggregate to be able to match the results of running the > 'md5sum' unix utility on a file that's been COPY'd out. Unti

Re: [HACKERS] MD5 aggregate

2013-06-14 Thread Craig Ringer
On 06/13/2013 05:35 PM, Dean Rasheed wrote: > Hi, > > Attached is a patch implementing a new aggregate function md5_agg() to > compute the aggregate MD5 sum across a number of rows. This is > something I've wished for a number of times. I think the primary use > case is to do a quick check that 2 t

Re: [HACKERS] Hard to Use WAS: Hard limit on WAL space

2013-06-14 Thread Craig Ringer
On 06/15/2013 02:16 AM, Josh Berkus wrote: > On 06/12/2013 02:03 PM, Joshua D. Drake wrote: >> What concerns me is we seem to be trying to make this "easy". It isn't >> supposed to be easy. This is hard stuff. Smart people built it and it >> takes a smart person to run it. When did it become a bad

Re: [HACKERS] [PATCH] Exorcise "zero-dimensional" arrays (Was: Re: Should array_length() Return NULL)

2013-06-14 Thread Brendan Jurd
On 14 June 2013 03:53, David E. Wheeler wrote: > Similar things should have dissimilar names. I propose: > > > > Old |New > --+-- > array_dims | array_desc array_bounds? > array_ndims | array_depth > array_length | array_size > array_lower | array_s

Re: [HACKERS] Hard to Use WAS: Hard limit on WAL space

2013-06-14 Thread Brendan Jurd
On 15 June 2013 14:43, Craig Ringer wrote: > The #1 question I see on Stack Overflow has to be confusion about > pg_hba.conf, mostly from people who have no idea it exists, don't understand > how to configure it, etc. The totally non-obvious name of the file probably has something to do with that

Re: [HACKERS] Hard to Use WAS: Hard limit on WAL space

2013-06-14 Thread Craig Ringer
On 06/15/2013 02:08 PM, Brendan Jurd wrote: > On 15 June 2013 14:43, Craig Ringer wrote: >> The #1 question I see on Stack Overflow has to be confusion about >> pg_hba.conf, mostly from people who have no idea it exists, don't understand >> how to configure it, etc. > The totally non-obvious name

Re: [HACKERS] Hard to Use WAS: Hard limit on WAL space

2013-06-14 Thread Brendan Jurd
On 15 June 2013 16:18, Craig Ringer wrote: > On 06/15/2013 02:08 PM, Brendan Jurd wrote: >> On 15 June 2013 14:43, Craig Ringer wrote: >>> The #1 question I see on Stack Overflow has to be confusion about >>> pg_hba.conf, mostly from people who have no idea it exists, don't understand >>> how to

<    1   2