Strange reference problem

Hi, all

When I run this SQL script, I get this error at the end:

------------
ERROR:  UNIQUE constraint matching given keys for referenced table "swt" not found
------------

If you run the script, you will see that a unique constraint IS created on swt.  Am I missing a maturity constraint in the foreign key code?

Cheers...

MikeA

 

**********************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
Nick West - Global Infrastructure Manager.

This footnote also confirms that this email message has been swept by
MIMEsweeper for the presence of computer viruses.

www.mimesweeper.com
**********************************************************************