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 in double 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
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
