Home > mailing lists

Thread: PostgreSQL 8.3.4 Solaris x86 compilation issues

PostgreSQL 8.3.4 Solaris x86 compilation issues

From

"Dot Yet"

Date:

24 October 2008, 07:33:24

Hi everyone,

i am facing some problem while compiling postgresql 8.3.4 on Solaris 10 x86 10u5. the compiler is SunStudio 12.

The compilation happens without errors, but make check fails:

OpenSSL 0.9.8i compiled as:

./Configure --prefix=/opt/usr/local -m64 -xmodel=medium

PostgreSQL 8.3.4 compiled as:

./configure --prefix=/opt/usr/local --with-libs=/opt/usr/local/lib --without-readline --with-openssl CFLAGS=" -m64 -xmodel=medium"

The error happens while running make check:

./pg_regress --temp-install=./tmp_check --top-builddir=../../.. --srcdir=/export/home/dotyet/pginst/postgresql-8.3.4/src/test/regress --temp-port=55432 --schedule=./parallel_schedule --multibyte=SQL_ASCII --load-language=plpgsql

============== removing existing temp installation ==============

============== creating temporary installation ==============

============== initializing database system ==============

============== starting postmaster ==============

Killed

if I remove the --with-openssl, everything works as expected.

any thoughts?

thanks in advance.

dotyet

JDBC - Call stored function that returns user defined type

From

Date:

24 October 2008, 19:22:33

I am looking for info on how to call a stored function that returns a user defined type.

Assume I have a type defined as:

CREATE TYPE XYType AS (x int4, y int4);

and I use CYType in a function such as this:

CREATE FUNCTION test(IN z int4, OUT xy XYType, OUT status character) RETURNS RECORD AS $BODY$.....

I found info on how to formulate a

CallableStatement, but no info on how to process the results from the call? Or does Postgres JDBC support this type of calls?

Any help is greatly appreciated.

Regards,

CYW

Re: JDBC - Call stored function that returns user defined type

From

Date:

25 October 2008, 19:28:19

While I still don't know who to handle returns with scalars and user defined types mixes, I tested with a function that returns only a SETOF a user defined type, the behavior is the same as a normal select return. You can use ReseultSet to traverse and get each column.

CYW

----- Original Message -----
From: cyw@dls.net
To: General PostgreSQL List
Sent: Friday, October 24, 2008 2:23 PM
Subject: [GENERAL] JDBC - Call stored function that returns user defined type

I am looking for info on how to call a stored function that returns a user defined type.

Assume I have a type defined as:
    CREATE TYPE XYType AS (x int4, y int4);

and I use CYType in a function such as this:
    CREATE FUNCTION test(IN z int4, OUT xy XYType, OUT status character) RETURNS RECORD AS $BODY$.....

I found info on how to formulate a CallableStatement, but no info on how to process the results from the call? Or does Postgres JDBC support this type of calls?

Any help is greatly appreciated.

Regards,
CYW

Re: PostgreSQL 8.3.4 Solaris x86 compilation issues

From

Zdenek Kotala

Date:

01 November 2008, 08:09:36

Hi,

It is really strange. Is there any reason why you don't use integrated SSL?
64bit version is located in /usr/sfw/lib/64
Try

./configure --prefix=/opt/usr/local --with-libs=/usr/sfw/lib/64:/opt/usr/local/lib
  --without-readline --with-openssl CFLAGS=" -m64 -xmodel=medium"

Or you canuse precompiled binaries from PostgreSQL web site.

        Zdenek


Dot Yet napsal(a):
> Hi everyone,
> i am facing some problem while compiling postgresql 8.3.4 on Solaris 10 x86
> 10u5. the compiler is SunStudio 12.
>
> The compilation happens without errors, but make check fails:
>
> OpenSSL 0.9.8i compiled as:
> ./Configure --prefix=/opt/usr/local -m64 -xmodel=medium
>
> PostgreSQL 8.3.4 compiled as:
> ./configure --prefix=/opt/usr/local --with-libs=/opt/usr/local/lib
> --without-readline --with-openssl CFLAGS=" -m64 -xmodel=medium"
>
> The error happens while running make check:
>
> ./pg_regress --temp-install=./tmp_check --top-builddir=../../..
> --srcdir=/export/home/dotyet/pginst/postgresql-8.3.4/src/test/regress
> --temp-port=55432 --schedule=./parallel_schedule --multibyte=SQL_ASCII
> --load-language=plpgsql
> ============== removing existing temp installation    ==============
> ============== creating temporary installation        ==============
> ============== initializing database system           ==============
> ============== starting postmaster                    ==============
> Killed
> Killed
> Killed
> Killed
> Killed
> Killed
>
> if I remove the --with-openssl, everything works as expected.
>
> any thoughts?
>
> thanks in advance.
> dotyet
>


--
Zdenek Kotala              Sun Microsystems
Prague, Czech Republic     http://sun.com/postgresql

Re: PostgreSQL 8.3.4 Solaris x86 compilation issues

From

"postgres Emanuel CALVO FRANCO"

Date:

01 November 2008, 17:59:53

do you just read FAQ_Solaris in the docs. I don't remember at all, but
is explain some steps to run with SSL.

2008/11/1, Zdenek Kotala <Zdenek.Kotala@sun.com>:
> Hi,
>
> It is really strange. Is there any reason why you don't use integrated SSL?
> 64bit version is located in /usr/sfw/lib/64
> Try
>
> ./configure --prefix=/opt/usr/local
> --with-libs=/usr/sfw/lib/64:/opt/usr/local/lib
>   --without-readline --with-openssl CFLAGS=" -m64 -xmodel=medium"
>
> Or you canuse precompiled binaries from PostgreSQL web site.
>
>         Zdenek
>
>
> Dot Yet napsal(a):
>> Hi everyone,
>> i am facing some problem while compiling postgresql 8.3.4 on Solaris 10
>> x86
>> 10u5. the compiler is SunStudio 12.
>>
>> The compilation happens without errors, but make check fails:
>>
>> OpenSSL 0.9.8i compiled as:
>> ./Configure --prefix=/opt/usr/local -m64 -xmodel=medium
>>
>> PostgreSQL 8.3.4 compiled as:
>> ./configure --prefix=/opt/usr/local --with-libs=/opt/usr/local/lib
>> --without-readline --with-openssl CFLAGS=" -m64 -xmodel=medium"
>>
>> The error happens while running make check:
>>
>> ./pg_regress --temp-install=./tmp_check --top-builddir=../../..
>> --srcdir=/export/home/dotyet/pginst/postgresql-8.3.4/src/test/regress
>> --temp-port=55432 --schedule=./parallel_schedule --multibyte=SQL_ASCII
>> --load-language=plpgsql
>> ============== removing existing temp installation    ==============
>> ============== creating temporary installation        ==============
>> ============== initializing database system           ==============
>> ============== starting postmaster                    ==============
>> Killed
>> Killed
>> Killed
>> Killed
>> Killed
>> Killed
>>
>> if I remove the --with-openssl, everything works as expected.
>>
>> any thoughts?
>>
>> thanks in advance.
>> dotyet
>>
>
>
> --
> Zdenek Kotala              Sun Microsystems
> Prague, Czech Republic     http://sun.com/postgresql
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>


--
      Emanuel Calvo Franco
    Syscope Postgresql DBA
          BaPUG Member

Re: PostgreSQL 8.3.4 Solaris x86 compilation issues

From

Zdenek Kotala

Date:

01 November 2008, 18:00:44

I know solaris FAQ well. There is mention OpenSSL problem with Solaris 8.
Solaris 9 and newer are OK. They ship OpenSSL version which really work.

        Zdenek

postgres Emanuel CALVO FRANCO napsal(a):
> do you just read FAQ_Solaris in the docs. I don't remember at all, but
> is explain some steps to run with SSL.
>
> 2008/11/1, Zdenek Kotala <Zdenek.Kotala@sun.com>:
>> Hi,
>>
>> It is really strange. Is there any reason why you don't use integrated SSL?
>> 64bit version is located in /usr/sfw/lib/64
>> Try
>>
>> ./configure --prefix=/opt/usr/local
>> --with-libs=/usr/sfw/lib/64:/opt/usr/local/lib
>>   --without-readline --with-openssl CFLAGS=" -m64 -xmodel=medium"
>>
>> Or you canuse precompiled binaries from PostgreSQL web site.
>>
>>         Zdenek
>>
>>
>> Dot Yet napsal(a):
>>> Hi everyone,
>>> i am facing some problem while compiling postgresql 8.3.4 on Solaris 10
>>> x86
>>> 10u5. the compiler is SunStudio 12.
>>>
>>> The compilation happens without errors, but make check fails:
>>>
>>> OpenSSL 0.9.8i compiled as:
>>> ./Configure --prefix=/opt/usr/local -m64 -xmodel=medium
>>>
>>> PostgreSQL 8.3.4 compiled as:
>>> ./configure --prefix=/opt/usr/local --with-libs=/opt/usr/local/lib
>>> --without-readline --with-openssl CFLAGS=" -m64 -xmodel=medium"
>>>
>>> The error happens while running make check:
>>>
>>> ./pg_regress --temp-install=./tmp_check --top-builddir=../../..
>>> --srcdir=/export/home/dotyet/pginst/postgresql-8.3.4/src/test/regress
>>> --temp-port=55432 --schedule=./parallel_schedule --multibyte=SQL_ASCII
>>> --load-language=plpgsql
>>> ============== removing existing temp installation    ==============
>>> ============== creating temporary installation        ==============
>>> ============== initializing database system           ==============
>>> ============== starting postmaster                    ==============
>>> Killed
>>> Killed
>>> Killed
>>> Killed
>>> Killed
>>> Killed
>>>
>>> if I remove the --with-openssl, everything works as expected.
>>>
>>> any thoughts?
>>>
>>> thanks in advance.
>>> dotyet
>>>
>>
>> --
>> Zdenek Kotala              Sun Microsystems
>> Prague, Czech Republic     http://sun.com/postgresql
>>
>>
>> --
>> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
>> To make changes to your subscription:
>> http://www.postgresql.org/mailpref/pgsql-general
>>
>
>


--
Zdenek Kotala              Sun Microsystems
Prague, Czech Republic     http://sun.com/postgresql