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