Hi,
I have a problem with triggers in postgresql 7.3.4 and PHP... I have a lot of insert to do from a table x to table y ( average of 10000 rows each time). I use a trigger AFTER INSERT but it seems that PHP wait for the result of the trigger to ending the script... Is it possible to avoid waiting for a return value and let the trigger do the job...????
It's not so much the trigger that's holding up your script, it's the fact that the query is executed synchronously. Although I've never done it before, you can send the query asynchronously using pg_send_query(). I'm not sure that the script will complete while there are still queries pending (otherwise in the case of persistent connections, I can see this depleting the pool of connections), but it's worth a shot. For more information:
http://www.php.net/manual/en/function.pg-send-query.php
Keep in mind however that you won't receive a success or failure when you do this.
Greg
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
