From: Gerald Fischer <pgsql@gefi.at>
To: David Hartwig <daybee@bellatlantic.net>
Cc: pgsql-hackers@postgreSQL.org <pgsql-hackers@postgreSQL.org>
Cc: pgsql-interfaces@postgresql.org <pgsql-interfaces@postgreSQL.org>
Subject: Re: [INTERFACES] Re: DELETE FROM TABLE doesn't work (AGAIN)
Date: Tue, 08 Sep 1998 10:07:05 +0000
Message-ID: <199809080807.KAA07871@hp_server.gefi.home> (raw)
Hi David!
On Mon, 07 Sep 1998 17:48:52 -0400, David Hartwig wrote:
>> >> 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.
>>
>> 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 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.
>>
>> 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 use 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
I've got 3.5, as far as I remember (downloaded from MS some days ago).
>http://www.insightdist.com/psqlodbc This will not solve our current problem.
Thats right :-(
>> 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 (only with 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 the patch
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
I other words, I should try the snapshot every day or connect me to the cvs and hope for a working system... :-@
>> 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.
Maybe someone could send me his working binarys to determine if it is a compiler problem, or a 'distribution' problem. It might be an
old lib or something like this?!
>> PS: Sorry for my bad english...
>
>It way better that my second language.
Thanks.
Best regards,
Gerald Fischer
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: pgsql@gefi.at, daybee@bellatlantic.net, pgsql-hackers@postgreSQL.org
Subject: Re: [INTERFACES] Re: DELETE FROM TABLE doesn't work (AGAIN)
In-Reply-To: <199809080807.KAA07871@hp_server.gefi.home>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox