| From: | Frank Joerdens <frank(at)joerdens(dot)de> |
|---|---|
| To: | Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com> |
| Cc: | Frank Joerdens <frank(at)joerdens(dot)de>, 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 23:03:49 |
| Message-ID: | 20010321000349.A22401@rakete.joerdens.de |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-announce pgsql-general |
On Tue, Mar 20, 2001 at 02:18:23PM -0800, Stephan Szabo wrote:
>
> > 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.
Oh. That must've been the problem; I didn't know you had to quote it,
because
I did try using that name.
Cheers, Frank
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Stephan Szabo | 2001-03-20 23:38:50 | Re: RE: finding and removing a constraint... |
| Previous Message | Stephan Szabo | 2001-03-20 22:18:23 | Re: RE: finding and removing a constraint... |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | John Madden | 2001-03-20 23:08:12 | Re: Really Dumb Question...(Dumping db) |
| Previous Message | Joseph Koenig | 2001-03-20 22:20:39 | Re: Really Dumb Question...(Dumping db) |