I have some php scripts that make sql requests to a postgresql database. Some of the queries are timing out (despite increasing the efficiency of the query) but the script stalls since it's not getting any response it recognizes. Is there a way to get these php scripts to recognize when the database times out?
Currently, for the user in postgresql, the session_timeout variable is set to 30 seconds (however this could change anytime). pgAdmin III is able to detect when the timeout occurs but I can't find anything in the docs about how.