[OpenLayers-Users] Re: need a little help with this ( user input & wfsprotocol.read )

[Bartłomiej Burkot]

You are right it is not allowed.
"ERROR:  cannot use column references in default expression"
You must use update clouse:
alter yourtable add column additional_id int;
update yourtable set additional_id=id;

If you frequently update your table it is more usefull for you to use 
trigger. Look for it in postgresql doc.

Bartlomiej

W dniu 2012-03-13 12:10, Diego M. pisze:
> *Thanks!
> yes you are right!
> but are you sure of this command ?
> i get syntax error near default.*
>
> --
> View this message in context: http://osgeo-org.1560.n6.nabble.com/need-a-little-help-with-this-user-input-wfsprotocol-read-tp4468479p4573645.html
> Sent from the OpenLayers Users mailing list archive at Nabble.com.
> _______________________________________________
> Users mailing list
> Users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/openlayers-users
>