Re: dropping foreign keys - Mailing list pgsql-general

From Joseph Shraibman
Subject Re: dropping foreign keys
Date
Msg-id 3C19A79F.7090907@selectacast.net
Whole thread Raw
In response to Re: dropping foreign keys  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
List pgsql-general
OK that worked. Thanks for your help.

Stephan Szabo wrote:

>>I tried both table names, and in both cases I got :
>>drop trigger RI_ConstraintTrigger_569229 on utable;
>>ERROR:  DropTrigger: there is no trigger ri_constrainttrigger_569229 on relation utable
>>
>
> You'll need to double quote the name because it's actually mixed case
> (note the case folded name in the error message)
>


--
Joseph Shraibman
jks@selectacast.net
Increase signal to noise ratio.  http://xis.xtenit.com


pgsql-general by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: dropping foreign keys
Next
From: Antonio Fiol Bonnín
Date:
Subject: Re: slow queries on large syslog table