Re: libpqeasy cursor error after multiple calls

I am kind of stumped. Glad to see _someone_ is using libpgeasy. :-)

I would be glad to run tests here if you can shoot over the code.

> Hi all,
>
> I'm just wondering if this is an error on my part, or a bug. I have the
> same trouble with PG 7.1beta6 and PG7.1 snapshot (March 8th) on Solaris
> 8 INTEL, Solaris 8 SPARC and Linux Mandrake 7.2.
>
> When using the libpqeasy library in a C function, I have the following
> section of code :
>
> // Get the sequence number for the next directory entry (PostgreSQL
> commands)
> doquery("BEGIN WORK");
> doquery("DECLARE c_getdirid BINARY CURSOR FOR SELECT
> nextval('prescan_directories_idnum_seq'::text)");
> doquery("FETCH ALL IN c_getdirid");
> fetch(&enumdirstruc_p->presentdirid);
> doquery("CLOSE c_getdirid");
> doquery("COMMIT WORK");
>
> This is called once per entry in a filesystem (this is a filesystem
> scanning utility) but after about 1000 or so calls, it errors out and
> won't work again. I have to actually DROP the database and re-create it
> again before the code will work again at all. Just vacumming doesn't
> help, nor does just shutting down the database and starting it again
> (doing both and vacuum and restarting the database doesn't help either).
>
> The error message is :
>
> <list of files correctly inserted so far, then>
> /archive/install/kde/kdeadmin-2.1/ksysctrl/.cvsignore
> NOTICE: PerformPortalFetch: portal "c_getdirid" not found
> NOTICE: PerformPortalClose: portal "c_getdirid" not found
> Directory query failed, trying again...New directory idnum = -2147483648
> (This is my error message from the program)
> query error:
> failed request: insert into prescan_files(filename, dirent, ownername,
> owenerid, groupname, groupid, filesize, os, os_version, package_id)
> values ('/archive/install/kde/kdeadmin-2.1/add-on/.cvsignore',
> 2147483648, 'jclift', 100, 'staff', 10, 21, 1, '8 INTEL', 16777216)
> $
>
> I can include the database schema and complete source code if needed,
> but I'm just not sure where to start debugging... is it my app or is it
> PostgreSQL?
>
> Regards and best wishes,
>
> Justin Clift
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org
>

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026