<!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 have committed a change which fixes this problem for me in both the "postgresql" mode and the "postgresql-socket" mode. I was using the clsql::query command when I should have used clsql::execute-command. The clsql::postgresql-socket code checked the return condition, but the "postgresql" code was too lenient, and allowed my mistake.<BR>
<BR>
Let us know if it works for you now.<BR>
<BR>
<BR>
On Mon, 2007-03-05 at 22:14 -0600, Robert L. Read wrote:<BR>
<BLOCKQUOTE TYPE=CITE>
<FONT COLOR="#000000">Dear Frank,</FONT><BR>
<FONT COLOR="#000000"> 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.</FONT><BR>
<BR>
<FONT COLOR="#000000"> 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.)</FONT><BR>
<BR>
<FONT COLOR="#000000"> 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.</FONT><BR>
<BR>
</BLOCKQUOTE>
<BR>
</BODY>
</HTML>