Re: [SQL] dropping foreign key

2001-10-24 Thread Stephan Szabo
On Wed, 24 Oct 2001, Joseph Shraibman wrote: > Can I just set tgenabled to false? I'm not sure if it works now (in 7.2 devel) but I'm pretty sure that doesn't work in past versions unfortunately. ---(end of broadcast)--- TIP 5: Have you checked

Re: [SQL] dropping foreign key

2001-10-24 Thread Joseph Shraibman
Can I just set tgenabled to false? Stephan Szabo wrote: > 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 >>

Re: [SQL] dropping foreign key

2001-10-24 Thread Stephan Szabo
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

[SQL] dropping foreign key

2001-10-23 Thread Joseph Shraibman
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? -- Joseph Shraibman [EM