Subject Re: [firebird-support] deadlock while dropping stored procedure
Author Svein Erling Tysvaer
Hi Thomas!

I think you also have a trigger on your table referencing your procedure
or something. Anyway, try to use ALTER PROCEDURE (and possibly ALTER
TRIGGER) to make it an empty procedure and then start deleting.


Thomas Besand wrote:
> Hi ng,
> using FB2 RC2, but I don't think my problem is specific to that version.
> In my DB I have a table HPQMAIN with some fields.
> There's also a stored procedure sp_findDups in the DB, that queries
> several fields in HPQMAIN and returns some result.
> Now I want to drop both table and procedure, when my client program
> requests it.
> Tried to 'DROP TABLE HPQMAIN;' but received dependency error regarding
> sp_findDups.
> Tried to 'DROP PROCEDURE "sp_findDups";' but received dependency error
> regarding HPQMAIN.
> Is there something like 'DROP DEPENDENCY <somedep>'?
> regards,
> Thomas Besand