Thread: RESET CONNECTION behavior

RESET CONNECTION behavior

From
Bruce Momjian
Date:
Can we get a list features we want for RESET CONNECTION?  At this point,
I see ideas but no consistent approach.  Some say protocol only, others
say an SQL command is fine, but the protocol has to find out it happened
somehow.  Is that a plan?

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
359-1001+  If your life is a hard drive,     |  13 Roberts Road +  Christ can be your backup.        |  Newtown Square,
Pennsylvania19073
 


Re: RESET CONNECTION behavior

From
Bruce Momjian
Date:
Bruce Momjian wrote:
> Can we get a list features we want for RESET CONNECTION?  At this point,
> I see ideas but no consistent approach.  Some say protocol only, others
> say an SQL command is fine, but the protocol has to find out it happened
> somehow.  Is that a plan?

I have enhanced our TODO for this item:* Add RESET CONNECTION command to reset all session state  This would include
resettingof all variables (RESET ALL), dropping of  temporary tables, removing any NOTIFYs, cursors, open transactions,
prepared queries, currval()s, etc.  This could be used  for connection  pooling.  We could also change RESET ALL to
havethis functionality.  The difficult of this features is allowing RESET ALL to not affect  changes made by the
interfacedriver for its internal use.  One idea is  for this to be a protocol-only feature.  Another approach is to
notify the protocol when a RESET CONNECTION command is used.
 

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
359-1001+  If your life is a hard drive,     |  13 Roberts Road +  Christ can be your backup.        |  Newtown Square,
Pennsylvania19073