Ad Widget

Collapse

postgresql schema insert error

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • foundation
    Junior Member
    • Mar 2005
    • 6

    #1

    postgresql schema insert error

    Using postgresql 7.4 (as installed by fedora core 3)
    and zabbix 1.0 source tar

    when running the schema insert, I get an error trying to CREATE TABLE actions

    the comma following PRIMARY KEY (actionid) seems to be the culprit and when removed the schema runs problem free.

    The data insert has an error when inserting a row in to functions with itemid 17201. It violates the foreign key constraint. When looking in the items insert section the item that would be 17201 (just after 17200 and just before 17202) is actually item 17208
Working...