| From: | Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com> |
|---|---|
| To: | Frank Joerdens <frank(at)joerdens(dot)de> |
| Cc: | chris markiewicz <cmarkiew(at)commnav(dot)com>, "'PostgreSQL-general'" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: RE: finding and removing a constraint... |
| Date: | 2001-03-20 22:18:23 |
| Message-ID: | Pine.BSF.4.21.0103201415400.30805-100000@megazone23.bigpanda.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-announce pgsql-general |
> The problem is that the syntax
>
> create table SomeTable (
> SomeColumn int4 references OtherTable ( SomeColumn ),
> . . .
>
> creates an <unnamed> trigger which you can't drop with drop trigger
> because it doesn't have a name. What you suggest does work for me, i.e.
> deleting from pg_trigger and then adjusting the trigger count in
> pg_class but it is quite cumbersome.
You should be able to, you just have to use the *real* trigger name (first
column in pg_trigger, will look like RI_ConstraintTrigger_<oid> or
something like that) and make sure to "" it because it's a quoted mixed
case name.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Frank Joerdens | 2001-03-20 23:03:49 | Re: RE: finding and removing a constraint... |
| Previous Message | Frank Joerdens | 2001-03-20 22:00:40 | Re: RE: finding and removing a constraint... |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Stephan Szabo | 2001-03-20 22:19:16 | Re: trigger inheritence? |
| Previous Message | uros | 2001-03-20 22:16:55 | Real 7.1 |