[BUGS] BUG #5565: ERROR : syntax error at or near )

2010-07-19 Thread john
The following bug has been logged online: Bug reference: 5565 Logged by: john Email address: syaba...@yahoo.com PostgreSQL version: 8.4.1 Operating system: XP XP2 Description:ERROR : syntax error at or near ) Details: when insert using client dataset after post

[BUGS] PG 9.0 Solaris compile error on Sparc

2010-07-19 Thread Dave Page
I'm working on setting up a new buildfarm member as we don't seem to have any active Solaris ones :-( cc -Xa -m64 -mt -mt -D_REENTRANT -D_THREAD_SAFE -D_POSIX_PTHREAD_SEMANTICS -KPIC -DFRONTEND -DUNSAFE_STAT_OK -I. -I../../../src/include -I../../../src/port -I../../../src/port

Re: [BUGS] PG 9.0 Solaris compile error on Sparc

2010-07-19 Thread Tom Lane
Dave Page dp...@pgadmin.org writes: I'm working on setting up a new buildfarm member as we don't seem to have any active Solaris ones :-( cc -Xa -m64 -mt -mt -D_REENTRANT -D_THREAD_SAFE -D_POSIX_PTHREAD_SEMANTICS -KPIC -DFRONTEND -DUNSAFE_STAT_OK -I. -I../../../src/include

Re: [BUGS] PG 9.0 Solaris compile error on Sparc

2010-07-19 Thread Zdenek Kotala
Dave Page píše v po 19. 07. 2010 v 13:32 +0100: I'm working on setting up a new buildfarm member as we don't seem to have any active Solaris ones :-( Unfortunately, I had to stop them :(. Sorry. I cannot remember this bug. However for Solaris 10 is better to use SunStudio 11. I see lot of bugs

Re: [BUGS] PG 9.0 Solaris compile error on Sparc

2010-07-19 Thread Tom Lane
I wrote: That code wouldn't be getting compiled if configure hadn't found getpeerucred present, so I'll bet the problem is just lack of the #include file that declares the above symbols. A bit of grepping of /usr/include should give you the answer. ... but looking in src/backend/libpq/auth.c

Re: [BUGS] PG 9.0 Solaris compile error on Sparc

2010-07-19 Thread Dave Page
On Mon, Jul 19, 2010 at 2:03 PM, Tom Lane t...@sss.pgh.pa.us wrote: I wrote: That code wouldn't be getting compiled if configure hadn't found getpeerucred present, so I'll bet the problem is just lack of the #include file that declares the above symbols.  A bit of grepping of /usr/include

Re: [BUGS] PG 9.0 Solaris compile error on Sparc

2010-07-19 Thread Zdenek Kotala
Dave Page píše v po 19. 07. 2010 v 14:24 +0100: On Mon, Jul 19, 2010 at 1:56 PM, Zdenek Kotala zdenek.kot...@sun.com wrote: Dave Page píše v po 19. 07. 2010 v 13:32 +0100: I'm working on setting up a new buildfarm member as we don't seem to have any active Solaris ones :-(

Re: [BUGS] BUG #5565: ERROR : syntax error at or near )

2010-07-19 Thread Kevin Grittner
john syaba...@yahoo.com wrote: PostgreSQL version: 8.4.1 If you update to the latest 8.4 bug fix release (currently 8.4.4), you'll avoid any bugs which have already been found and fixed. http://www.postgresql.org/support/versioning when insert using client dataset after post

Re: [BUGS] PG 9.0 Solaris compile error on Sparc

2010-07-19 Thread Dave Page
On Mon, Jul 19, 2010 at 2:36 PM, Zdenek Kotala zdenek.kot...@sun.com wrote:  OpenSSL fails, due to lack of libcryto, and TCL seems to fail due to lack of headers (though I didn't look very hard). You need to set RPATH. Openssl is in /usr/sfw/lib (/usr/sfw/lib/64) You need this for 32bit

Re: [BUGS] PG 9.0 Solaris compile error on Sparc

2010-07-19 Thread Peter Eisentraut
On mån, 2010-07-19 at 13:32 +0100, Dave Page wrote: I'm working on setting up a new buildfarm member as we don't seem to have any active Solaris ones :-( cc -Xa -m64 -mt -mt -D_REENTRANT -D_THREAD_SAFE -D_POSIX_PTHREAD_SEMANTICS -KPIC -DFRONTEND -DUNSAFE_STAT_OK -I. -I../../../src/include

Re: [BUGS] PG 9.0 Solaris compile error on Sparc

2010-07-19 Thread Dave Page
On Mon, Jul 19, 2010 at 4:00 PM, Peter Eisentraut pete...@gmx.net wrote: On mån, 2010-07-19 at 13:32 +0100, Dave Page wrote: I'm working on setting up a new buildfarm member as we don't seem to have any active Solaris ones :-( cc -Xa -m64 -mt   -mt -D_REENTRANT -D_THREAD_SAFE

[BUGS] BUG #5566: High levels of savepoint nesting trigger stack overflow in AssignTransactionId

2010-07-19 Thread Hans van Kranenburg
The following bug has been logged online: Bug reference: 5566 Logged by: Hans van Kranenburg Email address: hans.van.kranenb...@mendix.com PostgreSQL version: 8.3.11 Operating system: Debian GNU/Linux 5.0 Description:High levels of savepoint nesting trigger stack

Re: [BUGS] BUG #5566: High levels of savepoint nesting trigger stack overflow in AssignTransactionId

2010-07-19 Thread Andres Freund
On Monday 19 July 2010 17:26:25 Hans van Kranenburg wrote: When issuing an update statement in a transaction with ~30800 levels of savepoint nesting, (which is insane, but possible), postgresql segfaults due to a stack overflow in the AssignTransactionId function, which recursively assign

Re: [BUGS][PATCH] BUG #5566: High levels of savepoint nesting trigger stack overflow in AssignTransactionId

2010-07-19 Thread Andres Freund
On Monday 19 July 2010 17:58:06 Andres Freund wrote: On Monday 19 July 2010 17:26:25 Hans van Kranenburg wrote: When issuing an update statement in a transaction with ~30800 levels of savepoint nesting, (which is insane, but possible), postgresql segfaults due to a stack overflow in the

Re: [BUGS] BUG #5566: High levels of savepoint nesting trigger stack overflow in AssignTransactionId

2010-07-19 Thread Alvaro Herrera
Excerpts from Andres Freund's message of lun jul 19 11:58:06 -0400 2010: On Monday 19 July 2010 17:26:25 Hans van Kranenburg wrote: When issuing an update statement in a transaction with ~30800 levels of savepoint nesting, (which is insane, but possible), postgresql segfaults due to a stack

Re: [BUGS] BUG #5566: High levels of savepoint nesting trigger stack overflow in AssignTransactionId

2010-07-19 Thread Andres Freund
Hi, On Monday 19 July 2010 19:57:13 Alvaro Herrera wrote: Excerpts from Andres Freund's message of lun jul 19 11:58:06 -0400 2010: On Monday 19 July 2010 17:26:25 Hans van Kranenburg wrote: When issuing an update statement in a transaction with ~30800 levels of savepoint nesting, (which

Re: [BUGS] BUG #5566: High levels of savepoint nesting trigger stack overflow in AssignTransactionId

2010-07-19 Thread Heikki Linnakangas
On 19/07/10 20:58, Andres Freund wrote: On Monday 19 July 2010 19:57:13 Alvaro Herrera wrote: Excerpts from Andres Freund's message of lun jul 19 11:58:06 -0400 2010: On Monday 19 July 2010 17:26:25 Hans van Kranenburg wrote: When issuing an update statement in a transaction with ~30800

Re: [BUGS] BUG #5566: High levels of savepoint nesting trigger stack overflow in AssignTransactionId

2010-07-19 Thread Alvaro Herrera
Excerpts from Andres Freund's message of lun jul 19 13:58:30 -0400 2010: Hi, On Monday 19 July 2010 19:57:13 Alvaro Herrera wrote: Excerpts from Andres Freund's message of lun jul 19 11:58:06 -0400 2010: On Monday 19 July 2010 17:26:25 Hans van Kranenburg wrote: When issuing an update

Re: [BUGS] BUG #5566: High levels of savepoint nesting trigger stack overflow in AssignTransactionId

2010-07-19 Thread Andres Freund
On Monday 19 July 2010 20:19:35 Heikki Linnakangas wrote: On 19/07/10 20:58, Andres Freund wrote: On Monday 19 July 2010 19:57:13 Alvaro Herrera wrote: Excerpts from Andres Freund's message of lun jul 19 11:58:06 -0400 2010: On Monday 19 July 2010 17:26:25 Hans van Kranenburg wrote: When

Re: [BUGS] PG 9.0 Solaris compile error on Sparc

2010-07-19 Thread Peter Eisentraut
On mån, 2010-07-19 at 13:32 +0100, Dave Page wrote: I'm working on setting up a new buildfarm member as we don't seem to have any active Solaris ones :-( cc -Xa -m64 -mt -mt -D_REENTRANT -D_THREAD_SAFE -D_POSIX_PTHREAD_SEMANTICS -KPIC -DFRONTEND -DUNSAFE_STAT_OK -I. -I../../../src/include

Re: [BUGS] BUG #5566: High levels of savepoint nesting trigger stack overflow in AssignTransactionId

2010-07-19 Thread Heikki Linnakangas
On 19/07/10 21:32, Andres Freund wrote: On Monday 19 July 2010 20:19:35 Heikki Linnakangas wrote: On 19/07/10 20:58, Andres Freund wrote: On Monday 19 July 2010 19:57:13 Alvaro Herrera wrote: Excerpts from Andres Freund's message of lun jul 19 11:58:06 -0400 2010: On Monday 19 July 2010

Re: [BUGS] BUG #5566: High levels of savepoint nesting trigger stack overflow in AssignTransactionId

2010-07-19 Thread Andres Freund
On Monday 19 July 2010 21:03:25 Heikki Linnakangas wrote: On 19/07/10 21:32, Andres Freund wrote: On Monday 19 July 2010 20:19:35 Heikki Linnakangas wrote: On 19/07/10 20:58, Andres Freund wrote: On Monday 19 July 2010 19:57:13 Alvaro Herrera wrote: Excerpts from Andres Freund's message

Re: [BUGS] PG 9.0 Solaris compile error on Sparc

2010-07-19 Thread Dave Page
On Mon, Jul 19, 2010 at 7:53 PM, Peter Eisentraut pete...@gmx.net wrote: On mån, 2010-07-19 at 13:32 +0100, Dave Page wrote: I'm working on setting up a new buildfarm member as we don't seem to have any active Solaris ones :-( cc -Xa -m64 -mt   -mt -D_REENTRANT -D_THREAD_SAFE

Re: [BUGS] BUG #5566: High levels of savepoint nesting trigger stack overflow in AssignTransactionId

2010-07-19 Thread Andres Freund
On Monday 19 July 2010 20:32:49 Andres Freund wrote: On Monday 19 July 2010 20:19:35 Heikki Linnakangas wrote: On 19/07/10 20:58, Andres Freund wrote: On Monday 19 July 2010 19:57:13 Alvaro Herrera wrote: Excerpts from Andres Freund's message of lun jul 19 11:58:06 -0400 2010: It