>>[mailto:pgadmin-support-owner(at)postgresql(dot)org] On Behalf Of
>>Sent: 25 July 2005 22:33
>>Subject: Re: [pgadmin-support] Problems displaying data from
>>Query Tool and
>>Thanks for your reply, I also suspected that it has something
>>to do with
>>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
>>## --------- ##
>>## 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
>>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
>>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.
>---------------------------(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
happening. I am not a expert in threads, therefore it looks like a
\\|// From near to far,
@ @ from here to there,
---oOOo-(_)-oOOo--- funny things are everywhere. (Dr. Seuss)
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
In response to
pgadmin-support by date
|Next:||From: Alex Perry||Date: 2005-07-27 06:08:27|
|Subject: Re: Debian/Stable can't build rereqs for svn tree|
|Previous:||From: Dave Page||Date: 2005-07-26 13:38:32|
|Subject: Re: void frmMain::OnClose(wxCloseEvent&)|