Error by Duplicated Record

[Noyori Tatsuya]

Hello

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 );

best regards,

--
Tatsuya Noyori (^o^)/

[Dave Johnson-8]

On Wed, Jul 23, 2008 at 10:45 AM, Tatsuya Noyori <nojorin@...> wrote:
> 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 );

Thanks for the suggestion, I added an issue for it here:
https://issues.apache.org/roller/browse/ROL-1739

- Dave