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