On Tue, 7 Dec 2004, cheng shan wrote: >In the first version, the function destroy_object_type( ) just drop the >table only. But when I find the triggers havn't >been actived yet, I add the delete setense. This time it becomes even >worse, the system throws error message.ERROR: could >not open relation with OID 1390714.
>To avoid the fatal error, I have no choice but to rollback the function >to the original version. >I have written a simplified test cast to verify the system, but it >performs as I expected and it's wrong. Once I remove the bare text from the test case, my 8.0b3 system seems to run the whole thing pasted in with no errors. What version are you trying it against? ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend