Re: [pgadmin-support] pgadmin go down when I want to start debug pl pgsql function
Dave Page píše v Po 13. 08. 2007 v 20:39 +0100: > > > --- Original Message --- > > From: Pavel Stěhule <[EMAIL PROTECTED]> > > To: pgAdmin Support > > Sent: 13/08/07, 19:36:26 > > Subject: [pgadmin-support] pgadmin go down when I want to start debug > > plpgsql function > > > > Hello > > > > this functionality works now? > > > > Yes. > > For anything more useful I'm afraid I need more clues than 'pgadmin go down' > - eg, server version? global or direct debugging? function definition? what > happens exactly and when in the debugging process? > > Regards, Dave I am sorry Dave. It was fast query, if has any sense test it. pgadmin3-src-20070814.tar.gz pgadmin3-1.8.0-beta3 PostgreSQL directory: /usr/local/pgsql PostgreSQL pg_config binary:/usr/local/pgsql/bin/pg_config PostgreSQL version: PostgreSQL 8.3devel PostgreSQL SSL support: Missing wxWidgets directory:/usr/local wxWidgets wx-config binary: /usr/local/bin/wx-config wxWidgets version: wxWidgets 2.8.4 libxml2 directory: /usr libxml2 xml2-config binary: /usr/bin/xml2-config libxml2 version:libxml2 2.6.29 libxslt directory: /usr libxslt xslt-config binary: /usr/bin/xslt-config libxslt version:libxslt 1.1.21 Building a debug version of pgAdmin:Yes Statically linking pgAdmin: No Building a Mac OS X appbundle: No platform fc7 === on right click over function item ./src/gtk/menu.cpp(984): assert "IsCheckable()" failed in IsChecked(): can't get state of uncheckable item! ASSERT INFO: ./src/gtk/menu.cpp(984): assert "IsCheckable()" failed in IsChecked(): can't get state of uncheckable item! BACKTRACE: [1] wxMenuItem::IsChecked() cons) [2] menuFactoryList::AppendEnabledMenus(wxMenuBar*, wxMenu*) /home/pavel/src/pgadmin3-1.8.0-beta3/pgadmin/./utils/factory.cpp:320 [3] frmMain::doPopup(wxWindow*, wxPoint, pgObject*) /home/pavel/src/pgadmin3-1.8.0-beta3/pgadmin/./frm/events.cpp:423 [4] frmMain::OnSelRightClick(wxTreeEvent&) /home/pavel/src/pgadmin3-1.8.0-beta3/pgadmin/./frm/events.cpp:506 [5] wxAppConsole::HandleEvent(wxEvtHandler*, void (wxEvtHandler::*)(wxEvent&), wxEvent&) cons) [6] wxEvtHandler::ProcessEventIfMatches(wxEventTableEntryBase const&, wxEvtHandler*, wxEvent&) [7] wxEventHashTable::HandleEvent(wxEvent&, wxEvtHandler*) [8] wxEvtHandler::ProcessEvent(wxEvent&) [9] wxEvtHandler::ProcessEvent(wxEvent&) [10] wxWindowBase::TryParent(wxEvent&) [11] wxEvtHandler::ProcessEvent(wxEvent&) [12] wxEvtHandler::ProcessEvent(wxEvent&) [13] wxScrollHelperEvtHandler::ProcessEvent(wxEvent&) [14] wxGenericTreeCtrl::OnMouse(wxMouseEvent&) [15] wxAppConsole::HandleEvent(wxEvtHandler*, void (wxEvtHandler::*)(wxEvent&), wxEvent&) cons) [16] wxEvtHandler::ProcessEventIfMatches(wxEventTableEntryBase const&, wxEvtHandler*, wxEvent&) [17] wxEventHashTable::HandleEvent(wxEvent&, wxEvtHandler*) [18] wxEvtHandler::ProcessEvent(wxEvent&) [19] wxEvtHandler::ProcessEvent(wxEvent&) [20] wxScrollHelperEvtHandler::ProcessEvent(wxEvent&) [21] wxWindow::GTKProcessEvent(wxEvent&) cons) [22] g_closure_invoke() [23] g_signal_emit_valist() [24] g_signal_emit() [25] gtk_propagate_event() [26] gtk_main_do_event() [27] g_main_context_dispatch() [28] g_main_loop_run() [29] gtk_main() [30] wxEventLoop::Run() [31] wxAppBase::MainLoop() After recompilation pgAdmin and wxWidget I can debug simple functions without problems (with one assert). With two parameters function pgadmin hangs before showing window with procedure params. (gdb) backtrace #0 0x0012d402 in __kernel_vsyscall () #1 0x00f4d206 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 #2 0x00ab5c0f in wxConditionInternal::Wait (this=0xa6ad7c0) at ./src/unix/threadpsx.cpp:379 #3 0x00ab5cd7 in wxCondition::Wait (this=0xa6ad78c) at ./include/wx/thrimpl.cpp:248 #4 0x00ab6c3c in wxSemaphoreInternal::Wait (this=0xa6ad788) at ./src/unix/threadpsx.cpp:511 #5 0x00ab6d3b in wxSemaphore::Wait (this=0xa6ad65c) at ./include/wx/thrimpl.cpp:304 #6 0x080d914b in dbgPgThread::Entry (this=0xa6ad648) at ./debugger/dbgPgThread.cpp:106 #7 0x00ab7dce in wxThreadInternal::PthreadStart (thread=0xa6ad648) at ./src/unix/threadpsx.cpp:766 #8 0x00ab7f39 in wxPthreadStart (ptr=0xa6ad648) at ./src/unix/threadpsx.cpp:718 #9 0x00f4944b in start_thread () from /lib/libpthread.so.0 #10 0x0102c80e in clone () from /lib/libc.so.6 CREATE OR REPLACE FUNCTION f3(character varying, boolean) RETURNS boolean AS ' begin return false; en
Re: [pgadmin-support] pgAdmin III v1.8.0 Beta 3 released
Le Monday 13 August 2007 16:50:08 Dave Page, vous avez écrit :
> Cousin Marc wrote:
> > Hi Dave,
> >
> > I just installed pgadmin3 and I'm having a problem : as soon as I right
> > click (on anything), I've got
> >
> > ASSERT INFO:
> > ./src/gtk/menu.cpp(984): assert "IsCheckable()" failed in IsChecked():
> > can't get state of uncheckable item!
> >
> > BACKTRACE:
> > [1] g_closure_invoke()
> > [2] g_signal_emit_valist()
> > [3] g_signal_emit()
> > [4] gtk_propagate_event()
> > [5] gtk_main_do_event()
> > [6] g_main_context_dispatch()
> > [7] g_main_loop_run()
> > [8] gtk_main()
> >
> >
> >
> > I'm on debian unstable, using a hand built pgadmin3 debian package.
> > I used wxwidgets 1.8.4, and built the whole thing by modifying the debian
> > rules and changelog files by hand to build the whole thing.
> > Is the problem coming from my installation ?
>
> I assume you mean wxWidgets *2*.8.4?
>
> I don't know anything about the debian rules or changelog files - what
> configure command line do they eventually execute?
>
> Regards, Dave
Yes I mean 2.8.4, sorry :) And sorry for the delay too ...
I'm using the provided debian rules file (in pkg subdirectory of pgadmin3),
slightly modified to use wxwidget 2.8.4
wxwidget 2.8.4 is built this way :
./configure --build=i486-linux-gnu \
--prefix=/usr/src/pgadmin3-1.8.0-beta3/wxWidgets-2.8.4/wxWidgets-2.8.4/localinst
\
--mandir=\${prefix}/share/man \
--infodir=\${prefix}/share/info \
--with-gtk --enable-gtk2 --enable-unicode \
--enable-debug \
--disable-shared
Then pgadmin3 is built like this :
CFLAGS="-Wall -g -O2" ./configure --host=i486-linux-gnu \
--build=i486-linux-gnu \
--prefix=/usr \
--mandir=\${prefix}/share/man \
--infodir=\${prefix}/share/info \
--disable-dependency-tracking \
--with-wx=/usr/src/pgadmin3-1.8.0-beta3/wxWidgets-2.8.4/wxWidgets-2.8.4/localinst
\
--with-wx-config=wx-config \
--with-pgsql-include="/usr/include/postgresql -I./include" \
--enable-gtk2 \
--enable-unicode \
--enable-debug --enable-static --with-libxml2=/usr
--with-libxslt=/usr
Thanks for your help
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
Re: [pgadmin-support] pgAdmin III v1.8.0 Beta 3 released
On 13/08/2007 20:21, Dave Page wrote: I wish you'd mentioned that before feature freeze (or reminded me if you did and I just forgot)!! No, I hadn't mentioned it before, I only just thought of it then. While it'd be nice to have, there's no rush on it and I certainly don't mean to increase your workload! :-) Ray. --- Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland [EMAIL PROTECTED] --- ---(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] pgAdmin III v1.8.0 Beta 3 released
On Tue, August 14, 2007 3:05 pm, Raymond O'Donnell wrote: > On 13/08/2007 20:21, Dave Page wrote: > >> I wish you'd mentioned that before feature freeze (or reminded me if >> you did and I just forgot)!! > > No, I hadn't mentioned it before, I only just thought of it then. While > it'd be nice to have, there's no rush on it and I certainly don't > mean to increase your workload! :-) Nah, it just seems like a cool feature, in line with a bunch of the other changes I made this cycle!! /D ---(end of broadcast)--- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate
Re: [pgadmin-support] pgAdmin III v1.8.0 Beta 3 released
On 14/08/2007 17:15, Dave Page wrote: Nah, it just seems like a cool feature, in line with a bunch of the other changes I made this cycle!! Yeah, it's handy alrightI came across it first in a nice little freebie text editor I use a lot (www.crimsoneditor.com), where ctrl-m comments and indents the currently-selected text. Maybe in pgAdmin 1.10...? :-) Ray. --- Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland [EMAIL PROTECTED] --- ---(end of broadcast)--- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate
Re: [pgadmin-support] pgAdmin III v1.8.0 Beta 3 released
On Tue, August 14, 2007 5:31 pm, Raymond O'Donnell wrote: > On 14/08/2007 17:15, Dave Page wrote: > >> Nah, it just seems like a cool feature, in line with a bunch of the >> other >> changes I made this cycle!! > > Yeah, it's handy alrightI came across it first in a nice little > freebie text editor I use a lot (www.crimsoneditor.com), where ctrl-m > comments and indents the currently-selected text. > > Maybe in pgAdmin 1.10...? :-) Make sure I don't forget!! :-) /D ---(end of broadcast)--- TIP 6: explain analyze is your friend
Re: [pgadmin-support] pgAdmin III v1.8.0 Beta 3 released
> On Tue, August 14, 2007 5:31 pm, Raymond O'Donnell wrote: > > Yeah, it's handy alrightI came across it first in a nice little > > freebie text editor I use a lot (www.crimsoneditor.com), where ctrl-m > > comments and indents the currently-selected text. I like the shortcut eclipse uses for toggling comments in java, and the reason I like it is that it uses the key you'd hit to start a comment. So how about Ctrl+hyphen for toggling comments in SQL, to add or remove -- from the start of each selected line? (I've written this without knowing whether that is already bound to anything.) Regards, Stephen. Disclaimer: At the Datamail Group we value team commitment, respect, achievement, customer focus, and courage. This email with any attachments is confidential and may be subject to legal privilege. If it is not intended for you please advise by reply immediately, destroy it and do not copy, disclose or use it in any way. __ This email has been scanned by the DMZGlobal Business Quality Electronic Messaging Suite. Please see http://www.dmzglobal.com/services/bqem.htm for details. __ ---(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] Using Quotation marks.
Hi Daniel!
On Aug 9, 1:01 pm, [EMAIL PROTECTED] ("Daniel Mendes")
wrote:
(...)
> I am using postgres installed in two different computers, in one I
> have to do the queries using quotation marks (select * from "Table")
> and in the other I can do select * from Table.
> What can I do to disable the use of quotation marks?
Without double-quotes identifiers are always cast to lower case before
execution. You might want to read this chapter of the docs on
identifiers and keywords:
http://www.postgresql.org/docs/8.2/static/sql-syntax-lexical.html#SQL-SYNTAX-IDENTIFIERS
Also, you'd better not use reserved words as identifiers. If you do,
you have to double-quote those every time.
http://www.postgresql.org/docs/8.2/static/sql-keywords-appendix.html
In any case, this is probably not the right list for your questions.
Try or .
Regards
Erwin
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
