The generated SQL for PostgreSQL is the following:
CREATE TABLE latest_updates
(
keycolumn bigint NOT NULL,
updateColumn timestamp without time zone,
CONSTRAINT fkd3ddc51597a25df5 FOREIGN KEY (keycolumn)
REFERENCES main_table (id) MATCH SIMPLE
ON UPDATE NO ACTION ON DELETE NO ACTION
)
As you can see, no primary key and wrong cascade behaviour.
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
I also see another problem. Consider the following:
The generated SQL for PostgreSQL is the following:
CREATE TABLE latest_updates ( keycolumn bigint NOT NULL, updateColumn timestamp without time zone, CONSTRAINT fkd3ddc51597a25df5 FOREIGN KEY (keycolumn) REFERENCES main_table (id) MATCH SIMPLE ON UPDATE NO ACTION ON DELETE NO ACTION )As you can see, no primary key and wrong cascade behaviour.