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.
Customer support service by UserEcho