Re: [BUGS] executing SELECT xmlelement(name foo); causes "server closed the connection unexpectedly" Error

Here is an update. the 8.3 version is now working after i reinstalled the OS. most probably the issue was due to corrupt libxml2. Thank you so much for all the help to get rid off the issue. Regards, Sushil Tom Lane wrote: > Peter Eisentraut <[EMAIL PROTECTED]> writes: > >

Re: [BUGS] executing SELECT xmlelement(name foo); causes "server closed the connection unexpectedly" Error

these RPMs on earlier system (where the select query works). the query still worked. Peter Eisentraut wrote: > Sushil wrote: >> *postgres: postgres testdb [local] SELECT: symbol lookup error: >> postgres: postgres testdb [local] SELECT: undefined symbol: >> xmlNewTextW

Re: [BUGS] executing SELECT xmlelement(name foo); causes "server closed the connection unexpectedly" Error

I tried installing following RPMs postgresql-8.3.5-1PGDG.rhel5.x86_64.rpm postgresql-libs-8.3.5-1PGDG.rhel5.x86_64.rpm postgresql-server-8.3.5-1PGDG.rhel5.x86_64.rpm still this issue is appearing. is there any thing i am missing? Please advise. Thanks, Peter Eisentraut wrote: > Sushil wr

[BUGS] executing SELECT xmlelement(name foo); causes "server closed the connection unexpectedly" Error

wrap limit is 2147484025, limited by database "template1" DEBUG: proc_exit(0) DEBUG: shmem_exit(0) DEBUG: exit(0) DEBUG: reaping dead processes LOG: autovacuum launcher started LOG: database system is ready to accept connections The server appeared as crashed and got restarte