| 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: | Whole Thread | Raw Message | 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
| 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 |