Thread: 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