Re: Problems displaying data from Query Tool and

>
>
>>-----Original Message-----
>>From: pgadmin-support-owner(at)postgresql(dot)org
>>[mailto:pgadmin-support-owner(at)postgresql(dot)org] On Behalf Of
>>Steve Martin
>>Sent: 25 July 2005 22:33
>>To: pgadmin-support(at)postgresql(dot)org
>>Subject: Re: [pgadmin-support] Problems displaying data from
>>Query Tool and
>>
>>Hello Dave,
>>
>>Thanks for your reply, I also suspected that it has something
>>to do with
>>the threading.
>>
>>I have compiled PostgreSQL with --enable-thread-safety
>>set and confirmed from the config.log that this option is set:
>>
>> :
>> :
>> It was created by PostgreSQL configure 8.0.3, which was
>>generated by GNU Autoconf 2.53. Invocation command line was
>>
>> $ ./configure --with-openssl --with-pam --enable-thread-safety
>>--enable-debug
>>
>>## --------- ##
>>## Platform. ##
>>## --------- ##
>>
>>hostname = xxxxx
>>uname -m = sun4u
>>uname -r = 5.9
>>uname -s = SunOS
>>uname -v = Generic_112233-07
>> :
>> :
>>configure:18926: checking thread safety of required library functions
>>configure:18951: gcc -o conftest -O2 -Wall -Wmissing-prototypes
>>-Wpointer-arith -fno-strict-aliasing -g -pthreads -pthreads
>>-D_REENTRANT -D_THREAD_SAFE -D_POSIX_PTHREAD_SEMANTICS -DIN_CONFIGURE
>>-I/usr/local/ssl/include conftest.c -lpam -lssl -lcrypto -lz
>>-lreadline -ltermcap -lrt -lresolv -lgen -lsocket -lnsl -ldl -lm
>>-lpthread -lpthread >&5
>>configure:18954: $? = 0
>>configure:18956: ./conftest
>>Your errno is thread-safe.
>>Your system uses strerror() which is thread-safe.
>>Your system has getpwuid_r(); it does not need getpwuid().
>>Your system has getaddrinfo(); it does not need gethostbyname()
>> or gethostbyname_r().
>>
>>Your platform is thread-safe.
>>configure:18959: $? = 0
>>configure:18961: result: yes
>>configure:19112: creating ./config.status
>> :
>> :
>>
>>I then re-made pgadmin, unfortunately, I still have the same
>>problems but I
>>suspect it has improved slightly. When using the Query
>>window, I now get
>>results more often than I did, but it still often fails.
>>Using the View
>>button
>>still results in 100% failure.
>>
>>I am using gdb to try and understand how this process works
>>but I can only
>>spend a short time at work looking at this problem. I have
>>no such problem
>>on my Linux (Fedora core 3) machine at home.
>>
>>
>>
>
>Hmm, you might also try increasing pgAdmin's debug level. I can remember
>how much logging is done by the query tools, but it might help. Look
>under File -> Options.
>
>Regards, Dave.
>
>---------------------------(end of broadcast)---------------------------
>TIP 6: explain analyze is your friend
>
>
>
Thanks Dave for the advice, I have been using the log, it indicates the
the query is
sent, but there is no data received, I have confirmed that it is being
sent. I now
understand some of the code and will modify to get more information on
what is
happening. I am not a expert in threads, therefore it looks like a
opportunity to
learn.

Regards, Steve

--
\\|// From near to far,
@ @ from here to there,
---oOOo-(_)-oOOo--- funny things are everywhere. (Dr. Seuss)
xXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXx
Steve Martin < smartin(at)wlg(dot)nec(dot)co(dot)nz > Cell 029-381 6291
Snail Mail Development, Telecom Unit, NEC New Zealand Ltd.,
PO Box 1936, Wellington, New Zealand.
Voice: +64-4-381 1111 Fax: +64-4-381 6262 DDI +64-4-381 6291
NEC NZ web site: http://www.nec.co.nz
xXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXx