[Tickets #9638] Re: null value in column rule_id with postgresql

[bugs at horde.org]

DO NOT REPLY TO THIS MESSAGE. THIS EMAIL ADDRESS IS NOT MONITORED.

Ticket URL: http://bugs.horde.org/ticket/9638
------------------------------------------------------------------------------
  Ticket             | 9638
  Updated By         | Jan Schneider <jan at horde.org>
  Summary            | null value in column rule_id with postgresql
  Queue              | Ingo
  Version            | Git master
  Type               | Bug
-State              | Feedback
+State              | Assigned
  Priority           | 2. Medium
-Milestone          |
+Milestone          | 4.0
  Patch              |
-Owners             |
+Owners             | Chuck Hagenbuch, Horde Developers
------------------------------------------------------------------------------


Jan Schneider <jan at horde.org> (2011-03-09 15:33) wrote:

I'm not a PostgreSQL expert, but this statement should enable  
autoincrementing on the rule_id column:
ALTER TABLE "ingo_rules" ALTER COLUMN "rule_id" SET DEFAULT  
NEXTVAL('ingo_rules_rule_id_seq')

No idea why it doesn't work.