postgreSQL 有什么办法让外键的约束效果暂时失效

asdf2110

如果有多个外键，你要搞清楚到底要查哪个外键
我举的例子就是有两个外键

1. create table t(a int primary key, b int, c int, d int);
   
2. create table t1(a int primary key, b int, c int, d int);
   
3. create table s(a1 int references t(a), a2 int references t1(a), a3 int);
   
4. 
   
5. postgres=# select conname from pg_constraint where contype = 'f' and conrelid = (select oid from pg_class where relname = 's');
   
6.   conname  
   
7. -----------
   
8. s_a1_fkey
   
9. s_a2_fkey
   
10. (2 rows)
    
11. 
    
12. postgres=# \d s
    
13.        Table "public.s"
    
14. Column |  Type   | Modifiers
    
15. --------+---------+-----------
    
16. a1     | integer |
    
17. a2     | integer |
    
18. a3     | integer |
    
19. Foreign-key constraints:
    
20.     "s_a1_fkey" FOREIGN KEY (a1) REFERENCES t(a)
    
21.     "s_a2_fkey" FOREIGN KEY (a2) REFERENCES t1(a)
    
22. 
    

复制代码

回复 10# stone531


   

stone531

谢谢
回复 11# asdf2110