drop a constraint
От | ochapiteau |
---|---|
Тема | drop a constraint |
Дата | |
Msg-id | 01022317532300.03953@ochapiteau.dagon.pdt обсуждение исходный текст |
Ответы |
Re: drop a constraint
|
Список | pgsql-general |
Hello, I create my constraint like this : drop table table1; drop table table2; CREATE table table1 (id int4, id_dest int4); CREATE table table2 (id int4,id_dest int4); ALTER TABLE table1 add constraint table1_id_table2_id_dest foreign key(id_dest) references table2(id); drop view dev_ri; CREATE VIEW dev_ri AS SELECT t.oid as trigoid ,c.relname as trig_tbl ,t.tgname ,t.tgfoid -- ,f.proname as trigfunc -- ,t.tgenabled -- ,t.tgconstrname ,c2.relname as const_tbl -- ,t.tgdeferrable -- ,t.tginitdeferred ,t.tgargs FROM pg_trigger t, pg_class c, pg_class c2, pg_proc f WHERE t.tgrelid=c.oid AND t.tgconstrrelid=c2.oid AND tgfoid=f.oid AND tgname ~ '^RI_'; i list the trigger so generated : select * from dev_ri; trigoid | trig_tbl | tgname | tgfoid | const_tbl | tgargs ---------+----------+------------------------------+--------+-----------+---------------------------------------------------------------------------------- 1641628 | table1 | RI_ConstraintTrigger_1641627 | 1644 | table2 | table1_id_table2_id_dest\000table1\000table2\000UNSPECIFIED\000id_dest\000id\000 1641630 | table2 | RI_ConstraintTrigger_1641629 | 1654 | table1 | table1_id_table2_id_dest\000table1\000table2\000UNSPECIFIED\000id_dest\000id\000 1641632 | table2 | RI_ConstraintTrigger_1641631 | 1655 | table1 | table1_id_table2_id_dest\000table1\000table2\000UNSPECIFIED\000id_dest\000id\000 And i try to drop any of this trigger generated : =# drop trigger RI_ConstraintTrigger_1641627 on table1; DropTrigger: there is no trigger ri_constrainttrigger_1641627 on relationtable1; any suggestion? do i badly name my trigger ? thanks,
В списке pgsql-general по дате отправления: