Re: Problems displaying data from Query Tool and

> -----Original Message-----
> From: pgadmin-support-owner@postgresql.org
> [mailto:pgadmin-support-owner@postgresql.org] On Behalf Of
> Steve Martin
> Sent: 25 July 2005 22:33
> To: pgadmin-support@postgresql.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.