Postgres Pro
Downloads
Home   >   mailing lists

Thread: Editing outdated script

Editing outdated script

From
Aleksey Chirkin
Date:
Hi!

Sometimes when working with SQL Editor I'm having some problems.
This is due to the fact that I forget to press the refresh button
before opening the SQL Edirot. This leads to the fact that I get a old
script. And after editing it, I lose some data introduced me as
before.

For example, create any sql function.
Then open "Create script" from context menu.
Change the function and run script.
When you look to the function in object browser, you will not see changes.
And when you open "Create script" again, you get the old script.

This is bad for me, becouse I lose some data, and I just did not notice.

Maybe you should think about preventing the user of stale data, or
forced refresh before creating script.

Regards,
Aleksey

Re: Editing outdated script

From
Aleksey Chirkin
Date:
I think that auto recreating sql script when an object is selected
would be cool.

2011/6/10 Aleksey Chirkin <a4irkin@gmail.com>
>
> Hi!
>
> Sometimes when working with SQL Editor I'm having some problems.
> This is due to the fact that I forget to press the refresh button
> before opening the SQL Edirot. This leads to the fact that I get a old
> script. And after editing it, I lose some data introduced me as
> before.
>
> For example, create any sql function.
> Then open "Create script" from context menu.
> Change the function and run script.
> When you look to the function in object browser, you will not see changes.
> And when you open "Create script" again, you get the old script.
>
> This is bad for me, becouse I lose some data, and I just did not notice.
>
> Maybe you should think about preventing the user of stale data, or
> forced refresh before creating script.
>
> Regards,
> Aleksey

Re: Editing outdated script

From
Guillaume Lelarge
Date:
On Wed, 2011-07-13 at 12:55 +0400, Aleksey Chirkin wrote:
> I think that auto recreating sql script when an object is selected
> would be cool.
> 

And a sure way to lose performance.

Anyways, Andreas Scherbaum, Dave Page and I spoke about that a few days
ago, during char(11), and it's possible we'll try to do something like
that (automatically refreshing properties, and so the SQL script).

Patch welcome.


-- 
Guillaume http://blog.guillaume.lelarge.info http://www.dalibo.com