Bug in Pgadmin III 1.2.0

From: "Marcel Gsteiger" <Marcel(dot)Gsteiger(at)milprog(dot)ch>
To: <pgadmin-support(at)postgresql(dot)org>
Subject: Bug in Pgadmin III 1.2.0
Date: 2005-01-25 08:22:52
Message-ID: s1f61001.030@milprog1.milprog.ch
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 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

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Andreas Pflug 2005-01-25 09:45:14 Re: Bug in Pgadmin III 1.2.0
Previous Message J.Itamar 2005-01-24 20:43:28 Problems with VB6 and PostGreSQL .....