Using postgres. I see an error in mail.log from dbmail-smtp. I thought that the
word INTO was required for postgres INSERT? This query inserts a record ok if I
paste it manually and execute the query on postgres - only if I add the word
INTO after INSERT. Other details of my config at end.
Sep 18 22:44:12 crunch-a dbmail/smtp[590]: dbpgsql.c, db_query: Error executing
query [INSERT dbmail_messageblks (is_header,messageblk,blocksize, physmessage_id
) VALUES ('1','Return-Path: <[EMAIL PROTECTED]> Received: from web60108.mail.
yahoo.com (web60108.mail.yahoo.com [216.109.118.87]) ^Iby crunch-a.mailcruncher.
com (8.13.1/8.13.1/Debian-13) with SMTP id i8J2iBWL000587 ^Ifor <[EMAIL
PROTECTED]>; Sat, 18 Sep 2004 22:44:12 -0400 Message-ID:
<20040919024406.61221.qmai
[EMAIL PROTECTED]> Received: from [68.9.200.247] by web60108.mail.yahoo.
com via HTTP; Sat, 18 Sep 2004 19:44:06 PDT Date: Sat, 18 Sep 2004 19:44:06 -070
0 (PDT) From: April Lorenzen <[EMAIL PROTECTED]> Subject: test 20 To: [EMAIL
PROTECTED] MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii ',
'621', '329')] : [ERROR: syntax error at or near "dbmail_messageblks" at
character 8 ]
dbmail version is the debian one available today by apt-get install dbmail-pgsql
sendmail installed fresh today from apt-get install sendmail/testing which is
8.13
Used dbmail.m4 from here:
http://www.helgrim.com/dbmaildocs/files/dbmail.m4
Sendmail is working. Postgres is v 7.4.5 and is working. SELECT queries done by
dbmail-smtp are showing up successful such as finding aliases in the postgres
table etc.
Am I correct that INSERT INTO is the required syntax, if so, how can I cause
the word INTO to be added into these queries?
I saw some postings in the dbmail list archives where other people's queries
had the INTO in them.
Thank you,
- April
