PostgreSQL installation fails

I'm using a PostgreSQL database, and the CREATE TABLE statement does not work, most likely due to the KEY syntax.

Instead I used (simply removed two KEY statements):

CREATE TABLE weblinks
( nid int NOT NULL default '0',
tid int NOT NULL default '0',
vid int NOT NULL default '0',
url varchar(155) NOT NULL default '',
weight smallint NOT NULL default '0');

Which seems to work.