Comment 3 for bug 689757

Revision history for this message
Thomas Schweikle (tps) wrote :

INSERT INTO table [ ( column [, ...] ) ]
    { DEFAULT VALUES | VALUES ( { expression | DEFAULT } [, ...] ) [, ...] | query }
    [ RETURNING * | output_expression [ AS output_name ] [, ...] ]

has to correspond to
INSERT INTO `log` (logcode, timestamp, datestamp, source, program, message) VALUES ($1, $2, $3, $4, $5, $6)

and to
CREATE TABLE log
(
        logid int8 NOT NULL,
        "timestamp" int8 NOT NULL,
        datestamp varchar NOT NULL,
        source varchar NOT NULL,
        program varchar NOT NULL,
        message text NOT NULL,
        CONSTRAINT log_logid_pkey PRIMARY KEY (logid)
)

logcode should be logid