Strange reference problem

From: Michael Ansley <Michael(dot)Ansley(at)intec-telecom-systems(dot)com>
To: "'pgsql-general(at)postgresql(dot)org '" <pgsql-general(at)postgresql(dot)org>
Subject: Strange reference problem
Date: 2001-01-18 01:37:05
Message-ID: 7F124BC48D56D411812500D0B747251480F39B@FILESERVER002
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


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
**********************************************************************

Attachment Content-Type Size
test1 application/octet-stream 1.9 KB

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2001-01-18 02:20:47 Re: Strange reference problem
Previous Message Tom Lane 2001-01-18 01:16:55 Re: how to obtain latest beta release?