Cannot add athletes to existing competition

[Chris]

This problem has been seen once when moving competition databases between vifferent versions of PostgreSQL (8/9/10).
A unique index sequence gets lost. TScore continues to work ok, until you try adding any more entrants to the database, when it just refuses.
If you check the TScoreX/TStemp folder, you’l see the TScore SQL error log in there has entries in complaining about ‘null value in column “id” violates not-null constraint”‘.

You need to use the PGAdmin tool to fix one at present – recreating the sequence item and the default value for the Entrants.ID column.
Full instructions are in this file:
https://tscore.co.uk/Downloads/UnableToAddEntrantsToDatabase.docx

[Author]

Posts