Thread: Error adding new column to existing table.

Error adding new column to existing table.

From
Ted Taylor
Date:
<div class="Section1"><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;
font-family:Arial">Short version: using the “Add Column” GUI on an existing table puts double quotes around the
datatype,and won’t run.</span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;
 
font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;
font-family:Arial">Long version:</span></font><p class="MsoNormal"><font face="Arial" size="2"><span
style="font-size:10.0pt;
font-family:Arial">Using pgAdmin III Version 1.2.0 Beta 1 (</span></font><font face="Arial" size="2"><span
style="font-size:10.0pt;font-family:Arial">Sep 8 2004</span></font><font face="Arial" size="2"><span
style="font-size:10.0pt;font-family:Arial">)on Windows 2000, fully patched from Windows Update site.  Connecting to
PostgreSQL7.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)")</span></font><p class="MsoNormal"><font face="Arial" size="2"><span
style="font-size:10.0pt;
font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;
font-family:Arial">Opened “Servers” </span></font><font face="Wingdings" size="2"><span
style="font-size:10.0pt;font-family:Wingdings">à</span></font><fontface="Arial" size="2"><span
style="font-size:10.0pt;font-family:Arial"><my server name> </span></font><font face="Wingdings" size="2"><span
style="font-size:10.0pt;font-family:Wingdings">à</span></font><fontface="Arial" size="2"><span
style="font-size:10.0pt;font-family:Arial">“Databases” </span></font><font face="Wingdings" size="2"><span
style="font-size:10.0pt;
font-family:Wingdings">à</span></font><font face="Arial" size="2"><span style="font-size:10.0pt;font-family:Arial">
<mydatabase name> </span></font><font face="Wingdings" size="2"><span
style="font-size:10.0pt;font-family:Wingdings">à</span></font><fontface="Arial" size="2"><span
style="font-size:10.0pt;font-family:Arial">“Schemas” </span></font><font face="Wingdings" size="2"><span
style="font-size:10.0pt;
font-family:Wingdings">à</span></font><font face="Arial" size="2"><span style="font-size:10.0pt;font-family:Arial">
“public”</span></font><font face="Wingdings" size="2"><span
style="font-size:10.0pt;font-family:Wingdings">à</span></font><fontface="Arial" size="2"><span
style="font-size:10.0pt;font-family:Arial">“Tables” and single-clicked on my table name to highlight
it.</span></font><pclass="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;
 
font-family:Arial">Right clicked on the table name and chose “Properties”.</span></font><p class="MsoNormal"><font
face="Arial"size="2"><span style="font-size:10.0pt;
 
font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;
font-family:Arial">The Table dialog box has “Properties” “Columns” “Constraints” “Privileges” and “SQL” tabs; clicked
on“Columns”.</span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;
 
font-family:Arial">Clicked on the “Add”  button at the bottom.</span></font><p class="MsoNormal"><font face="Arial"
size="2"><spanstyle="font-size:10.0pt;
 
font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;
font-family:Arial">In the New Column dialog box, I entered:</span></font><p class="MsoNormal"><font face="Arial"
size="2"><spanstyle="font-size:10.0pt;
 
font-family:Arial">            Name=      user_surname</span></font><p class="MsoNormal"><font face="Arial"
size="2"><spanstyle="font-size:10.0pt;
 
font-family:Arial">            Datatype=         varchar</span></font><p class="MsoNormal"><font face="Arial"
size="2"><spanstyle="font-size:10.0pt;
 
font-family:Arial">            Length=            80</span></font><p class="MsoNormal"><font face="Arial"
size="2"><spanstyle="font-size:10.0pt;
 
font-family:Arial">I left all other available properties “Default Value” “Not Null” “Statistics” and “Comment” at the
defaultof blank.</span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;
 
font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;
font-family:Arial">Clicked OK to close the New Column dialog box.</span></font><p class="MsoNormal"><font face="Arial"
size="2"><spanstyle="font-size:10.0pt;
 
font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;
font-family:Arial">>>> Back on the Table </span></font><font face="Wingdings" size="2"><span
style="font-size:10.0pt;font-family:Wingdings">à</span></font><fontface="Arial" size="2"><span
style="font-size:10.0pt;font-family:Arial">Columns dialog box, I notice the keyword “varchar” has double quotes around
it. Other datatypes such as “int4” do not have double quotes around it.</span></font><p class="MsoNormal"><font
face="Arial"size="2"><span style="font-size:10.0pt;
 
font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;
font-family:Arial">On the Table dialog box, click OK.  I receive an error message ERROR: syntax error at or near “(“ at
character67.</span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;
 
font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;
font-family:Arial">I clear the error and go to the Table </span></font><font face="Wingdings" size="2"><span
style="font-size:10.0pt;font-family:Wingdings">à</span></font><fontface="Arial" size="2"><span
style="font-size:10.0pt;font-family:Arial">SQL tab.  I have copied its SQL here:</span></font><p
class="MsoNormal"><fontface="Arial" size="2"><span style="font-size:10.0pt;
 
font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;
font-family:Arial">ALTER TABLE <my table name> ADD COLUMN user_surname "varchar"(80);</span></font><p
class="MsoNormal"><fontface="Arial" size="2"><span style="font-size:10.0pt;
 
font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;
font-family:Arial">I removed the double quotes around varchar, and executed the SQL directly, with no
errors.</span></font><pclass="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt; 
font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;
font-family:Arial">Thanks,</span></font><p class="MsoNormal"><font face="Arial" size="2"><span
style="font-size:10.0pt;
font-family:Arial">Ted Tayloor</span></font><p class="MsoNormal"><font face="Arial" size="2"><span
style="font-size:10.0pt;
font-family:Arial">ted.taylor@aircanada.ca</span></font><p class="MsoNormal"><font face="Arial" size="2"><span
style="font-size:10.0pt;
font-family:Arial"> </span></font></div>

Re: Error adding new column to existing table.

From
"Dave Page"
Date:
 


From: pgadmin-support-owner@postgresql.org [mailto:pgadmin-support-owner@postgresql.org] On Behalf Of Ted Taylor
Sent: 16 September 2004 21:51
To: pgadmin-support@postgresql.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

Re: Error adding new column to existing table.

From
Ted Taylor
Date:
<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> 

Re: Error adding new column to existing table.

From
"Dave Page"
Date:
 


From: Ted.Taylor@aircanada.ca [mailto:Ted.Taylor@aircanada.ca]
Sent: 17 September 2004 14:52
To: Dave Page; pgadmin-support@postgresql.org
Subject: RE: [pgadmin-support] Error adding new column to existing table.

Hi Dave,

 

Hi Ted,

 

Thank you for your quick response.

 

Your welcome.

 

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.

 

I can't reproduce that here, however it does sound like it might be the 'find focus' bug that was worked around yesterday.

 

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? 

 

Bug reports should always come from the latest snapshot where possible (you can install and run multiple versions at once BTW - the settings will be shared, but the code is self contained as long as you install in a different directory). I can email you a copy of the build I have if you want to re-test the bug above?

 

Regards, Dave.

Re: Error adding new column to existing table.

From
Andreas Pflug
Date:
Dave Page wrote:

>      
> 
>     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.
> 
>      
> 
> I can't reproduce that here, however it does sound like it might be the 
> 'find focus' bug that was worked around yesterday.

I located another bug (invalid current node after editing an object) an 
hour ago, might be that one.
Recheck with cvs version or the 2004-09-17 snapshot (upload tonight).

Regards,
Andreas


Re: Error adding new column to existing table.

From
Ted Taylor
Date:
Andreas, Dave,

It is fixed in the executable that Dave sent me [Version 1.2.0 Post Beta 1
(Sep 17 2004)].  I will also download the snapshot when it becomes
available.

Thanks!
Ted.

-----Original Message-----
From: Andreas Pflug [mailto:pgadmin@pse-consulting.de] 
Sent: Friday, September 17, 2004 10:40 AM
To: Dave Page
Cc: Ted.Taylor@aircanada.ca; pgadmin-support@postgresql.org
Subject: Re: [pgadmin-support] Error adding new column to existing table.

Dave Page wrote:

>      
> 
>     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.
> 
>      
> 
> I can't reproduce that here, however it does sound like it might be the 
> 'find focus' bug that was worked around yesterday.

I located another bug (invalid current node after editing an object) an 
hour ago, might be that one.
Recheck with cvs version or the 2004-09-17 snapshot (upload tonight).

Regards,
Andreas


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
individualor entity to whom they are addressed.  Views expressed are those of the author and not necessarily those of
AirCanada or its subsidiaries.  Any unauthorized use or disclosure is prohibited.  Please notify the sender if you have
receivedthis 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
seulusage de leurs destinataires, qu'il s'agisse de particuliers ou d'organismes. Les opinions qui y sont exprim�es
sontcelles de l'auteur et ne correspondent pas n�cessairement � celles d'Air Canada ou de ses filiales. Il est interdit
d'utiliserou de divulguer ces renseignements sans autorisation. Si vous avez re�u ce courriel par erreur, veuillez
communiqueravec son exp�diteur. Nous vous remercions de votre collaboration.
 
---------------------------------------------------------------------



Error adding columns to existing tables

From
derrick@grifflink.com
Date:
I am running PGAdminIII Version 1.2.0 Post Beta 1 (Sept 16 2004) on Windows XP.  Connecting to postgres 7.4.
 
When we navigate to the table name, click on properties, add a new column.  All works well, the column is added.  Then click on properties again and the application crashes.
 
Thanks for the great work,
Derrick