Postgres Pro
Downloads
Home   >   mailing lists

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

From Dave Page
Subject Re: Error adding new column to existing table.
Date
Msg-id E7F85A1B5FF8D44C8A1AF6885BC9A0E43064DB@ratbert.vale-housing.co.uk
Whole thread Raw
In response to Error adding new column to existing table.  (Ted Taylor <Ted.Taylor@aircanada.ca>)
Responses Re: Error adding new column to existing table.  (Ted Taylor <Ted.Taylor@aircanada.ca>)
List pgadmin-support
Tree view
 

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

pgadmin-support by date:

Previous
From: Ted Taylor
Date:
Subject: Error adding new column to existing table.
Next
From: "Dave Page"
Date:
Subject: Re: Data insert & column name problems