Re: [HACKERS] PostgreSQL 9.4 InterlockedCompareExchange appearing in mingw64-w32 causing issue with PostGIS win32 load

2014-05-22 Thread Paragon Corporation
-- REVISED NOTE -- > Hm. s_lock.h does define TAS() in terms of InterlockedCompareExchange() if WIN32_ONLY_COMPILER is defined ... but that code hasn't changed in quite a long time. It > seems like the combination of an extension built with WIN32_ONLY_COMPILER and a core built without that flag

Re: [HACKERS] Congrats Andres Freund, the newest PostgreSQL Commiter!

2014-05-22 Thread Atri Sharma
Congrats Andres! On Fri, May 23, 2014 at 7:54 AM, Fabrízio de Royes Mello < fabriziome...@gmail.com> wrote: > Hi All, > > At the Developer Meeting that occurred 21th May 2014 was announced a new > PostgreSQL commiter [1], Mr. Andres Freund. > > I had the opportunity to work and be mentored by hi

Re: [HACKERS] Congrats Andres Freund, the newest PostgreSQL Commiter!

2014-05-22 Thread David Fetter
On Thu, May 22, 2014 at 11:24:47PM -0300, Fabrízio de Royes Mello wrote: > Hi All, > > At the Developer Meeting that occurred 21th May 2014 was announced a new > PostgreSQL commiter [1], Mr. Andres Freund. > > I had the opportunity to work and be mentored by him. He deserves very much > this conf

Re: [HACKERS] Congrats Andres Freund, the newest PostgreSQL Commiter!

2014-05-22 Thread Michael Paquier
On Fri, May 23, 2014 at 11:24 AM, Fabrízio de Royes Mello wrote: > Thank you and Congrats Andres! +1. -- Michael -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

[HACKERS] Congrats Andres Freund, the newest PostgreSQL Commiter!

2014-05-22 Thread Fabrízio de Royes Mello
Hi All, At the Developer Meeting that occurred 21th May 2014 was announced a new PostgreSQL commiter [1], Mr. Andres Freund. I had the opportunity to work and be mentored by him. He deserves very much this confidence, for the excellent work that has been doing for the community. Thank you and Co

Re: [HACKERS] 9.4 release notes

2014-05-22 Thread Tomonari Katsumata
Hi, I have two comments about 9.4 release notes. 1. typo >Pg_upgrade now uses -U to specify the user name (Bruce Momjian) It should be pg_upgrade. 2. undesirable link >Allow pg_recvlogical to receive data logical decoding data (Andres Freund) The term of "pg_recvlogical" jumps to a page of pg

Re: [HACKERS] -DDISABLE_ENABLE_ASSERT

2014-05-22 Thread Alvaro Herrera
Andres Freund wrote: > On 2014-05-22 16:37:35 -0400, Tom Lane wrote: > > We could do that ... but I wonder if we shouldn't remove assert_enabled > > altogether. What's the use case for turning it off? Not matching the > > speed of a non-cassert build, because for instance MEMORY_CONTEXT_CHECKING

Re: [HACKERS] -DDISABLE_ENABLE_ASSERT

2014-05-22 Thread Andres Freund
On 2014-05-22 16:37:35 -0400, Tom Lane wrote: > Andres Freund writes: > > Since there seem to be multiple static checkers (coverity, clang > > checker) having problems with assert_enabled can we just optionally > > disable it? > > I am thinking of replacing it by a AssertionsEnabled() macro which

Re: [HACKERS] -DDISABLE_ENABLE_ASSERT

2014-05-22 Thread Robert Haas
On Thu, May 22, 2014 at 4:31 PM, Andres Freund wrote: > Since there seem to be multiple static checkers (coverity, clang > checker) having problems with assert_enabled can we just optionally > disable it? > I am thinking of replacing it by a AssertionsEnabled() macro which then > is unconditionall

Re: [HACKERS] -DDISABLE_ENABLE_ASSERT

2014-05-22 Thread Tom Lane
Andres Freund writes: > Since there seem to be multiple static checkers (coverity, clang > checker) having problems with assert_enabled can we just optionally > disable it? > I am thinking of replacing it by a AssertionsEnabled() macro which then > is unconditionally defined when DISABLE_ENABLE_AS

[HACKERS] -DDISABLE_ENABLE_ASSERT

2014-05-22 Thread Andres Freund
Hi, Since there seem to be multiple static checkers (coverity, clang checker) having problems with assert_enabled can we just optionally disable it? I am thinking of replacing it by a AssertionsEnabled() macro which then is unconditionally defined when DISABLE_ENABLE_ASSERT is defined. Greetings,

Re: [HACKERS] uuid-ossp (Re: [pgsql-packagers] Postgresapp 9.4 beta build ready)

2014-05-22 Thread Robert Haas
On Thu, May 22, 2014 at 11:07 AM, Tom Lane wrote: > Robert Haas writes: >> On Sun, May 18, 2014 at 12:28 AM, Tom Lane wrote: >>> So, having seen that proof-of-concept, I'm wondering if we shouldn't make >>> an effort to support contrib/uuid-ossp with a choice of UUID libraries >>> underneath it.

Re: [HACKERS] uuid-ossp (Re: [pgsql-packagers] Postgresapp 9.4 beta build ready)

2014-05-22 Thread Matteo Beccati
On 22/05/2014 17:07, Tom Lane wrote: > Robert Haas writes: >> On Sun, May 18, 2014 at 12:28 AM, Tom Lane wrote: >>> So, having seen that proof-of-concept, I'm wondering if we shouldn't make >>> an effort to support contrib/uuid-ossp with a choice of UUID libraries >>> underneath it. There is a n

Re: [HACKERS] PostgreSQL 9.4 InterlockedCompareExchange appearing in mingw64-w32 causing issue with PostGIS win32 load

2014-05-22 Thread Paragon Corporation
> Hm. s_lock.h does define TAS() in terms of InterlockedCompareExchange() if WIN32_ONLY_COMPILER is defined ... but that code hasn't changed in quite a long time. It > seems like the combination of an extension built with WIN32_ONLY_COMPILER and a core built without that flag should never have

Re: [HACKERS] pg_upgrade fails: Mismatch of relation OID in database 8.4 -> 9.3

2014-05-22 Thread Jeff Ross
On 5/21/14, 2:37 PM, Bruce Momjian wrote: On Wed, May 21, 2014 at 04:23:34PM -0400, Tom Lane wrote: Bruce Momjian writes: On Wed, May 21, 2014 at 10:56:59AM -0600, Jeff Ross wrote: Yes, using 9.3's pg_dump of 8.4 and applying it to both an 8.4 and a 9.3 cluster, the contact_email table now

Re: [HACKERS] uuid-ossp (Re: [pgsql-packagers] Postgresapp 9.4 beta build ready)

2014-05-22 Thread Tom Lane
Robert Haas writes: > On Sun, May 18, 2014 at 12:28 AM, Tom Lane wrote: >> So, having seen that proof-of-concept, I'm wondering if we shouldn't make >> an effort to support contrib/uuid-ossp with a choice of UUID libraries >> underneath it. There is a non-OSSP set of UUID library functions >> av

Re: [HACKERS] uuid-ossp (Re: [pgsql-packagers] Postgresapp 9.4 beta build ready)

2014-05-22 Thread Robert Haas
On Sun, May 18, 2014 at 12:28 AM, Tom Lane wrote: > I was intending to draft something more self-contained to present to > -hackers, but since this is where we're at ... the quoted material > omits a couple of important points: > > (1) People had been working around uuid-ossp's issues on OS X by >

Re: [HACKERS] pg_upgrade fails: Mismatch of relation OID in database 8.4 -> 9.3

2014-05-22 Thread Tom Lane
Alvaro Herrera writes: > Bruce Momjian wrote: >> Moving forward, I think you need to add a dummy column to each problem >> table and drop the column that will create a toast table and allow >> you to do the upgrade. I could have pg_upgrade detect this problem, but >> until I know the cause,

Re: [HACKERS] pg_upgrade fails: Mismatch of relation OID in database 8.4 -> 9.3

2014-05-22 Thread Alvaro Herrera
Bruce Momjian wrote: > Moving forward, I think you need to add a dummy column to each problem > table and drop the column that will create a toast table and allow > you to do the upgrade. I could have pg_upgrade detect this problem, but > until I know the cause, I don't think that is wise.

Re: [HACKERS] PostgreSQL 9.4 InterlockedCompareExchange appearing in mingw64-w32 causing issue with PostGIS win32 load

2014-05-22 Thread Tom Lane
"Paragon Corporation" writes: > Not sure if people know this, but PostGIS windows builds are built with > mingw64-w32 and mingw64-w64 chains and usually used with EDB VC++ built > PostgreSQL. > This is mostly because there is too much unix stuff ingrained in PostGIS > toolchain making it difficul

Re: [HACKERS] 9.5 commit fest schedule

2014-05-22 Thread Tom Lane
=?UTF-8?Q?Fabr=C3=ADzio_de_Royes_Mello?= writes: > Deadlines? I think the plan is 1 month for each of the first 4 fests, and a bit more for the last one (6-8 weeks maybe). regards, tom lane -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make

Re: [HACKERS] pg_upgrade fails: Mismatch of relation OID in database 8.4 -> 9.3

2014-05-22 Thread Bruce Momjian
On Wed, May 21, 2014 at 04:37:13PM -0400, Bruce Momjian wrote: > On Wed, May 21, 2014 at 04:23:34PM -0400, Tom Lane wrote: > > Bruce Momjian writes: > > > On Wed, May 21, 2014 at 10:56:59AM -0600, Jeff Ross wrote: > > >> Yes, using 9.3's pg_dump of 8.4 and applying it to both an 8.4 and a > > >> 9

Re: [HACKERS] 9.5 commit fest schedule

2014-05-22 Thread Fabrízio de Royes Mello
Em quinta-feira, 22 de maio de 2014, Heikki Linnakangas < hlinnakan...@vmware.com> escreveu: > On 05/22/2014 07:55 AM, Fabrízio de Royes Mello wrote: > >> Em quinta-feira, 22 de maio de 2014, Peter Eisentraut >> escreveu: >> >> For those who were not at the developer meeting, here is the commit

Re: [HACKERS] 9.5 commit fest schedule

2014-05-22 Thread Heikki Linnakangas
On 05/22/2014 07:55 AM, Fabrízio de Royes Mello wrote: Em quinta-feira, 22 de maio de 2014, Peter Eisentraut escreveu: For those who were not at the developer meeting, here is the commit fest schedule for 9.5: June 15 August 15 October 15 December 15 February 15 beta in June 2015 Actually

Re: [HACKERS] 9.5 commit fest schedule

2014-05-22 Thread Fabrízio de Royes Mello
Em quinta-feira, 22 de maio de 2014, Peter Eisentraut escreveu: > For those who were not at the developer meeting, here is the commit fest > schedule for 9.5: > > June 15 > August 15 > October 15 > December 15 > February 15 > > beta in June 2015 > > Actually you meant: June 14 August 14 October 1

Re: [HACKERS] 9.5 commit fest schedule

2014-05-22 Thread Abhijit Menon-Sen
At 2014-05-22 07:22:42 -0400, pete...@gmx.net wrote: > > We need a volunteer to manage the first commit fest. I volunteer. -- Abhijit -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

Re: [HACKERS] relaying errors from background workers

2014-05-22 Thread Robert Haas
On Thu, May 22, 2014 at 6:33 AM, Petr Jelinek wrote: > On 22/05/14 06:21, Robert Haas wrote: >> The main thing I'm not sure about is how to format the message that we >> write to the shm_mq. One option is to try to use the good old FEBE >> protocol. This doesn't look entirely straightforward, be

[HACKERS] 9.5 commit fest schedule

2014-05-22 Thread Peter Eisentraut
For those who were not at the developer meeting, here is the commit fest schedule for 9.5: June 15 August 15 October 15 December 15 February 15 beta in June 2015 The obvious change is that there will be five commit fests instead of four. Also, the time between beta and release is planned to be

Re: [HACKERS] relaying errors from background workers

2014-05-22 Thread Petr Jelinek
On 22/05/14 06:21, Robert Haas wrote: The main thing I'm not sure about is how to format the message that we write to the shm_mq. One option is to try to use the good old FEBE protocol. This doesn't look entirely straightforward, because send_message_to_frontend() assembles the message using p