In the PostgreSQL 1.6->1.8 Upgrade SQL, this statement is incorrect:

CREATE TABLE sysmaps_tmp
(
sysmapid bigint NOT NULL DEFAULT 0,
name varchar(128) NOT NULL DEFAULT '',
width integer NOT NULL DEFAULT 0,
height integer NOT NULL DEFAULT 0,
backgroundid bigint NOT NULL DEFAULT 0,
label_type integer NOT NULL DEFAULT 0,
label_location integer NOT NULL DEFAULT 0,
highlight integer NOT NULL DEFAULT 1
)
WITH (
OIDS=TRUE
);

Here's the correct statement:

CREATE TABLE sysmaps_tmp
(
sysmapid bigint NOT NULL DEFAULT 0,
name varchar(128) NOT NULL DEFAULT '',
width integer NOT NULL DEFAULT 0,
height integer NOT NULL DEFAULT 0,
backgroundid bigint NOT NULL DEFAULT 0,
label_type integer NOT NULL DEFAULT 0,
label_location integer NOT NULL DEFAULT 0,
highlight integer NOT NULL DEFAULT 1
)
WITH OIDS=TRUE;

Strangely, all other statements are written correctly. The bug leaves you with a complete loss of all system maps (because the sysmaps table is dropped after this statement).