[pgadmin-hackers] Crash of the Option dialog
Dear friends, When opening the Option dialog, a warning message is displayed once every two openings (reproducable): /usr/include/wx/checkbox.h(70): assert "!Is3State()" failed: Calling IsChecked() doesn't make sense for a three state checkbox, Use Get3StateValue() instead Please find the log attached. Also, I don't understand why "2003-10-24 15:50:49 DEBUG : Mailcap file /etc/ mailcap, line 199: unknown field 'xmms '%s'' for the MIME type 'audio/mpeg' ignored." is in the log. Is this crash linked to a syslogd problem? Best regards, Jean-Michel 2003-10-24 15:50:43 INFO : ## 2003-10-24 15:50:43 INFO : # pgAdmin III Version 1.1.0 Devel Startup 2003-10-24 15:50:43 INFO : ## 2003-10-24 15:50:43 INFO : Compiled with OpenSSL 0.9.7c 30 Sep 2003 2003-10-24 15:50:43 INFO : Creating a splash screen 2003-10-24 15:50:43 INFO : Loading /usr/share/pgadmin3//ui/common/dlgIndexConstraint.xrc 2003-10-24 15:50:43 INFO : Loading /usr/share/pgadmin3//ui/common/dlgAggregate.xrc 2003-10-24 15:50:43 INFO : Loading /usr/share/pgadmin3//ui/common/dlgCast.xrc 2003-10-24 15:50:43 INFO : Loading /usr/share/pgadmin3//ui/common/dlgCheck.xrc 2003-10-24 15:50:43 INFO : Loading /usr/share/pgadmin3//ui/common/dlgColumn.xrc 2003-10-24 15:50:43 INFO : Loading /usr/share/pgadmin3//ui/common/dlgConversion.xrc 2003-10-24 15:50:43 INFO : Loading /usr/share/pgadmin3//ui/common/dlgDatabase.xrc 2003-10-24 15:50:43 INFO : Loading /usr/share/pgadmin3//ui/common/dlgDomain.xrc 2003-10-24 15:50:43 INFO : Loading /usr/share/pgadmin3//ui/common/dlgForeignKey.xrc 2003-10-24 15:50:43 INFO : Loading /usr/share/pgadmin3//ui/common/dlgFunction.xrc 2003-10-24 15:50:43 INFO : Loading /usr/share/pgadmin3//ui/common/dlgGroup.xrc 2003-10-24 15:50:43 INFO : Loading /usr/share/pgadmin3//ui/common/dlgIndex.xrc 2003-10-24 15:50:43 INFO : Loading /usr/share/pgadmin3//ui/common/frmAddTableView.xrc 2003-10-24 15:50:43 INFO : Loading /usr/share/pgadmin3//ui/common/dlgLanguage.xrc 2003-10-24 15:50:43 INFO : Loading /usr/share/pgadmin3//ui/common/dlgOperator.xrc 2003-10-24 15:50:43 INFO : Loading /usr/share/pgadmin3//ui/common/dlgRule.xrc 2003-10-24 15:50:43 INFO : Loading /usr/share/pgadmin3//ui/common/dlgSchema.xrc 2003-10-24 15:50:43 INFO : Loading /usr/share/pgadmin3//ui/common/dlgSequence.xrc 2003-10-24 15:50:43 INFO : Loading /usr/share/pgadmin3//ui/common/dlgTable.xrc 2003-10-24 15:50:43 INFO : Loading /usr/share/pgadmin3//ui/common/dlgTrigger.xrc 2003-10-24 15:50:43 INFO : Loading /usr/share/pgadmin3//ui/common/dlgType.xrc 2003-10-24 15:50:43 INFO : Loading /usr/share/pgadmin3//ui/common/dlgUser.xrc 2003-10-24 15:50:43 INFO : Loading /usr/share/pgadmin3//ui/common/dlgView.xrc 2003-10-24 15:50:43 INFO : Loading /usr/share/pgadmin3//ui/common/frmMaintenance.xrc 2003-10-24 15:50:43 INFO : Loading /usr/share/pgadmin3//ui/common/frmConnect.xrc 2003-10-24 15:50:43 INFO : Loading /usr/share/pgadmin3//ui/common/frmExport.xrc 2003-10-24 15:50:43 INFO : Loading /usr/share/pgadmin3//ui/common/dlgEditGridOptions.xrc 2003-10-24 15:50:43 INFO : Loading /usr/share/pgadmin3//ui/common/frmOptions.xrc 2003-10-24 15:50:43 INFO : Loading /usr/share/pgadmin3//ui/common/frmPassword.xrc 2003-10-24 15:50:43 INFO : Loading /usr/share/pgadmin3//ui/common/frmQBJoin.xrc 2003-10-24 15:50:43 INFO : Loading /usr/share/pgadmin3//ui/common/dlgJob.xrc 2003-10-24 15:50:43 INFO : Loading /usr/share/pgadmin3//ui/common/frmStatus.xrc 2003-10-24 15:50:43 INFO : Loading /usr/share/pgadmin3//ui/common/dlgSchedule.xrc 2003-10-24 15:50:43 INFO : Loading /usr/share/pgadmin3//ui/common/dlgStep.xrc 2003-10-24 15:50:43 INFO : Loading /usr/share/pgadmin3//ui/common/frmIndexcheck.xrc 2003-10-24 15:50:43 INFO : Using fontmetrics 9/18, 14 Point 2003-10-24 15:50:43 INFO : Native Description 'Bitstream Vera Sans 14' 2003-10-24 15:50:43 INFO : Draw size of 'M': w=13, h=18, descent 0, external lead 0. 2003-10-24 15:50:43 INFO : Draw size of 'g': w=9, h=18, descent 0, external lead 0. 2003-10-24 15:50:43 INFO : Draw size of 'Mg': w=22, h=18, descent 0, external lead 0. 2003-10-24 15:50:43 INFO : Creating a ctlSQLBox 2003-10-24 15:50:44 INFO : Creating a pgCollection object 2003-10-24 15:50:44 INFO : Reloading servers... 2003-10-24 15:50:44 INFO : Creating a pgServer object 2003-10-24 15:50:44 INFO : Creating a pgServer object 2003-10-24 15:50:44 INFO : Destroying a splash screen 2003-10-24 15:50:47 INFO : Creating an options dialogue 2003-10-24 15:50:49 DEBUG : Mailcap file /etc/mailcap, line 199: unknown field 'xmms '%s'' for the MIME type 'audio/mpeg' ignored. 2003-10-24 15:50:49 DEBUG : Mailcap file /etc/mailcap, line 200: unknown field 'xmms '%s'' for the MIME type 'audio/mpegurl' ignored. 2003-10-24 15:50:49 DEBUG : Mailcap file /etc/mailcap, line 201: unknown field 'xmms '%s'' for
[pgadmin-hackers] Font display bug under wxGTK-2.5.1
Dear friends, Just to notice the wxGTK-2.5.1 font bug present in pgAdmin3 is also present in poEdit. You can see screenshots of today's latest installations: http://snake.pgadmin.org/jean-michel/screenshots/poedit-crop.png http://snake.pgadmin.org/jean-michel/screenshots/pgadmin-crop.png Do recent versions of wxWindows correct this problem? Best regards, Jean-Michel ---(end of broadcast)--- TIP 3: 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-hackers] Migration from other database systems to PostgreSQL
Dear friends, Because PostgreSQL is a mature database, most new PostgreSQL users are certainly migrating from other systems (mainly Oracle, DB2, MySQL, MS SQL, etc...). So, if we offer solutions for migration, we can probably boost pgAdmin3. This is no news... At first, this could be only a migration of database schemas (tables, constraints, views, etc...). Not server-side languages like PL. In this context, I asked a question recently on hackers about the possibility to create custom data types in PostgreSQL mapping Oracle data types. For example, I asked if it was possible to mapp Oracle nvarchar2(lenght) to PostgreSQL varchar(lenght). The aswer is that it is not possible, because types like "varchar(lenght)" are hard coded into PostgreSQL parser. So, to date, the only solution to read an Oracle ASCII dump into PostgreSQL is to convert the data types manually. Search "nvarchar2(lenght)", Replace by "varchar(lenght)". No news ... now we come to the point. What if I added a "Migration" section on pgAdmin3 web site. At first, this section would only list type mappings for MySQL/Oracle/DB2/MS SQL with PostgreSQL types, as well as any information related to the migration of constraints, views and default values. In a (close?) future, this would allow pgAdmin3 to include a series of Regexp that would replace foreing data types with native PostgreSQL data types. What do you think? Best regards, Jean-Michel ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings
Re: [pgadmin-hackers] Migration from other database systems to PostgreSQL
Hi Jean-Michel, There is an item on the todo list to create some more advanced data management tools for pgAmdin. Andreas & I have discussed this briefly and felt it would be a separate program to pgAdmin (though packaged/distributed together) along the line of SQL Server's DTS. I would like to allow some sort of source and target plugins with a mapping/scriptable transformation service in between, perhaps using embedded Python or Perl. This would allow complete flexibility with the user being able to go to or from any supported data type which should include (at least) PostgreSQL (of course), CSV, ODBC and maybe XML. In the meantime, whilst your docs will be useful, I think that a more appropriate place for them is techdocs.postgresql.org... Regards, Dave. > -Original Message- > From: Jean-Michel POURE [mailto:[EMAIL PROTECTED] > Sent: 24 October 2003 15:56 > To: [EMAIL PROTECTED] > Subject: [pgadmin-hackers] Migration from other database > systems to PostgreSQL > > Dear friends, > > Because PostgreSQL is a mature database, most new PostgreSQL > users are certainly migrating from other systems (mainly > Oracle, DB2, MySQL, MS SQL, etc...). So, if we offer > solutions for migration, we can probably boost pgAdmin3. This > is no news... > > At first, this could be only a migration of database schemas > (tables, constraints, views, etc...). Not server-side > languages like PL. > > In this context, I asked a question recently on hackers about > the possibility to create custom data types in PostgreSQL > mapping Oracle data types. For example, I asked if it was > possible to mapp Oracle nvarchar2(lenght) to PostgreSQL > varchar(lenght). > > The aswer is that it is not possible, because types like > "varchar(lenght)" are hard coded into PostgreSQL parser. > > So, to date, the only solution to read an Oracle ASCII dump > into PostgreSQL is to convert the data types manually. Search > "nvarchar2(lenght)", Replace by "varchar(lenght)". > > No news ... now we come to the point. > > What if I added a "Migration" section on pgAdmin3 web site. > At first, this section would only list type mappings for > MySQL/Oracle/DB2/MS SQL with PostgreSQL types, as well as any > information related to the migration of constraints, views > and default values. > > In a (close?) future, this would allow pgAdmin3 to include a > series of Regexp that would replace foreing data types with > native PostgreSQL data types. > > What do you think? > Best regards, Jean-Michel > > > ---(end of > broadcast)--- > TIP 7: don't forget to increase your free space map settings > ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
Re: [pgadmin-hackers] Migration from other database systems to PostgreSQL
Le Vendredi 24 Octobre 2003 17:04, Dave Page a écrit : > I would like to allow some sort of source and target plugins with a > mapping/scriptable transformation service in between, perhaps using > embedded Python or Perl. I would call it Advanced advance :) How do you plan to connect to any database? Using which drivers? Is this why you mention ODBC? But ODBC has its own virtual types. Is it reliable? And not all Oracle database have ODBC (you must pay for it). Just for information, can you describe in more details? A good start might be to be able to read the dumps from Oracle, MySQL, DB2 and MsSQL. This would be a small revolution for PostgreSQL and would suit 90% needs of users. When this is achieved, and only then, you would go for more complex things. I feel (but I am only an average programmer as you know) that a series of regexp would suffice. Cheers, Jean-Michel ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings
Re: [pgadmin-hackers] Crash of the Option dialog
Jean-Michel POURE wrote: Dear friends, When opening the Option dialog, a warning message is displayed once every two openings (reproducable): /usr/include/wx/checkbox.h(70): assert "!Is3State()" failed: Calling IsChecked() doesn't make sense for a three state checkbox, Use Get3StateValue() instead Please find the log attached. Also, I don't understand why "2003-10-24 15:50:49 DEBUG : Mailcap file /etc/ mailcap, line 199: unknown field 'xmms '%s'' for the MIME type 'audio/mpeg' ignored." is in the log. Is this crash linked to a syslogd problem? I don't know what's happening, but we don't use mailcap stuff, nor threestate checkboxes. Obviously, the memory is corrupted, having the wxCHK_3STATE bit for a checkbox set. Can you have a look at the memory space of that checkbox? Maybe you can identify where the data comes from. Regards, Andreas ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
Re: [pgadmin-hackers] Migration from other database systems to PostgreSQL
Dave Page wrote: Hi Jean-Michel, There is an item on the todo list to create some more advanced data management tools for pgAmdin. Andreas & I have discussed this briefly and felt it would be a separate program to pgAdmin (though packaged/distributed together) along the line of SQL Server's DTS. I would like to allow some sort of source and target plugins with a mapping/scriptable transformation service in between, perhaps using embedded Python or Perl. Since we could use wxPython, this is first choice. I feel that we should have the python scripting engine implemented in pgAdmin3 quite soon; I've put in on the TODO list. Regards, Andreas ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
Re: [pgadmin-hackers] Migration from other database systems to PostgreSQL
> -Original Message- > From: Jean-Michel POURE [mailto:[EMAIL PROTECTED] > Sent: 24 October 2003 16:23 > To: Dave Page; [EMAIL PROTECTED] > Subject: Re: [pgadmin-hackers] Migration from other database > systems to PostgreSQL > > Le Vendredi 24 Octobre 2003 17:04, Dave Page a écrit : > > I would like to allow some sort of source and target plugins with a > > mapping/scriptable transformation service in between, perhaps using > > embedded Python or Perl. > > I would call it Advanced advance :) > > How do you plan to connect to any database? Using which > drivers? Is this why you mention ODBC? But ODBC has its own > virtual types. Is it reliable? And not all Oracle database > have ODBC (you must pay for it). Just for information, can > you describe in more details? Database wise, yes, it would be like the pga2 Migration Wizard, allowing you to map incoming ODBC types to outgoing types. > A good start might be to be able to read the dumps from > Oracle, MySQL, DB2 and MsSQL. This would be a small > revolution for PostgreSQL and would suit 90% needs of users. > When this is achieved, and only then, you would go for more > complex things. This is a slightly different approach - mine is more like the old migration wizard, expanded with DTS style transformations, and plugable data sources/targets. > I feel (but I am only an average programmer as you know) that > a series of regexp would suffice. For migrating from a dump maybe, but I want to import/export text, or script data transformations between existing tables on the same or different databases and so on. Don't expect this anytime real soon though - it's one of those ideas I would love to implement but have no real reason to actually do so Regards, Dave. ---(end of broadcast)--- TIP 8: explain analyze is your friend
Re: [pgadmin-hackers] Migration from other database systems to PostgreSQL
> -Original Message- > From: Andreas Pflug [mailto:[EMAIL PROTECTED] > Sent: 24 October 2003 16:34 > To: Dave Page > Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] > Subject: Re: [pgadmin-hackers] Migration from other database > systems to PostgreSQL > > Dave Page wrote: > > >Hi Jean-Michel, > > > >There is an item on the todo list to create some more advanced data > >management tools for pgAmdin. Andreas & I have discussed > this briefly > >and felt it would be a separate program to pgAdmin (though > >packaged/distributed together) along the line of SQL Server's DTS. > > > >I would like to allow some sort of source and target plugins with a > >mapping/scriptable transformation service in between, perhaps using > >embedded Python or Perl. > > > > > Since we could use wxPython, this is first choice. I feel > that we should have the python scripting engine implemented > in pgAdmin3 quite soon; I've put in on the TODO list. Currently I'd love to do the same, I'm just having a hard job figuring out what to use it for! Regards, Dave. ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
Re: [pgadmin-hackers] Migration from other database systems to PostgreSQL
Dave Page wrote: -Original Message- From: Andreas Pflug [mailto:[EMAIL PROTECTED] Sent: 24 October 2003 16:34 To: Dave Page Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: [pgadmin-hackers] Migration from other database systems to PostgreSQL Dave Page wrote: Hi Jean-Michel, There is an item on the todo list to create some more advanced data management tools for pgAmdin. Andreas & I have discussed this briefly and felt it would be a separate program to pgAdmin (though packaged/distributed together) along the line of SQL Server's DTS. I would like to allow some sort of source and target plugins with a mapping/scriptable transformation service in between, perhaps using embedded Python or Perl. Since we could use wxPython, this is first choice. I feel that we should have the python scripting engine implemented in pgAdmin3 quite soon; I've put in on the TODO list. Currently I'd love to do the same, I'm just having a hard job figuring out what to use it for! It's not for us, more for folks out there that want to contribute some fancy stuff. IMHO we could provide some python objects, representing pgAdmin objects (pgObject, frmMain) so a plugin could extend the tree seamlessly. Regards, Andreas ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
Re: [pgadmin-hackers] Crash of the Option dialog
Jean-Michel POURE wrote: Dear friends, When opening the Option dialog, a warning message is displayed once every two openings (reproducable): /usr/include/wx/checkbox.h(70): assert "!Is3State()" failed: Calling IsChecked() doesn't make sense for a three state checkbox, Use Get3StateValue() instead OK, I get this too. It lasts a bit longer with German locale, but it appears. Stay tuned. Regards, Andreas ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
[pgadmin-hackers] That ole 3state assertion
I changed chkbox->IsChecked() to chkbox->GetValue() now, which bypasses that assertion check. The question still is, why is the m_style flag corrupted? I stripped down the dialog code and the xrc down, and the problem persisted. So this is not a fix, but a workaround. The problem might arise in other locations again. Jean-Michel, I didn't get the mailcap message, please check the new frmOption.cpp on your system. Regards, Andreas ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
Re: [pgadmin-hackers] [wx-dev] Font display bug under wxGTK-2.5.1
Jean-Michel POURE wrote: Dear friends, Just to notice the wxGTK-2.5.1 font bug present in pgAdmin3 is also present in poEdit. You can see screenshots of today's latest installations: http://snake.pgadmin.org/jean-michel/screenshots/poedit-crop.png http://snake.pgadmin.org/jean-michel/screenshots/pgadmin-crop.png Do recent versions of wxWindows correct this problem? Is this problem persisting with our snapshot? If so, what metrics are logged? Regards, Andreas ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
[pgadmin-hackers] what about crash of 1.0.1 / SQL Help ?
Hi Andreas, I didn't get time to build the latest wx snapshot (20031010-5) and debian snapshots linked against 20031010-4 still crash when selecting text when you select text in sql help. Did you get time to look at this ? Is this the reason why 20031010-5 came out ? If yes do you think it is possible to build a rev 2 debian package of 1.0.1 against it ? Regards, Raphaël ---(end of broadcast)--- TIP 8: explain analyze is your friend
