I have a web application on a Win box that accesses a Postgres DB on a *nix box using ODBC. I also have a trigger that fires every time I update,insert, or delete on a specific table. The trigger creates a temporary table and then drops it at the end. I can only update the table once before it complains "relation XXXXX not found." I've traced this back to not "committing" my transactions, but when I wrap my updates in "BEGIN;" and "COMMIT;" - it still doesn't work. I've tried using EMS PostgreSQL Manager, and even there if I do my own transaction, it fails, but if I use the "COMMIT" button, it works. Any ideas?
Red Flag Submitted
Thank you for helping keep Tek-Tips Forums free from inappropriate posts. The Tek-Tips staff will check this out and take appropriate action.
Reply To This Thread
Posting in the Tek-Tips forums is a member-only feature.