Re: Simple function closes connection to server - Mailing list pgsql-novice

"T- Bone" <jbowen333@hotmail.com> writes:
> However, when I execute it as follows, my connection to the db gets closed
> and, obviously, there is no result.  In fact, it appears that ALL
> connections are closed (this is not good).

> SELECT "ZoneID", "getZoneName"("ZoneID"::text) AS "ZoneName"
>    FROM "tblOrganisation";

Do you have any NULL entries in the ZoneID column?  It looks to me like
the uniqueidentifier package fails to declare its functions as STRICT,
and since most of them aren't actually coded to check for null input
values, they'll crash on nulls.  In particular uniqueidentifier_text
will.

My recommendation would be to mark all those functions as strict
(and get rid of the tests for null input that do exist in a couple).

            regards, tom lane