Re: [GENERAL] Effecient time ranges in 9.4/9.5?

2015-10-04 Thread Karsten Hilbert
On Fri, Oct 02, 2015 at 10:06:55AM -0400, Tom Lane wrote: > The problem you'll have in defining timetzrange is that you first need to > invent a "timetz - timetz" operator, which doesn't exist as a builtin > function because the behavior seems not well-defined. What would you do > with the

Re: [GENERAL] postgresql doesn't start

2015-10-04 Thread Paolo De Michele
Adrian, thanks a lot about your questions 1. postgresql was installed via apt-get install postgresql -y command 2. in /var/run/postgresql/ there is only one file called 9.3-main.pid 3. postgres is not running, I did not find nothing with ps command 4. I remove the postmaster.pid file and I tried

Re: [GENERAL] Shouldn't "WHEN (OLD.* IS DISTINCT FROM NEW.*)" clause be independent from data type?

2015-10-04 Thread Emre Hasegeli
> The other line of attack would be to deprecate all the fuzzy comparison > behavior in the geometric types, and just make it exact. Don't know how > much pain that would add, but surely it would also subtract some. How can we go forward about this? The current state of the operators stand in

Re: [GENERAL] Replication with 9.4

2015-10-04 Thread Michael Paquier
(Seems like you forgot to push the Reply-all button) On Sun, Oct 4, 2015 at 7:01 PM, Madovsky wrote: > On 10/3/2015 3:30 PM, Michael Paquier wrote: >> and no reason is given to justify *why* this would be needed in your case > reason for a choice can be often an issue for other :D > > I thought

Re: [GENERAL] Replication with 9.4

2015-10-04 Thread Madovsky
On 10/4/2015 3:47 AM, Michael Paquier wrote: (Seems like you forgot to push the Reply-all button) On Sun, Oct 4, 2015 at 7:01 PM, Madovsky wrote: On 10/3/2015 3:30 PM, Michael Paquier wrote: and no reason is given to justify *why* this would be needed in your case reason for a choice can

Re: [GENERAL] postgresql doesn't start

2015-10-04 Thread Adrian Klaver
On 10/04/2015 02:45 AM, Paolo De Michele wrote: Adrian, thanks a lot about your questions 1. postgresql was installed via apt-get install postgresql -y command 2. in /var/run/postgresql/ there is only one file called 9.3-main.pid 3. postgres is not running, I did not find nothing with ps

Re: [GENERAL] postgresql doesn't start

2015-10-04 Thread Adrian Klaver
On 10/04/2015 02:45 AM, Paolo De Michele wrote: Adrian, thanks a lot about your questions 1. postgresql was installed via apt-get install postgresql -y command What OS and version? 2. in /var/run/postgresql/ there is only one file called 9.3-main.pid 3. postgres is not running, I did not