Re: Error adding new column to existing table. - Mailing list pgadmin-support

From Ted Taylor
Subject Re: Error adding new column to existing table.
Date
Msg-id 001e01c49cbd$71835180$5281ce9f@TAG65144419
Whole thread Raw
In response to Re: Error adding new column to existing table.  ("Dave Page" <dpage@vale-housing.co.uk>)
List pgadmin-support
<div class="Section1"><p class="MsoNormal"><font face="Courier New" size="2"><span style="font-size:10.0pt;
font-family:"Courier New"">Hi Dave,</span></font><p class="MsoNormal"><font face="Courier New" size="2"><span
style="font-size:10.0pt;
font-family:"Courier New""> </span></font><p class="MsoNormal"><font face="Courier New" size="2"><span
style="font-size:10.0pt;
font-family:"Courier New"">Thank you for your quick response.</span></font><p class="MsoNormal"><font face="Courier
New"size="2"><span style="font-size:10.0pt; 
font-family:"Courier New""> </span></font><p class="MsoNormal"><font face="Courier New" size="2"><span
style="font-size:10.0pt;
font-family:"Courier New"">I downloaded pgAQdmin III “Version 1.2.0 Post Beta 1 (</span></font><font face="Courier New"
size="2"><spanstyle="font-size:10.0pt;font-family:"Courier New"">Sep 16 2004</span></font><font face="Courier New"
size="2"><spanstyle="font-size:10.0pt;font-family:"Courier New"">)” 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.</span></font><p
class="MsoNormal"><fontface="Courier New" size="2"><span style="font-size:10.0pt; 
font-family:"Courier New""> </span></font><p class="MsoNormal"><font face="Courier New" size="2"><span
style="font-size:10.0pt;
font-family:"Courier New"">…BUT…</span></font><p class="MsoNormal"><font face="Courier New" size="2"><span
style="font-size:10.0pt;
font-family:"Courier New""> </span></font><p class="MsoNormal"><font face="Courier New" size="2"><span
style="font-size:10.0pt;
font-family:"Courier New"">(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)</span></font><p class="MsoNormal"><font face="Courier
New"size="2"><span style="font-size:10.0pt; 
font-family:"Courier New""> </span></font><p class="MsoNormal"><font face="Courier New" size="2"><span
style="font-size:10.0pt;
font-family:"Courier New"">Short version:</span></font><p class="MsoNormal"><font face="Courier New" size="2"><span
style="font-size:10.0pt;
font-family:"Courier New"">(continuing the exact sequence of events from my previous report) After adding the new
columnsuccessfully, I cannot successfully re-right-click the same table name.</span></font><p class="MsoNormal"><font
face="CourierNew" size="2"><span style="font-size:10.0pt; 
font-family:"Courier New""> </span></font><p class="MsoNormal"><font face="Courier New" size="2"><span
style="font-size:10.0pt;
font-family:"Courier New""> </span></font><p class="MsoNormal"><font face="Courier New" size="2"><span
style="font-size:10.0pt;
font-family:"Courier New"">Long version:</span></font><p class="MsoNormal"><font face="Courier New" size="2"><span
style="font-size:10.0pt;
font-family:"Courier New"">Using pgAdmin III Version 1.2.0 Post Beta 1 (</span></font><font face="Courier New"
size="2"><spanstyle="font-size:10.0pt;font-family:"Courier New"">Sep  16 2004</span></font><font face="Courier New"
size="2"><spanstyle="font-size: 
10.0pt;font-family:"Courier New"">) on Windows 2000, fully patched from Windows Update site.  Connecting to PostgreSQL
7.4.5on Fedora Core 2 (select version() reports “"PostgreSQL 7.4.5 on i686-redhat-linux-gnu, compiled by GCC gcc (GCC)
3.3.320040412 (Red Hat Linux 3.3.3-7)")</span></font><p class="MsoNormal"><font face="Courier New" size="2"><span
style="font-size:10.0pt;
font-family:"Courier New""> </span></font><p class="MsoNormal"><font face="Courier New" size="2"><span
style="font-size:10.0pt;
font-family:"Courier New"">Opened “Servers” à <my server name> à “Databases” à <my database name> à
“Schemas”à “public” à “Tables” and single-clicked on my table name to highlight it.</span></font><p
class="MsoNormal"><fontface="Courier New" size="2"><span style="font-size:10.0pt; 
font-family:"Courier New"">Right clicked on the table name and chose “Properties”.</span></font><p
class="MsoNormal"><fontface="Courier New" size="2"><span style="font-size:10.0pt; 
font-family:"Courier New""> </span></font><p class="MsoNormal"><font face="Courier New" size="2"><span
style="font-size:10.0pt;
font-family:"Courier New"">The Table dialog box has “Properties” “Columns” “Constraints” “Privileges” and “SQL” tabs;
clickedon “Columns”.</span></font><p class="MsoNormal"><font face="Courier New" size="2"><span style="font-size:10.0pt; 
font-family:"Courier New"">Clicked on the “Add”  button at the bottom.</span></font><p class="MsoNormal"><font
face="CourierNew" size="2"><span style="font-size:10.0pt; 
font-family:"Courier New""> </span></font><p class="MsoNormal"><font face="Courier New" size="2"><span
style="font-size:10.0pt;
font-family:"Courier New"">In the New Column dialog box, I entered:</span></font><p class="MsoNormal"><font
face="CourierNew" size="2"><span style="font-size:10.0pt; 
font-family:"Courier New"">            Name=      user_surname</span></font><p class="MsoNormal"><font face="Courier
New"size="2"><span style="font-size:10.0pt; 
font-family:"Courier New"">            Datatype=         varchar</span></font><p class="MsoNormal"><font face="Courier
New"size="2"><span style="font-size:10.0pt; 
font-family:"Courier New"">            Length=            80</span></font><p class="MsoNormal"><font face="Courier New"
size="2"><spanstyle="font-size:10.0pt; 
font-family:"Courier New"">I left all other available properties “Default Value” “Not Null” “Statistics” and “Comment”
atthe default of blank.</span></font><p class="MsoNormal"><font face="Courier New" size="2"><span
style="font-size:10.0pt;
font-family:"Courier New""> </span></font><p class="MsoNormal"><font face="Courier New" size="2"><span
style="font-size:10.0pt;
font-family:"Courier New"">Clicked OK to close the New Column dialog box.</span></font><font face="Courier New"><span
style="font-family:"CourierNew"">  </span></font><font face="Courier New" size="2"><span
style="font-size:10.0pt;font-family:"CourierNew"">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).</span></font><p
class="MsoNormal"><fontface="Courier New" size="2"><span style="font-size:10.0pt; 
font-family:"Courier New""> </span></font><p class="MsoNormal"><font face="Courier New" size="2"><span
style="font-size:10.0pt;
font-family:"Courier New"">NOW, on the left hand side, I re-right-clicked on the same table name (eg if I wanted to add
anothernew 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.</span></font><p
class="MsoNormal"><fontface="Courier New" size="2"><span style="font-size:10.0pt; 
font-family:"Courier New""> </span></font><p class="MsoNormal"><font face="Courier New" size="2"><span
style="font-size:10.0pt;
font-family:"Courier New""> </span></font><p class="MsoNormal"><font face="Courier New" size="2"><span
style="font-size:10.0pt;
font-family:"Courier New"">Thanks,<br /> Ted.</span></font><p class="MsoNormal"><font face="Courier New" size="2"><span
style="font-size:10.0pt;
font-family:"Courier New""> </span></font><p class="MsoNormal"><font face="Courier New" size="2"><span
style="font-size:10.0pt;
font-family:"Courier New"">PS: Would you like me to revert to “Beta 1 </span></font><font face="Courier New"
size="2"><spanstyle="font-size:10.0pt;font-family:"Courier New"">Sep 8 2004</span></font><font face="Courier New"
size="2"><spanstyle="font-size: 
10.0pt;font-family:"Courier New"">”, 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?</span></font><pclass="MsoNormal"><font color="navy" face="Arial" size="2"><span style="font-size: 
10.0pt;font-family:Arial;color:navy"> </span></font><p class="MsoNormal" style="margin-left:.5in"><font face="Tahoma"
size="2"><spanstyle="font-size:10.0pt;font-family:Tahoma">-----Original Message-----<br /><b><span
style="font-weight:bold">From:</span></b>Dave Page [mailto:dpage@vale-housing.co.uk] <br /><b><span
style="font-weight:bold">Sent:</span></b>Friday, September 17, 2004 3:26 AM<br /><b><span
style="font-weight:bold">To:</span></b>Ted.Taylor@aircanada.ca; pgadmin-support@postgresql.org<br /><b><span
style="font-weight:bold">Subject:</span></b>RE: [pgadmin-support] Error adding new column to existing
table.</span></font><pclass="MsoNormal" style="margin-left:.5in"><font face="Times New Roman" size="3"><span
style="font-size:12.0pt"> </span></font><pclass="MsoNormal" style="margin-left:.5in"><font face="Times New Roman"
size="3"><spanstyle="font-size:12.0pt"> </span></font><blockquote style="border:none;border-left:solid blue
1.5pt;padding:0in0in 0in 4.0pt; 
margin-left:3.75pt;margin-top:5.0pt;margin-right:0in;margin-bottom:5.0pt"><p class="MsoNormal"
style="margin-left:.5in"><fontface="Times New Roman" size="3"><span style="font-size:12.0pt"> </span></font><div
align="center"class="MsoNormal" style="margin-left:.5in;text-align:center"><font face="Times New Roman" size="3"><span
style="font-size:12.0pt"><hralign="center" size="2" width="100%" /></span></font></div><p class="MsoNormal"
style="margin-right:0in;margin-bottom:12.0pt;margin-left:
.5in"><b><font face="Tahoma" size="2"><span style="font-size:10.0pt;font-family:
Tahoma;font-weight:bold">From:</span></font></b><font face="Tahoma" size="2"><span
style="font-size:10.0pt;font-family:Tahoma">pgadmin-support-owner@postgresql.org
[mailto:pgadmin-support-owner@postgresql.org]<b><span style="font-weight:bold">On Behalf Of </span></b>Ted Taylor<br
/><b><spanstyle="font-weight:bold">Sent:</span></b> 16 September 2004 21:51<br /><b><span
style="font-weight:bold">To:</span></b>pgadmin-support@postgresql.org<br /><b><span
style="font-weight:bold">Subject:</span></b>[pgadmin-support] Error adding new column to existing
table.</span></font><pclass="MsoNormal" style="margin-left:.5in"><font face="Arial" size="2"><span
style="font-size:10.0pt;font-family:Arial">Shortversion: using the “Add Column” GUI on an existing table puts double
quotesaround the datatype, and won’t run.</span></font><p class="MsoNormal" style="margin-left:.5in"><font face="Times
NewRoman" size="3"><span style="font-size:12.0pt"> </span></font></blockquote><p class="MsoNormal"
style="margin-left:.5in"><fontface="Arial" size="2"><span style="font-size:10.0pt;font-family:Arial">Hi
Ted,</span></font><pclass="MsoNormal" style="margin-left:.5in"><font face="Times New Roman" size="3"><span
style="font-size:12.0pt"> </span></font><pclass="MsoNormal" style="margin-left:.5in"><font face="Arial" size="2"><span
style="font-size:10.0pt;font-family:Arial">I'msurprised it didn't work with the quotes to be honest, but that aside,
theresa known quoting bug in beta1 that has been fixed for beta2 that almost certainly caused this. It should also be
fixedin the latest snapshot at <a
href="http://pgadmin.postgresql.org/snapshots/win32/">http://pgadmin.postgresql.org/snapshots/win32/</a> ifyou wish to
upgradeto that.</span></font><p class="MsoNormal" style="margin-left:.5in"><font face="Times New Roman" size="3"><span
style="font-size:12.0pt"> </span></font><pclass="MsoNormal" style="margin-left:.5in"><font face="Arial" size="2"><span
style="font-size:10.0pt;font-family:Arial">Thanksfor the email though - a textbook example of the perfect bug report; I
wishthey were all like that!</span></font><p class="MsoNormal" style="margin-left:.5in"><font face="Times New Roman"
size="3"><spanstyle="font-size:12.0pt"> </span></font><p class="MsoNormal" style="margin-left:.5in"><font face="Arial"
size="2"><spanstyle="font-size:10.0pt;font-family:Arial">Regards, Dave</span></font></div> 

pgadmin-support by date:

Previous
From: Jona
Date:
Subject: Create database
Next
From: "Dave Page"
Date:
Subject: Re: Error adding new column to existing table.