Re: [GENERAL] pg_base_backup limit bandwidth possible?

2015-01-02 Thread Matthew Kelly
The way I’ve solved the problem before 9.4 is to use a command called 'pv' (pipe view). Normally this command is useful for seeing the rate of data flow in a pipe, but it also does have a rate limiting capacity. The trick for me was running the output of pg_basebackup through pv (emulates havi

Re: [GENERAL] partial "on-delete set null" constraint

2015-01-02 Thread Adrian Klaver
On 01/02/2015 08:55 AM, Rafal Pietrak wrote: W dniu 02.01.2015 o 17:05, Adrian Klaver pisze: On 01/02/2015 07:45 AM, Rafal Pietrak wrote: W dniu 02.01.2015 o 16:03, Adrian Klaver pisze: On 01/02/2015 04:31 AM, Rafal Pietrak wrote: [] CCing the list. Ups, sorry - no

Re: [GENERAL] extra function calls from query returning composite type

2015-01-02 Thread Merlin Moncure
On Wed, Dec 31, 2014 at 5:41 PM, Ronald Peterson wrote: > Thanks much. Didn't know about LATERAL. That's a solution. Seems like the > implementation could be improved though. The existence of LATERAL seems to > imply that it's possible. Why introduce more complicated syntax? Of course > the

Re: [GENERAL] partial "on-delete set null" constraint

2015-01-02 Thread Rafal Pietrak
W dniu 02.01.2015 o 17:05, Adrian Klaver pisze: On 01/02/2015 07:45 AM, Rafal Pietrak wrote: W dniu 02.01.2015 o 16:03, Adrian Klaver pisze: On 01/02/2015 04:31 AM, Rafal Pietrak wrote: [] CCing the list. Ups, sorry - not that button clicked. [-

Re: [GENERAL] partial "on-delete set null" constraint

2015-01-02 Thread Adrian Klaver
On 01/02/2015 07:45 AM, Rafal Pietrak wrote: W dniu 02.01.2015 o 16:03, Adrian Klaver pisze: On 01/02/2015 04:31 AM, Rafal Pietrak wrote: [] CCing the list. Not sure about the standard, but pretty sure it will foul things up in general. From the table structures abov

Re: [GENERAL] partial "on-delete set null" constraint

2015-01-02 Thread Adrian Klaver
On 01/02/2015 04:31 AM, Rafal Pietrak wrote: Hello, Rewriting my mail-hub I fell into the following problem: 1. I have a table with mailmessages, which has an FK to a table of hub users. 2. I'd like to retain the content of message repository (with it's domain key not cleared), when I drop a par

Re: [GENERAL] partial "on-delete set null" constraint

2015-01-02 Thread Melvin Davidson
Your main problem is that column "domain" of mailboxes is specified as NOT NULL, so of course the "SET NULL" option will not work. Here is the full message I see when I execute your code, which should be self explanatory. ERROR: null value in column "domain" violates not-null constraint DETAIL:

[GENERAL] partial "on-delete set null" constraint

2015-01-02 Thread Rafal Pietrak
Hello, Rewriting my mail-hub I fell into the following problem: 1. I have a table with mailmessages, which has an FK to a table of hub users. 2. I'd like to retain the content of message repository (with it's domain key not cleared), when I drop a particular username from service to relea

Re: [GENERAL] BDR conpilation error un Ubuntu 12.4 LTS

2015-01-02 Thread Craig Ringer
On 12/23/2014 05:47 PM, stefano bonnin wrote: > Hi Giuseppe, adding: > > git checkout bdr-pg/REL9_4_STABLE FYI, we've tagged bdr 0.8.0beta1 now, and the wiki instructions have been updated accordingly. There have been a lot of fixes since 0.7.1, so I suggest starting with that if possible. --

Re: [GENERAL] bdr_init_copy fails when starting 2nd BDR node

2015-01-02 Thread Craig Ringer
On 12/30/2014 12:51 PM, John Casey wrote: > I’ve been having issues while attempting to begin BDR replication. If I > set up the main node, then use bdr_init_copy, it always fails on second > node, as shown below. On a semi-related note, all the BDR node configuration and join support is currently