Foreign Key Problem
Teradata Teradata Discussion Forums Teradata.com Discussion Forum
Visit Teradata.com
Home       Guidelines    Member List
Welcome Guest ( Login | Register )
        


This online forum is for user-to-user discussions of Teradata products, and is not an official customer support channel for Teradata. If you require direct assistance, please contact Teradata support.


Foreign Key Problem Expand / Collapse
Author
Message
Posted 1/29/2008 8:48:30 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: Forum Members
Last Login: 1/30/2008 8:39:33 AM
Posts: 1, Visits: 4
I'm running an insert select into a new table with a foreign key check constraint and getting an error 3807 Object Spool 2 does not exist.
when I run the select part of the query it works fine.
when I take the foreign key off the table being inserted to it works fine.

I can't even run an explain on the insert query - which implies its not my data.

Has anyone come across this before or have any immediate ideas ?




Post #10433
Posted 4/5/2008 6:00:08 AM
Forum Member

Forum MemberForum MemberForum MemberForum MemberForum MemberForum MemberForum MemberForum Member

Group: Forum Members
Last Login: 7/3/2008 4:50:48 AM
Posts: 33, Visits: 186
Post your query dude. After seeing that, we can comment on that.

Regards:
Monika
Post #11153
« Prev Topic | Next Topic »


Reading This Topic Expand / Collapse
Active Users: 0 ( 0 guests, 0 members, 0 anonymous members )
No members currently viewing this topic.


All times are GMT -5:00, Time now is 10:17pm

Powered By InstantForum.NET v4.1.4 © 2008
Execution: 0.031. 10 queries. Compression Disabled.