Обсуждение: BUG #4794: server closed the connection unexpectedly
The following bug has been logged online: Bug reference: 4794 Logged by: Markus Meyer Email address: markus@7val.com PostgreSQL version: 8.3.3 Operating system: Debian 2.6.22.19-vs2.2.0.7 Description: server closed the connection unexpectedly Details: If i make an SELECT xmlconcat(('<datanode>' || NULL || '</datanode>')::xml); follows server closed the connection unexpectedly This probably means the server terminated abnormally before or while processing the request.
On Wed, May 6, 2009 at 11:05 AM, Markus Meyer <markus@7val.com> wrote: > If i make an > > SELECT xmlconcat(('<datanode>' || NULL || '</datanode>')::xml); > > follows > > server closed the connection unexpectedly > =A0 =A0 =A0 =A0This probably means the server terminated abnormally > =A0 =A0 =A0 =A0before or while processing the request. It's fixed in 8.3.7: wombat=3D> SELECT xmlconcat(('<datanode>' || NULL || '</datanode>')::xml); xmlconcat ----------- (1 ligne) (More exactly see the release nots of 8.3.6: "Fix crash of xmlconcat(NULL) (Peter)") Consider upgrading your installation to the latest minor release of 8.3. It's highly recommended. --=20 Guillaume
Markus Meyer wrote: > The following bug has been logged online: > > Bug reference: 4794 > Logged by: Markus Meyer > Email address: markus@7val.com > PostgreSQL version: 8.3.3 > Operating system: Debian 2.6.22.19-vs2.2.0.7 > Description: server closed the connection unexpectedly > Details: > > If i make an > > SELECT xmlconcat(('<datanode>' || NULL || '</datanode>')::xml); > > follows > > server closed the connection unexpectedly > This probably means the server terminated abnormally > before or while processing the request. > > seems to work fine on 8.3.7 that inner expression -is- a NULL, so xmlconcat(NULL) is itself a null. not much use.