Bug in row locking?

From: hanak(at)asellus(dot)cz (Ing(dot) Pavel =?iso-8859-2?Q?Han=E1k?=)
To: pgsql-general(at)postgresql(dot)org
Subject: Bug in row locking?
Date: 2007-03-01 14:59:21
Message-ID: 83k5y13t86.fsf@alfik.habrovka.xx
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Hannes Dorbath 2007-03-01 15:06:00 Re: TSearch2: Can't build gendict output
Previous Message Hannes Dorbath 2007-03-01 14:59:11 TSearch2: Can't build gendict output