Re: 1.15 : wxw 2.9.3 : Graphical SQL builder allows dup tables

On Fri, 2012-05-04 at 06:43 -0400, Colin Beckingham wrote:
> This is not exactly a bug, just a suggestion for improvement for usability.
> 
> When using the graphical query builder it is possible to add more than 
> one copy of the same table by dragging from the table inventory to the 
> design window. This is quite valid, sometimes you need that facility. 
> However it is only when you run the query that user gets the error that 
> there is a duplicate table.
> 
> The workaround is very simple, just assign the tables different aliases 
> and then the query runs fine.
> 
> The question is at what stage should user be warned that there is a 
> duplicate table? pgadmin has an impressively intelligent way of dealing 
> with some errors/warnings, popping a warning dialog which contains a 
> facility to suppress this type of error in future. I'm wondering if the 
> dup table error might fall into this category?

Yes, the GQB can already notice this when you drop the table in the
canvas. So I guess we either put a message or immediately add an alias.
The latter seems better to me because it's less intrusive. But I don't
feel particularly strongly about either of these solutions.


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