Skip site navigation (1) Skip section navigation (2)

Re: Simple function closes connection to server

From: "T- Bone" <jbowen333(at)hotmail(dot)com>
To: tgl(at)sss(dot)pgh(dot)pa(dot)us
Cc: pgsql-novice(at)postgresql(dot)org, dmitry(at)taurussoft(dot)org
Subject: Re: Simple function closes connection to server
Date: 2005-04-15 21:06:01
Message-ID: BAY103-F365B9F88CDAE56FC83A7C5E7360@phx.gbl (view raw or flat)
Thread:
Lists: pgsql-novice
Thanks Tom.  I rid the NULLs and altered all uniqueidentifier functions to 
strict and everything worked fine.

Cheers,
Jim

>From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
>To: "T- Bone" <jbowen333(at)hotmail(dot)com>
>CC: pgsql-novice(at)postgresql(dot)org, dmitry(at)taurussoft(dot)org
>Subject: Re: [NOVICE] Simple function closes connection to server Date: 
>Mon, 11 Apr 2005 12:37:28 -0400
>
>"T- Bone" <jbowen333(at)hotmail(dot)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*.


In response to

pgsql-novice by date

Next:From: CimaDate: 2005-04-15 22:42:40
Subject: oids as primary keys?
Previous:From: Andres LedesmaDate: 2005-04-15 19:26:51
Subject: Re: oids as primary keys?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group