--_80659564-74d3-4fdf-b2db-f446f8773b68_ Content-Type: text/plain; charset="ks_c_5601-1987" Content-Transfer-Encoding: 8bit Hi there, I'm a developer who is working on PostgreSQL API and i got stuck in Terminating session. I'm working on PostgreSQL 8.3. Please, help if anyone has ideas on how to kill PostgreSQL session. i found this code in misc.c #ifdef NOT_USED /* Disabled in 8.0 due to reliability concerns; FIXME someday */ Datum pg_terminate_backend(PG_FUNCTION_ARGS) { PG_RETURN_INT32(pg_signal_backend(PG_GETARG_INT32(0), SIGTERM)); } #endif _________________________________________________________________ Discover the new Windows Vista http://search.msn.com/results.aspx?q=windows+vista&mkt=en-US&form=QBRE --_80659564-74d3-4fdf-b2db-f446f8773b68_ Content-Type: text/html; charset="ks_c_5601-1987" Content-Transfer-Encoding: 8bit <html> <head> <style> ..hmmessage P { margin:0px; padding:0px } body.hmmessage { FONT-SIZE: 10pt; FONT-FAMILY:Tahoma } </style> </head> <body class='hmmessage'> Hi there,<BR> <BR> I'm a developer who is working on PostgreSQL API and i got stuck in Terminating session.<BR> I'm working on PostgreSQL 8.3. <BR> <BR> Please, help if anyone has ideas on how to kill PostgreSQL session.<BR> <BR> i found this code in misc.c<BR> <BR> <P class=MsoNormal style="LAYOUT-GRID-MODE: char"><B><FONT face=Tahoma color=navy size=1><SPAN lang=EN-US style="FONT-WEIGHT: bold; FONT-SIZE: 9pt; COLOR: navy; FONT-FAMILY: Tahoma">#ifdef NOT_USED<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p></SPAN></FONT></B></P> <P class=MsoNormal style="LAYOUT-GRID-MODE: char"><B><FONT face=Tahoma color=navy size=1><SPAN lang=EN-US style="FONT-WEIGHT: bold; FONT-SIZE: 9pt; COLOR: navy; FONT-FAMILY: Tahoma"><o:p> </o:p></SPAN></FONT></B></P> <P class=MsoNormal style="LAYOUT-GRID-MODE: char"><B><FONT face=Tahoma color=navy size=1><SPAN lang=EN-US style="FONT-WEIGHT: bold; FONT-SIZE: 9pt; COLOR: navy; FONT-FAMILY: Tahoma">/* Disabled in 8.0 due to reliability concerns; FIXME someday */<o:p></o:p></SPAN></FONT></B></P> <P class=MsoNormal style="LAYOUT-GRID-MODE: char"><B><FONT face=Tahoma color=navy size=1><SPAN lang=EN-US style="FONT-WEIGHT: bold; FONT-SIZE: 9pt; COLOR: navy; FONT-FAMILY: Tahoma">Datum<o:p></o:p></SPAN></FONT></B></P> <P class=MsoNormal style="LAYOUT-GRID-MODE: char"><B><FONT face=Tahoma color=navy size=1><SPAN lang=EN-US style="FONT-WEIGHT: bold; FONT-SIZE: 9pt; COLOR: navy; FONT-FAMILY: Tahoma">pg_terminate_backend(PG_FUNCTION_ARGS)<o:p></o:p></SPAN></FONT></B></P> <P class=MsoNormal style="LAYOUT-GRID-MODE: char"><B><FONT face=Tahoma color=navy size=1><SPAN lang=EN-US style="FONT-WEIGHT: bold; FONT-SIZE: 9pt; COLOR: navy; FONT-FAMILY: Tahoma">{<o:p></o:p></SPAN></FONT></B></P> <P class=MsoNormal style="LAYOUT-GRID-MODE: char"><B><FONT face=Tahoma color=navy size=1><SPAN lang=EN-US style="FONT-WEIGHT: bold; FONT-SIZE: 9pt; COLOR: navy; FONT-FAMILY: Tahoma"> PG_RETURN_INT32(pg_signal_backend(PG_GETARG_INT32(0), SIGTERM));<o:p></o:p></SPAN></FONT></B></P> <P class=MsoNormal style="LAYOUT-GRID-MODE: char"><B><FONT face=Tahoma color=navy size=1><SPAN lang=EN-US style="FONT-WEIGHT: bold; FONT-SIZE: 9pt; COLOR: navy; FONT-FAMILY: Tahoma">}<o:p></o:p></SPAN></FONT></B></P> <DIV style="BORDER-RIGHT: medium none; PADDING-RIGHT: 0cm; BORDER-TOP: medium none; PADDING-LEFT: 0cm; PADDING-BOTTOM: 2pt; BORDER-LEFT: medium none; PADDING-TOP: 0cm; BORDER-BOTTOM: windowtext 1pt solid"> <P class=MsoNormal style="LAYOUT-GRID-MODE: char"><B><FONT face=Tahoma color=navy size=1><SPAN lang=EN-US style="FONT-WEIGHT: bold; FONT-SIZE: 9pt; COLOR: navy; FONT-FAMILY: Tahoma">#endif<o:p></o:p></SPAN></FONT></B></P></DIV> <BR><br /><hr />Discover the new Windows Vista <a href='http://search.msn.com/results.aspx?q=windows+vista&mkt=en-US&form=QBRE' target='_new'>Learn more!</a></body> </html> --_80659564-74d3-4fdf-b2db-f446f8773b68_--
