Re: [INTERFACES] Re: DELETE FROM TABLE doesn't work (AGAIN) - Mailing list pgsql-hackers

From David Hartwig
Subject Re: [INTERFACES] Re: DELETE FROM TABLE doesn't work (AGAIN)
Date
Msg-id 35F3F415.2E7A09C@bellatlantic.net
Whole thread Raw
In response to Re: [INTERFACES] Re: DELETE FROM TABLE doesn't work (AGAIN)  ("Gerald Fischer" <pgsql@gefi.at>)
List pgsql-hackers
Gerald Fischer wrote:

> Hi Jose, hi Hackers!
>
> I reinstalled Postgresql with this patch about 10 times in the last 2 days, but without success. :-(
>
> I tried now to use the snapshot, and it compiled nearly without problems (in /src/interfaces/ecpg/preproc/preproc.y
isa ';' missing on line 1562), but the ODBC-Driver can't connect to the database. The logfile 
> says:
> ----------------
>

The snapshot is very unstable at this time.    6.4 will not be official until after Oct.1.   I would suggest not using
itat this time 

> ---------
> And with the snapshot of sept. 6th, it complains about a missing MSysConf-Table. :-(
> --------
> conn=71501948, query='declare SQL_CUR71516440 cursor for SELECT Config, nValue FROM MSysConf'
> ERROR from backend during send_query: 'ERROR:  msysconf: Table does not exist.'
> --------

This is a normal error.  MS Access always queries this table.  It is not necessary for successful processing.

>
>
> Please help, because I would need a running system tomorrow :-( (For the moment it will do it without delete, but not
forever). 
>

It is difficult for me to figure out  what your problem is.   What we need is a reproducible sequence of events leading
upto the crash. 

If you can reproduce the crash through the psql monitor, then we should work with that.   No sense in adding an extra
layerof complexity by working through the ODBC driver. 

The same goes for the junkfilter patch.   The errors as you describe, do not point to the junkfilter patch.
Admittedly,it is possible.   See if the problem can be reproduced without the junkfilter. 


pgsql-hackers by date:

Previous
From: Massimo Dal Zotto
Date:
Subject: Re: [HACKERS] Open portability issues
Next
From: Peter T Mount
Date:
Subject: Re: [HACKERS] my office cam