Hello I get this error message : ERROR: cannot convert relation containing dropped columns to view I have googled, but find only very old posts that doesn't seem to be the same situation. What I have done is that I have a quite big table that I added a column to for deletion time. Then I droped that column and added it again with the right type. After that I cannot create a rule that is returning data. The reason I have to return data is irrelevant here, but PostgREST expects that. To reproduce: create table foo ( id serial, deleted int ); alter table foo drop column deleted; alter table foo add column deleted timestamp; CREATE or replace RULE del_post AS ON DELETE TO foo DO INSTEAD update foo set deleted = now() WHERE id = OLD.id returning *; returns: ERROR: cannot convert relation containing dropped columns to view If I don't drop any column (adding the right type at once) it works as expected. two questions: 1) is this a bug 2) is there a way to "cean" the table from the deleted columns without recreating it? Best Regards Nicklas Avén -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
