cursor bug - PostgreSQL Database

washingtonirving

Hi. I sent this bug to the bugs mailing list. But the email never turned
up on the list. Could somebody here tell me what I'm doing wrong, and why
the email won't show up? Am I breaking some unwritten rule of the bugs
list? I would really like to see an answer to this.

Thanks a lot!

-w

---
wa************* *@yahoo.com wrote:

=============== =============== =============== =============== =============== =
POSTGRESQL BUG REPORT TEMPLATE

=============== =============== =============== =============== =============== =
Your name : washington irving
Your email address : wa************* *@yahoo.com
System Configuration---------------------
Architecture (example: Intel Pentium) : Intel
Pentium/powerpc-apple-darwin6.6

Operating System (example: Linux 2.0.26 ELF) :Linux 2.4.18 ELF,
FreeBSD 4.8 Release, Mac OSX 10.2.6

PostgreSQL version (example: PostgreSQL-7.3.4): PostgreSQL-7.3.4,
7.3.3

Compiler used (example: gcc 2.95.2) :gcc3.1, gcc 3.3.1, gcc 2.95.4
Please enter a FULL description of your problem:
------------------------------------------------
Under some cases, using cursors and the fetch and move commands don't
work as expected. Please see below for a full decription of the
problem
with the attached dump.

Please describe a way to repeat the problem. Please try to provide a
concise reproducible example, if at all possible:
----------------------------------------------------------------------

I'm attaching the dump of a database named test. I've managed to
reproduce this bug on freebsd (postgresql 7.3.3), linux (7.3.3) and
mac osx
(both 7.3.3. and 7.3.4). This is the smallest test case I could come
up
with. In this test, I first declare a cursor and
then try to fetch 10k rows. It returns 2153 rows (the number of rowsthat
satisfy the select). Then I try to fetch another 10k rows. This
returns an empty list (as it should). Then I try to move the cursor
back by 2153. This does not move the cursor at all. This happens
regardless of the number you use in the fetch command (for instance
fetching 1000 rows at a time). It also happens regardless of the
number
passed in to the move command.

Either this is a bug, or I'm doing something terribly wrong. Could
people who know more about this please look into it.
-- psql session showing problem --
unix prompt> psql test
Welcome to psql 7.3.3, the PostgreSQL interactive terminal.

Type: \copyright for distribution terms
\h for help with SQL commands
\? for help on internal slash commands
\g or terminate with semicolon to execute query
\q to quit

test=# begin;
BEGINtest=# declare c cursor for SELECT * from pa, ua where ua.adid =
pa.adid
and pa.pid = 1;
DECLARE CURSOR
test=# fetch 10000 from c;
..... 2153 rows returned ....
test=# fetch 10000 from c;
pid | adid | cid | k | c | u | ad | adid
(0 rows)
test=# move -2153 from c;
MOVE 0
test=# fetch 10000 from c; pid | adid | cid | k | c | u | ad | adid
-----+------+-----+---+---+---+----+------
(0 rows)

test=#

If you know how this problem might be fixed, list the solution below:
---------------------------------------------------------------------
_______________ _______________ ____
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

Nov 11 '05 #1

Subscribe Reply

1746

Similar topics

17314

Mouse won't change (onmousedown="this.style.cursor='different'")

by: Csaba2000 | last post by:

I have set onmousedown to change the cursor, but this setting is ignored (IE 5.5; NN 6.1 on Win 2K Pro) until the mouse is either moved or the mouse button is released. On Opera 7.01, the setting seems to be ignored completely, even when I try with window.setTimeout. So my two questions are: (1) Most important: Is there anything I can do so that I don't have to wait for the next mouse event before the cursor gets repainted. (2) Why...

Javascript

14463

wait cursor

by: Vlad Simionescu | last post by:

Hello I'm trying to let my Windows Form application perform a lengthy operation while displaying a progress bar in a modal dialog window; the dialog has a cancel button. The dialog is displayed in the main thread while the work is done in a background thread. I managed to do it except for one minor problem: I want the cursor to be hourglass when it is over the main window and be normal (arrow) when it is over the dialog box. I cannot do...

C# / C Sharp

1781

cursor question

by: dave | last post by:

In my form Ive got a SaveData() routine that saves changes to a DB. When I encounter an exception in the save operations, I am having trouble chaning the cursor back to the default cursor, it just stays as an hourglass. It seems as though the cursor can only be set in the context of the form. I would like to set the cursor within my standard error handling module. See code below... Any ideas? Thanks, Dave

Visual Basic .NET

1975

Cursor

by: Lespaul36 | last post by:

I have a mdi app. I need to change the cursor when I click on certain button on a form that I made into a toolbar. I tried to use cursor.current. But the cursor won't show. if I change the form cursor it will work over the form. I need it to stay with the same cursor over all objects. Any ideas of what I am doing wrong here? TIA

Visual Basic .NET

17379

What's the difference between Cursor = Cursors.WaitCursor and CurrentCursor=Cursors.WaitCursor

by: Just Me | last post by:

Does Me.Cursor.Current=Cursors.WaitCursor set the current property of Me.Cursor to Cursors.WaitCursor And Me.Cursor.Current=Cursors.Default set the Me.Current property to something (default) stored in Me.Cursor. Or is Cursors.Default some process wide cursor shape? What is a correct statement?

Visual Basic .NET

1556

Need help understanding the Cursor

by: Alex | last post by:

In the code below, clicking on the button ButtonChangeCursor changes the form's cursor to a WaitCursor. Clicking the button ButtonRestoreCursor changes the form's cursor back to its original cursor. For the reasons I explain below I wouldn't expect this code to behave as it does, so why does it work? Public Class Form1 Dim OldCursor As Cursor Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As

Visual Basic .NET

9059

Problems Changing Mouse Cursor Type

by: Jim Frazer | last post by:

Hi, I'm working on an application in C# that will allow the user to create simple CAD drawings on a CEPC system. I would like to be able to change the cursor shape depending on the drawing mode selected by the user. I started out by setting up P/Invokes for LoadCursor and SetCursor. Calling LoadCursor followed by SetCursor does allow me to change to a different cursor, such as the cross cursor, but as soon as the application leaves...

C# / C Sharp

6188

Confused obout setting a Cursor

by: Academic | last post by:

What are the different effects of the following two statements: C1.Cursor = Cursors.WaitCursor C1.Cursor.Current = Cursors.WaitCursor I believe the first replaces the entire C1.Cursor object with a new one while the second only replaces the Current object of C1.Cursor, but I can't

C# / C Sharp

18043

Oracle REF CURSOR - 3

by: debasisdas | last post by:

RESTRICTIONS ON CURSOR VARIABLES ================================= Currently, cursor variables are subject to the following restrictions: Cannot declare cursor variables in a package spec. CREATE PACKAGE emp_stuff AS TYPE EmpCurTyp IS REF CURSOR RETURN emp%ROWTYPE; emp_cv EmpCurTyp; -- not allowed END emp_stuff;

Oracle Database

6979

Track Mouse Movement when the cursor is off screen?

by: mike | last post by:

I have the opportunity to rescue a project that uses a mouse to sense the relative position of a machine. The hardware is built...just needs to be programmed. Stop snickering!!! I didn't do it...I just gotta fix it. I need to make some calculations on the measurements and VB6 is my language. Yes, the system mouse will corrupt the measurement, but it's an auditing function and that's acceptable.

Visual Basic 4 / 5 / 6

9706

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...

General

10569

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...

C / C++

10325

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...

Online Marketing

10315

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...

Windows Server

6847

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...

C# / C Sharp

5651

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

4295

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

C# / C Sharp

3815

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

2990

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

General