Обсуждение: pgsql 7.4 & odbc 7.3.2 (problem ?)
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/ ==========================================================
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.