<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 TRANSITIONAL//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; CHARSET=UTF-8">
<META NAME="GENERATOR" CONTENT="GtkHTML/3.3.2">
</HEAD>
<BODY>
Dear Frank,<BR>
I just tried to get postgres-socket working. I had no problems at all---until I dropped my database and tried to recreate the tables via postgresql-socket, as you have done, and then I got the same error.<BR>
<BR>
Right at the moment, I can't conjecture if this is a but in CLSQL or in my usage of it. Apparently, you can work around this problem by opening the controller (which creates all the necessary tables) via the "postgresql" interface, and then using a postgresql-socket connection string. (I know that might not be acceptable, because one of the reasons one might use the socket interface is to avoid the need to use the Postgres libraries or to run on the same machine.)<BR>
<BR>
I will investigate a bit more and let you know if I can either fix the problem or work-around it in some other way.<BR>
<BR>
<BR>
On Mon, 2007-03-05 at 00:22 +0100, Frank Schorr wrote:
<BLOCKQUOTE TYPE=CITE>
<PRE>
<FONT COLOR="#000000">Ok, I tried the latest cvs on Windows.</FONT>
<FONT COLOR="#000000">This is BDB with ACL trial:</FONT>
<FONT COLOR="#000000">3 out of 125 total tests failed: ELE-TESTS::INDEXING-CLASS-OPT, ELE-TESTS::INDEXING-SLOT-MAKUNBOUND, ELE-TESTS::INDEXING-WIPE-INDEX.</FONT>
<FONT COLOR="#000000">This is BDB on LispWorks 5.0.1:</FONT>
<FONT COLOR="#000000">Exception C0000005 [flags 0] at 1541483 {inside foreign code}</FONT>
<FONT COLOR="#000000">eax 0 ebx 153FED0 ecx 7F edx 16</FONT>
<FONT COLOR="#000000">esp 153FEA8 ebp 153FEC0 esi 21C1E8E3 edi E8</FONT>
<FONT COLOR="#000000">when calling %db-env-create</FONT>
<FONT COLOR="#000000">Repairing this is far from what I can help with.</FONT>
<FONT COLOR="#000000">I tried the postgresql-socket version then.</FONT>
<FONT COLOR="#000000">This used to work with ACL and the last elephant version a while ago,</FONT>
<FONT COLOR="#000000">before I learned to make the dlls. </FONT>
<FONT COLOR="#000000">(asdf:operate 'asdf:load-op :elephant)</FONT>
<FONT COLOR="#000000">(asdf:operate 'asdf:load-op :ele-clsql)</FONT>
<FONT COLOR="#000000">(asdf:operate 'asdf:load-op :clsql-postgresql-socket)</FONT>
<FONT COLOR="#000000">(asdf:operate 'asdf:load-op :elephant-tests)</FONT>
<FONT COLOR="#000000">(do-backend-tests '(:clsql (:postgresql-socket "localhost" "clsql-tests" "postgres" "$postgres%")))</FONT>
<FONT COLOR="#000000">Warning: While accessing database #<POSTGRESQL-SOCKET-DATABASE localhost/clsql-tests/postgres OPEN @ #x2115e65a></FONT>
<FONT COLOR="#000000"> Warning: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "keyvalue_pkey" for table "keyvalue"</FONT>
<FONT COLOR="#000000"> has occurred.</FONT>
<FONT COLOR="#000000">Warning: POSTGRESQL-WARNING occurred on connection</FONT>
<FONT COLOR="#000000"> #S(POSTGRESQL-CONNECTION :HOST localhost</FONT>
<FONT COLOR="#000000"> :PORT 5432</FONT>
<FONT COLOR="#000000"> :DATABASE clsql-tests</FONT>
<FONT COLOR="#000000"> :USER postgres</FONT>
<FONT COLOR="#000000"> :PASSWORD $postgres%</FONT>
<FONT COLOR="#000000"> :OPTIONS</FONT>
<FONT COLOR="#000000"> :TTY</FONT>
<FONT COLOR="#000000"> :SOCKET #<MULTIVALENT stream socket connected from localhost/2413 to localhost/5432 @ #x2114e222></FONT>
<FONT COLOR="#000000"> :PID 3920</FONT>
<FONT COLOR="#000000"> :KEY 1974900746).</FONT>
<FONT COLOR="#000000"> Reason: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "keyvalue_pkey" for table "keyvalue"</FONT>
<FONT COLOR="#000000">Error: While accessing database #<POSTGRESQL-SOCKET-DATABASE localhost/clsql-tests/postgres OPEN @ #x2115e65a></FONT>
<FONT COLOR="#000000"> with expression "create table keyvalue (</FONT>
<FONT COLOR="#000000"> pk integer PRIMARY KEY DEFAULT nextval('serial'),</FONT>
<FONT COLOR="#000000"> clctn_id integer NOT NULL,</FONT>
<FONT COLOR="#000000"> key varchar NOT NULL,</FONT>
<FONT COLOR="#000000"> value varchar</FONT>
<FONT COLOR="#000000"> )":</FONT>
<FONT COLOR="#000000"> Error missing-result / Didn't receive result cursor for query.</FONT>
<FONT COLOR="#000000"> has occurred.</FONT>
<FONT COLOR="#000000">[condition type: SQL-DATABASE-DATA-ERROR]</FONT>
<FONT COLOR="#000000">Warning: While accessing database #<POSTGRESQL-SOCKET-DATABASE localhost/clsql-tests/postgres OPEN @ #x2115e65a></FONT>
<FONT COLOR="#000000"> Warning: WARNING: there is no transaction in progress</FONT>
<FONT COLOR="#000000"> has occurred.</FONT>
<FONT COLOR="#000000">Warning: POSTGRESQL-WARNING occurred on connection</FONT>
<FONT COLOR="#000000"> #S(POSTGRESQL-CONNECTION :HOST localhost</FONT>
<FONT COLOR="#000000"> :PORT 5432</FONT>
<FONT COLOR="#000000"> :DATABASE clsql-tests</FONT>
<FONT COLOR="#000000"> :USER postgres</FONT>
<FONT COLOR="#000000"> :PASSWORD $postgres%</FONT>
<FONT COLOR="#000000"> :OPTIONS</FONT>
<FONT COLOR="#000000"> :TTY</FONT>
<FONT COLOR="#000000"> :SOCKET #<MULTIVALENT stream socket connected from localhost/2416 to localhost/5432 @ #x2117923a></FONT>
<FONT COLOR="#000000"> :PID 3772</FONT>
<FONT COLOR="#000000"> :KEY 1674368639).</FONT>
<FONT COLOR="#000000"> Reason: WARNING: there is no transaction in progress</FONT>
<FONT COLOR="#000000">Do you think postgresql-socket should run and the error is with my new installation of postgres/cl-sql ?</FONT>
<FONT COLOR="#000000">It would be great if you made elephant available for Lispworks on windows.</FONT>
<FONT COLOR="#000000">Frank</FONT>
<FONT COLOR="#000000">_________________________________________________________________________</FONT>
<FONT COLOR="#000000">In 5 Schritten zur eigenen Homepage. Jetzt Domain sichern und gestalten! </FONT>
<FONT COLOR="#000000">Nur 3,99 EUR/Monat! <A HREF="http://www.maildomain.web.de/?mc=021114">http://www.maildomain.web.de/?mc=021114</A></FONT>
<FONT COLOR="#000000">_______________________________________________</FONT>
<FONT COLOR="#000000">elephant-devel site list</FONT>
<FONT COLOR="#000000"><A HREF="mailto:elephant-devel@common-lisp.net">elephant-devel@common-lisp.net</A></FONT>
<FONT COLOR="#000000"><A HREF="http://common-lisp.net/mailman/listinfo/elephant-devel">http://common-lisp.net/mailman/listinfo/elephant-devel</A></FONT>
</PRE>
</BLOCKQUOTE>
</BODY>
</HTML>