Re: [pgadmin-support] We just found another small bug in pgAdmin3
> -Original Message- > From: Justin Clift [mailto:[EMAIL PROTECTED] > Sent: 22 December 2003 06:01 > To: Dave Page > Cc: Danny Butler > Subject: We just found another small bug in pgAdmin3 > > Hi Dave, > > Danny (CC'd) here is learning PostgreSQL and PHP, and has > just been introduced to the wonders of pgAdmin 3. :) > > In the Data Grid, he's noticed that multiple rows can be > selected at once by holding down the Shift key, but if he > then goes and hits the delete icon only one of them is deleted. > > This is on a different PC from yesterday, and it's version of > pgAdmin is a development 1.1.0 snapshot from about a fortnight ago. > > Thought you'd like to know. Ahh, so it does. I'll forward this to the support list [hint hint :-) ]. Thanks, Dave. ---(end of broadcast)--- TIP 8: explain analyze is your friend
Re: [pgadmin-support] pgAdmin crashes when client_min_messages is
My Deja wrote: I am trying to get some query trees to appear in the PostgreSQL log and in order to that I have set client_min_messages = DEBUG1 in order to use the following settings debug_print_parse, debug_print_rewritten, or debug_print_plan which are required for the query tree to show up in the log. pgAdmin crashes whenever I set that option. I tried a few times and I am sure of it. I am using PostgreSQL 7.4 under Cygwin on a Windows 2000 machine, but I don't think that has any relevance. I can confirm this problem. Apparently the flood of debug notices will kill pgAdmin3 after a while. I'll have a deeper look into this later. Until then, do *not* set these options in postgresql.conf. Instead, set these options per user (if you want to observe a user *different* from the one you're using with pgAdmin3), or set these options in the query tool prior to executing your queries to inspect. Regards, Andreas ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
[pgadmin-support] Problems with editor
Hi! In query window I can't enter latvian special characters like "Å", "Å", etc. That is a real problem for me ;) Second thing is that when editing table data and if I insert new record from there and press button to save edited line it doesn't fill in column default values! Lafriks ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
Re: [pgadmin-support] We just found another small bug in pgAdmin3
Dave Page wrote: -Original Message- From: Justin Clift [mailto:[EMAIL PROTECTED] Sent: 22 December 2003 06:01 To: Dave Page Cc: Danny Butler Subject: We just found another small bug in pgAdmin3 Hi Dave, Danny (CC'd) here is learning PostgreSQL and PHP, and has just been introduced to the wonders of pgAdmin 3. :) In the Data Grid, he's noticed that multiple rows can be selected at once by holding down the Shift key, but if he then goes and hits the delete icon only one of them is deleted. This is on a different PC from yesterday, and it's version of pgAdmin is a development 1.1.0 snapshot from about a fortnight ago. Thought you'd like to know. Ahh, so it does. I'll forward this to the support list [hint hint :-) ]. A, I know... should join the list. It's just that there's no super easy way of joining a mailing list to report a bug and make sure that people know about it... without having all of the list traffic also come along for the ride. (Guess I'm in a lazy mood at the moment eh?) Ok, if we notice more bugs then we'll do it properly. :) Regards and best wishes, Justin Clift Thanks, Dave. -- Executive Director Digital Distribution Global Training Services Pty. Ltd. Premier OpenOffice.org Online Training providers http://www.digitaldistribution.com ---(end of broadcast)--- TIP 8: explain analyze is your friend
Re: [pgadmin-support] We just found another small bug in pgAdmin3
Justin Clift wrote: It's just that there's no super easy way of joining a mailing list to report a bug and make sure that people know about it... without having all of the list traffic also come along for the ride. There *is* a way, you can subscribe-nomail so your mail will go directly to the list. We usually CC the original sender so you would receive the answer in any case. If you don't subscribe, your mail to the mailing list will be stuck in a moderated queue, and suffer some delay until it's verified to be non-spam. Regards, Andreas ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
Re: [pgadmin-support] Problems with editor
Lauris BukÅis wrote: Hi! In query window I can't enter latvian special characters like "Å", "Å", etc. That is a real problem for me ;) I've heard that problem before, but can't imagine what should cause this. Which platform/version are you using? Second thing is that when editing table data and if I insert new record from there and press button to save edited line it doesn't fill in column default values! The Edit Grid shouldn't insert anything if you leave a field empty, thus forcing the backend to fill in default data. Please check in SQL logging if this works ok for you. Regards, Andreas ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
Re: [pgadmin-support] Problems with editor
Andreas Pflug wrote: Lauris BukÅis wrote: Hi! In query window I can't enter latvian special characters like "Å", "Å", etc. That is a real problem for me ;) I've heard that problem before, but can't imagine what should cause this. Which platform/version are you using? Win2K, pgAdminIII 1.0.2 also 1.1.0devel has the same problem. I think I had the same problem on Mandrake, too. Second thing is that when editing table data and if I insert new record from there and press button to save edited line it doesn't fill in column default values! The Edit Grid shouldn't insert anything if you leave a field empty, thus forcing the backend to fill in default data. Please check in SQL logging if this works ok for you. I know it should insert anything but after inserting it should display correctly what _is_ inserted including default values. Otherwise I have to close and reopen window to see what is realy inserted. Lafriks ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
[pgadmin-support] pgAdmin III - Database Migration Wizard Plugin
Hey List, Is there a DB Migration Wizard Plugin available for pgAdmin III. If not is there some equvilent functionality built into pgAdmin III? Or is this only available with pgAdmin II Thanks, Anthony Tanzola EMR Data Services Phone: 623.581.2875 Fax: 623.582.5499 [EMAIL PROTECTED] EMR Internet A Serious Internet Experience ** 56K Dial-up **DSL ** Web-hosting ** ** Co-location **T1s ** ISDN ** ** High-Speed Fiber Backbone ** Linux powered ** ** Support for all Windows & Linux platforms ** ** Custom Web Design ** Site Development ** ** Search Engine Placement & Web Consultation ** Visit us at http://www.emr.net! Ask about our reseller programs! ---(end of broadcast)--- TIP 8: explain analyze is your friend
Re: [pgadmin-support] pgAdmin III - Database Migration Wizard Plugin
> -Original Message- > From: Anthony Tanzola [mailto:[EMAIL PROTECTED] > Sent: 22 December 2003 20:24 > To: [EMAIL PROTECTED] > Subject: [pgadmin-support] pgAdmin III - Database Migration > Wizard Plugin > > Hey List, > > Is there a DB Migration Wizard Plugin available for pgAdmin > III. If not is there some equvilent functionality built into > pgAdmin III? Or is this only available with pgAdmin II Hi, Unfortunately there is no such functionality in pgAdmin III at the moment, though we do hope to add a data import/export tool in the future. Regards, Dave. ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
[pgadmin-support] 2003-12-11 snapshot crashes during new db creation
Hi All, I tried to add a new database to my server by right clicking the Databases node in the left hand treeview. It immediatelly crashed. Downgrading to the previous snapshot it worked fine. So there must be something with the ltest one. (WinXP, 12-11 snapshot, cygwin, posgres 7.3.2) Thanx. I wish you all a Merry Christmas. Bye, --Csaba Együd ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])