Re: ODBC SQLSetPos Delete problem

Hi Dave,
Its been awhile since I did this testing (about a year) but the only crashes
I remember seeing, and the only ones in my notes, were involving writable
cursors to update/delete rows. When my writable cursor tests were disabled I
didn't see any crashes. Since writable cursors had to be supported I never
did much, if any, testing without the UpdatableCursors option. Since then,
I've been developing with libpq so I don't think I'll get the time to go
back and try this out. :-(

-- Janet


> -----Original Message-----
> From: Dave Page [mailto:dpage@vale-housing.co.uk]
> Sent: Wednesday, September 15, 2004 12:53 PM
> To: Janet Borschowa; pgsql-odbc@postgresql.org
> Cc: Lothar Behrens
> Subject: RE: [ODBC] ODBC SQLSetPos Delete problem
>
>
>
>
> > -----Original Message-----
> > From: pgsql-odbc-owner@postgresql.org
> > [mailto:pgsql-odbc-owner@postgresql.org] On Behalf Of Janet
> Borschowa
> > Sent: 15 September 2004 17:14
> > To: pgsql-odbc@postgresql.org
> > Cc: Lothar Behrens
> > Subject: Re: [ODBC] ODBC SQLSetPos Delete problem
> >
> > Hi,
> > I've used various versions of the PostgreSQL odbc driver on
> > Windows and Unix. I found that versions 7.2.1 to 7.2.2 will
> > not crash but will give an error when subsequently fetching a
> > row after having deleted a row even though the delete works
> > OK. With versions 7.2.3 to 7.3.3 the program will crash but
> > this is not consistent depending on the table involved and
> > what platform the driver is on.
> >
> > I think you're best bet is to either use a different version
> > of the driver although I don't know if this can work in your
> > app, or better yet, do what Philippe has suggested.
>
> Out of interest, does it still crash if you turn off the
> updateable cursors option?
>
> Regards, Dave.
>