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 [email protected] http://lists.osgeo.org/mailman/listinfo/openlayers-users
_______________________________________________ Users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/openlayers-users
