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@xxxxxx Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals ------------------------------------------------------------------ -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
