On Tue, 23 Oct 2001, Joseph Shraibman wrote:
> I have to drop a froeign key from one of my tables. The problem is that I have >another > table that has a foreign key on the first one, so I can't do the select to >temp-table > thing and move it back. > > Is there any way I can remove it by mucking with pg's internal tables? Yeah. All you should need to do is remove the three triggers that were created for the constraint (1 on the fk table, 2 on the pk table). You can find them in pg_trigger and you'll need to double quote the names for the drop trigger statements because they're mixed case. ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
