"Sergey E. Koposov" <[EMAIL PROTECTED]> writes: > I've recently proposed a patch > http://archives.postgresql.org/pgsql-patches/2006-02/msg00165.php > to fix an old problem with dropped columns, but recently > http://archives.postgresql.org/pgsql-patches/2006-02/msg00246.php > Neil Conway have discovered the problem even with the patch. After looking > on the problem it seems that my patch just discovered an additional set of > incosistencies of Postgres in the work with droppped columns.
> I looked in the source of those problems and it seems that I have found > it, but it is situated rather deep in Postgres and I don't have enough > expertise too judge it. So I would be interested if someone clarify the > issue for me and how the problem should be fixed. This is not really fixable without some infrastructure to flush cached plans when the things they depend on change. That's a system-wide problem and it'd be a mistake to spend much time hacking localized stopgaps. Neil has been making noises about working on the real problem, but I dunno how far along he is. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org