(continued from -general)
W dniu 7 stycznia 2010 22:31 użytkownik Greg Smith <g...@2ndquadrant.com>napisał: > Filip Rembiałkowski wrote: > >> After dropping a column from table, there is still entry in pg_attribute >> >> fi...@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.rembialkow...@gmail.com http://filip.rembialkowski.net/
