Skip site navigation (1) Skip section navigation (2)

Re: Problems displaying data from Query Tool and

From: Steve Martin <smartin(at)nec(dot)co(dot)nz>
To: pgadmin-support(at)postgresql(dot)org
Subject: Re: Problems displaying data from Query Tool and
Date: 2005-07-26 20:04:07
Message-ID: 42E69737.5020709@nec.co.nz (view raw or flat)
Thread:
Lists: pgadmin-support
>
>
>>-----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


In response to

pgadmin-support by date

Next:From: Alex PerryDate: 2005-07-27 06:08:27
Subject: Re: Debian/Stable can't build rereqs for svn tree
Previous:From: Dave PageDate: 2005-07-26 13:38:32
Subject: Re: void frmMain::OnClose(wxCloseEvent&)

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group