R: table_to_xml command isn"t working
am 28.11.2007 10:32:43 von Luigi PirilloThis is a multi-part message in MIME format.
------=_NextPart_000_000D_01C831AA.02C16810
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Here it is (see attached file).
Regards,
Luigi Pirillo
-----Messaggio originale-----
Da: pgsql-odbc-owner@postgresql.org [mailto:pgsql-odbc-owner@postgresql.org]
Per conto di Hiroshi Inoue
Inviato: mercoled=EC 28 novembre 2007 4.29
A: Luigi Pirillo
Cc: pgsql-odbc@postgresql.org
Oggetto: Re: [ODBC] table_to_xml command isn't working
Luigi Pirillo wrote:
> Hello,
>=20
>
>=20
> I have registered an odbc entry (named xfpdb) on my Windows XP Pro=20
> machine using PosgreSQL Ansi vers. 8.02.05 (my db server is 8.3 beta 1).
>=20
> Using a simple VB 6.0 code, I have tried to connect to it and return=20
> some XML information using ADO as in the following:
Could you send me directly the Mylog output ?
regards,
Hiroshi Inoue
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
------=_NextPart_000_000D_01C831AA.02C16810
Content-Type: application/octet-stream;
name="mylog_1260.log"
Content-Transfer-Encoding: quoted-printable
Content-Disposition: attachment;
filename="mylog_1260.log"
[5136-0.000]calling getDSNdefaults=0A=
[5136-0.001]CC_connect: entering...=0A=
[5136-0.001]sslmode=3Ddisable=0A=
[5136-0.001]original_CC_connect: entering...=0A=
[5136-0.002]Driver Version=3D'08.02.0500,200709120001' linking 1310 static =
Multithread library=0A=
[5136-0.003]original_CC_connect: DSN =3D 'xfpdb', server =3D 'localhost', p=
ort =3D '5432', database =3D 'xfpdb', username =3D 'postgres', password=3D'=
xxxxx'=0A=
[5136-0.004]connecting to the server socket...=0A=
[5136-0.015](0)(null) ERRNO=3D0=0A=
[5136-0.015]connection to the server socket succeeded.=0A=
[5136-0.016]sizeof startup packet =3D 78=0A=
[5136-0.016]sent the authentication block successfully.=0A=
[5136-0.017]gonna do authentication=0A=
[5136-0.017]read -1, global_socket_buffersize=3D4096=0A=
[5136-0.017]Lasterror=3D10035=0A=
[5136-0.071]read 13, global_socket_buffersize=3D4096=0A=
[5136-0.071]auth got 'R'=0A=
[5136-0.071]areq =3D 5 salt=3D5268dfc900=0A=
[5136-0.072]in AUTH_REQ_MD5=0A=
[5136-0.072]read -1, global_socket_buffersize=3D4096=0A=
[5136-0.072]Lasterror=3D10035=0A=
[5136-0.076]read 277, global_socket_buffersize=3D4096=0A=
[5136-0.076]auth got 'R'=0A=
[5136-0.076]areq =3D 0 salt=3D0000000000=0A=
[5136-0.076]auth got 'S'=0A=
[5136-0.076]auth got 'S'=0A=
[5136-0.077]auth got 'S'=0A=
[5136-0.077]auth got 'S'=0A=
[5136-0.077]auth got 'S'=0A=
[5136-0.077]auth got 'S'=0A=
[5136-0.077]Got the PostgreSQL version string: '8.3beta1'=0A=
[5136-0.077]Extracted PostgreSQL version number: '8.3'=0A=
[5136-0.078]auth got 'S'=0A=
[5136-0.078]auth got 'S'=0A=
[5136-0.078]auth got 'S'=0A=
[5136-0.078]auth got 'K'=0A=
[5136-0.078]auth got 'Z'=0A=
[5136-0.078]CC_send_settings: entering...=0A=
[5136-0.079]PGAPI_AllocStmt: entering...=0A=
[5136-0.079]**** PGAPI_AllocStmt: hdbc =3D 034C3FA8, stmt =3D 034C1FC0=0A=
[5136-0.079]CC_add_statement: self=3D034C3FA8, stmt=3D034C1FC0=0A=
[5136-0.080]PGAPI_FreeStmt: entering...hstmt=3D034C1FC0, fOption=3D1=0A=
[5136-0.080]QResult: enter DESTRUCTOR=0A=
[5136-0.080]SC_init_Result(34c1fc0)[5136-0.080]SC_Destructor : self=3D034C1F=
C0, self->result=3D00000000, self->hdbc=3D034C3FA8=0A=
[5136-0.081]APD_free_params: ENTER, self=3D034C20C0=0A=
[5136-0.081]IPD_free_params: ENTER, self=3D034C2100=0A=
[5136-0.082]PDATA_free_params: ENTER, self=3D034C2164=0A=
[5136-0.082]SC_Destructor: EXIT=0A=
[5136-0.082]CC_lookup_lo: entering...=0A=
[5136-0.082]CC_send_query: conn=3D034C3FA8, query=3D'select oid, typbasetyp=
e from pg_type where typname =3D 'lo''=0A=
[5136-0.083]send_query: done sending query 63bytes flushed=0A=
[5136-0.083]in QR_Constructor=0A=
[5136-0.083]exit QR_Constructor=0A=
[5136-0.084]read -1, global_socket_buffersize=3D4096=0A=
[5136-0.084]Lasterror=3D10035=0A=
[5136-0.086]read 77, global_socket_buffersize=3D4096=0A=
[5136-0.087]send_query: got id =3D 'T'=0A=
[5136-0.087]QR_fetch_tuples: cursor =3D '', self->cursor=3D00000000=0A=
[5136-0.087]num_fields =3D 2=0A=
[5136-0.087]READING ATTTYPMOD=0A=
[5136-0.087]CI_read_fields: fieldname=3D'oid', adtid=3D26, adtsize=3D4, att=
typmod=3D-1 (rel,att)=3D(1247,65534)=0A=
[5136-0.088]READING ATTTYPMOD=0A=
[5136-0.088]CI_read_fields: fieldname=3D'typbasetype', adtid=3D26, adtsize=
=3D4, atttypmod=3D-1 (rel,att)=3D(1247,22)=0A=
[5136-0.089]QR_fetch_tuples: past CI_read_fields: num_fields =3D 2=0A=
[5136-0.089]MALLOC: tuple_size =3D 100, size =3D 1600=0A=
[5136-0.089]QR_next_tuple: inTuples =3D true, falling through: fcount =3D 0=
, fetch_number =3D 0=0A=
[5136-0.090]end of tuple list -- setting inUse to false: this =3D 034C21E8 =
SELECT=0A=
[5136-0.090]_QR_next_tuple: 'C' fetch_total =3D 0 & this_fetch =3D 0=0A=
[5136-0.091]QR_next_tuple: backend_rows < CACHE_SIZE: brows =3D 0, cache_si=
ze =3D 0=0A=
[5136-0.091]QR_next_tuple: reached eof now=0A=
[5136-0.091]_QR_next_tuple: 'C': DONE (fcount == 0)=0A=
[5136-0.092]send_query: got id =3D 'Z'=0A=
[5136-0.092]QResult: enter DESTRUCTOR=0A=
[5136-0.092]QResult: in QR_close_result=0A=
[5136-0.092]QResult: free memory in, fcount=3D0=0A=
[5136-0.093]QResult: free memory out=0A=
[5136-0.093]QResult: enter DESTRUCTOR=0A=
[5136-0.093]QResult: exit close_result=0A=
[5136-0.093]QResult: exit DESTRUCTOR=0A=
[5136-0.094]Got the large object oid: -999=0A=
[5136-0.094]CC_lookup_characterset: entering...=0A=
[5136-0.094]conn->unicode=3D0=0A=
[5136-0.094]CC_connect: returning...=0A=
[5136-0.094]szConnStrOut =3D 'DSN=3Dxfpdb;DATABASE=3Dxfpdb;SERVER=3Dlocalho=
st;PORT=3D5432;UID=3Dpostgres;PWD=3Dxxxxxxxxx;SSLmode=3Ddisa ble;ReadOnly=3D=
0;Protocol=3D7.4-1;FakeOidIndex=3D0;ShowOidColumn=3D0;RowVer sioning=3D0;Sho=
wSystemTables=3D0;ConnSettings=3D;Fetch=3D100;Socket=3D4096; UnknownSizes=3D=
0;MaxVarcharSize=3D255;MaxLongVarcharSize=3D8190;Debug=3D1;C ommLog=3D0;Opti=
mizer=3D1;Ksqo=3D1;UseDeclareFetch=3D0;TextAsLongVarchar=3D1 ;UnknownsAsLong=
Varchar=3D0;BoolsAsChar=3D1;Parse=3D0;CancelAsFreeStmt=3D0;E xtraSysTablePre=
fixes=3Ddd_;;LFConversion=3D1;UpdatableCursors=3D1;DisallowP remature=3D0;Tr=
ueIsMinus1=3D0;BI=3D0;ByteaAsLongVarBinary=3D0;UseServerSide Prepare=3D0;Low=
erCaseIdentifier=3D0;XaOpt=3D1' len=3D597,1024=0A=
[5136-0.097]PGAPI_DriverConnect: returning 0=0A=
[5136-0.097][[SQLGetDiagRec]]=0A=
[5136-0.098]PGAPI_GetDiagRec entering type=3D2 rec=3D1=0A=
[5136-0.098]**** PGAPI_ConnectError: hdbc=3D034C3FA8 <0>=0A=
[5136-0.098]enter CC_get_error=0A=
[5136-0.098]enter CC_create_errormsg=0A=
[5136-0.098]msg =3D ''=0A=
[5136-0.099]exit CC_create_errormsg=0A=
[5136-0.099]exit CC_get_error=0A=
[5136-0.099]CC_Get_error returned nothing.=0A=
[5136-0.099]PGAPI_GetDiagRec exiting 100=0A=
[5136-0.099][SQLGetFunctions][5136-0.100][SQLGetInfo(30)][51 36-0.100]PGAPI_=
GetInfo: entering...fInfoType=3D23=0A=
[5136-0.100]PGAPI_GetInfo: p=3D'
[5136-0.100][SQLGetInfo(30)][5136-0.101]PGAPI_GetInfo: entering...fInfoType=
=3D24=0A=
[5136-0.101]PGAPI_GetInfo: p=3D'
[5136-0.101][SQLGetInfo(30)][5136-0.101]PGAPI_GetInfo: entering...fInfoType=
=3D79=0A=
[5136-0.102]PGAPI_GetInfo: p=3D'
[5136-0.102][SQLGetInfo(30)][5136-0.102]PGAPI_GetInfo: entering...fInfoType=
=3D83=0A=
[5136-0.102]PGAPI_GetInfo: p=3D'
[5136-0.103][SQLGetInfo(30)][5136-0.103]PGAPI_GetInfo: entering...fInfoType=
=3D78=0A=
[5136-0.103]PGAPI_GetInfo: p=3D'
[5136-0.104][SQLGetInfo(30)][5136-0.104]PGAPI_GetInfo: entering...fInfoType=
=3D81=0A=
[5136-0.104]PGAPI_GetInfo: p=3D'
[5136-0.104][SQLGetInfo(30)][5136-0.105]PGAPI_GetInfo: entering...fInfoType=
=3D72=0A=
[5136-0.105]PGAPI_GetInfo: p=3D'
[5136-0.105][SQLGetInfo(30)][5136-0.105]PGAPI_GetInfo: entering...fInfoType=
=3D82=0A=
[5136-0.106]PGAPI_GetInfo: p=3D'
[5136-0.106][SQLGetInfo(30)][5136-0.106]PGAPI_GetInfo: entering...fInfoType=
=3D44=0A=
[5136-0.106]PGAPI_GetInfo: p=3D'
[5136-0.107][SQLGetInfo(30)][5136-0.107]PGAPI_GetInfo: entering...fInfoType=
=3D43=0A=
[5136-0.107]PGAPI_GetInfo: p=3D'
[5136-0.108][SQLGetInfo(30)][5136-0.108]PGAPI_GetInfo: entering...fInfoType=
=3D144=0A=
[5136-0.108]CC_error_statements: self=3D034C3FA8=0A=
[5136-0.108]PGAPI_GetInfo30: p=3D'
[5136-0.109][SQLGetInfo(30)][5136-0.109]PGAPI_GetInfo: entering...fInfoType=
=3D150=0A=
[5136-0.109]CC_error_statements: self=3D034C3FA8=0A=
[5136-0.109]PGAPI_GetInfo30: p=3D'
=3D4=0A=
[5136-0.110][SQLGetInfo(30)][5136-0.110]PGAPI_GetInfo: entering...fInfoType=
=3D167=0A=
[5136-0.110]CC_error_statements: self=3D034C3FA8=0A=
[5136-0.110]PGAPI_GetInfo30: p=3D'
=3D4=0A=
[5136-0.111][SQLGetInfo(30)][5136-0.111]PGAPI_GetInfo: entering...fInfoType=
=3D146=0A=
[5136-0.111]CC_error_statements: self=3D034C3FA8=0A=
[5136-0.112]PGAPI_GetInfo30: p=3D'
[5136-0.112][SQLGetInfo(30)][5136-0.112]PGAPI_GetInfo: entering...fInfoType=
=3D151=0A=
[5136-0.112]CC_error_statements: self=3D034C3FA8=0A=
[5136-0.113]PGAPI_GetInfo30: p=3D'
=0A=
[5136-0.113][SQLGetInfo(30)][5136-0.113]PGAPI_GetInfo: entering...fInfoType=
=3D168=0A=
[5136-0.113]CC_error_statements: self=3D034C3FA8=0A=
[5136-0.114]PGAPI_GetInfo30: p=3D'
=0A=
[5136-0.114][SQLGetInfo(30)][5136-0.114]PGAPI_GetInfo: entering...fInfoType=
=3D111=0A=
[5136-0.115]PGAPI_GetInfo: p=3D'N', len=3D0, value=3D0, cbMax=3D512=0A=
[5136-0.115][SQLGetInfo(30)][5136-0.115]PGAPI_GetInfo: entering...fInfoType=
=3D16=0A=
[5136-0.115]PGAPI_GetInfo: p=3D'xfpdb', len=3D0, value=3D0, cbMax=3D0=0A=
[5136-0.116][SQLGetInfo(30)][5136-0.116]PGAPI_GetInfo: entering...fInfoType=
=3D23=0A=
[5136-0.116]PGAPI_GetInfo: p=3D'
[5136-0.117][SQLGetInfo(30)][5136-0.117]PGAPI_GetInfo: entering...fInfoType=
=3D24=0A=
[5136-0.117]PGAPI_GetInfo: p=3D'
[5136-0.117][SQLGetInfo(30)][5136-0.117]PGAPI_GetInfo: entering...fInfoType=
=3D46=0A=
[5136-0.118]PGAPI_GetInfo: p=3D'
[5136-0.118][[SQLSetConnectAttr]] 1=0A=
[5136-0.118]PGAPI_SetConnectAttr for 034C3FA8: 1 00000000=0A=
[5136-0.119]PGAPI_SetConnectOption: entering fOption =3D 1 vParam =3D 0=0A=
[5136-0.119]SetStmtOption(): SQL_MAX_ROWS, vParam =3D 0=0A=
[5136-0.119][[SQLSetConnectAttr]] 0=0A=
[5136-0.120]PGAPI_SetConnectAttr for 034C3FA8: 0 00000000=0A=
[5136-0.120]PGAPI_SetConnectOption: entering fOption =3D 0 vParam =3D 0=0A=
[5136-0.120]SetStmtOption: SQL_QUERY_TIMEOUT, vParam =3D 0=0A=
[5136-0.121][SQLGetInfo(30)][5136-0.121]PGAPI_GetInfo: entering...fInfoType=
=3D6=0A=
[5136-0.121]PGAPI_GetInfo: p=3D'PSQLODBC.DLL', len=3D0, value=3D0, cbMax=3D=
52=0A=
[5136-0.121][SQLGetInfo(30)][5136-0.122]PGAPI_GetInfo: entering...fInfoType=
=3D6=0A=
[5136-0.122]PGAPI_GetInfo: p=3D'PSQLODBC.DLL', len=3D0, value=3D0, cbMax=3D=
52=0A=
[5136-0.122][SQLGetInfo(30)][5136-0.122]PGAPI_GetInfo: entering...fInfoType=
=3D6=0A=
[5136-0.123]PGAPI_GetInfo: p=3D'PSQLODBC.DLL', len=3D0, value=3D0, cbMax=3D=
52=0A=
[5136-0.123][SQLGetInfo(30)][5136-0.123]PGAPI_GetInfo: entering...fInfoType=
=3D6=0A=
[5136-0.124]PGAPI_GetInfo: p=3D'PSQLODBC.DLL', len=3D0, value=3D0, cbMax=3D=
48=0A=
[5136-0.124][SQLGetInfo(30)][5136-0.124]PGAPI_GetInfo: entering...fInfoType=
=3D1=0A=
[5136-0.124]PGAPI_GetInfo: p=3D'
[5136-0.125][[SQLGetConnectAttr]] 109=0A=
[5136-0.125]PGAPI_GetConnectAttr 109=0A=
[5136-0.125]PGAPI_GetConnectOption: entering...=0A=
[5136-0.126][SQLGetInfo(30)][5136-0.126]PGAPI_GetInfo: entering...fInfoType=
=3D26=0A=
[5136-0.126]PGAPI_GetInfo: p=3D'
[5136-0.128][[SQLAllocHandle]][5136-0.128]PGAPI_AllocStmt: entering...=0A=
[5136-0.128]**** PGAPI_AllocStmt: hdbc =3D 034C3FA8, stmt =3D 034C1FC0=0A=
[5136-0.128]CC_add_statement: self=3D034C3FA8, stmt=3D034C1FC0=0A=
[5136-0.129][[SQLGetStmtAttr]] Handle=3D55320512 10010=0A=
[5136-0.129]PGAPI_GetStmtAttr Handle=3D034C1FC0 10010=0A=
[5136-0.129][[SQLGetStmtAttr]] Handle=3D55320512 10011=0A=
[5136-0.130]PGAPI_GetStmtAttr Handle=3D034C1FC0 10011=0A=
[5136-0.130][[SQLGetStmtAttr]] Handle=3D55320512 10012=0A=
[5136-0.130]PGAPI_GetStmtAttr Handle=3D034C1FC0 10012=0A=
[5136-0.131][[SQLGetStmtAttr]] Handle=3D55320512 10013=0A=
[5136-0.131]PGAPI_GetStmtAttr Handle=3D034C1FC0 10013=0A=
[5136-0.131][[SQLSetStmtAttr]] Handle=3D034C1FC0 18,10=0A=
[5136-0.131]PGAPI_SetStmtAttr Handle=3D034C1FC0 18,10(0000000A)=0A=
[5136-0.132][[SQLSetStmtAttr]] Handle=3D034C1FC0 18,0=0A=
[5136-0.132]PGAPI_SetStmtAttr Handle=3D034C1FC0 18,0(00000000)=0A=
[5136-0.133][[SQLSetStmtAttr]] Handle=3D034C1FC0 17,1306520=0A=
[5136-0.133]PGAPI_SetStmtAttr Handle=3D034C1FC0 17,1306520(0013EF98)=0A=
[5136-0.133][[SQLSetStmtAttr]] Handle=3D034C1FC0 17,0=0A=
[5136-0.134]PGAPI_SetStmtAttr Handle=3D034C1FC0 17,0(00000000)=0A=
[5136-0.134][[SQLSetDescField]] h=3D034C20A0 rec=3D1 field=3D1004 val=3D001=
3EF98=0A=
[5136-0.134]PGAPI_SetDescField h=3D034C20A0(10011) rec=3D1 field=3D1004 val=
=3D0013EF98,0=0A=
[5136-0.135]extend_parameter_bindings: entering ... self=3D034C20C0, parame=
ters_allocated=3D0, num_params=3D1,00000000=0A=
[5136-0.135]exit extend_parameter_bindings=3D034C25D8=0A=
[5136-0.136][[SQLSetDescField]] h=3D034C20A0 rec=3D1 field=3D1004 val=3D000=
00000=0A=
[5136-0.136]PGAPI_SetDescField h=3D034C20A0(10011) rec=3D1 field=3D1004 val=
=3D00000000,0=0A=
[5136-0.136][SQLGetInfo(30)][5136-0.136]PGAPI_GetInfo: entering...fInfoType=
=3D36=0A=
[5136-0.136]PGAPI_GetInfo: p=3D'Y', len=3D0, value=3D0, cbMax=3D4=0A=
[5136-0.136][[SQLGetStmtAttr]] Handle=3D55320512 6=0A=
[5136-0.137]PGAPI_GetStmtAttr Handle=3D034C1FC0 6=0A=
[5136-0.137]PGAPI_GetStmtOption: entering...=0A=
[5136-0.137]GetStmtOption(): SQL_CURSOR_TYPE 0=0A=
[5136-0.138][[SQLGetStmtAttr]] Handle=3D55320512 7=0A=
[5136-0.138]PGAPI_GetStmtAttr Handle=3D034C1FC0 7=0A=
[5136-0.138]PGAPI_GetStmtOption: entering...=0A=
[5136-0.138]GetStmtOption(): SQL_CONCURRENCY 1=0A=
[5136-0.139][[SQLGetConnectAttr]] 108=0A=
[5136-0.139]PGAPI_GetConnectAttr 108=0A=
[5136-0.139]PGAPI_GetConnectOption: entering...=0A=
[5136-0.139][[SQLSetStmtAttr]] Handle=3D034C1FC0 0,30=0A=
[5136-0.140]PGAPI_SetStmtAttr Handle=3D034C1FC0 0,30(0000001E)=0A=
[5136-0.140]PGAPI_SetStmtOption: entering...=0A=
[5136-0.140]SetStmtOption: SQL_QUERY_TIMEOUT, vParam =3D 30=0A=
[5136-0.140][[SQLSetStmtAttr]] Handle=3D034C1FC0 22,1=0A=
[5136-0.141]PGAPI_SetStmtAttr Handle=3D034C1FC0 22,1(00000001)=0A=
[5136-0.141][[SQLSetStmtAttr]] Handle=3D034C1FC0 21,0=0A=
[5136-0.141]PGAPI_SetStmtAttr Handle=3D034C1FC0 21,0(00000000)=0A=
[5136-0.142][SQLExecDirect][5136-0.142]PGAPI_ExecDirect: entering...1=0A=
[5136-0.142]SC_recycle_statement: self=3D 034C1FC0=0A=
[5136-0.142]**** PGAPI_ExecDirect: hstmt=3D034C1FC0, statement=3D'select * =
from table_to_xml('"Versions"', true, true, '')'=0A=
[5136-0.143]PGAPI_ExecDirect: calling PGAPI_Execute...=0A=
[5136-0.143]PGAPI_Execute: entering...1=0A=
[5136-0.144]PGAPI_Execute: clear errors...=0A=
[5136-0.144]PGAPI_NumParams: entering...=0A=
[5136-0.144]SC_scanQueryAndCountParams: entering...=0A=
[5136-0.144]prepareParameters 0 end=0A=
[5136-0.145]SC_recycle_statement: self=3D 034C1FC0=0A=
[5136-0.145]Exec_with_parameters_resolved: copying statement params: trans_=
status=3D1, len=3D56, stmt=3D'select * from table_to_xml('"Versions"', true=
, true, '')'=0A=
[5136-0.146] stmt_with_params =3D 'select * from table_to_xml('"Versions"=
', true, true, '')'=0A=
[5136-0.146]about to begin SC_execute=0A=
[5136-0.147] Sending SELECT statement on stmt=3D034C1FC0, cursor_name=
=3D'SQL_CUR034C1FC0' qflag=3D0,1=0A=
[5136-0.147]CC_send_query: conn=3D034C3FA8, query=3D'select * from table_to=
_xml('"Versions"', true, true, '')'=0A=
[5136-0.148]send_query: done sending query 62bytes flushed=0A=
[5136-0.148]in QR_Constructor=0A=
[5136-0.148]exit QR_Constructor=0A=
[5136-0.149]read -1, global_socket_buffersize=3D4096=0A=
[5136-0.149]Lasterror=3D10035=0A=
[5136-0.158]read 987, global_socket_buffersize=3D4096=0A=
[5136-0.158]send_query: got id =3D 'T'=0A=
[5136-0.159]QR_fetch_tuples: cursor =3D '', self->cursor=3D00000000=0A=
[5136-0.159]num_fields =3D 1=0A=
[5136-0.159]READING ATTTYPMOD=0A=
[5136-0.159]CI_read_fields: fieldname=3D'table_to_xml', adtid=3D142, adtsiz=
e=3D-1, atttypmod=3D-1 (rel,att)=3D(0,0)=0A=
[5136-0.160]QR_fetch_tuples: past CI_read_fields: num_fields =3D 1=0A=
[5136-0.160]MALLOC: tuple_size =3D 100, size =3D 800=0A=
[5136-0.161]QR_next_tuple: inTuples =3D true, falling through: fcount =3D 0=
, fetch_number =3D 0=0A=
[5136-0.161]qresult: len=3D920, buffer=3D'
=0A=
=0A=
=0A=
=0A=
=0A=
=0A=
=0A=
=0A=
=0A=
'=0A=
[5136-0.166]end of tuple list -- setting inUse to false: this =3D 034C21E8 =
SELECT=0A=
[5136-0.167]_QR_next_tuple: 'C' fetch_total =3D 1 & this_fetch =3D 1=0A=
[5136-0.167]QR_next_tuple: backend_rows < CACHE_SIZE: brows =3D 0, cache_si=
ze =3D 0=0A=
[5136-0.168]QR_next_tuple: reached eof now=0A=
[5136-0.168]send_query: got id =3D 'Z'=0A=
[5136-0.168] done sending the query:=0A=
[5136-0.168]extend_column_bindings: entering ... self=3D034C2048, bindings_=
allocated=3D0, num_columns=3D1=0A=
[5136-0.169]exit extend_column_bindings=3D034C25F8=0A=
[5136-0.169]SC_set_Result(34c1fc0, 34c21e8)[5136-0.170]QResult: enter DESTR=
UCTOR=0A=
[5136-0.170]retval=3D0=0A=
[5136-0.170]PGAPI_ExecDirect: returned 0 from PGAPI_Execute=0A=
[5136-0.170][[SQLGetDiagField]] Handle=3D(3,034C1FC0) Rec=3D0 Id=3D-1249 in=
fo=3D(0013ED34,4)=0A=
[5136-0.171]PGAPI_GetDiagField entering rec=3D0[5136-0.171]PGAPI_GetDiagFie=
ld exiting 0=0A=
[5136-0.171][SQLRowCount][5136-0.171]PGAPI_RowCount: entering...=0A=
[5136-0.172]RowCount=3D1=0A=
[5136-0.172][SQLNumResultCols][5136-0.172]PGAPI_NumResultCol s: entering...=
=0A=
[5136-0.172]SC_pre_execute: status =3D 3=0A=
[5136-0.172]PGAPI_NumResultCols: result =3D 034C21E8, status =3D 3, numcols=
=3D 1=0A=
[5136-0.173][SQLNumResultCols][5136-0.173]PGAPI_NumResultCol s: entering...=
=0A=
[5136-0.173]SC_pre_execute: status =3D 3=0A=
[5136-0.173]PGAPI_NumResultCols: result =3D 034C21E8, status =3D 3, numcols=
=3D 1=0A=
[5136-0.174][SQLDescribeCol][5136-0.174]PGAPI_DescribeCol: entering.1..=0A=
[5136-0.174]SC_pre_execute: status =3D 3=0A=
[5136-0.175]PGAPI_DescribeCol: result =3D 034C21E8, status =3D 3, numcols =
=3D 1=0A=
[5136-0.175]getCharColumnSize: type=3D142, col=3D0, unknown =3D 0=0A=
[5136-0.175]describeCol: col 0 fieldname =3D 'table_to_xml'=0A=
[5136-0.176]describeCol: col 0 fieldtype =3D 142=0A=
[5136-0.176]describeCol: col 0 column_size =3D 920=0A=
[5136-0.176]describeCol: col 0 *pfSqlType =3D 12=0A=
[5136-0.176]describeCol: col 0 *pcbColDef =3D 920=0A=
[5136-0.177]describeCol: col 0 *pibScale =3D 0=0A=
[5136-0.177]describeCol: col 0 *pfNullable =3D 1=0A=
[5136-0.177][[SQLColAttribute]][5136-0.177]PGAPI_ColAttribut es: entering..c=
ol=3D1 18 len=3D512.=0A=
[5136-0.261]SC_pre_execute: status =3D 3=0A=
[5136-0.261]PGAPI_ColAttributes: result =3D 034C21E8, status =3D 3, numcols=
=3D 1=0A=
[5136-0.261]colAttr: col 0 field_type=3D142 fi,ti=3D00000000,00000000=0A=
[5136-0.261]PGAPI_ColAttributes: COLUMN_NAME =3D 'table_to_xml'=0A=
[5136-0.261][[SQLColAttribute]][5136-0.261]PGAPI_ColAttribut es: entering..c=
ol=3D1 10 len=3D0.=0A=
[5136-0.262]SC_pre_execute: status =3D 3=0A=
[5136-0.262]PGAPI_ColAttributes: result =3D 034C21E8, status =3D 3, numcols=
=3D 1=0A=
[5136-0.262]colAttr: col 0 field_type=3D142 fi,ti=3D00000000,00000000=0A=
[5136-0.263]PGAPI_ColAttributes: UPDATEABLE =3D 0=0A=
[5136-0.263][[SQLGetStmtAttr]] Handle=3D55320512 6=0A=
[5136-0.263]PGAPI_GetStmtAttr Handle=3D034C1FC0 6=0A=
[5136-0.264]PGAPI_GetStmtOption: entering...=0A=
[5136-0.264]GetStmtOption(): SQL_CURSOR_TYPE 0=0A=
[5136-0.265][[SQLGetStmtAttr]] Handle=3D55320512 6=0A=
[5136-0.265]PGAPI_GetStmtAttr Handle=3D034C1FC0 6=0A=
[5136-0.265]PGAPI_GetStmtOption: entering...=0A=
[5136-0.266]GetStmtOption(): SQL_CURSOR_TYPE 0=0A=
[5136-0.266][[SQLSetStmtAttr]] Handle=3D034C1FC0 9,2=0A=
[5136-0.266]PGAPI_SetStmtAttr Handle=3D034C1FC0 9,2(00000002)=0A=
[5136-0.266]PGAPI_SetStmtOption: entering...=0A=
[5136-0.267]SetStmtOption(): SQL_ROWSET_SIZE, vParam =3D 2=0A=
[5136-0.267][[SQLGetStmtAttr]] Handle=3D55320512 9=0A=
[5136-0.267]PGAPI_GetStmtAttr Handle=3D034C1FC0 9=0A=
[5136-0.268]PGAPI_GetStmtOption: entering...=0A=
[5136-0.268][[SQLSetStmtAttr]] Handle=3D034C1FC0 5,1008=0A=
[5136-0.268]PGAPI_SetStmtAttr Handle=3D034C1FC0 5,1008(000003F0)=0A=
[5136-0.268]PGAPI_SetStmtOption: entering...=0A=
[5136-0.269][[SQLSetStmtAttr]] Handle=3D034C1FC0 23,1306828=0A=
[5136-0.269]PGAPI_SetStmtAttr Handle=3D034C1FC0 23,1306828(0013F0CC)=0A=
[5136-0.269][[SQLSetStmtAttr]] Handle=3D034C1FC0 23,0=0A=
[5136-0.270]PGAPI_SetStmtAttr Handle=3D034C1FC0 23,0(00000000)=0A=
[5136-0.270][[SQLSetStmtAttr]] Handle=3D034C1FC0 11,0=0A=
[5136-0.270]PGAPI_SetStmtAttr Handle=3D034C1FC0 11,0(00000000)=0A=
[5136-0.271]PGAPI_SetStmtOption: entering...=0A=
[5136-0.271]SetStmtOption(): SQL_RETRIEVE_DATA, vParam =3D 0=0A=
[5136-0.271][[SQLSetStmtAttr]] Handle=3D034C1FC0 11,1=0A=
[5136-0.272]PGAPI_SetStmtAttr Handle=3D034C1FC0 11,1(00000001)=0A=
[5136-0.272]PGAPI_SetStmtOption: entering...=0A=
[5136-0.272]SetStmtOption(): SQL_RETRIEVE_DATA, vParam =3D 1=0A=
[5136-0.273][[SQLSetStmtAttr]] Handle=3D034C1FC0 23,53981720=0A=
[5136-0.273]PGAPI_SetStmtAttr Handle=3D034C1FC0 23,53981720(0337B218)=0A=
[5136-0.273][SQLBindCol][5136-0.274]PGAPI_BindCol: entering...=0A=
[5136-0.274]**** PGAPI_BindCol: stmt =3D 034C1FC0, icol =3D 1=0A=
[5136-0.274]**** : fCType=3D1 rgb=3D00000050 valusMax=3D921 pcb=3D0000004C=
=0A=
[5136-0.274]extend_getdata_info: entering ... self=3D034C2124, gdata_alloca=
ted=3D0, num_columns=3D1=0A=
[5136-0.275]exit extend_gdata_info=3D034C8E78=0A=
[5136-0.275] bound buffer[0] =3D 00000050=0A=
[5136-0.275][[SQLSetStmtAttr]] Handle=3D034C1FC0 9,1=0A=
[5136-0.276]PGAPI_SetStmtAttr Handle=3D034C1FC0 9,1(00000001)=0A=
[5136-0.276]PGAPI_SetStmtOption: entering...=0A=
[5136-0.276]SetStmtOption(): SQL_ROWSET_SIZE, vParam =3D 1=0A=
[5136-0.277][SQLExtendedFetch][5136-0.277]PGAPI_ExtendedFetc h: stmt=3D034C1=
FC0 rowsetSize=3D1=0A=
[5136-0.277]SQL_FETCH_NEXT: num_tuples=3D1, currtuple=3D-1, rowst=3D-1=0A=
[5136-0.278]PGAPI_ExtendedFetch: new currTuple =3D -1=0A=
[5136-0.278]fetch_cursor=3D0, 034C21E8->total_read=3D1=0A=
[5136-0.278]**** SC_fetch: non-cursor_result=0A=
[5136-0.278]fetch: cols=3D1, lf=3D0, opts =3D 034C2048, opts->bindings =3D =
034C25F8, buffer[] =3D 00000050=0A=
[5136-0.279]type =3D 142=0A=
[5136-0.279]value =3D '
=0A=
=0A=
=0A=
=0A=
=0A=
=0A=
=0A=
=0A=
=0A=
'=0A=
[5136-0.284]copy_and_convert: field_type =3D 142, fctype =3D 1, value =3D '=
=0A=
=0A=
=0A=
=0A=
=0A=
=0A=
=0A=
=0A=
', cbValueMax=3D921=0A=
[5136-0.290]DEFAULT: len =3D 952, ptr =3D '
=0A=
=0A=
=0A=
=0A=
=0A=
=0A=
=0A=
=0A=
=0A=
'=0A=
[5136-0.296] SQL_C_CHAR, default: len =3D 952, cbValueMax =3D 921, rgbVa=
lueBindRow =3D '
=0A=
=0A=
=0A=
=0A=
=0A=
=0A=
=0A=
=0A=
[5136-0.302]STATEMENT WARNING: func=3DSC_fetch, desc=3D'', errnum=3D-2, err=
msg=3D'Fetched item was truncated.'=0A=
------=_NextPart_000_000D_01C831AA.02C16810
Content-Type: text/plain
Content-Disposition: inline
MIME-Version: 1.0
Content-Transfer-Encoding: quoted-printable
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
------=_NextPart_000_000D_01C831AA.02C16810--