Thread: Bug in row locking?

Hi,

I noticed a problem by trying to lock rows of the view for update,
if the definition of the view consists the reference to another view.

Example:

create table test (a int)

insert into test values (1)
insert into test values (2)
insert into test values (3)
insert into test values (4)

create view vtest1 as
select a from test
where a > 1

create view vtest2 as
select a from vtest1
where a > 2

If you try to lock rows in the view vtest1, everything is OK.

But if you try to lock rows in the view vtest2, this error message
occurs:

ERROR:  no relation entry for relid 5

Any ideas, whats wrong?

Best regards

Pavel Hanak

hanak@asellus.cz (Ing. Pavel =?iso-8859-2?Q?Han=E1k?=) writes:
> But if you try to lock rows in the view vtest2, this error message
> occurs:
> ERROR:  no relation entry for relid 5

Wow, amazing no one reported this before, because it seems to be broken
all the way back to 7.3 ... will look into it.

            regards, tom lane