Drop constraint in PostgreSQL 7.1.2
Greetings,
How can I drop a referencial integrity constraint in 7.1.2 once there are no such thing before 7.2 release? Can I just execute DROP TRIGGERs to get constraints dropped?
Thanks in advance.
--------------------------------------------------------------------------------
José Vilson de Mello de Farias
Software Engineer
Dígitro Tecnologia Ltda - www.digitro.com.br
APC - Customer Oriented Applications
E-mail: vilson.farias@digitro.com.br
Tel.: +55 48 281 7158
ICQ 11866179
On Tue, 4 Feb 2003, Vilson farias wrote:
Ok, but I'm having some problems to identify wich triggers should be
destroyed. How can I remove those triggers? Can I just delete these records
from pg_trigger?
ALTER TABLE cham_atendimento
ADD CONSTRAINT RLoginXAtend FOREIGN KEY (pa, dt_login)
REFERENCES pa__login;bxs=# select * from pg_trigger where tgconstrname = 'rloginxatend';
- These three constraints are the ones you need
bxs=# drop trigger RI_ConstraintTrigger_20885 on cham_atendimento;
ERROR: DropTrigger: there is no trigger ri_constrainttrigger_20885 on
relation cham_atendimento
bxs=# drop trigger RI_ConstraintTrigger_20885 on pa__login;
ERROR: DropTrigger: there is no trigger ri_constrainttrigger_20885 on
relation pa__loginHow can I remove those triggers? Can I just delete these records from
You'll need to double quote the names because they're mixed case.
pg_trigger?
Not without also altering reltriggers on pg_class.
Import Notes
Reply to msg id not found: 009b01c2cc8a$e9be9650$98a0a8c0@dgtac | Resolved by subject fallback