Development Specifications

If the connection pool mechanism is used during application development, comply with the following specifications:

• If GUC parameters are set in the connection, you must run SET SESSION AUTHORIZATION DEFAULT; RESET ALL; to reset the connection state before returning it to the connection pool.
• If a temporary table is used, you must delete the temporary table before returning the connection to the connection pool.

Otherwise, the connections in the connection pool will remain stateful, potentially affecting the correctness of subsequent operations using the connection pool.