in postgresql greater than 7.2, in order to be used as a foreign key, serial type must be classed as 'unique'. Hence in the avsap.sql file, wherever a table field is mentioned as 'serial' this must be changed to 'serial unique'
Log in to post a comment.