[pgadmin-support] Change email request
Hi, I'm registered with email [EMAIL PROTECTED] Can that be changed to [EMAIL PROTECTED] or do I need to re-register? I'm interested in the pgsql-admin posts. I'd like the email to continue to [EMAIL PROTECTED], but I'd like to send posts to the list from [EMAIL PROTECTED] If I have to do one or the other, please change my email to [EMAIL PROTECTED] THANKS! D.J. Kavan (301)680-9770 x218 Information in this e-mail may be confidential. It is intended only for the addressee(s) identified above. If you are not the addressee(s), or an employee or agent of the addressee(s), please note that any dissemination, distribution, or copying of this communication is strictly prohibited. If you have received this e-mail in error, please notify the sender of the error. ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings
pgadmin-support@postgresql.org
Am I missing something here? if g++ -DHAVE_CONFIG_H -I. -I. -I.. -DDATA_DIR=\"/usr/share/pgadmin3/\" -Wall -g -I../src/include -I../src/agent/include -I/usr/include -DSSL -I/usr/lib/wx/include/gtk2-unicode-release-static-2.6 -I/usr/include/wx-2.6 -DGTK_NO_CHECK_CASTS -D__WXGTK__ -D_FILE_OFFSET_BITS=64 -D_LARGE_FILES -D_LARGEFILE_SOURCE=1 -DDATA_DIR=\"/usr/share/pgadmin3/\" -Wall -g -I../src/include -I../src/agent/include -O2 -mcpu=i686 -march=i686 -mmmx -msse -m3dnow -mfpmath=sse,387 -MT events.o -MD -MP -MF ".deps/events.Tpo" -c -o events.o `test -f 'ui/events.cpp' || echo './'`ui/events.cpp; \ then mv -f ".deps/events.Tpo" ".deps/events.Po"; else rm -f ".deps/events.Tpo"; exit 1; fi ui/events.cpp: In member function `void frmMain::OnClose(wxCloseEvent&)': ui/events.cpp:172: error: `Node' is not a member of type `windowList' ui/events.cpp:172: error: `node' undeclared (first use this function) ui/events.cpp:172: error: (Each undeclared identifier is reported only once for each function it appears in.) make[2]: *** [events.o] Error 1 make[2]: Leaving directory `/usr/src/pgadmin3-1.2.2/src' make[1]: *** [all-recursive] Error 1 make[1]: Leaving directory `/usr/src/pgadmin3-1.2.2' make: *** [all] Error 2 ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
pgadmin-support@postgresql.org
What version of pgAdmin/wx is this? Have you tried 'make clean' and then recompilng? Regards, Dave. > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of > Dennis Veatch > Sent: 25 July 2005 20:27 > To: pgadmin-support@postgresql.org > Subject: [pgadmin-support] void frmMain::OnClose(wxCloseEvent&) > > Am I missing something here? > > if g++ -DHAVE_CONFIG_H -I. -I. -I.. > -DDATA_DIR=\"/usr/share/pgadmin3/\" -Wall > -g -I../src/include -I../src/agent/include -I/usr/include -DSSL > -I/usr/lib/wx/include/gtk2-unicode-release-static-2.6 > -I/usr/include/wx-2.6 > -DGTK_NO_CHECK_CASTS -D__WXGTK__ -D_FILE_OFFSET_BITS=64 > -D_LARGE_FILES > -D_LARGEFILE_SOURCE=1 -DDATA_DIR=\"/usr/share/pgadmin3/\" -Wall -g > -I../src/include -I../src/agent/include -O2 -mcpu=i686 > -march=i686 -mmmx > -msse -m3dnow -mfpmath=sse,387 -MT events.o -MD -MP -MF > ".deps/events.Tpo" -c > -o events.o `test -f 'ui/events.cpp' || echo './'`ui/events.cpp; \ > then mv -f ".deps/events.Tpo" ".deps/events.Po"; else rm -f > ".deps/events.Tpo"; exit 1; fi > ui/events.cpp: In member function `void > frmMain::OnClose(wxCloseEvent&)': > ui/events.cpp:172: error: `Node' is not a member of type `windowList' > ui/events.cpp:172: error: `node' undeclared (first use this function) > ui/events.cpp:172: error: (Each undeclared identifier is > reported only once > for >each function it appears in.) > make[2]: *** [events.o] Error 1 > make[2]: Leaving directory `/usr/src/pgadmin3-1.2.2/src' > make[1]: *** [all-recursive] Error 1 > make[1]: Leaving directory `/usr/src/pgadmin3-1.2.2' > make: *** [all] Error 2 > > ---(end of > broadcast)--- > TIP 1: if posting/reading through Usenet, please send an appropriate >subscribe-nomail command to [EMAIL PROTECTED] > so that your >message can get through to the mailing list cleanly > ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [pgadmin-support] errorreport: try to add a column
Erwin Moller wrote: > Hi group, Hi Erwin, > I hope I give you all the information needed to fix this. > I am not really a guru, so if you miss anything, just let me know. Your report is well detailed! You are the second person here to post something related to debian/sarge and a wxWidgets assert that I can't reproduce. The first one was Jan (CCed). May I ask for more details? What graphical environment are you using? KDE? Gnome? Something else? If KDE, is the package 'gtk2-engines-gtk-qt' installed and configured (check this with 'dpkg -l gtk2-engines-gtk-qt' it should give you a line with 'ii' in it's begining). If gtk2-engines-gtk-qt installed, can you give me the parameters configured in the KDE control center under "GTK Styles and fonts"? May I ask that you try with the following three packages available from here: http://www.enrici.com/pgadmin/debian/1.3.0/20050724/pgadmin3_1.3.0-0.1.svn20050724_i386.deb http://www.enrici.com/pgadmin/debian/1.3.0/20050724/pgadmin3-data_1.3.0-0.1.svn20050724_all.deb http://www.enrici.com/pgadmin/debian/1.3.0/20050724/libwxgtk2.6-0_2.6.1.0-0.pgadmin3.sarge.1_i386.deb (just DL then dpkg -i *.deb) @Andreas, any track to follow while reading the assert? Regards, Raphaël > > System: Debian Sarge > Postgres installed with apt-get. Version 7.4.7 > I installed PGADMIN3 also via apt-get from: > deb > ftp://ftp.nl.postgresql.org/pub/mirror/postgresql/pgadmin3/release/debian > sarge pgadmin > > The install went painless (as usual with apt-get. :-) > > I did the following WITHOUT PGADMIN3: > created a table called tbltest from psql commandline: > create table tbltest( > testid SERIAL PRIMARY KEY, > naam text); > > Then I started PGADMIN3 and connected as dbowner (erwin). > All OK so far. > I could browse the tables, etc. No errors. > > When I tried to add a new column (a column named 'geboortedatum' of type > date), I got the following warning. > Actually I receive such a warning for every column I try to add. > > --- > > src/common/string.cpp(2406): assert "wxAssertFailure" failed: bad index in > wxArrayString::Remove > > Call stack: > [05] wxStackWalker::Walk(unsigned) > [06] 0x4078cea8 > [07] wxAppConsole::OnAssert(wchar_t const*, int, wchar_t const*, wchar_t > const*) > [08] wxApp::OnAssert(wchar_t const*, int, wchar_t const*, wchar_t const*) > [09] wxOnAssert(wchar_t const*, int, wchar_t const*, wchar_t const*) > [10] wxAssert(int, wchar_t const*, int, wchar_t const*, wchar_t const*) > [11] wxArrayString::RemoveAt(unsigned, unsigned) > [12] 0x0819dc16 > [13] 0x081a1556 > [14] 0x081a27f3 > [15] wxAppConsole::HandleEvent(wxEvtHandler*, void > (wxEvtHandler::*)(wxEvent&), wxEvent&) const > [16] wxEvtHandler::ProcessEventIfMatches(wxEventTableEntryBase const&, > wxEvtHandler*, wxEvent&) > [17] wxEventHashTable::HandleEvent(wxEvent&, wxEvtHandler*) > [18] wxEvtHandler::ProcessEvent(wxEvent&) > [19] wxWindowBase::TryParent(wxEvent&) > [20] wxEvtHandler::ProcessEvent(wxEvent&) > [21] wxWindowBase::TryParent(wxEvent&) > [22] wxEvtHandler::ProcessEvent(wxEvent&) > [23] wxWindowBase::TryParent(wxEvent&) > [24] wxEvtHandler::ProcessEvent(wxEvent&) > [25] 0x404e4573 > Do you want to stop the program? > You can also choose [Cancel] to suppress further warnings. > > --- > > > I answered 'NO' and all was fine from there on. The new column was created > just fine. > > What is wrong? > Should I give you more information? > > Thanks for your time! > > Regards, > Erwin Moller ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
Re: [pgadmin-support] Problems displaying data from Query Tool and View/Edit Data Tool.
Hi Steve,
The main difference between those tools and the rest of the code is that
they execute their queries in a separate thread.
I wonder if PostgreSQL needs to be compiled with --enable-thread-safety
on Solaris for pgAdmin to work as it should?
Regards, Dave.
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of
> Steve Martin
> Sent: 25 July 2005 05:58
> To: pgadmin-support@postgresql.org
> Subject: [pgadmin-support] Problems displaying data from
> Query Tool and View/Edit Data Tool.
>
> Hi All,
>
> I have problems when using the "Edit Window" and "Query Window". It
> seems that for some reason the recv is exiting early with the
> reception of a EAGAIN (Resource temporarily unavailable) signal.
> Refer to the truss output below. This results in no data being
> displayed. For the query window, data will be intermittently be
> displayed. There is 3 rows of data. For the "Edit Data" window, if
> selected via the menu (Tools->View Data), data will sometimes be
> displayed, but when the "View Data" bottom is pressed, the Edit Window
> is displayed with no column or row data and the text "aborting" is
> displayed at the bottom left of the window.
>
> Has anyone any ideas whether what would cause this and/or how to
> isolate the cause. There seems to be no problem with gathering data
> on the set-up of the database.
>
> This were obtained when "F5" (Execute) was pressed in the sql query
> window, no data displayed. The following is a truss of the pgadmin
> process.
>
> 23191: lwp_create(0xFFBFD868, LWP_SUSPENDED, 0xFFBFD864) = 102
> 23191/1:lwp_continue(102) = 0
> 23191/102: lwp_create()(returning as new lwp ...) = 0
> 23191/102: lwp_schedctl(SC_STATE|SC_PREEMPT, 0, 0xFE0FBBBC) = 0
> 23191/102: time()
> = 1122264710
> 23191/102: getpid()
> = 23191
> [23441]
> 23191/102: open64("pgadmin.log",
> O_WRONLY|O_APPEND|O_CREAT, 0666) = 9
> 23191/102: llseek(9, 0, SEEK_END)
> = 2255822
> 23191/102: fstat64(9, 0xFE0FB948) = 0
> 23191/102: fstat64(9, 0xFE0FB7F0) = 0
> 23191/102: ioctl(9, TCGETA, 0xFE0FB8D4)
> Err#25
> ENOTTY
> 23191/102: write(9, 0x011B3074, 65)= 65
> 23191/102: 2 0 0 5 - 0 7 - 2 5 1 6 : 1 1 : 5 0 I
> N F O
> : R u n
> 23191/102: n i n g q u e r y s e l e c t * f
> r o m w e
> a t h e r
> 23191/102:\n
> 23191/102: close(9)= 0
> 23191/102: time()
> = 1122264710
> 23191/102: getpid()
> = 23191
> [23441]
> 23191/102: open64("pgadmin.log",
> O_WRONLY|O_APPEND|O_CREAT, 0666) = 9
> 23191/102: llseek(9, 0, SEEK_END)
> = 2255887
> 23191/102: fstat64(9, 0xFE0FB958) = 0
> 23191/102: fstat64(9, 0xFE0FB800) = 0
> 23191/102: ioctl(9, TCGETA, 0xFE0FB8E4)
> Err#25
> ENOTTY
> 23191/102: write(9, 0x011B3074, 64)= 64
> 23191/102: 2 0 0 5 - 0 7 - 2 5 1 6 : 1 1 : 5 0 Q
> U E R Y
> : T h r
> 23191/102: e a d Q u e r y s e l e c t * f r
> o m w e a
> t h e r\n
> 23191/1:write(6, 0x00BA8A08, 2832) = 2832
> 23191/1: 12\0\007\0 x L O\0\001AD\0\0\006
> 03\004\0\0\001 L 089
> y 8 x\005
> 23191/1: \0 x\0 E\0\b80\0\0\0\0\0\0\0\0\0 8FF\004\0 x\0
> F\0\b\0\0\0\0\0\0
> :
> :
> 23191/1: 02 ?\0D4 ;03\005\0 x\0 #\0\0\0\0\0\0\0\002 P\0E6
> >03\007\0 x ` k
> 23191/1: \0 x L g\0 x\0 #\0\0\0\0\0\0\0\002 P\0E6
> 8\0\004\0 x\0
> #\0\b\0\0
> 23191/1: \0\0\0\0 6 x\002\0 x ` k +9B\001
> 23191/102: close(9)= 0
> 23191/102: sigaction(SIGPIPE, 0xFE0FB9E0, 0xFE0FBB00) = 0
> 23191/102: send(8, 0x0105E878, 27, 0) = 27
> 23191/102: Q\0\0\01A s e l e c t * f r o m w e
> a t h e r\0
> 23191/102: sigaction(SIGPIPE, 0xFE0FB9E0, 0xFE0FBB00) = 0
> 23191/102: recv(8, 0x0105A870, 16384, 0) = 304
> 23191/102: T\0\0\07F\005 c i t y\0\012
> NC4\001\0\00413\0\0\0
> T\0\0 t e
> 23191/102: m p _ l o\0\012
> NC4\002\0\0\017\004\0\0 t e m
> p _ h i\0
> 23191/102:\012 NC4\003\0\0\017\004\0\0 p r c p\0\012
> NC4\004\0\002
> 23191/102:BC\004\0\0 d a t e\0\012 NC4\005\0\004
> :\004\0\0
> 23191/102: D\0\0\0 6\005\0\0\0\r S a n F r a n c i s c
> o\0\0\002 4 1\0\0
> 23191/102:\002 5 5\0\0\001 0\0\0\0\n 1 9 9 4 -
pgadmin-support@postgresql.org
On Monday 25 July 2005 03:56 pm, Dave Page wrote: > What version of pgAdmin/wx is this? Have you tried 'make clean' and then > recompilng? > pgadmin 1.2.2 and wxGTK/wxWidgets 2.6.1 make clean in pgadmin? > Regards, Dave. > > > -Original Message- > > From: [EMAIL PROTECTED] > > [mailto:[EMAIL PROTECTED] On Behalf Of > > Dennis Veatch > > Sent: 25 July 2005 20:27 > > To: pgadmin-support@postgresql.org > > Subject: [pgadmin-support] void frmMain::OnClose(wxCloseEvent&) > > > > Am I missing something here? > > > > if g++ -DHAVE_CONFIG_H -I. -I. -I.. > > -DDATA_DIR=\"/usr/share/pgadmin3/\" -Wall > > -g -I../src/include -I../src/agent/include -I/usr/include -DSSL > > -I/usr/lib/wx/include/gtk2-unicode-release-static-2.6 > > -I/usr/include/wx-2.6 > > -DGTK_NO_CHECK_CASTS -D__WXGTK__ -D_FILE_OFFSET_BITS=64 > > -D_LARGE_FILES > > -D_LARGEFILE_SOURCE=1 -DDATA_DIR=\"/usr/share/pgadmin3/\" -Wall -g > > -I../src/include -I../src/agent/include -O2 -mcpu=i686 > > -march=i686 -mmmx > > -msse -m3dnow -mfpmath=sse,387 -MT events.o -MD -MP -MF > > ".deps/events.Tpo" -c > > -o events.o `test -f 'ui/events.cpp' || echo './'`ui/events.cpp; \ > > then mv -f ".deps/events.Tpo" ".deps/events.Po"; else rm -f > > ".deps/events.Tpo"; exit 1; fi > > ui/events.cpp: In member function `void > > frmMain::OnClose(wxCloseEvent&)': > > ui/events.cpp:172: error: `Node' is not a member of type `windowList' > > ui/events.cpp:172: error: `node' undeclared (first use this function) > > ui/events.cpp:172: error: (Each undeclared identifier is > > reported only once > > for > >each function it appears in.) > > make[2]: *** [events.o] Error 1 > > make[2]: Leaving directory `/usr/src/pgadmin3-1.2.2/src' > > make[1]: *** [all-recursive] Error 1 > > make[1]: Leaving directory `/usr/src/pgadmin3-1.2.2' > > make: *** [all] Error 2 > > > > ---(end of > > broadcast)--- > > TIP 1: if posting/reading through Usenet, please send an appropriate > >subscribe-nomail command to [EMAIL PROTECTED] > > so that your > >message can get through to the mailing list cleanly > > ---(end of broadcast)--- > TIP 1: if posting/reading through Usenet, please send an appropriate >subscribe-nomail command to [EMAIL PROTECTED] so that your >message can get through to the mailing list cleanly ---(end of broadcast)--- TIP 6: explain analyze is your friend
pgadmin-support@postgresql.org
> -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of > Dennis Veatch > Sent: 25 July 2005 21:46 > To: pgadmin-support@postgresql.org > Subject: Re: [pgadmin-support] void frmMain::OnClose(wxCloseEvent&) > > On Monday 25 July 2005 03:56 pm, Dave Page wrote: > > What version of pgAdmin/wx is this? Have you tried 'make > clean' and then > > recompilng? > > > pgadmin 1.2.2 and wxGTK/wxWidgets 2.6.1 OK, they /should/ both be OK. > make clean in pgadmin? Yes. If that doesn't work, what OS are you on? (forgot to ask last time!). Regards, Dave. ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings
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 = x
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/includeconftest.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.
Regards, Steve
Dave Page wrote:
Hi Steve,
The main difference between those tools and the rest of the code is that
they execute their queries in a separate thread.
I wonder if PostgreSQL needs to be compiled with --enable-thread-safety
on Solaris for pgAdmin to work as it should?
Regards, Dave.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
Steve Martin
Sent: 25 July 2005 05:58
To: pgadmin-support@postgresql.org
Subject: [pgadmin-support] Problems displaying data from
Query Tool and View/Edit Data Tool.
Hi All,
I have problems when using the "Edit Window" and "Query Window". It
seems that for some reason the recv is exiting early with the
reception of a EAGAIN (Resource temporarily unavailable) signal.
Refer to the truss output below. This results in no data being
displayed. For the query window, data will be intermittently be
displayed. There is 3 rows of data. For the "Edit Data" window, if
selected via the menu (Tools->View Data), data will sometimes be
displayed, but when the "View Data" bottom is pressed, the Edit Window
is displayed with no column or row data and the text "aborting" is
displayed at the bottom left of the window.
Has anyone any ideas whether what would cause this and/or how to
isolate the cause. There seems to be no problem with gathering data
on the set-up of the database.
This were obtained when "F5" (Execute) was pressed in the sql query
window, no data displayed. The following is a truss of the pgadmin
process.
23191: lwp_create(0xFFBFD868, LWP_SUSPENDED, 0xFFBFD864) = 102
23191/1:lwp_continue(102) = 0
23191/102: lwp_create()(returning as new lwp ...) = 0
23191/102: lwp_schedctl(SC_STATE|SC_PREEMPT, 0, 0xFE0FBBBC) = 0
23191/102: time()
= 1122264710
23191/102: getpid()
= 23191
[23441]
23191/102: open64("pgadmin.log",
O_WRONLY|O_APPEND|O_CREAT, 0666) = 9
23191/102: llseek(9, 0, SEEK_END)
= 2255822
23191/102: fstat64(9, 0xFE0FB948) = 0
23191/102: fstat64(9, 0xFE0FB7F0) = 0
23191/102: ioctl(9, TCGETA, 0xFE0FB8D4)
Err#25
ENOTTY
23191/102: write(9, 0x011B3074, 65)= 65
23191/102: 2 0 0 5 - 0 7 - 2 5 1 6 : 1 1 : 5 0 I
N F O
: R u n
23191/102: n i n g q u e r y s e l e c t * f
r o m w e
a t h e r
23191/102:\n
23191/102: close(9)= 0
23191/102: time()
= 1122264710
23191/102: getpid()
= 23191
[23441]
23191/102: open64("pgadmin.log",
O_WRONLY|O_APPEND|O_CREAT, 0666) = 9
23191/102: llseek(9, 0, SEEK_END)
= 2255887
23191/102: fstat64(9, 0xFE0FB958) = 0
23191/102: fstat64(9, 0xFE0FB800) = 0
pgadmin-support@postgresql.org
On Monday 25 July 2005 05:06 pm, Dave Page wrote: > > -Original Message- > > From: [EMAIL PROTECTED] > > [mailto:[EMAIL PROTECTED] On Behalf Of > > Dennis Veatch > > Sent: 25 July 2005 21:46 > > To: pgadmin-support@postgresql.org > > Subject: Re: [pgadmin-support] void frmMain::OnClose(wxCloseEvent&) > > > > On Monday 25 July 2005 03:56 pm, Dave Page wrote: > > > What version of pgAdmin/wx is this? Have you tried 'make > > > > clean' and then > > > > > recompilng? > > > > pgadmin 1.2.2 and wxGTK/wxWidgets 2.6.1 > > OK, they /should/ both be OK. > > > make clean in pgadmin? > > Yes. If that doesn't work, what OS are you on? (forgot to ask last > time!). > The make clean had no effect. The distro is a source based one - Lunar Linux, http://lunar-linux.org/ I have a compile log that includes the configure and make phases if you would like that. ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster
