SQL error when creating a service

[marcial4]

Hi, we installed OTRS:ITSM 3.0.5 in a Debian Squeeze based server with PostgreSQL 9.1.2, when I do want to create a service in the ticket settings part of the admin config, I'm receiving the following error:

ERROR: column "type_id" of relation "service" does not existLINE 1: ..., create_time, create_by, change_time, change_by, type_id, c... ^, SQL: 'INSERT INTO service (name, valid_id, comments, create_time, create_by, change_time, change_by, type_id, criticality_id) VALUES (?, ?, ?, current_timestamp, ?, current_timestamp, ?, ?, ?)'

there's not other services created, we executed every script for postgres available in the otrs zip file for installation, what should I need to do to solve this problem?.

Thank you!.

[allissa]

it seems the column of type_id is missing, you can fix it or added in service table