pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedproblem with pgaccess 0.93
3+ messages / 2 participants
[nested] [flat]
* problem with pgaccess 0.93
@ 1999-01-10 14:59 pat@patoche.org
0 siblings, 1 reply; 3+ messages in thread
From: pat@patoche.org @ 1999-01-10 14:59 UTC (permalink / raw)
To: pgsql-interfaces
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/
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: [INTERFACES] problem with pgaccess 0.93
@ 1999-01-11 07:50 Constantin Teodorescu <teo@flex.ro>
parent: pat@patoche.org
0 siblings, 1 reply; 3+ messages in thread
From: Constantin Teodorescu @ 1999-01-11 07:50 UTC (permalink / raw)
To: pgsql-interfaces
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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: [INTERFACES] problem with pgaccess 0.93
@ 1999-01-13 20:50 pat@patoche.org
parent: Constantin Teodorescu <teo@flex.ro>
0 siblings, 0 replies; 3+ messages in thread
From: pat@patoche.org @ 1999-01-13 20:50 UTC (permalink / raw)
To: Constantin Teodorescu <teo@flex.ro>; +Cc: pgsql-interfaces
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/
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~1999-01-13 20:50 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1999-01-10 14:59 problem with pgaccess 0.93 pat@patoche.org
1999-01-11 07:50 ` Constantin Teodorescu <teo@flex.ro>
1999-01-13 20:50 ` pat@patoche.org
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox