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

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

From
"Gerald Fischer"
Date:
Hi David!

On Mon, 07 Sep 1998 10:56:21 -0400, David Hartwig wrote:

First of all I want to thank you for your mail.

>> 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 

Well, I gave it a try.

>> ---------
>> 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.

Typically M$ :-(

>>
>>
>> Please help, because I would need a running system tomorrow :-( (For the moment it will do it without delete, but
notfor ever). 
>>
>
>It is difficult for me to figure out  what your problem is.   What we need is a reproducible sequence of events
leadingup to the crash. 

Well, no problem :-) I can reproduce the crash. With or without the ODBC-Driver.

>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.

Ok, once again.

I've installed postgresql 6.3.2 with all patches from ftp.postgresql.org/pub/patches. It worked great, but I could not
usethe ODBC-Driver for stuff like order by and group by  
(this is the bug where the junkfilter is a workaround, i think).
Therefore I installed the junkfilter, compiled again, and now I was able to order/group over the ODBC-Driver.
At this time I was happy :-), but than I wanted to make a destroyuser and the backend crashed. I thought it was the
destroyuser-script,but then I tryed to make a simple  
'delete from test;' and this crashed the backend, too :-(.
A few minutes ago we found out that triggers wont work, too.
Ok, I hoped it was another patch that does not like the junkfilter and I tryed to recompile a completly new version
(onlywith the junkfilter applied). The same error occured.  
Therefore I started today to give the snapshot a try, but it will not work together with the ODBC-Driver :-(.

Here a capture of psql:
-----
test=> \d test

Table    = test
+----------------------------------+----------------------------------+-------+
|              Field               |              Type                | Length|
+----------------------------------+----------------------------------+-------+
| i                                | int4                             |     4 |
| j                                | int4                             |     4 |
+----------------------------------+----------------------------------+-------+
test=> select * from test;
  i|  j
---+---
100|100
(1 row)

test=> delete from test;
PQexec() -- Request was sent to backend, but backend closed the channel before r
esponding.
        This probably means the backend terminated abnormally before or while pr
ocessing the request.
test=>
test=> select * from test;
PQexec() -- There is no connection to the backend.
------

I hope you can help me, because the only thing I could try is to get another linux-distribution and try it with eg
redhat(at the moment I use SuSE). 

Best regards,
Gerald Fischer

PS: Sorry for my bad english...



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

From
David Hartwig
Date:

Gerald Fischer wrote:

> Hi David!
>
> On Mon, 07 Sep 1998 10:56:21 -0400, David Hartwig wrote:
>
> First of all I want to thank you for your mail.
>
> >> 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.yis 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
usingit at this time 
>
> Well, I gave it a try.
>
> >> ---------
> >> 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.
>
> Typically M$ :-(
>
> >>
> >>
> >> Please help, because I would need a running system tomorrow :-( (For the moment it will do it without delete, but
notfor ever). 
> >>
> >
> >It is difficult for me to figure out  what your problem is.   What we need is a reproducible sequence of events
leadingup to the crash. 
>
> Well, no problem :-) I can reproduce the crash. With or without the ODBC-Driver.
>
> >If you can reproduce the crash through the psql monitor, then we should work with that.   No sense in adding an
extralayer 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.
>
> Ok, once again.
>
> I've installed postgresql 6.3.2 with all patches from ftp.postgresql.org/pub/patches. It worked great, but I could
notuse the ODBC-Driver for stuff like order by and group by 
> (this is the bug where the junkfilter is a workaround, i think).

Correct.   You may want to make sure you have the latest Jet Engine from M$.     That are serious bugs in older
versions.  See our FAQ at 
http://www.insightdist.com/psqlodbc         This will not solve our current problem.

>
> Therefore I installed the junkfilter, compiled again, and now I was able to order/group over the ODBC-Driver.
> At this time I was happy :-), but than I wanted to make a destroyuser and the backend crashed. I thought it was the
destroyuser-script,but then I tryed to make a simple 
> 'delete from test;' and this crashed the backend, too :-(.
> A few minutes ago we found out that triggers wont work, too.
> Ok, I hoped it was another patch that does not like the junkfilter and I tryed to recompile a completly new version
(onlywith the junkfilter applied). The same error occured. 

Hmm...  Something is not right here.    I have not problem on either AIX or Caldera Linux and I know others are using
thepatch without any problems.    I doubt if I are going to be 
able to resolve this soon.  I am juggling too many things right now.    Our best bet may be to wait until 6.4


>
> Therefore I started today to give the snapshot a try, but it will not work together with the ODBC-Driver :-(.

> Here a capture of psql:
> -----
> test=> \d test
>
> Table    = test
> +----------------------------------+----------------------------------+-------+
> |              Field               |              Type                | Length|
> +----------------------------------+----------------------------------+-------+
> | i                                | int4                             |     4 |
> | j                                | int4                             |     4 |
> +----------------------------------+----------------------------------+-------+
> test=> select * from test;
>   i|  j
> ---+---
> 100|100
> (1 row)
>
> test=> delete from test;
> PQexec() -- Request was sent to backend, but backend closed the channel before r
> esponding.
>         This probably means the backend terminated abnormally before or while pr
> ocessing the request.
> test=>
> test=> select * from test;
> PQexec() -- There is no connection to the backend.
> ------
>
> I hope you can help me, because the only thing I could try is to get another linux-distribution and try it with eg
redhat(at the moment I use SuSE). 
>
>

I am not a Linux guru.  So I don't have a clue a to weather this is an issue.

>
>
> PS: Sorry for my bad english...

It way better that my second language.


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

From
Stephen Davies
Date:
daybee@bellatlantic.net said:
> Correct.   You may want to make sure you have the latest Jet Engine
> from M$.     That are serious bugs in older versions.   See our FAQ at
> http://www.insightdist.com/psqlodbc         This will not solve our
> current problem.

David,

Could you please post some more details on which is the latest version of Jet
and where it is hidden among all of the hype at www. microsoft.com.

Cheers and thanks,
Stephen.

========================================================================
Stephen Davies Consulting                                            scldad@sdc.com.au
Adelaide, South Australia.                                             Voice: 61-8-82728863
Computing & Network solutions.                                     Fax: 61-8-82741015



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

From
Sferacarta Software
Date:
Hello David,

lunedì, 7 settembre 98, you wrote:



DH> Gerald Fischer wrote:

>> Hi David!
>>
>> On Mon, 07 Sep 1998 10:56:21 -0400, David Hartwig wrote:
>>
>> First of all I want to thank you for your mail.
>>
>> >> 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.yis 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
usingit at this time 
>>
>> Well, I gave it a try.
>>
>> >> ---------
>> >> 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.
>>
>> Typically M$ :-(
>>
>> >>
>> >>
>> >> Please help, because I would need a running system tomorrow :-( (For the moment it will do it without delete, but
notfor ever). 
>> >>
>> >
>> >It is difficult for me to figure out  what your problem is.   What we need is a reproducible sequence of events
leadingup to the crash. 
>>
>> Well, no problem :-) I can reproduce the crash. With or without the ODBC-Driver.
>>
>> >If you can reproduce the crash through the psql monitor, then we should work with that.   No sense in adding an
extralayer 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.
>>
>> Ok, once again.
>>
>> I've installed postgresql 6.3.2 with all patches from ftp.postgresql.org/pub/patches. It worked great, but I could
notuse the ODBC-Driver for stuff like order by and group by 
>> (this is the bug where the junkfilter is a workaround, i think).

DH> Correct.   You may want to make sure you have the latest Jet Engine from M$.     That are serious bugs in older
versions.  See our FAQ at 
DH> http://www.insightdist.com/psqlodbc         This will not solve our current problem.

>>
>> Therefore I installed the junkfilter, compiled again, and now I was able to order/group over the ODBC-Driver.
>> At this time I was happy :-), but than I wanted to make a destroyuser and the backend crashed. I thought it was the
destroyuser-script,but then I tryed to make a simple 
>> 'delete from test;' and this crashed the backend, too :-(.
>> A few minutes ago we found out that triggers wont work, too.
>> Ok, I hoped it was another patch that does not like the junkfilter and I tryed to recompile a completly new version
(onlywith the junkfilter applied). The same error occured. 

DH> Hmm...  Something is not right here.    I have not problem on either AIX or Caldera Linux and I know others are
usingthe patch without any problems.    I doubt if I are going to be 
DH> able to resolve this soon.  I am juggling too many things right now.    Our best bet may be to wait until 6.4

>>
>> Therefore I started today to give the snapshot a try, but it will not work together with the ODBC-Driver :-(.

>> Here a capture of psql:
>> -----
>> test=> \d test
>>
>> Table    = test
>> +----------------------------------+----------------------------------+-------+
>> |              Field               |              Type                | Length|
>> +----------------------------------+----------------------------------+-------+
>> | i                                | int4                             |     4 |
>> | j                                | int4                             |     4 |
>> +----------------------------------+----------------------------------+-------+
>> test=> select * from test;
>>   i|  j
>> ---+---
>> 100|100
>> (1 row)
>>
>> test=> delete from test;
>> PQexec() -- Request was sent to backend, but backend closed the channel before r
>> esponding.
>>         This probably means the backend terminated abnormally before or while pr
>> ocessing the request.
>> test=>
>> test=> select * from test;
>> PQexec() -- There is no connection to the backend.
>> ------
>>
>> I hope you can help me, because the only thing I could try is to get
>> another linux-distribution and try it with eg redhat (at the moment I use SuSE).
>>

I'm using Debian distribution and I have exactly the same problem. The
first time, it was a couple of weeks ago, then I recompiled and
reinstalled PostgreSQL and I solved my problem for a few days, but
now I have this error again.
I can't surely connect this error with the junkfilter patch but I can't
discard this possibility because I'm been using v-6.3.2 from the beginning
of its delivery, with no problems except lately after I applied this patch.

Best regards,
  Jose'                           mailto:sferac@bo.nettuno.it



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

From
David Hartwig
Date:

Stephen Davies wrote:

> daybee@bellatlantic.net said:
> > Correct.   You may want to make sure you have the latest Jet Engine
> > from M$.     That are serious bugs in older versions.   See our FAQ at
> > http://www.insightdist.com/psqlodbc         This will not solve our
> > current problem.
>
> David,
>
> Could you please post some more details on which is the latest version of Jet
> and where it is hidden among all of the hype at www. microsoft.com.
>

The link is on the our FAQ.   M$ will first prompt you for some basic demographics tidbits.  Like:
"Do you have any pets?  If so, do they  enjoy M$ products as much as you do."

On the FAQ see:   3.  Why does MS Access sometimes complain about a GROUP BY or ORDER BY not being
in the target list?