From: | Bartosz Dmytrak <bdmytrak(at)gmail(dot)com> |
---|---|
To: | PgAdmin Support <pgadmin-support(at)postgresql(dot)org> |
Subject: | Graphical Query Builder bug |
Date: | 2012-09-13 20:09:09 |
Message-ID: | CAD8_UcZQFyejv8uQc=LHGcERo2X26jd8xOqS3tNVDeK+EBV93Q@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
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
regards,
Bartek
From | Date | Subject | |
---|---|---|---|
Next Message | Guillaume Lelarge | 2012-09-13 20:10:30 | Re: using libpq create database |
Previous Message | 墨香 | 2012-09-13 12:08:54 | using libpq create database |