Re: plpgsql: UPDATE...Returning in FOR loop

On 02/03/2009 20:19, Tom Lane wrote:

> Well, that has nothing to do with UPDATE RETURNING; it's apparently
> failing here:
>
>>   rec recipients;
>
> I suppose "recipients" is a composite type one of whose columns is of a
> NOT NULL domain.  Best advice is "don't do that" --- not-null domains

Thanks Tom and Sam for your replies - I hadn't absorbed the bit in the
docs about variables being initialised to NULL in the absence of
anything else.... removing NOT NULL from message_type_domain did the
trick, and all works as I hoped.

Ray.


------------------------------------------------------------------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
rod@iol.ie
Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals
------------------------------------------------------------------

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general