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