On Thu, 19 Jun 2003, Tom Lane wrote:
> "Nigel J. Andrews" <nandrews@investsystems.co.uk> writes:
> > If in a trigger one does a select * from the table the trigger is on
> > is it safe to assume that tg_trigtuple (and so tg_newtuple) will use
> > the same TupleDesc as that returned from the select *, i.e. the
> > tg_relation->rd_att TupleDesc?
>
> Given recent discussions about decoupling logical and physical column
> order, I'd think that assumption might blow up in your face in a version
> or two. It's unsafe even today if the relation has dropped columns.
Thanks, that's what started me thinking about what I was doing and although I
added a check for attisdropped in my loop it still relies on the trigtuple and
the one returned from select * being the same.
Plus of course I wasn't thinking that at some stage that the logical order
might be changed since I'm not likely to do that, but then one never knows and
someone else might change it.
--
Nigel J. Andrews