Re: [GENERAL] pg.dropped

(continued from -general)

W dniu 7 stycznia 2010 22:31 użytkownik Greg Smith
<greg(at)2ndquadrant(dot)com>napisał:

> Filip Rembiałkowski wrote:
>
>> After dropping a column from table, there is still entry in pg_attribute
>>
>> filip(at)la_dev=# select * from pg_attribute where attrelid = (select oid
>> from pg_class where relname='thetable') order by attnum desc limit 1;
>> -[ RECORD 1 ]-+------------------------------
>> attrelid | 4753849
>> attname | ........pg.dropped.69........
>> ...
>> attisdropped | t
>>
>
> See that last part? That's what happens when you drop a
> table--"attisdropped" is set to true. The server can't just delete the
> pg_attribute entry altogether for various internal reasons, this is what it
> does instead.

When should server delete this row? In my case it looks like it's never
deleted (it lasts even server restart).

>
>
> And of course this makes my INSERT not working...
>>
>
> There's obviously something wrong here, but the fact that the pg_attribute
> entry is still there (but marked dropped) is a not a direct cause of your
> problem.
>

Thanks, I get it.

--
Filip Rembiałkowski
JID,mailto:filip(dot)rembialkowski(at)gmail(dot)com
http://filip.rembialkowski.net/