Re: Error adding new column to existing table.

Hi Dave,

Thank you for your quick response.

I downloaded pgAQdmin III “Version 1.2.0 Post Beta 1 (Sep 16 2004)” and I
confirm that my original bug report has been fixed. The GUI does not add
the quotes to the datatype, and the column is added.

…BUT…

(and I realize the SEP 16 snapshot is exactly that, a work-in-progress, not
ready for prime time. So take this new bug report with the usual grain of
salt)

Short version:

(continuing the exact sequence of events from my previous report) After
adding the new column successfully, I cannot successfully re-right-click the
same table name.

Long version:

Using pgAdmin III Version 1.2.0 Post Beta 1 (Sep 16 2004) on Windows 2000,
fully patched from Windows Update site. Connecting to PostgreSQL 7.4.5 on
Fedora Core 2 (select version() reports “"PostgreSQL 7.4.5 on
i686-redhat-linux-gnu, compiled by GCC gcc (GCC) 3.3.3 20040412 (Red Hat
Linux 3.3.3-7)")

Opened “Servers” à <my server name> à “Databases” à <my database name> à
“Schemas” à “public” à “Tables” and single-clicked on my table name to
highlight it.

Right clicked on the table name and chose “Properties”.

The Table dialog box has “Properties” “Columns” “Constraints” “Privileges”
and “SQL” tabs; clicked on “Columns”.

Clicked on the “Add” button at the bottom.

In the New Column dialog box, I entered:

Name= user_surname

Datatype= varchar

Length= 80

I left all other available properties “Default Value” “Not Null”
“Statistics” and “Comment” at the default of blank.

Clicked OK to close the New Column dialog box. On the Table dialog box,
click OK. The column has been successfully added (The only “transaction” I
did was to scroll the bottom-right corner of the window that shows the
CREATE TABLE command, and the new column is shown. I did not click anywhere
else except that scrollbar).

NOW, on the left hand side, I re-right-clicked on the same table name (eg if
I wanted to add another new column name). pgAdmin abruptly closes with no
error messages at all (the app exits, no GPF, no Illegal Operation, no BSOD,
no nothing). The expected context menu that normally appears, did not
appear.

Thanks,
Ted.

PS: Would you like me to revert to “Beta 1 Sep 8 2004”, in case I discover
more bugs? Or should I stay on the Sep 16 snapshot for any bug reports.
Note I am not asking about whether the snapshot will corrupt my database;
that’s my decision and my responsibility. My question is solely from the
bug-reports-for-pgAdminIII, which version would *you* prefer?

-----Original Message-----
From: Dave Page [mailto:dpage(at)vale-housing(dot)co(dot)uk]
Sent: Friday, September 17, 2004 3:26 AM
To: Ted(dot)Taylor(at)aircanada(dot)ca; pgadmin-support(at)postgresql(dot)org
Subject: RE: [pgadmin-support] Error adding new column to existing table.

_____

From: pgadmin-support-owner(at)postgresql(dot)org
[mailto:pgadmin-support-owner(at)postgresql(dot)org] On Behalf Of Ted Taylor
Sent: 16 September 2004 21:51
To: pgadmin-support(at)postgresql(dot)org
Subject: [pgadmin-support] Error adding new column to existing table.

Short version: using the “Add Column” GUI on an existing table puts double
quotes around the datatype, and won’t run.

Hi Ted,

I'm surprised it didn't work with the quotes to be honest, but that aside,
theres a known quoting bug in beta1 that has been fixed for beta2 that
almost certainly caused this. It should also be fixed in the latest snapshot
at http://pgadmin.postgresql.org/snapshots/win32/ if you wish to upgrade to
that.

Thanks for the email though - a textbook example of the perfect bug report;
I wish they were all like that!

Regards, Dave

Air Canada offers the most non stop flights between Canada and
South America, including Lima, Peru, effective November 1st, 2004.


Air Canada offre le plus grand nombre de vols sans escale entre le
Canada et l'Amérique du Sud, incluant Lima, Pérou en vigueur le 1er
novembre, 2004.

------------------- Air Canada Disclaimer/Avertissement -------------
This email and any files transmitted with it are privileged, confidential, and intended solely for the use of the individual or entity to whom they are addressed. Views expressed are those of the author and not necessarily those of Air Canada or its subsidiaries. Any unauthorized use or disclosure is prohibited. Please notify the sender if you have received this email in error. Thank you for your co-operation.

Le présent courriel et, s'il y a lieu, ses pièces jointes constituent des renseignements confidentiels et destinés au seul usage de leurs destinataires, qu'il s'agisse de particuliers ou d'organismes. Les opinions qui y sont exprimées sont celles de l'auteur et ne correspondent pas nécessairement à celles d'Air Canada ou de ses filiales. Il est interdit d'utiliser ou de divulguer ces renseignements sans autorisation. Si vous avez reçu ce courriel par erreur, veuillez communiquer avec son expéditeur. Nous vous remercions de votre collaboration.
---------------------------------------------------------------------