Garfield Lewis <garfield.lewis@lzlabs.com> writes:
> I am trying to pass an array into a new function I am creating called lzxmlexists via the following statement:
> wdbs=# SELECT "XT"."ROWKEY" , "XT"."XMLT1C1" FROM "LZQAAS"."T642_XML_T1" "XT" WHERE "ROWKEY"=64201 AND lzxmlexists( '
$XTX//DeptName[. = $Dn ]', 'DEFAULT', ARRAY["XT"."XMLT1C1"] ) ORDER BY "ROWKEY";
> The column XT.XMLT1C1 exists because I can do a simple select to see the contents. The problem is that in the code
aboveI hit the following error at line 161.
> 160 for ( size_t ix = 0; ix < iXmlCount; ++ix ) {
> (gdb)
> 163 xmltype *pX = DatumGetXmlP( pXmlData[ix] );
> (gdb)
> Program received signal SIGSEGV, Segmentation fault.
> 0x00000000008b3514 in pg_detoast_datum ()
The most obvious theory is that there are some nulls in the XT.XMLT1C1
column. Since your code isn't bothering to check pXmlDataNulls[ix],
it would hit a null-pointer dereference when accessing pXmlData[ix].
regards, tom lane