New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Issue when dropping view and then create another view with same name #398

Closed
mclaeysb opened this Issue Jun 28, 2017 · 2 comments

Comments

Projects
None yet
2 participants
@mclaeysb

mclaeysb commented Jun 28, 2017

When I drop a view, and immediately after create a new view with the same name but different SQL definition, then it takes the SL definition from the first view.

Not shure if it's only me or if others also have this problem?

I'm doing this often, e.g. creating views called 'temp' to do some quick edits during which I only want to see a certain selection of columns (as a workaround for #236).

@jakob

This comment has been minimized.

Show comment
Hide comment
@jakob

jakob Jul 19, 2017

Owner

Thanks for the bug report! There was an error in the logic that invalidates cached table & view information. I've fixed the problem in build 1711 (download here)

The new version should work if you use the UI to delete the view. If you delete & replace the view in a SQL script, Postico won't detect it, and you'll still have to refresh manually.

Owner

jakob commented Jul 19, 2017

Thanks for the bug report! There was an error in the logic that invalidates cached table & view information. I've fixed the problem in build 1711 (download here)

The new version should work if you use the UI to delete the view. If you delete & replace the view in a SQL script, Postico won't detect it, and you'll still have to refresh manually.

@jakob jakob closed this Jul 19, 2017

@mclaeysb

This comment has been minimized.

Show comment
Hide comment
@mclaeysb

mclaeysb Jul 19, 2017

Awesome, thanks!

mclaeysb commented Jul 19, 2017

Awesome, thanks!

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment