Tickets :: Comment on [#9638] null value in column rule

* Your Email Address
* Spam protection	Enter the letters below: . .. ..__ . ,.__ \| \|\ /[__) \./ \| \ \|__\| \/ [__) \| \|__/
Comment	>> 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. > > The Postgress logs show that the following statement is executed > > INSERT INTO ingo_rules (rule_id, rule_owner, rule_name, rule_action, > rule_value, rule_fl > ags, rule_conditions, rule_combine, rule_stop, rule_active, > rule_order) VALUES (NULL, 'zrsmm01', 'Whitelist', 9, NULL, NULL, > NULL, NULL, > NULL, 1, 1) > > which fails as rule_id has not-null constraint. Omitting the columns > with NULL vlaues or relpacing them with DEFAULT works > > INSERT INTO ingo_rules (rule_owner, rule_name, rule_action, > rule_active, rule_order) VALUES ('zrsmm01','Whitelist',9,1,1); > > INSERT INTO ingo_rules (rule_id, rule_owner, rule_name, rule_action, > rule_value, rule_flags, rule_conditions, rule_combine, rule_stop, > rule_active, rule_order) VALUES > (DEFAULT,'zrsmm01','Whitelist',9,DEFAULT,DEFAULT,DEFAULT,DEFAULT,DEFAULT,1,1); >
Attachment
Watch this ticket