Re: dropping foreign keys

From: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
To: Joseph Shraibman <jks(at)selectacast(dot)net>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: dropping foreign keys
Date: 2001-12-14 06:35:00
Message-ID: 20011213223425.I8121-100000@megazone23.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Joseph Shraibman 2001-12-14 07:17:51 Re: dropping foreign keys
Previous Message Joseph Shraibman 2001-12-14 05:59:23 Re: dropping foreign keys