Thread: pgplsh on postgresql 8.0.2

pgplsh on postgresql 8.0.2

From
cad0022@iperbole.bologna.it
Date:
Hi,
I migrated my db from postgresql 7.4.6 to 8.0.2 but I'm not able to make plsh
functions working.
I installed plsh ver. 1.0-7.3 after having installed postgresql 8.0.2 rpms for
fedora core 2.
I used the same, succesfull, install procedure I used on postgresql 7.4.6.

Every time I try to run a plsh function (ie. postmasterstarttime()) I get the
following error message:

sano_gis=# select postmasterstarttime();
server closed the connection unexpectedly
        This probably means the server terminated abnormally
        before or while processing the request.
The connection to the server was lost. Attempting reset: Succeeded.
sano_gis=#

Do you know if plsh ver. 1.0-7.3 is compatible with postgresql 8.0.2 ?
Is there any solution or alternative?

Thank you very much,
Paolo Mattioli



Re: pgplsh on postgresql 8.0.2

From
Russell Smith
Date:
On Fri, 13 May 2005 06:39 pm, cad0022@iperbole.bologna.it wrote:
> Hi,
> I migrated my db from postgresql 7.4.6 to 8.0.2 but I'm not able to make plsh
> functions working.
> I installed plsh ver. 1.0-7.3 after having installed postgresql 8.0.2 rpms for
> fedora core 2.
> I used the same, succesfull, install procedure I used on postgresql 7.4.6.
>
> Every time I try to run a plsh function (ie. postmasterstarttime()) I get the
> following error message:
>
> sano_gis=# select postmasterstarttime();
> server closed the connection unexpectedly
>         This probably means the server terminated abnormally
>         before or while processing the request.
> The connection to the server was lost. Attempting reset: Succeeded.
> sano_gis=#
>
> Do you know if plsh ver. 1.0-7.3 is compatible with postgresql 8.0.2 ?
> Is there any solution or alternative?

I have had an issue getting plsh working with 8.0.x  Even after editing some
of the source code.  I contacted Peter E about it and he said he would like into
it.  I think you can run exec from both plperlu and plphpu.  You may want to look
into those to see if you can get what you want.  They may even provide more flexibility.

Regards

Russell Smith
>
> Thank you very much,
> Paolo Mattioli
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
>       subscribe-nomail command to majordomo@postgresql.org so that your
>       message can get through to the mailing list cleanly
>
>