Values in the select

am 22.12.2005 23:47:50 von a.j.langereis

This is a multi-part message in MIME format.

------=_NextPart_000_0011_01C60752.1E697BE0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Dear all,

I have written an application that uses Postgresql (8.1.0) trough an =
ODBC (ANSI) connection. I noticed that a query like "select 'bar' as =
foo" does not give the value "bar" in the column "foo". This works =
normally under PGadmin and even on other databases via ODBC. Am I =
overlooking something or might this be a bug?

Values that I do get are like "#0#0#0#0#0"

A piece of Delphi code to show the problem:

procedure show_problem(conn : TADOConnection)
var
qry : TAdoQuery;
datasource: TDataSource;
begin
qry :=3D TADOQuery.create(nil);
qry.Connection:=3Dconn;
qry.SQL.Text:=3D 'select ''bar'' as foo';
=20
qry.Open;

if not qry.eof then
begin
datasource :=3D TDataSource.Create(nil);
datasource.dataset :=3D qry;

//datasource.DataSet.Fields[1].AsString now has the value of =
'#0#0#0#0#0'
//datasource.DataSet.Fields[1].FieldName is now equal to 'foo'

datasource.free;
end;

qry.close;
qry.free;
end;

The version of ODBC that I've got installed is 08.00.0102 (via MSI =
installed).

Yours,

Aarjan
------=_NextPart_000_0011_01C60752.1E697BE0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

charset=3Diso-8859-1">

Dear all,

I have written an application that uses =
Postgresql=20
(8.1.0) trough an ODBC (ANSI) connection. size=3D2>I=20
noticed that a query like "select 'bar' as foo" does not give the value =
"bar" in=20
the column "foo". This works normally under PGadmin and even on other =
databases=20
via ODBC. Am I overlooking something or might this be a =
bug?

Values that I do get are like=20
"#0#0#0#0#0"

A piece of Delphi code to show the=20
problem:

procedure show_problem(conn :=20
TADOConnection)

var

qry : =
TAdoQuery;

datasource:=20
TDataSource;

begin

qry :=
TADOQuery.create(nil);

=20
qry.Connection:=3Dconn;

qry.SQL.Text:=3D =
' face=3DArial size=3D2>select ''bar'' as foo';

=
qry.Open;

if not qry.eof =
then

=20
begin

size=3D2> =20
datasource :=3D TDataSource.Create(nil);

=20
datasource.dataset :=3D qry;

=20
//datasource.DataSet.Fields[1].AsString now has the value=20
of '#0#0#0#0#0'

=20
//datasource.DataSet.Fields[1].FieldName is now equal to =
'foo'

size=3D2> =20
datasource.free;

=20
end;

=
qry.close;

=
qry.free;

end;

The version of ODBC that I've got =
installed is=20
08.00.0102 (via MSI installed).

Yours,

Aarjan

------=_NextPart_000_0011_01C60752.1E697BE0--

Re: Values in the select

am 23.12.2005 10:52:03 von Ludek Finstrle

> The version of ODBC that I've got installed is 08.00.0102 (via MSI installed).

Has Unicode version same problem? Could you try psqlodbc 08.01.0104?
Do you get same result?

If there is still the problem could you send here mylog output?

I can't see how you connect to pgsql (what options do you use?).

Regards,

Luf

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly

Re: Values in the select

am 23.12.2005 12:56:41 von a.j.langereis

Dear Luf,

The connectionstring that is used is the following:

Provider=MSDASQL.1;Password=;Persist Security Info=True;User
ID=intwis2;Data Source=PostgreSQL;Extended
Properties="DSN=PostgreSQL;DATABASE=intwis9;SERVER=localhost ;PORT=5432;SSLMO
DE=prefer;UID=intwis2;PWD=intwis2;ReadOnly=0;Protocol=6.4;Fa keOidIndex=0;Sho
wOidColumn=0;RowVersioning=0;ShowSystemTables=0;ConnSettings =;Fetch=100;Sock
et=8192;UnknownSizes=0;MaxVarcharSize=254;MaxLongVarcharSize =8190;Debug=0;Co
mmLog=0;Optimizer=1;Ksqo=1;UseDeclareFetch=0;TextAsLongVarch ar=1;UnknownsAsL
ongVarchar=0;BoolsAsChar=1;Parse=0;CancelAsFreeStmt=0;ExtraS ysTablePrefixes=
dd_;;LFConversion=1;UpdatableCursors=0;DisallowPremature=0;T rueIsMinus1=0;BI
=0;ByteaAsLongVarBinary=0;UseServerSidePrepare=0;LowerCaseId entifier=0"

The contents of psqlodbc_2972.log:

conn=120025968, PGAPI_DriverConnect(
in)='DSN=PostgreSQL;UID=intwis2;PWD=xxxxxxx;', fDriverCompletion=0
DSN info:
DSN='PostgreSQL',server='localhost',port='5432',dbase='intwi s9',user='intwis
2',passwd='xxxxx'

onlyread='0',protocol='6.4',showoid='0',fakeoidindex='0',sho wsystable='0'
conn_settings='',conn_encoding='OTHER'
translation_dll='',translation_option=''

And of mylog_2972.log

[144]globals.extra_systable_prefixes = 'dd_;'
[144][[SQLAllocHandle]][144]**** in PGAPI_AllocEnv **
[144]** exit PGAPI_AllocEnv: phenv = 120063888 **
[144][[SQLSetEnvAttr]] att=200,2
[144][[SQLAllocHandle]][144]PGAPI_AllocConnect: entering...
[144]**** PGAPI_AllocConnect: henv = 120063888, conn = 120025968
[144]EN_add_connection: self = 120063888, conn = 120025968
[144] added at i =0, conn->henv = 120063888, conns[i]->henv =
120063888
[144][SQLGetInfo(30)][144]PGAPI_GetInfo: entering...fInfoType=77
[144]PGAPI_GetInfo: p='03.00', len=5, value=0, cbMax=12
[144][[SQLSetConnectAttr]] 103
[144]PGAPI_SetConnectAttr 103
[144]PGAPI_SetConnectOption: entering fOption = 103 vParam = 15
[144][SQLDriverConnect][144]PGAPI_DriverConnect: entering...
[144]**** PGAPI_DriverConnect: fDriverCompletion=0,
connStrIn='DSN=PostgreSQL;UID=intwis2;PWD=xxxxxxx;'
[144]our_connect_string = 'DSN=PostgreSQL;UID=intwis2;PWD=xxxxxxx;'
[144]attribute = 'DSN', value = 'PostgreSQL'
[144]copyAttributes:
DSN='PostgreSQL',server='',dbase='',user='',passwd='xxxxx',p ort='',sslmode='
',onlyread='',protocol='',conn_settings='',disallow_prematur e=-1)
[144]attribute = 'UID', value = 'intwis2'
[144]copyAttributes:
DSN='PostgreSQL',server='',dbase='',user='intwis2',passwd='x xxxx',port='',ss
lmode='',onlyread='',protocol='',conn_settings='',disallow_p remature=-1)
[144]attribute = 'PWD', value = 'xxxxx'
[144]copyAttributes:
DSN='PostgreSQL',server='',dbase='',user='intwis2',passwd='x xxxx',port='',ss
lmode='',onlyread='',protocol='',conn_settings='',disallow_p remature=-1)
[144]globals.extra_systable_prefixes = 'dd_;'
[144]globals.extra_systable_prefixes = 'dd_;'
[144]our_connect_string = 'DSN=PostgreSQL;UID=intwis2;PWD=xxxxxxx;'
[144]attribute = 'DSN', value = 'PostgreSQL'
[144]CopyCommonAttributes:
A7=100;A8=8192;A9=0;B0=254;B1=8190;B2=0;B3=0;B4=1;B5=1;B6=0; B7=1;B8=0;B9=1;C
0=0;C1=0;C2=dd_;[144]attribute = 'UID', value = 'intwis2'
[144]CopyCommonAttributes:
A7=100;A8=8192;A9=0;B0=254;B1=8190;B2=0;B3=0;B4=1;B5=1;B6=0; B7=1;B8=0;B9=1;C
0=0;C1=0;C2=dd_;[144]attribute = 'PWD', value = 'xxxxx'
[144]CopyCommonAttributes:
A7=100;A8=8192;A9=0;B0=254;B1=8190;B2=0;B3=0;B4=1;B5=1;B6=0; B7=1;B8=0;B9=1;C
0=0;C1=0;C2=dd_;[144]PGAPI_Disconnect: about to CC_cleanup
[144]in CC_Cleanup, self=120025968
[144]after CC_abort
[144]entering PGCONN_Destructor
[144]exiting PGCONN_Destructor
[144]after LIBPQ destructor
[144]exit CC_Cleanup
[144]PGAPI_Disconnect: done CC_cleanup
[144]PGAPI_Disconnect: returning...
[144][[SQLFreeHandle]][144]PGAPI_FreeConnect: entering...
[144]**** in PGAPI_FreeConnect: hdbc=120025968
[144]enter CC_Destructor, self=120025968
[144]in CC_Cleanup, self=120025968
[144]after LIBPQ destructor
[144]exit CC_Cleanup
[144]after CC_Cleanup
[144]after free statement holders
[144]exit CC_Destructor
[144]PGAPI_FreeConnect: returning...
[144][[SQLFreeHandle]][144]**** in PGAPI_FreeEnv: env = 120063888 **
[144]in EN_Destructor, self=120063888
[144]exit EN_Destructor: rv = 1
[144] ok

Unfortunately I did not find version 08.01.0104 on the postgresql web site
(http://www.postgresql.org/ftp/odbc/versions/msi/), where can I find it?

I've tested it with the Unicode version and the same problem occours.

Yours,

Aarjan

----- Original Message -----
From: "Ludek Finstrle"
To: "A.j. Langereis"
Cc:
Sent: Friday, December 23, 2005 10:52 AM
Subject: Re: [ODBC] Values in the select

> > The version of ODBC that I've got installed is 08.00.0102 (via MSI
installed).
>
> Has Unicode version same problem? Could you try psqlodbc 08.01.0104?
> Do you get same result?
>
> If there is still the problem could you send here mylog output?
>
> I can't see how you connect to pgsql (what options do you use?).
>
> Regards,
>
> Luf
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly
>
>

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

Re: Values in the select

am 23.12.2005 13:12:23 von Ludek Finstrle

Hello,

> And of mylog_2972.log

Did you enable mylog output under both buttons (Global and DataSource)?
It seems to me you don't or you didn't send me right mylog.
This only connects and disconnects (like open DataSource options dialog).

Please, enable mylog output in both dialogs (under Global and DataSource
button). Delete all C:\mylog*.log after enabling mylog output.
Than run you example app. There may appear mylog_XXXX.log in C:\
There have to be SQLExecDirect or SQLExecute with your query in the
mylog output. It's unuseable mylog in other cases.

> Unfortunately I did not find version 08.01.0104 on the postgresql web site
> (http://www.postgresql.org/ftp/odbc/versions/msi/), where can I find it?

It's not official release. It is development snapshot. Main psqlodbc
site is hosted on pgfoundry.org (http://pgfoundry.org/projects/psqlodbc/).
Development snapshot contains only psqlodbc[aw].dll. So you have to
installed psqlodbc 8.01.0102 (latest official release) before.

It could be enough to try psqlodbc 8.01.0102. And please send me mylog
output from psqlodbc 8.01.0102 (not from 8.00.XXXX or even older).

> I've tested it with the Unicode version and the same problem occours.

Ok. It could speed up locating the problem.

Thanks,

Luf

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org

Re: Values in the select

am 23.12.2005 16:43:40 von a.j.langereis

This is a multi-part message in MIME format.

------=_NextPart_000_0014_01C607E0.0771E010
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

Dear Luf,

Attached is a file with both mylogs enabled.Note: I have put the log through
a parser because the lines were only delimeted with a #10 instead of both
#10 and #13

Do I only need to replace the .dll files in order to upgrade the odbc
driver?

Yours,

Aarjan

----- Original Message -----
From: "Ludek Finstrle"
To: "A.j. Langereis"
Cc:
Sent: Friday, December 23, 2005 1:12 PM
Subject: Re: [ODBC] Values in the select

> Hello,
>
> > And of mylog_2972.log
>
> Did you enable mylog output under both buttons (Global and DataSource)?
> It seems to me you don't or you didn't send me right mylog.
> This only connects and disconnects (like open DataSource options dialog).
>
> Please, enable mylog output in both dialogs (under Global and DataSource
> button). Delete all C:\mylog*.log after enabling mylog output.
> Than run you example app. There may appear mylog_XXXX.log in C:\
> There have to be SQLExecDirect or SQLExecute with your query in the
> mylog output. It's unuseable mylog in other cases.
>
> > Unfortunately I did not find version 08.01.0104 on the postgresql web
site
> > (http://www.postgresql.org/ftp/odbc/versions/msi/), where can I find it?
>
> It's not official release. It is development snapshot. Main psqlodbc
> site is hosted on pgfoundry.org (http://pgfoundry.org/projects/psqlodbc/).
> Development snapshot contains only psqlodbc[aw].dll. So you have to
> installed psqlodbc 8.01.0102 (latest official release) before.
>
> It could be enough to try psqlodbc 8.01.0102. And please send me mylog
> output from psqlodbc 8.01.0102 (not from 8.00.XXXX or even older).
>
> > I've tested it with the Unicode version and the same problem occours.
>
> Ok. It could speed up locating the problem.
>
> Thanks,
>
> Luf
>
>

------=_NextPart_000_0014_01C607E0.0771E010
Content-Type: application/octet-stream;
name="mylog_2697.log"
Content-Transfer-Encoding: quoted-printable
Content-Disposition: attachment;
filename="mylog_2697.log"

[3312]globals.extra_systable_prefixes =3D 'dd_;'=0A=
[3312][[SQLAllocHandle]][3312]**** in PGAPI_AllocEnv ** =
[3312]** exit PGAPI_AllocEnv: phenv =3D 120063888 **=0A=
[3312][[SQLSetEnvAttr]] att=3D200,2=0A=
[3312][[SQLAllocHandle]][3312]PGAPI_AllocConnect: entering...=0A=
[3312]**** PGAPI_AllocConnect: henv =3D 120063888, conn =3D 120025968=0A=
[3312]EN_add_connection: self =3D 120063888, conn =3D 120025968=0A=
[3312] added at i =3D0, conn->henv =3D 120063888, conns[i]->henv =3D =
120063888=0A=
[3312][SQLGetInfo(30)][3312]PGAPI_GetInfo: entering...fInfoType=3D77=0A=
[3312]PGAPI_GetInfo: p=3D'03.00', len=3D5, value=3D0, cbMax=3D12=0A=
[3312][[SQLSetConnectAttr]] 103=0A=
[3312]PGAPI_SetConnectAttr 103=0A=
[3312]PGAPI_SetConnectOption: entering fOption =3D 103 vParam =3D 15=0A=
[3312][SQLDriverConnect][3312]PGAPI_DriverConnect: entering...=0A=
[3312]**** PGAPI_DriverConnect: fDriverCompletion=3D0, connStrIn=3D'DSN=3DP=
ostgreSQL;UID=3Dintwis2;PWD=3Dxxxxxxx;'=0A=
[3312]our_connect_string =3D 'DSN=3DPostgreSQL;UID=3Dintwis2;PWD=3Dxxxxxxx;'=
=0A=
[3312]attribute =3D 'DSN', value =3D 'PostgreSQL'=0A=
[3312]copyAttributes: DSN=3D'PostgreSQL',server=3D'',dbase=3D'',user=3D'',p=
asswd=3D'xxxxx',port=3D'',sslmode=3D'',onlyread=3D'',protoco l=3D'',conn_set=
tings=3D'',disallow_premature=3D-1)=0A=
[3312]attribute =3D 'UID', value =3D 'intwis2'=0A=
[3312]copyAttributes: DSN=3D'PostgreSQL',server=3D'',dbase=3D'',user=3D'int=
wis2',passwd=3D'xxxxx',port=3D'',sslmode=3D'',onlyread=3D'', protocol=3D'',c=
onn_settings=3D'',disallow_premature=3D-1)=0A=
[3312]attribute =3D 'PWD', value =3D 'xxxxx'=0A=
[3312]copyAttributes: DSN=3D'PostgreSQL',server=3D'',dbase=3D'',user=3D'int=
wis2',passwd=3D'xxxxx',port=3D'',sslmode=3D'',onlyread=3D'', protocol=3D'',c=
onn_settings=3D'',disallow_premature=3D-1)=0A=
[3312]globals.extra_systable_prefixes =3D 'dd_;'=0A=
[3312]globals.extra_systable_prefixes =3D 'dd_;'=0A=
[3312]our_connect_string =3D 'DSN=3DPostgreSQL;UID=3Dintwis2;PWD=3Dxxxxxxx;'=
=0A=
[3312]attribute =3D 'DSN', value =3D 'PostgreSQL'=0A=
[3312]CopyCommonAttributes: A7=3D100;A8=3D8192;A9=3D0;B0=3D254;B1=3D8190;B2=
=3D1;B3=3D1;B4=3D1;B5=3D1;B6=3D0;B7=3D1;B8=3D0;B9=3D1;C0=3D0 ;C1=3D0;C2=3Ddd=
_;[3312]attribute =3D 'UID', value =3D 'intwis2'=0A=
[3312]CopyCommonAttributes: A7=3D100;A8=3D8192;A9=3D0;B0=3D254;B1=3D8190;B2=
=3D1;B3=3D1;B4=3D1;B5=3D1;B6=3D0;B7=3D1;B8=3D0;B9=3D1;C0=3D0 ;C1=3D0;C2=3Ddd=
_;[3312]attribute =3D 'PWD', value =3D 'xxxxx'=0A=
[3312]CopyCommonAttributes: A7=3D100;A8=3D8192;A9=3D0;B0=3D254;B1=3D8190;B2=
=3D1;B3=3D1;B4=3D1;B5=3D1;B6=3D0;B7=3D1;B8=3D0;B9=3D1;C0=3D0 ;C1=3D0;C2=3Ddd=
_;[3312]CC_connect: entering...=0A=
[3312]CC_connect(): DSN =3D 'PostgreSQL', server =3D 'localhost', port =3D =
'5432', sslmode =3D 'prefer', database =3D 'intwis9', username =3D 'intwis2=
', password=3D'xxxxx'=0A=
[3312]connecting to the server =
[3312]connecting to the database using localhost as the server=0A=
[3312]the size is 15 =
[3312]connection to the database succeeded.=0A=
[3312]connection to the database succeeded.=0A=
[3312]CC_lookup_pg_version: entering...=0A=
[3312]PGAPI_AllocStmt: entering...=0A=
[3312]SC_Constructor: entering ...=0A=
[3312]SC_Constructor: created stmt =3D 120063008=0A=
[3312]**** PGAPI_AllocStmt: hdbc =3D 120025968, stmt =3D 120063008=0A=
[3312]CC_add_statement: self=3D120025968, stmt=3D120063008=0A=
[3312]PGAPI_ExecDirect: entering...=0A=
[3312]recycle statement: self=3D 120063008=0A=
[3312]PDATA_free_params: ENTER, self=3D120063440=0A=
[3312]**** PGAPI_ExecDirect: hstmt=3D120063008, statement=3D'select version=
()'=0A=
[3312]PGAPI_ExecDirect: calling PGAPI_Execute...=0A=
[3312]PGAPI_Execute: entering...=0A=
[3312]PGAPI_Execute: clear errors...=0A=
[3312]recycle statement: self=3D 120063008=0A=
[3312]PDATA_free_params: ENTER, self=3D120063440=0A=
[3312]PGAPI_NumParams: entering...=0A=
[3312]Exec_with_parameters_resolved: copying statement params: trans_status=
=3D1, len=3D16, stmt=3D'select version()'=0A=
[3312] stmt_with_params =3D 'select version()'=0A=
[3312] Sending SELECT statement on stmt=3D120063008, cursor_name=3D'S=
QL_CUR07280420'=0A=
[3312]send_query(): conn=3D120025968, query=3D'select version()'=0A=
[3312]LIBPQ_execute_query: entering ...=0A=
[3312]in QR_Constructor=0A=
[3312]exit QR_Constructor=0A=
[3312]LIBPQ_execute_query: get next result with status =3D 2=0A=
[3312]LIBPQ_execute_query: query =3D select version()=0A=
[3312]LIBPQ_execute_query: recent_processed_row_count =3D 1=0A=
[3312]LIBPQ_execute_query: rest types ...=0A=
[3312]CC_mapping: entering ...=0A=
[3312]CC_mapping: rows =3D 1, columns =3D 1=0A=
[3312]CC_mapping: column =3D 0=0A=
[3312]CC_mapping: set field info: name =3D version, typ =3D 25, typlen =3D =
8190, attypmod =3D -1=0A=
[3312]in TL_Constructor=0A=
[3312]exit TL_Constructor=0A=
[3312]CC_mapping: fetch column =3D version, value =3D PostgreSQL 8.1.0 on i=
686-pc-mingw32, compiled by GCC gcc.exe (GCC) 3.4.2 (mingw-special)=0A=
[3312]send_query: done sending query with status: 2=0A=
[3312]QR_fetch_tuples: cursor =3D '', self->cursor=3D0=0A=
[3312]QR_fetch_tuples: past CI_read_fields: num_fields =3D 1=0A=
[3312]MALLOC: tuple_size =3D 100, size =3D 800=0A=
[3312] done sending the query:=0A=
[3312]extend_column_bindings: entering ... self=3D120063144, bindings_alloc=
ated=3D0, num_columns=3D1=0A=
[3312]exit extend_column_bindings=0A=
[3312]PGAPI_ExecDirect: returned 0 from PGAPI_Execute=0A=
[3312]PGAPI_Fetch: stmt =3D 120063008, stmt->result=3D 120062848=0A=
[3312]manual_result =3D 1, use_declarefetch =3D 0=0A=
[3312]**** SC_fetch: manual_result=0A=
[3312]extend_getdata_info: entering ... self=3D120063364, gdata_allocated=
=3D0, num_columns=3D1=0A=
[3312]exit extend_gdata_info=0A=
[3312]fetch: cols=3D1, lf=3D0, opts =3D 120063144, opts->bindings =3D 12006=
2496, buffer[] =3D 0=0A=
[3312]PGAPI_GetData: enter, stmt=3D120063008=0A=
[3312] value =3D 'PostgreSQL 8.1.0 on i686-pc-mingw32, compiled by GCC =
gcc.exe (GCC) 3.4.2 (mingw-special)'=0A=
[3312]**** PGAPI_GetData: icol =3D 0, fCType =3D 1, field_type =3D 25, valu=
e =3D 'PostgreSQL 8.1.0 on i686-pc-mingw32, compiled by GCC gcc.exe (GCC) 3=
..4.2 (mingw-special)'=0A=
[3312]copy_and_convert: field_type =3D 25, fctype =3D 1, value =3D 'Postgre=
SQL 8.1.0 on i686-pc-mingw32, compiled by GCC gcc.exe (GCC) 3.4.2 (mingw-sp=
ecial)', cbValueMax=3D128=0A=
[3312]DEFAULT: len =3D 88, ptr =3D 'PostgreSQL 8.1.0 on i686-pc-mingw32, co=
mpiled by GCC gcc.exe (GCC) 3.4.2 (mingw-special)'=0A=
[3312] SQL_C_CHAR, default: len =3D 88, cbValueMax =3D 128, rgbValueBind=
Row =3D 'PostgreSQL 8.1.0 on i686-pc-mingw32, compiled by GCC gcc.exe (GCC)=
3.4.2 (mingw-special)'=0A=
[3312]Got the PostgreSQL version string: 'PostgreSQL 8.1.0 on i686-pc-mingw=
32, compiled by GCC gcc.exe (GCC) 3.4.2 (mingw-special)'=0A=
[3312]Extracted PostgreSQL version number: '8.1'=0A=
[3312]PGAPI_FreeStmt: entering...hstmt=3D120063008, fOption=3D1=0A=
[3312]QResult: in DESTRUCTOR=0A=
[3312]TupleList: in DESTRUCTOR=0A=
[3312]TupleList: exit DESTRUCTOR=0A=
[3312]QResult: free memory in, fcount=3D101=0A=
[3312]QResult: free memory out=0A=
[3312]QResult: exit DESTRUCTOR=0A=
[3312]SC_Destructor: self=3D120063008, self->result=3D0, self->hdbc=3D12002=
5968=0A=
[3312]APD_free_params: ENTER, self=3D120063260=0A=
[3312]IPD_free_params: ENTER, self=3D120063324=0A=
[3312]PDATA_free_params: ENTER, self=3D120063440=0A=
[3312]ARDFields_free 72804a8 bookmark=3D72806a0[3312]ARD_unbind_cols freeal=
l=3D1 allocated=3D1 bindings=3D7280220=0A=
[3312]reset_a_column_binding: entering ... self=3D120063144, bindings_alloc=
ated=3D1, icol=3D1=0A=
[3312]APD_free_params: ENTER, self=3D120063260=0A=
[3312]IPD_free_params: ENTER, self=3D120063324=0A=
[3312]GDATA_unbind_cols freeall=3D1 allocated=3D1 gdata=3D7280200=0A=
[3312]SC_Destructor: EXIT=0A=
[3312]CC_send_settings: entering...=0A=
[3312]PGAPI_AllocStmt: entering...=0A=
[3312]SC_Constructor: entering ...=0A=
[3312]SC_Constructor: created stmt =3D 120063008=0A=
[3312]**** PGAPI_AllocStmt: hdbc =3D 120025968, stmt =3D 120063008=0A=
[3312]CC_add_statement: self=3D120025968, stmt=3D120063008=0A=
[3312]PGAPI_ExecDirect: entering...=0A=
[3312]recycle statement: self=3D 120063008=0A=
[3312]PDATA_free_params: ENTER, self=3D120063440=0A=
[3312]**** PGAPI_ExecDirect: hstmt=3D120063008, statement=3D'set DateStyle =
to 'ISO''=0A=
[3312]PGAPI_ExecDirect: calling PGAPI_Execute...=0A=
[3312]PGAPI_Execute: entering...=0A=
[3312]PGAPI_Execute: clear errors...=0A=
[3312]recycle statement: self=3D 120063008=0A=
[3312]PDATA_free_params: ENTER, self=3D120063440=0A=
[3312]PGAPI_NumParams: entering...=0A=
[3312]Exec_with_parameters_resolved: copying statement params: trans_status=
=3D1, len=3D22, stmt=3D'set DateStyle to 'ISO''=0A=
[3312] stmt_with_params =3D 'set DateStyle to 'ISO''=0A=
[3312] it's NOT a select statement: stmt=3D120063008=0A=
[3312]send_query(): conn=3D120025968, query=3D'set DateStyle to 'ISO''=0A=
[3312]LIBPQ_execute_query: entering ...=0A=
[3312]in QR_Constructor=0A=
[3312]exit QR_Constructor=0A=
[3312]LIBPQ_execute_query: get next result with status =3D 1=0A=
[3312]LIBPQ_execute_query: query =3D set DateStyle to 'ISO'=0A=
[3312]LIBPQ_execute_query: recent_processed_row_count =3D 0=0A=
[3312]The query was executed successfully and the query did not return any =
result =
[3312]send_query: done sending command=0A=
[3312]PGAPI_ExecDirect: returned 0 from PGAPI_Execute=0A=
[3312]CC_send_settings: result 0, status 1 from set DateStyle=0A=
[3312]PGAPI_ExecDirect: entering...=0A=
[3312]recycle statement: self=3D 120063008=0A=
[3312]QResult: in DESTRUCTOR=0A=
[3312]QResult: free memory in, fcount=3D0=0A=
[3312]QResult: free memory out=0A=
[3312]QResult: exit DESTRUCTOR=0A=
[3312]PDATA_free_params: ENTER, self=3D120063440=0A=
[3312]**** PGAPI_ExecDirect: hstmt=3D120063008, statement=3D'set geqo to 'O=
FF''=0A=
[3312]PGAPI_ExecDirect: calling PGAPI_Execute...=0A=
[3312]PGAPI_Execute: entering...=0A=
[3312]PGAPI_Execute: clear errors...=0A=
[3312]recycle statement: self=3D 120063008=0A=
[3312]PDATA_free_params: ENTER, self=3D120063440=0A=
[3312]PGAPI_NumParams: entering...=0A=
[3312]Exec_with_parameters_resolved: copying statement params: trans_status=
=3D1, len=3D17, stmt=3D'set geqo to 'OFF''=0A=
[3312] stmt_with_params =3D 'set geqo to 'OFF''=0A=
[3312] it's NOT a select statement: stmt=3D120063008=0A=
[3312]send_query(): conn=3D120025968, query=3D'set geqo to 'OFF''=0A=
[3312]LIBPQ_execute_query: entering ...=0A=
[3312]in QR_Constructor=0A=
[3312]exit QR_Constructor=0A=
[3312]LIBPQ_execute_query: get next result with status =3D 1=0A=
[3312]LIBPQ_execute_query: query =3D set geqo to 'OFF'=0A=
[3312]LIBPQ_execute_query: recent_processed_row_count =3D 0=0A=
[3312]The query was executed successfully and the query did not return any =
result =
[3312]send_query: done sending command=0A=
[3312]PGAPI_ExecDirect: returned 0 from PGAPI_Execute=0A=
[3312]CC_send_settings: result 0, status 1 from set geqo=0A=
[3312]PGAPI_ExecDirect: entering...=0A=
[3312]recycle statement: self=3D 120063008=0A=
[3312]QResult: in DESTRUCTOR=0A=
[3312]QResult: free memory in, fcount=3D0=0A=
[3312]QResult: free memory out=0A=
[3312]QResult: exit DESTRUCTOR=0A=
[3312]PDATA_free_params: ENTER, self=3D120063440=0A=
[3312]**** PGAPI_ExecDirect: hstmt=3D120063008, statement=3D'set extra_floa=
t_digits to 2'=0A=
[3312]PGAPI_ExecDirect: calling PGAPI_Execute...=0A=
[3312]PGAPI_Execute: entering...=0A=
[3312]PGAPI_Execute: clear errors...=0A=
[3312]recycle statement: self=3D 120063008=0A=
[3312]PDATA_free_params: ENTER, self=3D120063440=0A=
[3312]PGAPI_NumParams: entering...=0A=
[3312]Exec_with_parameters_resolved: copying statement params: trans_status=
=3D1, len=3D27, stmt=3D'set extra_float_digits to 2'=0A=
[3312] stmt_with_params =3D 'set extra_float_digits to 2'=0A=
[3312] it's NOT a select statement: stmt=3D120063008=0A=
[3312]send_query(): conn=3D120025968, query=3D'set extra_float_digits to 2'=
=0A=
[3312]LIBPQ_execute_query: entering ...=0A=
[3312]in QR_Constructor=0A=
[3312]exit QR_Constructor=0A=
[3312]LIBPQ_execute_query: get next result with status =3D 1=0A=
[3312]LIBPQ_execute_query: query =3D set extra_float_digits to 2=0A=
[3312]LIBPQ_execute_query: recent_processed_row_count =3D 0=0A=
[3312]The query was executed successfully and the query did not return any =
result =
[3312]send_query: done sending command=0A=
[3312]PGAPI_ExecDirect: returned 0 from PGAPI_Execute=0A=
[3312]CC_send_settings: result 0, status 1 from set extra_float_digits=0A=
[3312]PGAPI_FreeStmt: entering...hstmt=3D120063008, fOption=3D1=0A=
[3312]QResult: in DESTRUCTOR=0A=
[3312]QResult: free memory in, fcount=3D0=0A=
[3312]QResult: free memory out=0A=
[3312]QResult: exit DESTRUCTOR=0A=
[3312]SC_Destructor: self=3D120063008, self->result=3D0, self->hdbc=3D12002=
5968=0A=
[3312]APD_free_params: ENTER, self=3D120063260=0A=
[3312]IPD_free_params: ENTER, self=3D120063324=0A=
[3312]PDATA_free_params: ENTER, self=3D120063440=0A=
[3312]ARDFields_free 72804a8 bookmark=3D72806a0[3312]ARD_unbind_cols freeal=
l=3D1 allocated=3D0 bindings=3D0=0A=
[3312]APD_free_params: ENTER, self=3D120063260=0A=
[3312]IPD_free_params: ENTER, self=3D120063324=0A=
[3312]GDATA_unbind_cols freeall=3D1 allocated=3D0 gdata=3D0=0A=
[3312]SC_Destructor: EXIT=0A=
[3312]CC_lookup_lo: entering...=0A=
[3312]PGAPI_AllocStmt: entering...=0A=
[3312]SC_Constructor: entering ...=0A=
[3312]SC_Constructor: created stmt =3D 120063008=0A=
[3312]**** PGAPI_AllocStmt: hdbc =3D 120025968, stmt =3D 120063008=0A=
[3312]CC_add_statement: self=3D120025968, stmt=3D120063008=0A=
[3312]PGAPI_ExecDirect: entering...=0A=
[3312]recycle statement: self=3D 120063008=0A=
[3312]PDATA_free_params: ENTER, self=3D120063440=0A=
[3312]**** PGAPI_ExecDirect: hstmt=3D120063008, statement=3D'select oid fro=
m pg_type where typname=3D'lo''=0A=
[3312]PGAPI_ExecDirect: calling PGAPI_Execute...=0A=
[3312]PGAPI_Execute: entering...=0A=
[3312]PGAPI_Execute: clear errors...=0A=
[3312]recycle statement: self=3D 120063008=0A=
[3312]PDATA_free_params: ENTER, self=3D120063440=0A=
[3312]PGAPI_NumParams: entering...=0A=
[3312]Exec_with_parameters_resolved: copying statement params: trans_status=
=3D1, len=3D42, stmt=3D'select oid from pg_type where typname=3D'lo''=0A=
[3312] stmt_with_params =3D 'select oid from pg_type where typname=3D'lo''=
=0A=
[3312] Sending SELECT statement on stmt=3D120063008, cursor_name=3D'S=
QL_CUR07280420'=0A=
[3312]send_query(): conn=3D120025968, query=3D'select oid from pg_type wher=
e typname=3D'lo''=0A=
[3312]LIBPQ_execute_query: entering ...=0A=
[3312]in QR_Constructor=0A=
[3312]exit QR_Constructor=0A=
[3312]LIBPQ_execute_query: get next result with status =3D 2=0A=
[3312]LIBPQ_execute_query: query =3D select oid from pg_type where typname=
=3D'lo'=0A=
[3312]LIBPQ_execute_query: recent_processed_row_count =3D 0=0A=
[3312]LIBPQ_execute_query: rest types ...=0A=
[3312]CC_mapping: entering ...=0A=
[3312]CC_mapping: rows =3D 0, columns =3D 1=0A=
[3312]CC_mapping: column =3D 0=0A=
[3312]CC_mapping: set field info: name =3D oid, typ =3D 26, typlen =3D 4, a=
ttypmod =3D -1=0A=
[3312]in TL_Constructor=0A=
[3312]exit TL_Constructor=0A=
[3312]send_query: done sending query with status: 2=0A=
[3312]QR_fetch_tuples: cursor =3D '', self->cursor=3D0=0A=
[3312]QR_fetch_tuples: past CI_read_fields: num_fields =3D 1=0A=
[3312]MALLOC: tuple_size =3D 100, size =3D 800=0A=
[3312] done sending the query:=0A=
[3312]extend_column_bindings: entering ... self=3D120063144, bindings_alloc=
ated=3D0, num_columns=3D1=0A=
[3312]exit extend_column_bindings=0A=
[3312]PGAPI_ExecDirect: returned 0 from PGAPI_Execute=0A=
[3312]PGAPI_Fetch: stmt =3D 120063008, stmt->result=3D 120062160=0A=
[3312]manual_result =3D 1, use_declarefetch =3D 0=0A=
[3312]PGAPI_FreeStmt: entering...hstmt=3D120063008, fOption=3D1=0A=
[3312]QResult: in DESTRUCTOR=0A=
[3312]TupleList: in DESTRUCTOR=0A=
[3312]TupleList: exit DESTRUCTOR=0A=
[3312]QResult: free memory in, fcount=3D101=0A=
[3312]QResult: free memory out=0A=
[3312]QResult: exit DESTRUCTOR=0A=
[3312]SC_Destructor: self=3D120063008, self->result=3D0, self->hdbc=3D12002=
5968=0A=
[3312]APD_free_params: ENTER, self=3D120063260=0A=
[3312]IPD_free_params: ENTER, self=3D120063324=0A=
[3312]PDATA_free_params: ENTER, self=3D120063440=0A=
[3312]ARDFields_free 72804a8 bookmark=3D72806a0[3312]ARD_unbind_cols freeal=
l=3D1 allocated=3D1 bindings=3D7280020=0A=
[3312]reset_a_column_binding: entering ... self=3D120063144, bindings_alloc=
ated=3D1, icol=3D1=0A=
[3312]APD_free_params: ENTER, self=3D120063260=0A=
[3312]IPD_free_params: ENTER, self=3D120063324=0A=
[3312]GDATA_unbind_cols freeall=3D1 allocated=3D0 gdata=3D0=0A=
[3312]SC_Destructor: EXIT=0A=
[3312]CC_lookup_characterset: entering...=0A=
[3312]send_query(): conn=3D120025968, query=3D'select pg_client_encoding()'=
=0A=
[3312]LIBPQ_execute_query: entering ...=0A=
[3312]in QR_Constructor=0A=
[3312]exit QR_Constructor=0A=
[3312]LIBPQ_execute_query: get next result with status =3D 2=0A=
[3312]LIBPQ_execute_query: query =3D select pg_client_encoding()=0A=
[3312]LIBPQ_execute_query: recent_processed_row_count =3D 1=0A=
[3312]LIBPQ_execute_query: rest types ...=0A=
[3312]CC_mapping: entering ...=0A=
[3312]CC_mapping: rows =3D 1, columns =3D 1=0A=
[3312]CC_mapping: column =3D 0=0A=
[3312]CC_mapping: set field info: name =3D pg_client_encoding, typ =3D 19, =
typlen =3D 64, attypmod =3D -1=0A=
[3312]in TL_Constructor=0A=
[3312]exit TL_Constructor=0A=
[3312]CC_mapping: fetch column =3D pg_client_encoding, value =3D UTF8=0A=
[3312]send_query: done sending query with status: 2=0A=
[3312]QR_fetch_tuples: cursor =3D '', self->cursor=3D0=0A=
[3312]QR_fetch_tuples: past CI_read_fields: num_fields =3D 1=0A=
[3312]MALLOC: tuple_size =3D 100, size =3D 800=0A=
[3312]QResult: in DESTRUCTOR=0A=
[3312]TupleList: in DESTRUCTOR=0A=
[3312]TupleList: exit DESTRUCTOR=0A=
[3312]QResult: free memory in, fcount=3D101=0A=
[3312]QResult: free memory out=0A=
[3312]QResult: exit DESTRUCTOR=0A=
[3312]send_query(): conn=3D120025968, query=3D'set client_encoding to 'lati=
n9''=0A=
[3312]LIBPQ_execute_query: entering ...=0A=
[3312]in QR_Constructor=0A=
[3312]exit QR_Constructor=0A=
[3312]LIBPQ_execute_query: get next result with status =3D 1=0A=
[3312]LIBPQ_execute_query: query =3D set client_encoding to 'latin9'=0A=
[3312]LIBPQ_execute_query: recent_processed_row_count =3D 0=0A=
[3312]The query was executed successfully and the query did not return any =
result =
[3312]send_query: done sending command=0A=
[3312]QResult: in DESTRUCTOR=0A=
[3312]QResult: free memory in, fcount=3D0=0A=
[3312]QResult: free memory out=0A=
[3312]QResult: exit DESTRUCTOR=0A=
[3312]CC_connect: returning...=0A=
[3312]szConnStrOut =3D 'DSN=3DPostgreSQL;DATABASE=3Dintwis9;SERVER=3Dlocalh=
ost;PORT=3D5432;SSLMODE=3Dprefer;UID=3Dintwis2;PWD=3Dxxxxxxx ;ReadOnly=3D0;P=
rotocol=3D6.4;FakeOidIndex=3D0;ShowOidColumn=3D0;RowVersioni ng=3D0;ShowSyst=
emTables=3D0;ConnSettings=3D;Fetch=3D100;Socket=3D8192;Unkno wnSizes=3D0;Max=
VarcharSize=3D254;MaxLongVarcharSize=3D8190;Debug=3D1;CommLo g=3D1;Optimizer=
=3D1;Ksqo=3D1;UseDeclareFetch=3D0;TextAsLongVarchar=3D1;Unkn ownsAsLongVarch=
ar=3D0;BoolsAsChar=3D1;Parse=3D0;CancelAsFreeStmt=3D0;ExtraS ysTablePrefixes=
=3Ddd_;;LFConversion=3D1;UpdatableCursors=3D0;DisallowPremat ure=3D0;TrueIsM=
inus1=3D0;BI=3D0;ByteaAsLongVarBinary=3D0;UseServerSidePrepa re=3D0;LowerCas=
eIdentifier=3D0' len=3D590,1024=0A=
[3312]PGAPI_DriverConnect: returning 0=0A=
[3312][[SQLGetDiagRec]]=0A=
[3312]PGAPI_GetDiagRec entering rec=3D1[3312]**** PGAPI_ConnectError: hdbc=
=3D120025968 <0>=0A=
[3312]enter CC_get_error=0A=
[3312]enter CC_create_errormsg=0A=
[3312]msg =3D ''=0A=
[3312]exit CC_create_errormsg=0A=
[3312]exit CC_get_error=0A=
[3312]CC_Get_error returned nothing.=0A=
[3312]PGAPI_GetDiagRec exiting 100=0A=
[3312][SQLGetFunctions][3312][SQLGetInfo(30)][3312]PGAPI_Get Info: entering.=
...fInfoType=3D23=0A=
[3312]PGAPI_GetInfo: p=3D'', len=3D2, value=3D2, cbMax=3D2=0A=
[3312][SQLGetInfo(30)][3312]PGAPI_GetInfo: entering...fInfoType=3D24=0A=
[3312]PGAPI_GetInfo: p=3D'', len=3D2, value=3D2, cbMax=3D2=0A=
[3312][SQLGetInfo(30)][3312]PGAPI_GetInfo: entering...fInfoType=3D79=0A=
[3312]PGAPI_GetInfo: p=3D'', len=3D4, value=3D3, cbMax=3D4=0A=
[3312][SQLGetInfo(30)][3312]PGAPI_GetInfo: entering...fInfoType=3D83=0A=
[3312]PGAPI_GetInfo: p=3D'', len=3D4, value=3D0, cbMax=3D4=0A=
[3312][SQLGetInfo(30)][3312]PGAPI_GetInfo: entering...fInfoType=3D78=0A=
[3312]PGAPI_GetInfo: p=3D'', len=3D4, value=3D1, cbMax=3D4=0A=
[3312][SQLGetInfo(30)][3312]PGAPI_GetInfo: entering...fInfoType=3D81=0A=
[3312]PGAPI_GetInfo: p=3D'', len=3D4, value=3D15, cbMax=3D4=0A=
[3312][SQLGetInfo(30)][3312]PGAPI_GetInfo: entering...fInfoType=3D72=0A=
[3312]PGAPI_GetInfo: p=3D'', len=3D4, value=3D10, cbMax=3D4=0A=
[3312][SQLGetInfo(30)][3312]PGAPI_GetInfo: entering...fInfoType=3D82=0A=
[3312]PGAPI_GetInfo: p=3D'', len=3D4, value=3D90, cbMax=3D4=0A=
[3312][SQLGetInfo(30)][3312]PGAPI_GetInfo: entering...fInfoType=3D44=0A=
[3312]PGAPI_GetInfo: p=3D'', len=3D4, value=3D17, cbMax=3D4=0A=
[3312][SQLGetInfo(30)][3312]PGAPI_GetInfo: entering...fInfoType=3D43=0A=
[3312]PGAPI_GetInfo: p=3D'', len=3D4, value=3D1, cbMax=3D4=0A=
[3312][SQLGetInfo(30)][3312]PGAPI_GetInfo: entering...fInfoType=3D144=0A=
[3312]PGAPI_GetInfo30: p=3D'', len=3D4, value=3D0, cbMax=3D4=0A=
[3312][SQLGetInfo(30)][3312]PGAPI_GetInfo: entering...fInfoType=3D150=0A=
[3312]PGAPI_GetInfo30: p=3D'', len=3D4, value=3D4687, cbMax=3D4=0A=
[3312][SQLGetInfo(30)][3312]PGAPI_GetInfo: entering...fInfoType=3D167=0A=
[3312]PGAPI_GetInfo30: p=3D'', len=3D4, value=3D4687, cbMax=3D4=0A=
[3312][SQLGetInfo(30)][3312]PGAPI_GetInfo: entering...fInfoType=3D146=0A=
[3312]PGAPI_GetInfo30: p=3D'', len=3D4, value=3D1, cbMax=3D4=0A=
[3312][SQLGetInfo(30)][3312]PGAPI_GetInfo: entering...fInfoType=3D151=0A=
[3312]PGAPI_GetInfo30: p=3D'', len=3D4, value=3D1, cbMax=3D4=0A=
[3312][SQLGetInfo(30)][3312]PGAPI_GetInfo: entering...fInfoType=3D168=0A=
[3312]PGAPI_GetInfo30: p=3D'', len=3D4, value=3D1, cbMax=3D4=0A=
[3312][SQLGetInfo(30)][3312]PGAPI_GetInfo: entering...fInfoType=3D111=0A=
[3312]PGAPI_GetInfo: p=3D'N', len=3D1, value=3D0, cbMax=3D512=0A=
[3312][SQLGetInfo(30)][3312]PGAPI_GetInfo: entering...fInfoType=3D16=0A=
[3312]PGAPI_GetInfo: p=3D'', len=3D0, value=3D0, cbMax=3D0=0A=
[3312][SQLGetInfo(30)][3312]PGAPI_GetInfo: entering...fInfoType=3D23=0A=
[3312]PGAPI_GetInfo: p=3D'', len=3D2, value=3D2, cbMax=3D4=0A=
[3312][SQLGetInfo(30)][3312]PGAPI_GetInfo: entering...fInfoType=3D24=0A=
[3312]PGAPI_GetInfo: p=3D'', len=3D2, value=3D2, cbMax=3D4=0A=
[3312][SQLGetInfo(30)][3312]PGAPI_GetInfo: entering...fInfoType=3D46=0A=
[3312]PGAPI_GetInfo: p=3D'', len=3D2, value=3D2, cbMax=3D4=0A=
[3312][[SQLSetConnectAttr]] 1=0A=
[3312]PGAPI_SetConnectAttr 1=0A=
[3312]PGAPI_SetConnectOption: entering fOption =3D 1 vParam =3D 0=0A=
[3312]SetStmtOption(): SQL_MAX_ROWS, vParam =3D 0=0A=
[3312][[SQLSetConnectAttr]] 0=0A=
[3312]PGAPI_SetConnectAttr 0=0A=
[3312]PGAPI_SetConnectOption: entering fOption =3D 0 vParam =3D 0=0A=
[3312]SetStmtOption: SQL_QUERY_TIMEOUT, vParam =3D 0=0A=
[3312][SQLGetInfo(30)][3312]PGAPI_GetInfo: entering...fInfoType=3D6=0A=
[3312]PGAPI_GetInfo: p=3D'PSQLODBCA.DLL', len=3D13, value=3D0, cbMax=3D52=
=0A=
[3312][SQLGetInfo(30)][3312]PGAPI_GetInfo: entering...fInfoType=3D6=0A=
[3312]PGAPI_GetInfo: p=3D'PSQLODBCA.DLL', len=3D13, value=3D0, cbMax=3D52=
=0A=
[3312][SQLGetInfo(30)][3312]PGAPI_GetInfo: entering...fInfoType=3D6=0A=
[3312]PGAPI_GetInfo: p=3D'PSQLODBCA.DLL', len=3D13, value=3D0, cbMax=3D52=
=0A=
[3312][SQLGetInfo(30)][3312]PGAPI_GetInfo: entering...fInfoType=3D6=0A=
[3312]PGAPI_GetInfo: p=3D'PSQLODBCA.DLL', len=3D13, value=3D0, cbMax=3D48=
=0A=
[3312][SQLGetInfo(30)][3312]PGAPI_GetInfo: entering...fInfoType=3D1=0A=
[3312]PGAPI_GetInfo: p=3D'', len=3D2, value=3D0, cbMax=3D4=0A=
[3312][[SQLGetConnectAttr]] 109=0A=
[3312]PGAPI_GetConnectAttr 109=0A=
[3312]PGAPI_GetConnectOption: entering...=0A=
[3312][SQLGetInfo(30)][3312]PGAPI_GetInfo: entering...fInfoType=3D26=0A=
[3312]PGAPI_GetInfo: p=3D'', len=3D4, value=3D2, cbMax=3D4=0A=
[3312][[SQLAllocHandle]][3312]PGAPI_AllocStmt: entering...=0A=
[3312]SC_Constructor: entering ...=0A=
[3312]SC_Constructor: created stmt =3D 120063008=0A=
[3312]**** PGAPI_AllocStmt: hdbc =3D 120025968, stmt =3D 120063008=0A=
[3312]CC_add_statement: self=3D120025968, stmt=3D120063008=0A=
[3312][[SQLGetStmtAttr]] Handle=3D120063008 10010=0A=
[3312]PGAPI_GetStmtAttr Handle=3D120063008 10010=0A=
[3312][[SQLGetStmtAttr]] Handle=3D120063008 10011=0A=
[3312]PGAPI_GetStmtAttr Handle=3D120063008 10011=0A=
[3312][[SQLGetStmtAttr]] Handle=3D120063008 10012=0A=
[3312]PGAPI_GetStmtAttr Handle=3D120063008 10012=0A=
[3312][[SQLGetStmtAttr]] Handle=3D120063008 10013=0A=
[3312]PGAPI_GetStmtAttr Handle=3D120063008 10013=0A=
[3312][[SQLSetStmtAttr]] Handle=3D120063008 18,10=0A=
[3312]PGAPI_SetStmtAttr Handle=3D120063008 18,10=0A=
[3312][[SQLSetStmtAttr]] Handle=3D120063008 18,0=0A=
[3312]PGAPI_SetStmtAttr Handle=3D120063008 18,0=0A=
[3312][[SQLSetStmtAttr]] Handle=3D120063008 17,1243176=0A=
[3312]PGAPI_SetStmtAttr Handle=3D120063008 17,1243176=0A=
[3312][[SQLSetStmtAttr]] Handle=3D120063008 17,0=0A=
[3312]PGAPI_SetStmtAttr Handle=3D120063008 17,0=0A=
[3312][[SQLSetDescField]] h=3D120063228 rec=3D1 field=3D1004 val=3D12f828=
=0A=
[3312]PGAPI_SetDescField h=3D120063228 rec=3D1 field=3D1004 val=3D12f828,0=
=0A=
[3312]DESCRIPTOR ERROR: func=3DPGAPI_SetDescField, desc=3D'', errnum=3D11, =
errmsg=3D'bad parameter number'=0A=
[3312][[SQLSetStmtAttr]] Handle=3D120063008 0,30=0A=
[3312]PGAPI_SetStmtAttr Handle=3D120063008 0,30=0A=
[3312]PGAPI_SetStmtOption: entering...=0A=
[3312]SetStmtOption: SQL_QUERY_TIMEOUT, vParam =3D 30=0A=
[3312][SQLFreeStmt][3312]PGAPI_FreeStmt: entering...hstmt=3D120063008, fOpt=
ion=3D3=0A=
[3312]APD_free_params: ENTER, self=3D120063260=0A=
[3312]IPD_free_params: ENTER, self=3D120063324=0A=
[3312]PDATA_free_params: ENTER, self=3D120063440=0A=
[3312][SQLPrepare][3312]PGAPI_Prepare: entering...=0A=
[3312]**** PGAPI_Prepare: STMT_ALLOCATED, copy=0A=
[3312][SQLGetInfo(30)][3312]PGAPI_GetInfo: entering...fInfoType=3D36=0A=
[3312]PGAPI_GetInfo: p=3D'Y', len=3D1, value=3D0, cbMax=3D4=0A=
[3312][[SQLSetStmtAttr]] Handle=3D120063008 1227,1=0A=
[3312]PGAPI_SetStmtAttr Handle=3D120063008 1227,1=0A=
[3312]PGAPI_SetStmtOption: entering...=0A=
[3312][[SQLSetStmtAttr]] Handle=3D120063008 1228,1=0A=
[3312]PGAPI_SetStmtAttr Handle=3D120063008 1228,1=0A=
[3312]PGAPI_SetStmtOption: entering...=0A=
[3312][[SQLGetStmtAttr]] Handle=3D120063008 6=0A=
[3312]PGAPI_GetStmtAttr Handle=3D120063008 6=0A=
[3312]PGAPI_GetStmtOption: entering...=0A=
[3312]GetStmtOption(): SQL_CURSOR_TYPE 0=0A=
[3312][[SQLGetStmtAttr]] Handle=3D120063008 7=0A=
[3312]PGAPI_GetStmtAttr Handle=3D120063008 7=0A=
[3312]PGAPI_GetStmtOption: entering...=0A=
[3312]GetStmtOption(): SQL_CONCURRENCY 1=0A=
[3312][[SQLGetConnectAttr]] 108=0A=
[3312]PGAPI_GetConnectAttr 108=0A=
[3312]PGAPI_GetConnectOption: entering...=0A=
[3312][[SQLSetStmtAttr]] Handle=3D120063008 22,1=0A=
[3312]PGAPI_SetStmtAttr Handle=3D120063008 22,1=0A=
[3312][[SQLSetStmtAttr]] Handle=3D120063008 21,0=0A=
[3312]PGAPI_SetStmtAttr Handle=3D120063008 21,0=0A=
[3312][SQLExecDirect][3312]PGAPI_ExecDirect: entering...=0A=
[3312]recycle statement: self=3D 120063008=0A=
[3312]PDATA_free_params: ENTER, self=3D120063440=0A=
[3312]**** PGAPI_ExecDirect: hstmt=3D120063008, statement=3D'select 'asdfg'=
as asdfg=0A=
'=0A=
[3312]PGAPI_ExecDirect: calling PGAPI_Execute...=0A=
[3312]PGAPI_Execute: entering...=0A=
[3312]PGAPI_Execute: clear errors...=0A=
[3312]recycle statement: self=3D 120063008=0A=
[3312]PDATA_free_params: ENTER, self=3D120063440=0A=
[3312]PGAPI_NumParams: entering...=0A=
[3312]Exec_with_parameters_resolved: copying statement params: trans_status=
=3D1, len=3D25, stmt=3D'select 'asdfg' as asdfg=0A=
'=0A=
[3312] stmt_with_params =3D 'select 'asdfg' as asdfg=0A=
'=0A=
[3312] Sending SELECT statement on stmt=3D120063008, cursor_name=3D'S=
QL_CUR07280420'=0A=
[3312]send_query(): conn=3D120025968, query=3D'select 'asdfg' as asdfg=0A=
'=0A=
[3312]LIBPQ_execute_query: entering ...=0A=
[3312]in QR_Constructor=0A=
[3312]exit QR_Constructor=0A=
[3312]LIBPQ_execute_query: get next result with status =3D 2=0A=
[3312]LIBPQ_execute_query: query =3D select 'asdfg' as asdfg=0A=

------=_NextPart_000_0014_01C607E0.0771E010
Content-Type: text/plain
Content-Disposition: inline
MIME-Version: 1.0
Content-Transfer-Encoding: quoted-printable

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

------=_NextPart_000_0014_01C607E0.0771E010--

Re: Values in the select

am 24.12.2005 05:05:45 von Greg Campbell

This is a multi-part message in MIME format.
--------------030203020905090603080407
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit

Nice sample.
Perhaps you can use a DSN connection and in the PostgreSQL ODBC Driver setup for the connection turn on
mylog.
Or you can use the ODBC Administrator, under the tracing tab, Start Tracing.
Or in the server postgresql.conf temporarily turn the logging on for all statements, to capture lower
level ODBC communication.

Do the ODBC connection encoding, and the database encoding match?

A.j. Langereis wrote:
> Dear all,
>
> I have written an application that uses Postgresql (8.1.0) trough an ODBC (ANSI) connection. I noticed that a query like "select 'bar' as foo" does not give the value "bar" in the column "foo". This works normally under PGadmin and even on other databases via ODBC. Am I overlooking something or might this be a bug?
>
> Values that I do get are like "#0#0#0#0#0"
>
> A piece of Delphi code to show the problem:
>
> procedure show_problem(conn : TADOConnection)
> var
> qry : TAdoQuery;
> datasource: TDataSource;
> begin
> qry := TADOQuery.create(nil);
> qry.Connection:=conn;
> qry.SQL.Text:= 'select ''bar'' as foo';
>
> qry.Open;
>
> if not qry.eof then
> begin
> datasource := TDataSource.Create(nil);
> datasource.dataset := qry;
>
> //datasource.DataSet.Fields[1].AsString now has the value of '#0#0#0#0#0'
> //datasource.DataSet.Fields[1].FieldName is now equal to 'foo'
>
> datasource.free;
> end;
>
> qry.close;
> qry.free;
> end;
>
> The version of ODBC that I've got installed is 08.00.0102 (via MSI installed).
>
> Yours,
>
> Aarjan

--------------030203020905090603080407
Content-Type: text/x-vcard; charset=utf-8;
name="greg.campbell.vcf"
Content-Transfer-Encoding: 7bit
Content-Disposition: attachment;
filename="greg.campbell.vcf"

begin:vcard
fn:Greg Campbell
n:Campbell;Greg
org:Michelin North America - US5 Lexington;ENG-ASE
email;internet:greg.campbell@us.michelin.com
title:ASE Systems Engineer
tel;work:803-951-5561/x75561
x-mozilla-html:FALSE
version:2.1
end:vcard

--------------030203020905090603080407
Content-Type: text/plain
Content-Disposition: inline
MIME-Version: 1.0
Content-Transfer-Encoding: quoted-printable

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org

--------------030203020905090603080407--

Re: Values in the select

am 25.12.2005 08:36:22 von Ludek Finstrle

> Attached is a file with both mylogs enabled.Note: I have put the log through
> a parser because the lines were only delimeted with a #10 instead of both
> #10 and #13

The log is truncated in the middle of SQLExecDirect operation. I can't
tell you anything now. I need whole log.
I don't see neither what driver read from backend nor how you get tha data.

Regards,

Luf

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Re: Values in the select

am 08.01.2006 12:12:32 von Ludek Finstrle

> > Attached is a file with both mylogs enabled.Note: I have put the log through
> > a parser because the lines were only delimeted with a #10 instead of both
> > #10 and #13
>
> The log is truncated in the middle of SQLExecDirect operation. I can't
> tell you anything now. I need whole log.
> I don't see neither what driver read from backend nor how you get tha data.

What's the state? Could I release it from my mind?

Thanks,

Luf

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Re: Values in the select

am 11.01.2006 09:34:38 von a.j.langereis

This is a multi-part message in MIME format.

------=_NextPart_000_0018_01C61692.3DA975B0
Content-Type: multipart/alternative;
boundary="----=_NextPart_001_0019_01C61692.3DA975B0"

------=_NextPart_001_0019_01C61692.3DA975B0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Unfortunately it has not been solved yet: I missed your previous email.

I have attached the complete log file, however the requested part is a bit=
=20
messed up. Hopefully you are still able to make any sense out of it. If not=
,=20
I'll make a new logfile, but that is a bit difficult at the moment due to a=
=20
broken down workstation.

Regards,

Aarjan

----- Original Message -----=20
From: "Ludek Finstrle"
To: "A.j. Langereis"
Cc:
Sent: Sunday, January 08, 2006 12:12 PM
Subject: Re: [ODBC] Values in the select

>> > Attached is a file with both mylogs enabled.Note: I have put the log=
=20
>> > through
>> > a parser because the lines were only delimeted with a #10 instead of=
=20
>> > both
>> > #10 and #13
>>
>> The log is truncated in the middle of SQLExecDirect operation. I can't
>> tell you anything now. I need whole log.
>> I don't see neither what driver read from backend nor how you get tha=20
>> data.
>
> What's the state? Could I release it from my mind?
>
> Thanks,
>
> Luf
>
>=20

------=_NextPart_001_0019_01C61692.3DA975B0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Unfortunately it has not been solved yet: I missed =
your=20
previous email.

I have attached the complete log file, however the=
=20
requested part is a bit
messed up. Hopefully you are still able to make=
any=20
sense out of it. If not,
I'll make a new logfile, but that is a bit=20
difficult at the moment due to a
broken down=20
workstation.

Regards,

Aarjan

----- Original Message --=
---=20

From: "Ludek Finstrle" <>
To: "=
A.j.=20
Langereis" <>
Cc: <<=
A=20
href=3D"">pgsql-odbc@postgresql.org>
Sent: Sunday, January 08, 20=
06=20
12:12 PM
Subject: Re: [ODBC] Values in the select

>> &g=
t;=20
Attached is a file with both mylogs enabled.Note: I have put the log=20

>> > through
>> > a parser because the lines were =
only=20
delimeted with a #10 instead of
>> > both
>> > #10=
and=20
#13
>>
>> The log is truncated in the middle of SQLExecDi=
rect=20
operation. I can't
>> tell you anything now. I need whole=20
log.
>> I don't see neither what driver read from backend nor how =
you=20
get tha
>> data.
>
> What's the state? Could I releas=
e it=20
from my mind?
>
> Thanks,
>
> Luf
>
> <=
BR>

------=_NextPart_001_0019_01C61692.3DA975B0--

------=_NextPart_000_0018_01C61692.3DA975B0
Content-Type: application/octet-stream;
name="mylog_2697.rar"
Content-Transfer-Encoding: base64
Content-Disposition: attachment;
filename="mylog_2697.rar"

UmFyIRoHAM+QcwAADQAAAAAAAACPV3QgkDMAUhIAAMp9AAACUfzDJlxHKTQd
Mw4AIAAAAG15bG9nXzI2OTcubG9nAPCMhkcQAdEMzRDXxYDdOqcHU67qp173
oPQP1eFU+bK3eKTABKJKS0b3HSSt1U1uo6SVvbtb5UGEQCUa0/HiAdWrqcHQ
OBwdB0D9VegdV7YOkcHSODYPQODoH/AODoOgcDgcDgcnQepYCtSQBV5g+OAg
EIlfLd5GqW6BmXl/HLy7vLGAfyl3l/LL/X8K/fgTl5+zMAzMu6sIhE+WRIOP
2a9m5tJWVc9T0LXkkVd1VZLasqI3bylax6FFTEDIyaaOnG978XlIHeXy0/Dr
TbLFaveStpsJ2dlq37IfjLFsyj3ZtHVRIBULfnMC0cx8OpmSwtiAekZd21Lf
nAkMCNNlSJnrAwr4mU1FgCZq2GBmwxLgkN8xz+RNIojzrlu2pVWZqZoWUvYZ
K+f6x41gNiFAYMI5lULpuxP0NGVMcF6h4EUgVJVax+xwTHFVLNYW4Y1+ARKJ
gjZlhgi4IGZ3bhzPK+WxswbtwXDUZ3VFtW3WuZsg3sPlFt275RFYdjU3bqiE
uX734oYMuoRjZGezPGZ/ssZQ0OC86Vm+oQ6NrvpehA4/FyubWM3locx5+On4
HE3+vdaWk4eZlZqxMQHhsJFFK8laH2aBagp7CvOw5sXnyjz655FhLEC6znfa
u2VBmK5lfp8YerwyNPp+BCjcVWr3lAMTT2NWegy0tuWFT9Oj8fC/Q1+e0lXL
95xjVFiozHHpsy0TJLBitq/xjt4uM3k6PueFDoazhd3ZrmPK8agyaWER1eOE
El4j4SntJcMH0X98j/+7w9XcT4SQww7rl5YdtxJZtXEyB/jNs7rI6SZAy9cW
uM3WR9Y0n441GdwSVUgxxn4ZLNzcG5ptcYV/AEM47sQyKAoNextRfOCJOC/1
IjFH4xWtFv2xRbLYJ7LQ7qLRROEQ137TO5eQ82WgcabpzZiEw7RZom6KHDO4
agfoSeCOHZh3HsCwCQP/JO9ob0oYRLwcTB9OiIzjd6cdv8MRGl2Xt9ewRyRT
Y/UpxzpyNWIfyPX2b2CaUYjAvGe1pdHbBIKcbe2F2FqPSIOzw0SDxgrWkodi
Nrth4WaaSyQ9ST2V2iFqPU1bStPsxo5hNUbKSaEDX2Q0DbpWueu21HDNx4E6
VwJQ7Z09jOJChG4IiWNj5eAwkBE6gDi5b3lb9WqooElLn8qCwXnhSuea/dRu
10QMlUMPDZNFSxVNa1D5e0xAIyoOCmZmebzweMiASqDulgqeFoBq7KcevXqV
H3KLe2ntVS5baPjsdOnEmBVVgI1oDSamBEMTH0IGIaL6h6FKs+xexrVwXG7V
sqGYo8gmPRnzak1GsxAHpw5RoNNhlDwVKFKO1g2sFJkmwicFmLtvzsjvFpCM
IgCGN5jZvYjY9AA0LZHky9cg4DKRl9bwydYgGChuNZg969cZ86TVE0YXgv2q
LYbCHKM3UdywtttDRQAJVFmJW5Z86iYHqDwYahnTcMcLQRArapGNb6uANTrx
0ptiGPXSYYQDKL4kTaJDh/qbLqYzIp0NahOqFGaGs9i53Vb7Ily8iN1rhIB4
ojO2KRss+YbJYG6OFQGSPyX2b90b0gbhItvIlxEINravco+FFRrNpoTw+sAb
lfw0i9ZrlwTcnQ91DDuuow62EjuYGSL9nghq+MaX4uT4rA3/QA2KhsVhQaYB
Egk2rnBqsZTR4RuBB6v2yOROQxQPu1g2zKpj+F/tJXboKih1VF34EA0XBlcJ
di/atk7IUJavgvTRcwTBJlaxx6pmWCbg1uGQ2oKOM5Bq70CdINhB2DjnuHJL
BYBEiXOccVmCprC64e6LMysIVdt483TGckgno42AZ52eaNtFiVMlZ12rnWgE
e5IPGo60ybhqws7W6Z3WXTK9WqE0Yx7NDs7BkjPk55/CyBmcrdUq2GW+xBb/
YS08AHFZa0qksy2U9J5lIGrxD4R4mBUauk3pcHq0jNOeM7ttWSBuOwgSFixk
7VBywlhBJkkFpbv2m+svNvvzdbW152kYTFIkj0hehRNjG+uYIPnCHyHxxymk
jeyQsNN2l7I7VggQq/aDLeenSZLNTgOiPYdVRxex7y4Z5NtGoHPs8Q5Fx8FH
AhsicOyZhpla9ctP4Mj/D6g1k6UCNhp7RndtpwY3cHzJLsCu0lhuw+otX48f
JLn0U2YrKV5RpopAx/FAEjzWaJr7GYiygdHxyliLWl9jVkSJQjXIE5WsWu6O
3L1s1AwzUGmsMUXLqxGOHstR2Od23F9uXZ8nRCErtX6wTcnl2S0/O0iqeBSb
QnGydQ2aYXa6c96qYz7IzEN6wCfDP1lmtOHS9Ws1CaQkVmu8/Qj9MHKOQaRS
I3vbB2BbSgmXWqrOnf6PNkMNteIZGap7LuXc+hqTdjWqYX238YaO7q17pJUg
2NySQfre9NCWoTUrJBpTLMp49CNfgsb1dqy7gNlUrm50kdPduLEedlEluE8Y
1QuNLpAxaA6KtVHs6oQxwcc7XCsBAoxJ7fUCcfQNrnA2A7dV9ec7eGkR26Gl
pl2fQp1KWxOqa9LfaoOEFrWFcgvyOvYIG6Phz34y0pauXt0BAehccqOFBJOi
gpgi0C/xhKB9/nqPbjMp8QROmo07cCBrnePcRoQK+tNoz+S2Mh8oVdXIA1h8
nl2zEm0p+oSQlJhTCT46UwzaDfJ2mQPMgOwlJGuhaN+2OAeHBkVIswIPjKpj
0IQ52O4TAPPdJQKeUWRSxI4+XyFR0cj6tA7pNb7ui9cmm5IrLSaGm4xjmh49
WoVNdDlV3aqZ1+oegv+4OMw7aa27ZUHS7o2rT143X6h/xTh54kil246h/cjh
g/MSYOZ4NeoYk5vyi1dPmA8soc8UW/Y2h1nC3YVFfe5dQ/zrKKjm5kwrBWom
xeTarHLFa2G+zxSE4u9ugGJ2OG27ize33C83XEZ5LfNBKmhtgJ803JUF+U2X
jY7i1zmsa+Vt0I71i5XjkZTY3nWU06Ve4rqfJcIz9r6mp1+e7inTpYrIdd+I
e547BdGPa4cse272h8h3X57eFsjVl1+euCkycGP1rNziVFOxXwlqjaJP6/Pa
BTh4reRXpEPc8gxXRj3HImH7bvhsYj/r8+OFswVddIVGPpZ8Dr9UHBODRIb7
E0700VMkp3LXEsrNzr9TtfbriVNywm06lu12vGsbm3h3UMDqJwtyzc6/blMU
7Jcp5PKcj2Ok+eUi/1bxPfKTu9ueKJZAlPOEqL0VxSo0XaAppzik8oSyed+K
SdfeJMC+/OlGii9fvPxC/dFIGi/F5XsI6u2kPhv68Cn+/z5TIZBE9q2bA4hX
r2EjVt95OafoVH/XTmnkFQHJCM7REsqT0lzUeFM1vkMNipqTPvtIzfeiG5k1
W7xM75PE6WUgp8Wj94fGjxCOe3lXF9hKoSV7KhpFcSHX8s4nvimvfWg+3Ujj
EdybToNe3WaOnwql4vXIOexZ6dFmuogHst7iqnrd/XwgoE9lcxvt8mHBJPXt
2d1A3iZv3MeVnydPUS8ymvYT1bafGUF3TZd3A7pxHeod9LAPETljAIE3f093
CApaqB7kkFS70yIfb90J0yT1o/auqbMbLSxPavdi35rbGGDWPlJj3fS9HiSv
DkHw7EftaoWWsyRXLth+1yz1Nq+zwcBGtWmAD6RzvdoL+8HX+lX5Lgf9sKqT
2p9housWqBommqlDNA5wxVX9uwvuXOO0LSc0DUd8MmjRdK3VUs4A5sHwWQ+Y
bgnhE6ote7FD9tT09bUnD502NV8ZKujlLwA04j7QaaT2veHqLnvDoHNevqaq
vfsW76pwzJ1R/5urKJOne7nFeADy1BL1MftTtOwmMoupEEbBtziLDVxZq8S2
1rAP6QROMT4UJomxzjXpdyF+DXOtNvavfK18Mdw4JV6TBNnZfiJ65edwBwxx
6YPZVSPNkWgOnjNVXx57WZ2je24OCCcwNH4HbqJKfpAuWqvk1eWla7l+HUSJ
G+enY8NcvoBICz7ome3SAdJ7Y9W+PT4BcNPTjXldtKxqX7Y/b9ldnmnxHM+Q
LJ2vBsa2t22viP48TH7y6cvLkkXypeiLdkiaRvSRSEyQJ8aKZlzBPjueUwcu
/0OeU7PE/55XiZlxd0RTUmTlyeS15qR1Sz/OwdLIvSmnk7QNy8wpMqZzzkeO
lS+rzEZPXgc9MH9A7qwwpUzeOiHw/gbL86BoF0Dj+cU7x5a36GixCUH6ok7p
Ivl84vf8rnAuQ3zlz3on5yjlHzl+785Ydz2DEj2l9oEHRYgMpHvzfGjS1/jp
x4TBQ51mizmigmi1NHV4dihS8iNTV79DX2KkMd3Ls2ojN/RAa68/uTpufP1t
ZzWrIg61l5Hr8YwpuTM5wez5brzhJOpsuYLzYO07KA4m/xdJJVK45g9f5K7R
JFpivqY/WHjM7meYyc3na0pJ4KHQlDsR5UVg+QDslIRwnq9V948T08T6QJ6v
VyF1gzzI50GFavl37F93LB9lY9l4Tz5LDZcrKSLAwuSEo3A8gIfDzQlUnn4g
H222APPECVJtryLw60xJG5dC+rTD5kApuiTJRG8Y4eAFnUtWjvGUKVLgQ8Bg
KgKhBHUcxMOok6MFRyDxzoT9BOoKlf4l2kkzHOQuNfCgRspWfNjyN7HBsRAG
yiU6eHYz6croNnl3DdJHsnwlwaOt15d8jjdnyH2Ud0Hp1O/URJ5ZvCBQnxx8
pV5vF8kCy+THbkmTlWsM88Nf/KGf8RgohnGSGVME+wdS+rkIMkFfDgZkoCIM
Luwu1unbFKnr0kanko0DDcpOqWJzv9C7/X8AHZSocD5DDuRmzZgtOOv+aMln
n5UyUWG5EPTsqh84LBjx3kquz7eehHoySqdavGD68WTpzADv9FszM/B6Q/vh
EMAwCf6f++Jlp+Z9Ad+DA0AP4cxr9+gP7KUCsgHf6t4H4N8slsz/b/60Qe+I
jPThk8neO3/H8OY7f/hEcpyFLFH19sSertll5hy7fSFviqbLSGcJMiadXwOE
swCCC2dmOnd/uIxyg73Cj++5ADobXgf7/l02IfW+1sQyJgl+oBCFcSlqx86A
k+YOspcboJtiOeUOPGIwXZbwdMIgi6ZqGKwwpZE3uhduM4zcRAM5oRhN/XtC
DmX/FCJWZadzo9S5LzmjrnTbAfBAWDHuVE4BEKT5c4qpJ/aFdJxDINgMXRlR
N7gAHGlYKhElhN9oITi648ZquyKNZEtiLaYsGpG+WxijpiSeHXEuj8+As57U
j3NMXQWHbuYq6oj+mlmZkK7hJgKwuF2+nSX/omAQQ7lGRztsSMfZo5mZz3sC
nmxPmwFBdbujFq0eRjI9peXzfhEXwWa8bH9pghIEv9Jj2i4eqhUVNp0zuidy
O8bFERvCX4hFrdmvAkeY/fw/IueXLEDfZL5v/pcDVpLLMHpliu+gYcVm3JiH
rCcsXJytBJkfbFl+6ULF8s77JS938w74NH9eDv4CJbtj9++XGyCzEkFOIeiU
LeyOmRWYBBgT3Vy/pvbx4/xoCu+0O9x/o/fcPQJPVoC3uVnheyiBBBqfrx/G
ivMES1qTIElhkpdv8g0XEzbXagYDyhP4r8L8r8Oqir+0RGF+/Agfca67JgCR
M7R2oOAaJs0RxuJxVCSSodH+AfIyGfkgxUPSKP4SBXOSgOwH9ku3v/qgIjfT
WAfd6RiQ/pDWmRwsRKSe6JzTFSaDYnNaOD90Q2x6A1CdQmIXMyf5OX8BdF4H
+5ovAbYiYU7Y8Zr/Zvd43FhnYYV2jmv9ud/xvUxai9LH2gJfs/RFztA3RGuK
iDpByrgT79sQYKgGRj9b22qJo4BGQ0KmC7EkOvPv7D2tGMxMSUfVniiSRLZF
Fk70gt/9nZHs6AodC9fVnLnkCt8UBcHoUP15wtHdFTQD+5RxVX9eC88plTMz
sriyFwSP5RxQJwuxLovxpDUxONpvOSPxx3+1uCbZxzMIKYM2xN9fwCGQ1Axf
vi3mkn4IdrHRpiSxL9XZgzBHRpeLeSGrmG5bE8wJ7vZFd9wSzOWuYfX2BRpU
gTfsASY3HxlH6RU0Q/uWc1X+aAghW/+XOU8fmKWJ9ea/EP45r/dQ+KA50ed3
fOACJVp2uZph3P9+xfL7maJ5LK3En84z9vT1B3xOehxUNH0RhRPHG3phRR/s
KL9n5+WtwXT/z84on6hRdES/kE5PEv9fzc3kwen8y7rs9kTbYjzHxQn/QC7z
NjHkD+6E9Xl/lEUWj6Q37fp3y53/uEcT1u93sTHVxKmMOxcFXKr/wX6q9m+T
Sid7/vw8Q7xkJC/vxQXL3OfsErx0fv/K/hSfP+VwqZD5lv/9xD17AEAHAA==

------=_NextPart_000_0018_01C61692.3DA975B0
Content-Type: text/plain
Content-Disposition: inline
MIME-Version: 1.0
Content-Transfer-Encoding: quoted-printable

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

------=_NextPart_000_0018_01C61692.3DA975B0--

Re: Values in the select

am 12.01.2006 15:30:55 von Ludek Finstrle

> I have written an application that uses Postgresql (8.1.0) trough
> an ODBC (ANSI) connection. I noticed that a query like
> "select 'bar' as foo" does not give the value "bar" in the column
> "foo". This works normally under PGadmin and even on other databases
> via ODBC. Am I overlooking something or might this be a bug?

I'm able to reproduce the problem here. Stay tuned. I hope I'll fix it
in 08.01.0107 development snapshot.

Regards,

Luf

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

Re: Values in the select

am 13.01.2006 09:37:58 von a.j.langereis

Great! (well is it ? ;) )

Looking forward to that snapshot!

Regards,

Aarjan

----- Original Message -----
From: "Ludek Finstrle"
To: "A.j. Langereis"
Cc:
Sent: Thursday, January 12, 2006 3:30 PM
Subject: Re: [ODBC] Values in the select

>> I have written an application that uses Postgresql (8.1.0) trough
>> an ODBC (ANSI) connection. I noticed that a query like
>> "select 'bar' as foo" does not give the value "bar" in the column
>> "foo". This works normally under PGadmin and even on other databases
>> via ODBC. Am I overlooking something or might this be a bug?
>
> I'm able to reproduce the problem here. Stay tuned. I hope I'll fix it
> in 08.01.0107 development snapshot.
>
> Regards,
>
> Luf
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend
>
>

---------------------------(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

patch: Re: Values in the select

am 14.01.2006 00:10:05 von Ludek Finstrle

--zYM0uCDKw75PZbzx
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline

> > I have written an application that uses Postgresql (8.1.0) trough
> > an ODBC (ANSI) connection. I noticed that a query like
> > "select 'bar' as foo" does not give the value "bar" in the column
> > "foo". This works normally under PGadmin and even on other databases
> > via ODBC. Am I overlooking something or might this be a bug?
>
> I'm able to reproduce the problem here. Stay tuned. I hope I'll fix it
> in 08.01.0107 development snapshot.

I has good news for you. I found the problem and fix it. psqlODBC
08.01.0107 will contain this patch. I hope I put it on the web
during weekend (the date couldn't be final).

Patch is attached.

Please review and comment

Luf

--zYM0uCDKw75PZbzx
Content-Type: text/plain; charset=us-ascii
Content-Disposition: attachment; filename="psqlodbc-typlen_var_length.diff"

diff -c psqlodbc.orig\connection.c psqlodbc\connection.c
*** psqlodbc.orig\connection.c Sun Jan 08 12:12:01 2006
--- psqlodbc\connection.c Sat Jan 14 00:09:10 2006
***************
*** 1959,1965 ****
* (UNKNOWNS_AS_MAX), and UNKNOWNS_AS_LONGEST won't work because we don't
* have data at this point
*/
! if(typlen == -1)
{
switch (ci->drivers.unknown_sizes)
{
--- 1959,1965 ----
* (UNKNOWNS_AS_MAX), and UNKNOWNS_AS_LONGEST won't work because we don't
* have data at this point
*/
! if(typlen < 0)
{
switch (ci->drivers.unknown_sizes)
{

--zYM0uCDKw75PZbzx
Content-Type: text/plain
Content-Disposition: inline
MIME-Version: 1.0
Content-Transfer-Encoding: quoted-printable

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly

--zYM0uCDKw75PZbzx--