Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Bellus
Starting Member
29 Posts |
 Posted - 2007-10-15 : 05:42:23
|
| I get this error when I try to references to the table meta_host_types: there is no unique constraint matching given keys for referenced table "meta_host_types"the table looks like this: Table "public.meta_host_types" Column | Type | Modifiers -------------+---------+--------------------------------------------------------------------- id | integer | not null default nextval('meta_types_application_id_seq'::regclass) application | integer | value | text | comments | text | types | text | Indexes: "meta_types_application_pkey" PRIMARY KEY, btree (id) "meta_host_types_id_key" UNIQUE, btree (id) "meta_host_types_value_key" UNIQUE, btree (value, application)Foreign-key constraints: "meta_types_application_application_fkey" FOREIGN KEY (application) REFERENCES appsmarteye(id)Whats the problem??Can someone please help!:) |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-10-15 : 05:46:58
|
| moved from article discussion._______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenpSSMS Add-in that does a few things: www.ssmstoolspack.com |
 |
|
|
|
|
|
problems with error statement