7.3: Change in cursor behaviour?

From: "Jeroen T(dot) Vermeulen" <jtv(at)xs4all(dot)nl>
To: pgsql-hackers(at)postgresql(dot)org
Subject: 7.3: Change in cursor behaviour?
Date: 2002-12-02 15:20:59
Message-ID: 20021202152059.GC1260@localhost
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

I've been getting reports of one of my test scenarios for libpqxx
failing with postgres 7.3. At the moment I can't reproduce this (I'm
still on 7.2) and I can't find anything pertinent in CVS commit
messages, mailing lists etc. so I'd really appreciate any lucidity from
this list.

My problem appears to be related to moving a cursor backwards beyond its
point of origin. I realize this is a tacky thing to do, but I sort of
got the impression that moving backwards by some number larger than the
current position would be equivalent to MOVE BACKWARD ALL. Which makes
my code a hell of a lot simpler. It makes a good portion of my life a
hell of a lot simpler, come to think of it, so I'd really appreciate
having this property in the future.

The scenario boils down to: Create a cursor, fetch n rows, move minus 2
billion or so rows, fetch 1 row. That last fetch used to give me the
row I was hoping for (the original first row again), but with 7.3 it
appears to yield nothing.

Is this intentional? Should I change my code? Have I been a bad boy?

Jeroen

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Marc G. Fournier 2002-12-02 15:28:23 Re: Postgres 7.3 announcement on postgresql.org
Previous Message Tom Lane 2002-12-02 15:16:34 Re: USAGE on schema allowed by default?