Обсуждение: problem with pgaccess 0.93
Hi, sorry if it was asked/answered before, but i just tested pgaccess 0.93 (excellent work by the way !) with postgres 6.3 and it does not work. Should it ? or should i use 6.4 ? Previous version (0.6 i think) of pgaccess works without problems. Details: -Debian 2.0 on Intel Pentium -at startup i have an error message -after that everything seem to work except (and that's a big problem) i'm unable to view the tables: i can view the list of tables but not the data inside them. It opens the view but then gives an error message and seems to sit in an endless loop, without showing anything. If it's not something already seen, i would be happy to help as much as possible to debug it. (i can not give more details like error messages and such as i'm at home and the problem is at work, but i could if necessary) I'd love to have 0.93 running because the functionnality of removing/changing fields in tables is very useful in early databases development. Thanks for your help, Patrick /\//\/\/\\/\/\//\/\\/\/\\/\\/\//\/\\/\//\/\\/\//\/\\/\//\/\\ Patrick M. pat@patoche.org http://www.patoche.org/
pat@patoche.org wrote: > > Hi, > > sorry if it was asked/answered before, but i just tested pgaccess 0.93 > (excellent work by the way !) with postgres 6.3 and it does not work. PgAccess 0.93 is working fine with PostgreSQL 6.4.x due to some changes in libpgtcl ! There is a small patch that you have to make in order to make it work with 6.3.2! So, in order to make PgAccess 0.93 work with PostgreSQL 6.3.x you should : replace in procedure wpg_exec the following line: set pgsql(errmsg) [pg_result $pgsql(res) -error] with this one : set pgsql(errmsg) "NO ERROR INFORMATION SUPPLIED" And it will work fine! In some error cases, you will not get the appropriate error message from libpgtcl. Tell me if that works! All the best, -- Constantin Teodorescu FLEX Consulting Braila, ROMANIA
On 11-Jan-99, Constantin Teodorescu took time to write : >> sorry if it was asked/answered before, but i just tested pgaccess 0.93 >> (excellent work by the way !) with postgres 6.3 and it does not work. > > PgAccess 0.93 is working fine with PostgreSQL 6.4.x due to some changes > in libpgtcl ! > There is a small patch that you have to make in order to make it work > with 6.3.2! > > So, in order to make PgAccess 0.93 work with PostgreSQL 6.3.x you should: > > replace in procedure wpg_exec the following line: > > set pgsql(errmsg) [pg_result $pgsql(res) -error] > > with this one : > > set pgsql(errmsg) "NO ERROR INFORMATION SUPPLIED" yeah that worked very well ! thanks for your support. unfortunately i do not know tcl enough (that is not at all in fact) to add some kind of test, so that if people are running with 6.3.x it works. You should maybe think of adding something like that to your code, in order to take care of that problem. Thanks again for your great software and your help Patrick /\//\/\/\\/\/\//\/\\/\/\\/\\/\//\/\\/\//\/\\/\//\/\\/\//\/\\ Patrick M. pat@patoche.org http://www.patoche.org/