I wrote:
> Nicklas =?ISO-8859-1?Q?Av=E9n?= writes:
>> ERROR: cannot convert relation containing dropped columns to view
> When we made rules with RETURNING go through this logic, in 2006, we
> don't seem to have revisited the message text, much less thought about
> whether we needed to take "mor
Tom Lane skrev
> Nicklas =?ISO-8859-1?Q?Av=E9n?= writes:
> > 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 INST
Nicklas =?ISO-8859-1?Q?Av=E9n?= writes:
> 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 = O
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 drope
