Upgrading Postgres from 1.8 to 2.0 doesn't work

[Niteshade]

Hi there,

thought I was gonna updating my Zabbix server from 1.8.10 to 2.0...
I did it several times but I've never had to update my database before...

When I'm running the patch.sql from the /upgrades/dbpatches/2.0/postgresql,I'm getting constantly this error:

./patch.sql: Zeile 1: ALTER: Kommando nicht gefunden.
./patch.sql: Zeile 2: ALTER: Kommando nicht gefunden.
./patch.sql: Zeile 3: ALTER: Kommando nicht gefunden.
./patch.sql: Zeile 4: Syntaxfehler beim unerwarteten Wort `('
./patch.sql: Zeile 4: `DELETE FROM acknowledges WHERE NOT EXISTS (SELECT 1 FROM users WHERE users.userid=acknowledges.userid);'

I'm not really into PostgresQL to find out what's actually wrong.

Hope somebody can help me out.

------

Got it to work now!