[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 up

[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 -DSO_MAJOR_VERSIO

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

2010-07-19 Thread Tom Lane
Dave Page 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 -I../../../src/port -I../../

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 bug

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/aut

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 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 should give y

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

2010-07-19 Thread Dave Page
On Mon, Jul 19, 2010 at 1:56 PM, Zdenek Kotala 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 :-( > > Unfortunately, I had to stop them :(. Sorry. > > I cannot remember this bug. Howev

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 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 :-( > > > > Unfortunately, I had t

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

2010-07-19 Thread Kevin Grittner
"john" 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 upplyupdates(0) in > delphi

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 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 > 'LDFLAGS' =>

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/in

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 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 >> -D_POSIX_PTHREAD_SEM

[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 over

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 t

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 t

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

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,

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 levels

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 issuin

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

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/in

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 17:26

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 Freu

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 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 >> -D_POSIX_PTHREAD_SEM

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: >