Re: [HACKERS] Does people favor to have matrix data type?

2016-05-29 Thread Joe Conway
On 05/28/2016 03:33 PM, Kouhei Kaigai wrote: >> -Original Message- >> From: Joe Conway [mailto:m...@joeconway.com] >> Sent: Sunday, May 29, 2016 1:40 AM >> To: Kaigai Kouhei(海外 浩平); Jim Nasby; Ants Aasma; Simon Riggs >> Cc: pgsql-hackers@postgresql.org >> Subject: Re: [HACKERS] Does people

Re: [HACKERS] Re: Request for Patch Feedback: Lag & Lead Window Functions Can Ignore Nulls

2016-05-29 Thread Emre Hasegeli
> My interpretation of the standard is that FILTER is not allowable for > a window function, and IGNORE|RESPECT NULLS is not allowable for an > ordinary aggregate. Yes, it is clear. > So if we support IGNORE|RESPECT NULLS for anything other than a window > function, we have to come up with our

Re: [HACKERS] [sqlsmith] PANIC: failed to add BRIN tuple

2016-05-29 Thread Andreas Seltenreich
Alvaro Herrera writes: > If you can re-run sqlsmith and see if you can find different bugs, I'd > appreciate it. [...] > [2. text/x-diff; brincrash-2.patch] BRIN is inconspicuous since applying this patch. All coredumps I see now are either due to the parallel worker shutdown issue or acl.c's

Re: [HACKERS] Reviewing freeze map code

2016-05-29 Thread Masahiko Sawada
On Sun, May 29, 2016 at 2:44 PM, Noah Misch wrote: > On Fri, May 06, 2016 at 04:42:48PM -0400, Robert Haas wrote: >> On Thu, May 5, 2016 at 2:20 PM, Andres Freund wrote: >> > On 2016-05-02 14:48:18 -0700, Andres Freund wrote: >> > +

[HACKERS] Question and suggestion about application binary compatibility policy

2016-05-29 Thread Tsunakawa, Takayuki
Hello, I'd like to ask you about the policy of application binary compatibility. And have a suggestion as well. QUESTION == My customer asked me if the following usage is correct. - Build an embedded SQL C application with PostgreSQL 9.2. -

Re: [HACKERS] [GENERAL] Permission Denied Error on pg_xlog/RECOVERYXLOG file

2016-05-29 Thread Michael Paquier
On Sat, May 28, 2016 at 9:57 AM, Andres Freund wrote: > On 2016-05-27 20:54:43 -0400, Tom Lane wrote: >> Andres Freund writes: >> > On 2016-05-26 12:44:51 -0400, Tom Lane wrote: >> > 2016-04-27 17:02:06 EDT 572128cd.1811 [7-1] user=,db=,remote= FATAL: >>

[HACKERS] regexp_match() returning text

2016-05-29 Thread Emre Hasegeli
Attached patch adds regexp_match() function which is a simple variant of regexp_matches() that doesn't return a set. It is based on Tom Lane's comment to bug #10889 [1]. [1] https://www.postgresql.org/message-id/23769.1404747...@sss.pgh.pa.us From f8c113c77864ef1ca6386195aea02b2090ff17b6 Mon Sep

[HACKERS] Redesigning parallel dump/restore's wait-for-workers logic

2016-05-29 Thread Tom Lane
One of the things I do not like about the current coding of parallel pg_dump/pg_restore is its baroque logic for handling worker completion reports, specifically the ListenToWorkers/ReapWorkerStatus APIs. That code is messy and hard to use --- if the existing logic in restore_toc_entries_parallel

Re: [HACKERS] Does people favor to have matrix data type?

2016-05-29 Thread Kouhei Kaigai
> On 05/28/2016 03:33 PM, Kouhei Kaigai wrote: > >> -Original Message- > >> From: Joe Conway [mailto:m...@joeconway.com] > >> Sent: Sunday, May 29, 2016 1:40 AM > >> To: Kaigai Kouhei(海外 浩平); Jim Nasby; Ants Aasma; Simon Riggs > >> Cc: pgsql-hackers@postgresql.org > >> Subject: Re:

[HACKERS] IPv6 link-local addresses and init data type

2016-05-29 Thread Tom Dunstan
Hi all I just ran into an issue that was originally reported way back in 2007 - https://www.postgresql.org/message-id/flat/0262b803-b664-4ebe-85b4-3c9a40ea6...@mobygames.com Basically the inet data