Could not add new column to PostGIS Table

View: New views
2 Messages — Rating Filter:   Alert me  

Could not add new column to PostGIS Table

by Surachai Locharoen-2 :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Dear list
  I could not add new column to the Table. I use QGIS to add column. It seem to be fine but there is no column in table.
If I add new column by using pgadminIII, I could not set value to new column.
The error message show that in valid sql update statement. I notice that QGIS retrieve column name with blank column name between old colums and new columns.
So when it generate sql statement it use blank column name in statement. The value I want to set is shift in to invalid column.
 
Does anybody found this problem? How to work around it?
 
I have to finish my project soon. It 's very appreciate for you help.
 
Thank you in advanced.

--
Surachai Locharoen
 

_______________________________________________
Qgis-user mailing list
Qgis-user@...
http://lists.qgis.org/cgi-bin/mailman/listinfo/qgis-user

Re: Could not add new column to PostGIS Table

by Tim Sutton :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Hi

Could you explain exactly what steps you have carried out?

Regards

Tim

2008/2/7, Surachai Locharoen <kan2005@...>:

> Dear list
>   I could not add new column to the Table. I use QGIS to add column. It seem
> to be fine but there is no column in table.
> If I add new column by using pgadminIII, I could not set value to new
> column.
> The error message show that in valid sql update statement. I notice that
> QGIS retrieve column name with blank column name between old colums and new
> columns.
> So when it generate sql statement it use blank column name in statement. The
> value I want to set is shift in to invalid column.
>
> Does anybody found this problem? How to work around it?
>
> I have to finish my project soon. It 's very appreciate for you help.
>
> Thank you in advanced.
>
> --
> Surachai Locharoen
>
> _______________________________________________
> Qgis-user mailing list
> Qgis-user@...
> http://lists.qgis.org/cgi-bin/mailman/listinfo/qgis-user
>
>


--
Tim Sutton
QGIS Project Steering Committee Member - Release  Manager
Visit http://qgis.org for a great open source GIS
openModeller Desktop Developer
Visit http://openModeller.sf.net for a great open source ecological
niche modelling tool
Home Page: http://tim.linfiniti.com
Skype: timlinux
Irc: timlinux on #qgis at freenode.net
_______________________________________________
Qgis-user mailing list
Qgis-user@...
http://lists.qgis.org/cgi-bin/mailman/listinfo/qgis-user
LightInTheBox - Buy quality products at wholesale price