From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | "Zeugswetter Andreas SB SD" <ZeugswetterA(at)spardat(dot)at> |
Cc: | "Hannu Krosing" <hannu(at)tm(dot)ee>, pgsql-hackers(at)postgreSQL(dot)org, pgsql-sql(at)postgreSQL(dot)org |
Subject: | Re: Cursors and backwards scans and SCROLL |
Date: | 2003-03-10 14:40:55 |
Message-ID: | 17076.1047307255@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-sql |
"Zeugswetter Andreas SB SD" <ZeugswetterA(at)spardat(dot)at> writes:
>> but just give a warning and then run the underlying
>> query _again_, this toime with materialize on top and also do a Move to
>> reposition the cursor. This will probably not work correctly for all
>> tranasaction isolation levels though but it will penalize only these
>> cases that absolutely need it. The penalty will of course be
>> heavier ;(
> rescan can only work in serializable isolation, no?
I had thought about this and concluded it was not worth the trouble.
It could be made to work if we copy the snapshot data from old plan to
new, but realistically there's no value in it. Existing applications
that are successfully using backwards-fetch are using queries that don't
need materialization; therefore there's no compatibility gain from
adding this extra code.
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2003-03-10 14:49:47 | Re: SQL99 ARRAY support proposal |
Previous Message | Tatsuo Ishii | 2003-03-10 13:34:49 | Re: Bug #908: Can not INSERT Cyrilic characters when use |
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2003-03-10 15:07:32 | Re: Help on indexing timestamps |
Previous Message | Christoph Haller | 2003-03-10 14:34:48 | Re: How to notice column changes in trigger |