Bryan Field-Elliot wrote:
Searching the archives,
it seems you once tried to find out how to "drop constraint trigger" on
PostgreSQL; did you ever figure it out? Thank
you,Bryan
I wrote the following function and installed it in my database.
I can then call it with a select (yuk) to drop a constraint trigger:
-- Drop all constraint triggers with a given constraint name
-- calling sequence: drop_contrig(constrname)
create function drop_contrig(text) returns text as '
set d(tgname) {}
spi_exec -array d "select c.relname,t.tgname
from pg_class c, pg_trigger t where c.oid = t.tgrelid and tgconstrname
= \'$1\'" {
spi_exec "drop trigger
\\"$d(tgname)\\" on $d(relname)"
}
if {$d(tgname) == {}} {return "No constraint
trigger $1 found"}
return "Drop trigger $d(tgname) on $d(relname)"
' LANGUAGE 'pltcl';
|
begin:vcard
n:Bateman;Kyle
x-mozilla-html:FALSE
org:Action Target Inc.
adr:;;;;;;
version:2.1
email;internet:[EMAIL PROTECTED]
title:President
x-mozilla-cpt:;0
fn:Kyle Bateman
end:vcard
