Hi group,

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.

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/mirr...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(wxEventTableEn tryBase 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 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

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...50724_i386.deb
http://www.enrici.com/pgadmin/debian...050724_all.deb
http://www.enrici.com/pgadmin/debian...rge.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/mirr...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(wxEventTableEn tryBase 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