James Cloos wrote: > Package: libapache2-mod-log-sql > Version: 1.100-8 > Severity: normal > > The scoreboard patch hardcodes the query: > > insert ignore into %s (domain,vhost,month,year,count_impressions) values > ('%s','%s','%s','%s','0') > > but insert ignore is not portable and fails when using pgsql as the backend. > > It should instead use a transaction and rollback if the table does not exist.
Hi! The goal of making a INSERT IGNORE query is to create a record for the current month and year, plus the specified domain. As there is a UNIQUE KEY, there will be only ONE record, and the INSERT will fail if the record exists. The INSERT IGNORE make it works if there was a record already for the current month. As you seem to know about pgsql, do you know what I could do so it does the same as when using MySQL? Any help would be much appreciated. Thomas -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]