From: | linusliu <linusliu(at)pchome(dot)com(dot)tw> |
---|---|
To: | postgresql-list <pgsql-odbc(at)postgresql(dot)org> |
Subject: | pgsql 7.4 & odbc 7.3.2 (problem ?) |
Date: | 2004-01-04 19:40:46 |
Message-ID: | 20040105032458.ED6D.LINUSLIU@pchome.com.tw |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
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(at)pchome(dot)com(dot)tw>
==========================================================
lMl
http://edm-prg.epaper.com.tw/click.php?ad_code=50728
==========================================================
PChome~~ \*^o^*//
http://love.pchome.com.tw/
==========================================================
From | Date | Subject | |
---|---|---|---|
Next Message | Hiroshi Inoue | 2004-01-05 09:28:59 | Re: pgsql 7.4 & odbc 7.3.2 (problem ?) |
Previous Message | Jeff Eckermann | 2004-01-03 17:06:25 | Re: odbc : delay time is too long for pgsql 7.4 ?? |