> Adding a cheque number primary key would work tho'
Depending on the specifics of the application, check number may not
be a 'unique' field. Automatic bank checks come to mind, on my
monthy statments they tend to always have the same check number or none
at all.
In this case I'd use a serial column.
The best long term solution, IMHO, would be to change postgres so that
it has a unique system column for each record, like Oracle does.
--
Mike Nolan