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]
