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