Re: [INTERFACES] Re: DELETE FROM TABLE doesn't work (AGAIN)

From: David Hartwig <daybee(at)bellatlantic(dot)net>
To: Gerald Fischer <pgsql(at)gefi(dot)at>
Cc: "pgsql-hackers(at)postgreSQL(dot)org" <pgsql-hackers(at)postgreSQL(dot)org>, "pgsql-interfaces(at)postgresql(dot)org" <pgsql-interfaces(at)postgreSQL(dot)org>, Sferacarta Software <sferac(at)bo(dot)nettuno(dot)it>
Subject: Re: [INTERFACES] Re: DELETE FROM TABLE doesn't work (AGAIN)
Date: 1998-09-07 14:56:21
Message-ID: 35F3F415.2E7A09C@bellatlantic.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-interfaces

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 is a ';' 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 it at 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 for ever).
>

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

If you can reproduce the crash through the psql monitor, then we should work with that. No sense in adding an extra layer of 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.

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Thomas G. Lockhart 1998-09-07 14:59:33 Re: [HACKERS] SIGSEGV in 'select * from pg_user'
Previous Message Tatsuo Ishii 1998-09-07 07:56:57 Re: [HACKERS] SIGSEGV in 'select * from pg_user'

Browse pgsql-interfaces by date

  From Date Subject
Next Message Sferacarta Software 1998-09-07 15:09:04 Re: DELETE FROM TABLE doesn't work (AGAIN)
Previous Message Aleksey V. Meledin 1998-09-07 14:51:46 Can you help me?