You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@roller.apache.org by Tatsuya Noyori <no...@gmail.com> on 2008/07/23 16:45:12 UTC

Error by Duplicated Record

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^)/

Re: Error by Duplicated Record

Posted by Dave <sn...@gmail.com>.

On Wed, Jul 23, 2008 at 10:45 AM, Tatsuya Noyori <no...@gmail.com> 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