Обсуждение: pgsql 7.4 & odbc 7.3.2 (problem ?)

Поиск
Список
Период
Сортировка

pgsql 7.4 & odbc 7.3.2 (problem ?)

От
linusliu
Дата:
Hi, everybody :

I am a windows application developer in Taiwan.
I am testing the new version of pgsql : 7.4. ( current use : the version
7.2.4)

I have found a problem on psqlodbc_xxx.log.

The case is : I connect to two database on different PC. One is version
7.2.4 and the other is version 7.4. The data on both machine is the same.

I want to send a SQL command via ODBC (7.3.2) : "select * from
systemfile where 1=2" for three times.

Result in log :
<1>. verion 7.2.4 :  (correct)

conn=18691864, query='SELECT "waid", "custname", "superpass", "opendate", "worker", "isrev", "pnos", "pnol",
"evaluate","edate", "listdate", "sizes", "sizel", "colors", "colorl", "pr_top", "pr_left", "ispreview", "stockpid",
"isrevpid","pidpatten", "pidpattern", "listtype", "version", "safestock", "pnopattern", "type1" FROM "systemfile" WHERE
(1)= (2)' 
    [ fetched 0 rows ]
conn=18691864, query='SELECT "waid", "custname", "superpass", "opendate", "worker", "isrev", "pnos", "pnol",
"evaluate","edate", "listdate", "sizes", "sizel", "colors", "colorl", "pr_top", "pr_left", "ispreview", "stockpid",
"isrevpid","pidpatten", "pidpattern", "listtype", "version", "safestock", "pnopattern", "type1" FROM "systemfile" WHERE
(1)= (2)' 
    [ fetched 0 rows ]
conn=18691864, query='SELECT "waid", "custname", "superpass", "opendate", "worker", "isrev", "pnos", "pnol",
"evaluate","edate", "listdate", "sizes", "sizel", "colors", "colorl", "pr_top", "pr_left", "ispreview", "stockpid",
"isrevpid","pidpatten", "pidpattern", "listtype", "version", "safestock", "pnopattern", "type1" FROM "systemfile" WHERE
(1)= (2)' 
    [ fetched 0 rows ]
conn=18691864, PGAPI_Disconnect

<2>.  version 7.4 : (first time is wrong)

conn=18691864, query='SELECT * FROM "systemfile"'      <== WRONG, it
would get all data to my client machine, this made me waiting for a long
time and almost made me cry.  >< .......
    [ fetched 2 rows ]
conn=18691864, query='SELECT "waid", "custname", "superpass", "opendate", "worker", "isrev", "pnos", "pnol",
"evaluate","edate", "listdate", "sizes", "sizel", "colors", "colorl", "pr_top", "pr_left", "ispreview", "stockpid",
"isrevpid","pidpatten", "pidpattern", "listtype", "version", "safestock", "pnopattern", "type1" FROM "systemfile" WHERE
(1)= (2)' 
    [ fetched 0 rows ]
conn=18691864, query='SELECT "waid", "custname", "superpass", "opendate", "worker", "isrev", "pnos", "pnol",
"evaluate","edate", "listdate", "sizes", "sizel", "colors", "colorl", "pr_top", "pr_left", "ispreview", "stockpid",
"isrevpid","pidpatten", "pidpattern", "listtype", "version", "safestock", "pnopattern", "type1" FROM "systemfile" WHERE
(1)= (2)' 
    [ fetched 0 rows ]
conn=18691864, PGAPI_Disconnect

Do I need to do something to avoid this error on version 7.2.4. ? Please
help me with this. Or, I need to wait for new version of ODBC ?

   Note : I had tested all the setting on ODBC options.

Linus.Liu.

--
linusliu <linusliu@pchome.com.tw>




==========================================================
 ���l�M�������l
 http://edm-prg.epaper.com.tw/click.php?ad_code=50728
==========================================================
 PChome����~~���������� \*^o^*//
 http://love.pchome.com.tw/
==========================================================

Re: pgsql 7.4 & odbc 7.3.2 (problem ?)

От
Hiroshi Inoue
Дата:
linusliu wrote:
>
> Hi, everybody :
>
> I am a windows application developer in Taiwan.
> I am testing the new version of pgsql : 7.4. ( current use : the version
> 7.2.4)
>
> I have found a problem on psqlodbc_xxx.log.

Could you send me the Mylog debug output especially
for the 7.4 server ?

regards,
Hiroshi Inoue

> The case is : I connect to two database on different PC. One is version
> 7.2.4 and the other is version 7.4. The data on both machine is the same.
>
> I want to send a SQL command via ODBC (7.3.2) : "select * from
> systemfile where 1=2" for three times.
>
> Result in log :
> <1>. verion 7.2.4 :  (correct)
>
> conn=18691864, query='SELECT "waid", "custname", "superpass", "opendate", "worker", "isrev", "pnos", "pnol",
"evaluate","edate", "listdate", "sizes", "sizel", "colors", "colorl", "pr_top", "pr_left", "ispreview", "stockpid",
"isrevpid","pidpatten", "pidpattern", "listtype", "version", "safestock", "pnopattern", "type1" FROM "systemfile" WHERE
(1)= (2)' 
>     [ fetched 0 rows ]
> conn=18691864, query='SELECT "waid", "custname", "superpass", "opendate", "worker", "isrev", "pnos", "pnol",
"evaluate","edate", "listdate", "sizes", "sizel", "colors", "colorl", "pr_top", "pr_left", "ispreview", "stockpid",
"isrevpid","pidpatten", "pidpattern", "listtype", "version", "safestock", "pnopattern", "type1" FROM "systemfile" WHERE
(1)= (2)' 
>     [ fetched 0 rows ]
> conn=18691864, query='SELECT "waid", "custname", "superpass", "opendate", "worker", "isrev", "pnos", "pnol",
"evaluate","edate", "listdate", "sizes", "sizel", "colors", "colorl", "pr_top", "pr_left", "ispreview", "stockpid",
"isrevpid","pidpatten", "pidpattern", "listtype", "version", "safestock", "pnopattern", "type1" FROM "systemfile" WHERE
(1)= (2)' 
>     [ fetched 0 rows ]
> conn=18691864, PGAPI_Disconnect
>
> <2>.  version 7.4 : (first time is wrong)
>
> conn=18691864, query='SELECT * FROM "systemfile"'      <== WRONG, it
> would get all data to my client machine, this made me waiting for a long
> time and almost made me cry.  >< .......
>     [ fetched 2 rows ]
> conn=18691864, query='SELECT "waid", "custname", "superpass", "opendate", "worker", "isrev", "pnos", "pnol",
"evaluate","edate", "listdate", "sizes", "sizel", "colors", "colorl", "pr_top", "pr_left", "ispreview", "stockpid",
"isrevpid","pidpatten", "pidpattern", "listtype", "version", "safestock", "pnopattern", "type1" FROM "systemfile" WHERE
(1)= (2)' 
>     [ fetched 0 rows ]
> conn=18691864, query='SELECT "waid", "custname", "superpass", "opendate", "worker", "isrev", "pnos", "pnol",
"evaluate","edate", "listdate", "sizes", "sizel", "colors", "colorl", "pr_top", "pr_left", "ispreview", "stockpid",
"isrevpid","pidpatten", "pidpattern", "listtype", "version", "safestock", "pnopattern", "type1" FROM "systemfile" WHERE
(1)= (2)' 
>     [ fetched 0 rows ]
> conn=18691864, PGAPI_Disconnect
>
> Do I need to do something to avoid this error on version 7.2.4. ? Please
> help me with this. Or, I need to wait for new version of ODBC ?
>
>    Note : I had tested all the setting on ODBC options.