6.0.0-beta1
▾
Tasks
New Task
Search
Photos
Wiki
▾
Tickets
New Ticket
Search
dev.horde.org
Toggle Alerts Log
Help
1/9/26
H
istory
A
ttachments
C
omment
W
atch
Download
Comment on [#9638] null value in column rule_id with postgresql
*
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
N
ew Ticket
M
y Tickets
S
earch
Q
uery Builder
R
eports
Saved Queries
Open Bugs
Bugs waiting for Feedback
Open Bugs in Releases
Open Enhancements
Enhancements waiting for Feedback
Bugs with Patches
Enhancements with Patches
Release Showstoppers
Stalled Tickets
New Tickets
Horde 5 Showstoppers