Thread: Re: [GENERAL] pg.dropped

Filip Rembiałkowski wrote:

After dropping a column from table, there is still entry in pg_attribute

filip@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.

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.