Bug in Pgadmin III 1.2.0
От | Marcel Gsteiger |
---|---|
Тема | Bug in Pgadmin III 1.2.0 |
Дата | |
Msg-id | s1f61001.030@milprog1.milprog.ch обсуждение исходный текст |
Ответы |
Re: Bug in Pgadmin III 1.2.0
|
Список | pgadmin-support |
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
В списке pgadmin-support по дате отправления: