Re: problems selecting from altered table

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Richard Huxton <dev(at)archonet(dot)com>
Cc: Rikard Pavelic <rikard(dot)pavelic(at)zg(dot)htnet(dot)hr>, pgsql-general(at)postgresql(dot)org
Subject: Re: problems selecting from altered table
Date: 2007-06-19 16:07:54
Message-ID: 252.1182269274@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Richard Huxton <dev(at)archonet(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Richard Huxton 2007-06-19 16:35:57 Re: problems selecting from altered table
Previous Message Josh 2007-06-19 16:03:46 Re: [PERFORM] Postgres VS Oracle