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
--
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/689757
Title:
column "logcode" of relation "log" does not exist --- and other SQL errors
--
ubuntu-bugs mailing list
[email protected]
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
