Bug in row locking?

Started by Nonameabout 19 years ago2 messagesgeneral
Jump to latest
#1Noname
hanak@asellus.cz

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

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Noname (#1)
Re: Bug in row locking?

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