Обсуждение: Bug in Pgadmin III 1.2.0

Hi all,

I just wanted to report a small bug in PGAdmin III, probably regarding quoting.

In a PostgreSQL 8.0 database for a school, I have a table named "class" in a schema named exnr. When I do the
following:
right-click / properties on the table named "class", then "columns" "add",
enter any column name/type,
then click OK,
--then I get a messagebox "ERROR: syntax error at or near "someothercolumn" at character 111

Unfortunately, PGAdmin III does not show me the SQL generated, but I think that it probably does not put the table name
indouble quotes (as it should in the case of a table named "class") and then gives an error. The SQL generated should
be

ALTER TABLE exnr."class" ADD COLUMN mycolumnname varchar;

PGAdmin correctly shows this code in the lower right panel when clicking on the attribute in the tree at left.

Regards
--Marcel

Marcel Gsteiger wrote:
> Hi all,
> 
> I just wanted to report a small bug in PGAdmin III, probably regarding quoting.
> 
> In a PostgreSQL 8.0 database for a school, I have a table named "class" in a schema named exnr. When I do the
following:
> right-click / properties on the table named "class", then "columns" "add",
> enter any column name/type,
> then click OK,
> --then I get a messagebox "ERROR: syntax error at or near "someothercolumn" at character 111
> 
> Unfortunately, PGAdmin III does not show me the SQL generated, 

??? It is on the "SQL" page of the table properties dialog.

but I think that it probably does not put the table name in double quotes

This is not necessary for the class keyword.

You'd have to provide more details. I can't reproduce this.

Regards,
Andreas