Primary key generation creates errors

I have two tables, both with a column named "id" that is a SERIAL and the primary key of each.

The SQL that is generated creates a constraint to declare the primary key:

CONSTRAINT id PRIMARY KEY (id)

Using the generated SQL, the first table is created successfully.

The second table fails with the following error:

   relation "id" already exists

The constraint name must be unique.

A better solution would be to suffix the primary key column with "PRIMARY KEY".

Alternatively, if you must create a constraint, prefix the name with the table name.