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?
--
---
Colin Beckingham
613-454-5369
http://www.it4gh.com
