ScotlandPHP 2019


Please answer this simple SPAM challenge: max(six, one)?
(Example: nine)

The Note You're Voting On

ynzhang from lakeheadu canada
9 years ago
It seems that using pg_pconnect() will not persist the temporary views/tables. So if you are trying to create temporary views/tables with the query results and then access them with the next script of the same session, you are out of luck. Those temporary view/tables are gone after each PHP script ended. One way to get around this problem is to create real view/table with session ID as part of the name and record the name&creation time in a common table. Have a garbage collection script to drop the view/table who's session is expired.

<< Back to user notes page

To Top