Re: Simple function closes connection to server

Thanks Tom.  I rid the NULLs and altered all uniqueidentifier functions to 
strict and everything worked fine.

Cheers,
Jim

>From: Tom Lane 
>To: "T- Bone" 
>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"  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*.