The following bug has been logged online:

Bug reference: 2651
Logged by: Remy Beaumont
Email address: remyb (AT) medrium (DOT) com
PostgreSQL version: 8.2 - beta 1
Operating system: Solaris 10 on T2000
Description: 8.2 - beta 1 does now compile with Sun Studio 11
Details:

When we try to compile 8.2 - beta 1 on a T2000 wth Sun Studio 11, the build
fails at the following file:

make[5]: Entering directory
`/usr/home/remy/postgresql-8.2beta1/src/backend/utils/adt'
/opt/SUNWspro/bin/cc -Xa -xtarget=ultraT1 -fast -I../../../../src/include
-c -o float.o float.c
"float.c", line 112: identifier redeclared: cbrt
current : static function(double) returning double
previous: function(double) returning double :
"/usr/include/iso/math_c99.h", line 126
cc: acomp failed for float.c
make[5]: *** [float.o] Error 2


The flags used for compiling are: CC=/opt/SUNWspro/bin/cc
'CFLAGS=-xtarget=ultraT1 -fast'

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo (AT) postgresql (DOT) org so that your
message can get through to the mailing list cleanly

"Remy Beaumont" <remyb (AT) medrium (DOT) com> writes:
You need to find out why configure failed to detect that cbrt() is
available.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

Remy Beaumont napsal(a):
The cbrt function is not part of libc. It is located in the libm. Try
export LDFLAGS='-lm'

Zdenek

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo (AT) postgresql (DOT) org so that your
message can get through to the mailing list cleanly

Yes, that is the next item on my list.
I'm just trying to compile it for now on a T2000 with the best=20=20
possible optimization.

With PG 8.1.X. I saw a 30% to 40% performance increase on sorts when=20=20
compiling with Sun Studio 11 and -fast.

R=E9my
On 25-Sep-06, at 22:02, Tom Lane wrote:


---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match