Re: Dropped attributes in postgres

Kevin Rosenberg <kevin-HJRc7zDS/[email protected]>
Newsgroups gmane.lisp.clsql.devel
Message-ID <[email protected]>
Chris Capel wrote:
> Shouldn't dropped attributes (like columns, which remain in the
> table invisibly after dropped) be ignored by LIST-ATTRIBUTES? Since
> they can't be accessed by SQL, there's not much point in including
> them.

I'm not familiar with this aspect of postgresql.

> And completely off-topic, what is the rationale behind leaving
> dropped columns in the physical table like that? I wasn't aware of
> this issue before CLSQL.

Perhaps because the columns could be recovered before performing some
sort of expunge operation? But, I don't really know. If that is the
case, the columns on are "half-deleted". I still think your patch
makes sense for consistency sake.

Kevin
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.