Postgres Pro
Downloads
Home   >   mailing lists

Thread: BUG #1907: problem with function return as integer[]

BUG #1907: problem with function return as integer[]

From
"Michael Kappler"
Date:
The following bug has been logged online:

Bug reference:      1907
Logged by:          Michael Kappler
Email address:      ComputerChemist@aol.com
PostgreSQL version: 8.1beta1
Operating system:   Red Hat Linux 9.0
Description:        problem with function return as integer[]
Details:

I compiled/linked a shared object against 7.4.5.  My customer installed into
PostgreSQL 8.1beta1.  My functions that return as integer[] give an empty
string (1 row) instead of the correct result (e.g., {{2,7}{4,5}}.  Do I need
to recompile/link against 8.1 headers/objects?

FWIW, my 7.4.5 .so works in PostgreSQL 8.0.3.

Michael

Re: BUG #1907: problem with function return as integer[]

From
Tom Lane
Date:
"Michael Kappler" <ComputerChemist@aol.com> writes:
> I compiled/linked a shared object against 7.4.5.  My customer installed into
> PostgreSQL 8.1beta1.  My functions that return as integer[] give an empty
> string (1 row) instead of the correct result (e.g., {{2,7}{4,5}}.  Do I need
> to recompile/link against 8.1 headers/objects?

Yes.

> FWIW, my 7.4.5 .so works in PostgreSQL 8.0.3.

Pure luck.  We never guarantee binary compatibility across major releases.

            regards, tom lane