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
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])