Thanks Tom. I rid the NULLs and altered all uniqueidentifier functions to
strict and everything worked fine.
Cheers,
Jim
>From: Tom Lane <tgl@sss.pgh.pa.us>
>To: "T- Bone" <jbowen333@hotmail.com>
>CC: pgsql-novice@postgresql.org, dmitry@taurussoft.org
>Subject: Re: [NOVICE] Simple function closes connection to server Date:
>Mon, 11 Apr 2005 12:37:28 -0400
>
>"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
_________________________________________________________________
Powerful Parental Controls Let your child discover the best the Internet has
to offer.
http://join.msn.com/?pgmarket=en-ca&page=byoa/prem&xAPID=1994&DI=1034&SU=http://hotmail.com/enca&HL=Market_MSNIS_Taglines
Start enjoying all the benefits of MSN� Premium right now and get the
first two months FREE*.