update_8: adding columns with defaults
maho - June 19, 2008 - 14:55
| Project: | Advanced Poll |
| Version: | 5.x-1.0-beta6 |
| Component: | Code |
| Category: | bug report |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | active |
Description
As in [#/272445\
With postgresql (at least with postgresql 7.4) adding column with it's defaults/not null is forbidden.
ERROR:
# warning: pg_query() [function.pg-query]: Query failed: ERROR: adding columns with defaults is not implemented HINT: Add the column, then use ALTER TABLE SET DEFAULT. in /home/maho/workspace/longturn.org/includes/database.pgsql.inc on line 125.
# user warning: query: ALTER TABLE advpoll_choices ADD cid serial in /home/maho/workspace/longturn.org/includes/database.pgsql.inc on line 144.