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)
)
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