From: | "David Johnston" <polobo(at)yahoo(dot)com> |
---|---|
To: | <pgsql-general(at)postgresql(dot)org> |
Subject: | 9.0.X FOR UPDATE|SHARE on Sub-Query Causes "cannot extract system attribute from virtual tuple" if Sub-Query Returns Records (BUG) |
Date: | 2011-02-09 00:10:30 |
Message-ID: | 001c01cbc7ed$c3eb5eb0$4bc21c10$@yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I actually posted a more detail posting on this issue but I have a lot of
extra information that jumbles things up.
More simply if you run any query of the form:
SELECT subquerycolumn
FROM (
SELECT subquerycolumn FROM table WHERE [condition] FOR UPDATE -- WHERE
is optional but obviously useful; FOR SHARE also causes this behavior
) intermediate
The error "cannot extract system attribute from virtual tuple" is thrown IIF
the sub-query returns one or more records. My prior posting on this topic
made it seem as if some environments worked because the query I was testing
had a sub-query that was not returning any records. I have tested on both
Linux and Windows (both 64-bit) versions of 9.0.3 and get this behavior.
Anyway, the above query form works in both 8.2 and 8.4 but fails in 9.0.3
(at least, through probably all 9.0.X releases)
I'll ask in the other thread (once it appears) for suggestions as to
possible workarounds (and maybe better performing) methods to accomplish my
goal but figured the simple query form shown above should readily re-produce
the exception on any 9.0.X system.
If there is a BUG (or when one is opened) responding to this message with a
BUG# would be welcomed.
Thanks,
David J
From | Date | Subject | |
---|---|---|---|
Next Message | David Kerr | 2011-02-09 00:38:23 | pg_dump: schema with OID 58698 does not exist |
Previous Message | Jens Wilke | 2011-02-08 22:48:26 | Re: No Password Access |