Re: problems selecting from altered table - Mailing list pgsql-general

From Tom Lane
Subject Re: problems selecting from altered table
Date
Msg-id 252.1182269274@sss.pgh.pa.us
Whole thread Raw
In response to Re: problems selecting from altered table  (Richard Huxton <dev@archonet.com>)
Responses Re: problems selecting from altered table
List pgsql-general
Richard Huxton <dev@archonet.com> writes:
> Any developers care to comment?

plpgsql isn't very bright about tuple descriptors containing dropped
columns.  The immediate problem is that compatible_tupdesc() doesn't
think a tupdesc containing one column matches one containing the same
column plus a dropped column; but fixing that would just allow
subsequent processing to crash :-(.  It needs a fair amount of work.
I think the other PLs are no better.

            regards, tom lane

pgsql-general by date:

Previous
From: Rikard Pavelic
Date:
Subject: Re: problems selecting from altered table
Next
From: Noah Heusser
Date:
Subject: Re: Dynamic Log tigger (plpgsql)