On Thu, 2012-09-13 at 22:09 +0200, Bartosz Dmytrak wrote: > Hi All > Today I decided to build a query using Query Builder functionality of > pgAdmin, so I switched to Graphical Query Builder tab and did > some clicking Few seconds later I received something like this: > > SELECT > jpga_servergroups.groupid, > jpga_servergroups.groupname, > jpga_servergroups.caption > FROM > "MyShema".jpga_servergroups > WHERE > jpga_servergroups.rolid = 1 > ORDER BY > jpga_servergroups.groupname ASC; > > What was fine. Then I noticed there is a long table name before each > column, so I decided to add alias for a table. I switched again to GQB, I > added alias and problem appeared. SQL generated was like this one: > > SELECT > s.groupid, > s.groupname, > s.caption > FROM > "MyShema".jpga_servergroups s > WHERE > *jpga_servergroups.rolid = 1* > ORDER BY > s.groupname ASC; > > WHERE condition wasn't updated, so it is not a correct statement. > > env: > pgAdmin III 1.16.0 > Mandriva Linux 64 bit >
I reproduce this. I added a ticket to work on it later. -- Guillaume http://blog.guillaume.lelarge.info http://www.dalibo.com -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support
