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

2013-12-29 Thread Heikki Linnakangas
On 12/26/2013 01:27 AM, Peter Geoghegan wrote: On Wed, Dec 25, 2013 at 6:25 AM, Andres Freund and...@2ndquadrant.com wrote: And yes, I still think that promise tuples might be a better solution regardless of the issues you mentioned, but you know what? That doesn't matter. Me thinking it's the

[HACKERS] Polymorphic function calls

2013-12-29 Thread knizhnik
Is there any chance to implement polymorphic calls in PostgreSQL? Consider the following definitions: create table base_table (x integer, y integer); create table derived_table (z integer) inherits (base_table); create function volume(r base_table) returns integer as $$ begin return r.x*r.y;

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

2013-12-29 Thread Heikki Linnakangas
On 12/27/2013 07:11 AM, Peter Geoghegan wrote: On Thu, Dec 26, 2013 at 5:58 PM, Robert Haas robertmh...@gmail.com wrote: While mulling this over further, I had an idea about this: suppose we marked the tuple in some fashion that indicates that it's a promise tuple. I imagine an infomask bit,

Re: [HACKERS] [BUG FIX] Version number expressed in octal form by mistake

2013-12-29 Thread Kevin Grittner
Tom Lane t...@sss.pgh.pa.us wrote: On reflection, I'm not sure that pg_restore as such should be applying any server version check at all.  pg_restore itself has precious little to do with whether there will be a compatibility problem; that's mostly down to the DDL that pg_dump put into the

Re: [HACKERS] [BUG FIX] Version number expressed in octal form by mistake

2013-12-29 Thread Tom Lane
Kevin Grittner kgri...@ymail.com writes: Tom Lane t...@sss.pgh.pa.us wrote: So I'm inclined to propose that we set min/max to 0 and 99 here. Something like the attached back-patched to 8.4? Works for me. regards, tom lane -- Sent via pgsql-hackers mailing list

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

2013-12-29 Thread Tom Lane
I wrote: Perhaps though we should override Autoconf's setting of _DARWIN_USE_64_BIT_INODE, if we can do that easily? It's clearly not nearly as problem-free on 10.5 as the Autoconf boys believe, and it's already enabled by default on the release series where it does work. I looked into this

Re: [HACKERS] Polymorphic function calls

2013-12-29 Thread Sergey Konoplev
On Sun, Dec 29, 2013 at 8:44 AM, knizhnik knizh...@garret.ru wrote: create function volume(r base_table) returns integer as $$ begin return r.x*r.y; end; $$ language plpgsql strict stable; create function volume(r derived_table) returns integer as $$ begin return r.x*r.y*r.z; end; $$ language

Re: [HACKERS] [BUG FIX] Version number expressed in octal form by mistake

2013-12-29 Thread Kevin Grittner
Tom Lane t...@sss.pgh.pa.us wrote: Kevin Grittner kgri...@ymail.com writes: Tom Lane t...@sss.pgh.pa.us wrote: So I'm inclined to propose that we set min/max to 0 and 99 here. Something like the attached back-patched to 8.4? Works for me. Done. Thanks for the report, Joel! -- Kevin

Re: [HACKERS] XML Issue with DTDs

2013-12-29 Thread Florian Pflug
On Dec26, 2013, at 21:30 , Florian Pflug f...@phlo.org wrote: On Dec23, 2013, at 18:39 , Peter Eisentraut pete...@gmx.net wrote: On 12/19/13, 6:40 PM, Florian Pflug wrote: The following example fails for XMLOPTION set to DOCUMENT as well as for XMLOPTION set to CONTENT. select xmlconcat(

[HACKERS] Custom collations, collation modifiers (eg case-insensitive)

2013-12-29 Thread Craig Ringer
One of the big appeals of the new COLLATE feature was, to me, the possibility that we'd be able to support custom collations including case-insensitive collations in future. It's something I'd like to tackle one day, and in the mean time want to pop on the TODO so it's not lost and forgotten.

Re: [HACKERS] Custom collations, collation modifiers (eg case-insensitive)

2013-12-29 Thread Craig Ringer
On 12/30/2013 08:49 AM, Craig Ringer wrote: One of the big appeals of the new COLLATE feature was, to me, the possibility that we'd be able to support custom collations including case-insensitive collations in future. It's something I'd like to tackle one day, and in the mean time want to

Re: [HACKERS] control to don't toast one new type

2013-12-29 Thread Craig Ringer
On 12/28/2013 06:28 PM, Mohsen SM wrote: I create type based on varlena. I want control it that don't toast. In general it's probably going to be better to just specify the storage option on a column by column basis: ALTER TABLE ... ALTER COLUMN ... SET STORAGE PLAIN; A quick look at the

[HACKERS] Re: [bug fix] multibyte messages are displayed incorrectly on the client

2013-12-29 Thread Noah Misch
On Sun, Dec 22, 2013 at 07:51:55PM +0900, MauMau wrote: From: Noah Misch n...@leadboat.com Better to attack that directly. Arrange to apply any client_encoding named in the startup packet earlier, before authentication. This relates to the TODO item Let the client indicate character

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

2013-12-29 Thread Peter Geoghegan
On Sun, Dec 29, 2013 at 8:18 AM, Heikki Linnakangas hlinnakan...@vmware.com wrote: My position is not based on a gut feeling. It is based on carefully considering the interactions of the constituent parts, plus the experience of actually building a working prototype. I also carefully

Re: [HACKERS] [PATCH] Regression tests in windows ignore white space

2013-12-29 Thread Amit Kapila
On Sun, Dec 29, 2013 at 2:06 AM, David Rowley dgrowle...@gmail.com wrote: On Sun, Dec 29, 2013 at 2:29 AM, Amit Kapila amit.kapil...@gmail.com wrote: When I tried with your patch on windows, it results into following: == running regression test queries== test

Re: [HACKERS] [PATCH] Regression tests in windows ignore white space

2013-12-29 Thread David Rowley
On Mon, Dec 30, 2013 at 6:02 PM, Amit Kapila amit.kapil...@gmail.comwrote: On Sun, Dec 29, 2013 at 2:06 AM, David Rowley dgrowle...@gmail.com wrote: On Sun, Dec 29, 2013 at 2:29 AM, Amit Kapila amit.kapil...@gmail.com wrote: When I tried with your patch on windows, it results into