PostgreSQL 8.3.4 Solaris x86 compilation issues

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

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

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

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

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