[jira] Created: (ROL-1739) Missing constraint on weblogentrytagagg table

["David Johnson (JIRA)" <ji...@apache.org>]

Missing constraint on weblogentrytagagg table
---------------------------------------------

                 Key: ROL-1739
                 URL: https://issues.apache.org/roller/browse/ROL-1739
             Project: Roller
          Issue Type: Bug
          Components: Database Access & Data Model
            Reporter: David Johnson
            Assignee: Roller Unassigned


from Tatsuya Noyori on the Roller user list:

"I have had an error on Roller that is caused by duplicated records on
roller_weblogentrytagagg when I post an entry by AtomPub.
Thus, I would like to suggest to add the following SQL to dbscript of
create.sql in Roller."

alter table roller_weblogentrytagagg add constraint rweta_name_uq
unique ( websiteid, name );

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.