On 22/9/2006 2:14, "Bob Pawley" <[EMAIL PROTECTED]> wrote:

> I am seeking wording for a procedure that will initiate a trigger only after
> another trigger has completed its function. In this case I want to drop a
> table that is created and used by the first trigger.

Sounds like you should use a temporary table.

CREATE TEMP TABLE mytmptable (......

This table will just disappear shortly after your trigger is finished.

-- 

Shane Ambler
[EMAIL PROTECTED]

Get Sheeky @ http://Sheeky.Biz



---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

Reply via email to