> I see no problem. We only want to simulate your situation.
> We need to know the exact psqlODBC state.
>
> Please could you send us mylog output?
I add the mylog file to the attachment .
I hope it is helpful .
>
> Regards,
>
> Luf
>
> ---------------------------(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
>
[2784]globals.extra_systable_prefixes = 'dd_;'
[2784]aszKey='DSN', value='postgre_8.02'
[2784]copyAttributes:
DSN='postgre_8.02',server='',dbase='',user='',passwd='xxxxx',port='',onlyread='',protocol='',conn_settings='',disallow_premature=-1)
[2784]getDSNinfo: DSN=postgre_8.02 overwrite=0
[2784]globals.extra_systable_prefixes = 'dd_;'
[2784]rollback_on_error=1
[2784]globals.extra_systable_prefixes = 'dd_;'
[2784]calling getDSNdefaults
[2784]checking libpq library
[2784]hmodule=63100000
[2784]libpq_exist=1
[2784]DETACHING PROCESS