Re: Encountering NULLS in plpgsql

From: Richard Huxton <dev(at)archonet(dot)com>
To: Randy Yates <yates(at)ieee(dot)org>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Encountering NULLS in plpgsql
Date: 2006-03-17 15:29:11
Message-ID: 441AD5C7.40304@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Randy Yates wrote:
> I wrote a simple pl to compute running sums, but when it encountered a
> null on a float4 value it caused pgadminIII to crash (exited
> abruptly). Is this intended behavior?

No, but we'll need more information to figure out what is going on.

What language did you use for the procedural code?
Can you show us that code?
What version of postgreSQL?
What version of pgAdmin III?
Was there any error message?
Is there anything in the logs?

--
Richard Huxton
Archonet Ltd

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Richard Huxton 2006-03-17 15:30:11 Re: each line counter
Previous Message Tom Lane 2006-03-17 14:56:32 Re: after insert trigger hangs