Re: RE: finding and removing a constraint... - Mailing list pgsql-general

From Stephan Szabo
Subject Re: RE: finding and removing a constraint...
Date
Msg-id Pine.BSF.4.21.0103201538090.31120-100000@megazone23.bigpanda.com
Whole thread Raw
In response to Re: RE: finding and removing a constraint...  (Frank Joerdens <frank@joerdens.de>)
List pgsql-general
On Wed, 21 Mar 2001, Frank Joerdens wrote:

> 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.

Yeah, it confused me at first.  If you don't quote it it'll try
lowercasing the entire name on you and then it won't match.



pgsql-general by date:

Previous
From: "Eric, Audet"
Date:
Subject: Hope it is not too offtopic
Next
From: KuroiNeko
Date:
Subject: Bitwise ops