From: | "pgAdmin Trac" <trac(at)code(dot)pgadmin(dot)org> |
---|---|
To: | |
Cc: | pgadmin-hackers(at)postgresql(dot)org |
Subject: | [pgAdmin III] #379: Graphical Query Builder bug |
Date: | 2012-09-23 13:51:41 |
Message-ID: | 056.8d9cffc8406e37e65b8212712a82ba83@code.pgadmin.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-hackers |
#379: Graphical Query Builder bug
-----------------------------+----------------------------------------------
Reporter: Bartosz Dmytrak | Owner: dpage
Type: bug | Status: new
Priority: minor | Milestone:
Component: pgadmin | Version: trunk
Keywords: querybuilder | Platform: all
-----------------------------+----------------------------------------------
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
--
Ticket URL: <http://code.pgadmin.org/trac/ticket/379>
pgAdmin III <http://code.pgadmin.org/trac/>
pgAdmin III
From | Date | Subject | |
---|---|---|---|
Next Message | Dave Page | 2012-09-23 13:51:47 | pgAdmin III commit: Revert "Unbreak GIT version stamp generation." |
Previous Message | pgAdmin Trac | 2012-09-23 13:50:19 | [pgAdmin III] #378: Editing table properties drops all foreign keys and recreates them |