SQLTeam.com | Weblogs | Forums

PSQL 8.4 trigger to detect table deletion


#1

Hi all,

Appreciate if someone could assist me on the issue i have been having.

I was tasked in merging several data sources, after that i needed to automatize certain operations, for that i decided to use functions and respective triggers.

The input data is coming from a big data server and only let's me use select into, when this happens the destination table in psql that has the trigger is deleted and so the trigger.

What i need is a way to add the trigger after the new table is created in order for the trigger to work on the new input.

Best Regards,
Caeiro