That's perhaps the most confusing part. I'm assuming that the english version of what's happening here is something like: "insert this into referer_log if its not already there". I've tried cutting and pasting the the inserts and haven't had any problems (assuming that the "INSERT 0 0" that psql responds with is a-ok). The select statement in the "where 0 = select blah blah" is returning 1 so that the where clause fails.
Ultimately it seems I'm unable to reproduce the error on the command line.
Is there anything else I can do to troubleshoot this one? This is my first foray into the AOLServer/tcl/ACS/postgre world.
thanks for the help,
+jeff
