Received: from fw1b.telekom.de (gw1.telekom.de [194.25.15.11]) by hub.org (8.9.3/8.9.3) with SMTP id BAA66363 for ; Wed, 8 Sep 1999 01:50:58 -0400 (EDT) (envelope-from Michael.Rudolph@telekom.de) Received: by fw1b.telekom.de; (5.65v4.0/1.3/10May95) id AA27241; Wed, 8 Sep 1999 07:50:57 +0200 Received: from Q8P65.blf01.telekom.de by U8PW4.blf01.telekom.de with ESMTP for pgsql-sql@postgresql.org; Wed, 8 Sep 1999 07:51:42 +0200 Received: from u8p10.blf01.telekom.de by q8p65.blf01.telekom.de with ESMTP for pgsql-sql@postgresql.org; Wed, 8 Sep 1999 07:50:50 +0200 Received: by U8P10.blf01.telekom.de with Internet Mail Service (5.5.2448.0) id ; Wed, 8 Sep 1999 07:50:50 +0200 Message-Id: From: "Rudolph, Michael" To: "'pgsql-sql@postgresql.org'" Subject: Failed Regression Tests due to SQL-Errors Date: Wed, 8 Sep 1999 07:50:48 +0200 Mime-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2448.0) Content-Type: text/plain After compiling and installing postgreSQL 6.5.1 on my linux box (SuSE Linux 6.1, Pentium II), I tried the regression tests. More of the tests failed, than were ok and I checked the regression.diff - file to get more information. I realized, a lot of tests failed, when making for example an INSERT INTO CHAR_TBL (f1) VALUES (2); instead of INSERT INTO CHAR_TBL (f1) VALUES ('2'); (See the difference at the writing of the value 2, one time with and one without apostrophe) According to the SQL-command file it must be possible, to use both syntaxes, but why do I have the problems. The error code in the upper case is: "ERROR: fmgr_info: function text: not in internal table". If I do the same with a varchar, I even get the error message: "pqReadData() -- backend closed the channel unexpectedly. This probably means the backend terminated abnormally before or while processing the request. We have lost the connection to the backend, so further processing is impossible. Terminating." Can you help me? Thank you very much Michael