Tickets :: [#8441] Missing sequence in Ingo's SQL script

6.0.0-beta1

11/8/25

Summary	Missing sequence in Ingo's SQL script
Queue	Ingo
Queue Version	1.2.1
Type	Bug
State	Not A Bug
Priority	2. Medium
Owners
Requester	sebastien-horde (at) orniz (dot) org
Created	07/17/2009 (5958 days ago)
Due
Updated	07/23/2009 (5952 days ago)
Assigned
Resolved	07/17/2009 (5958 days ago)
Github Issue Link
Github Pull Request
Milestone
Patch	No

07/23/2009 12:49:55 PM	Jan Schneider	Comment #4	Reply to this comment
This is not how the DB package works, period. We don't have any influence on that.

07/22/2009 07:10:28 PM	sebastien-horde (at) orniz (dot) org	Comment #3	Reply to this comment
There is no point allowing horde user to create database entities. A database user should have the minimal permissions for an application to work. Here insert/update/delete/select is sufficient... On the portability point of view, why not provide database specific scripts and a generic one, Horde already do this...

07/17/2009 01:25:37 PM	Chuck Hagenbuch	Comment #2 State ⇒ Not A Bug Patch ⇒ No	Reply to this comment
The proper sequence is created by the PEAR DB drivers; if it's not for you, then you either have a buggy DB package or your db user doesn't have permissions to create tables inside the Horde database. Also, CREATE SEQUENCE is not a portable statement.

07/17/2009 06:49:41 AM	sebastien-horde (at) orniz (dot) org	Comment #1 Priority ⇒ 2. Medium New Attachment: ingo-sequence.patch Patch ⇒ Yes Milestone ⇒ Queue ⇒ Ingo Summary ⇒ Missing sequence in Ingo's SQL script Type ⇒ Bug State ⇒ Unconfirmed	Reply to this comment
When requesting SQL rules storage, adding a rule fails because Ingo tries to use ingo_rules_seq to generate ID of the new rule, this sequence isn't created with the provided SQL script. Attached is a patch that adds this sequence.