Thread: pgAdmin III enhancement
Hello, Here is the description of the problem: When you open the query tool, it displays the current object script (in fact the bottom right window content). Closing thetool does not refresh the main interface, I understand this is too difficult to analyse the requests and refresh the concernedobjects. However, this causes a problem with the current object. Imagine you open the query tool, you modify the current object thenclose the tool. The object script (bottom right window) is not refreshed: OK. Now, if you re-open the query tool, itwill take the content of the bottom right window, so the old script. If you don't pay attention to that (imagine a bigfunction, this was my case), you modify the script but from the previous version. Enhancement: when you open the query tool, it would be helpful to refresh the current object script. Platform: Windows 2000 Language: French Distribution: binary Thanks, Stephane DROUARD
Stephane DROUARD wrote: >When you open the query tool, it displays the current object script (in fact the bottom right window content). Closing thetool does not refresh the main interface, I understand this is too difficult to analyse the requests and refresh the concernedobjects. > >However, this causes a problem with the current object. Imagine you open the query tool, you modify the current object thenclose the tool. The object script (bottom right window) is not refreshed: OK. Now, if you re-open the query tool, itwill take the content of the bottom right window, so the old script. If you don't pay attention to that (imagine a bigfunction, this was my case), you modify the script but from the previous version. >Enhancement: when you open the query tool, it would be helpful to refresh the current object script. > > If the query tool's feature to get the currently selected object's script, you can disable this in options. The query tool can't know what you're doing, because it's meant for arbitrary queries. It's completely inacceptable to issue a complete refresh of the main window after each execute, which is what you're requesting in consequence. But you can do this yourself (F5 key on the object: table, schema, or even database). When using the property dialogs, which I'd recommend for minor changes, pgadmin knows what you're doing, and will refresh the tree after the change is successfully stored. Regards, Andreas
Stephane DROUARD wrote: >This was not my request. I have just proposed to refresh the CURRENT object >BEFORE opening the query tool. > > > Hi Stephane, this could well mean to refresh schema or database, thus might take a long time. Regards, Andreas
Hi Andreas, Thank you for your answer. I would just clarify something. You wrote: "It's completely inacceptable to issue a complete refresh of the main window after each execute, which is what you're requesting in consequence." This was not my request. I have just proposed to refresh the CURRENT object BEFORE opening the query tool. Regards, Stephane -----Original Message----- From: Andreas Pflug [mailto:pgadmin@pse-consulting.de] Sent: vendredi 28 novembre 2003 19:21 To: Stephane DROUARD Cc: pgadmin-support@postgresql.org Subject: Re: [pgadmin-support] pgAdmin III enhancement Stephane DROUARD wrote: >When you open the query tool, it displays the current object script (in >fact the bottom right window content). Closing the tool does not >refresh the main interface, I understand this is too difficult to >analyse the requests and refresh the concerned objects. > >However, this causes a problem with the current object. Imagine you >open the query tool, you modify the current object then close the tool. The object script (bottom right window) is not refreshed: OK. Now, if you re-open the query tool, it will take the content of the bottom right window, so the old script. If you don't pay attention to that (imagine a big function, this was my case), you modify the script but from the previous version. >Enhancement: when you open the query tool, it would be helpful to refresh the current object script. > > If the query tool's feature to get the currently selected object's script, you can disable this in options. The query tool can't know what you're doing, because it's meant for arbitrary queries. It's completely inacceptable to issue a complete refresh of the main window after each execute, which is what you're requesting in consequence. But you can do this yourself (F5 key on the object: table, schema, or even database). When using the property dialogs, which I'd recommend for minor changes, pgadmin knows what you're doing, and will refresh the tree after the change is successfully stored. Regards, Andreas