[kdepim-users] akonadi fsck fails

[Pablo Sanchez]

[ Comments below, in-line ]


On 08/25/2015 09:17 AM, J. Roeleveld wrote:

::: 1 :::

> delete from pimitemflagrelation
> where not exists
>     (select 1 from pimitemtable where pimitemtable.id =
> pimitemflagrelation.pimitem_id);


::: 2 :::
> delete from pimitemflagrelation
>     where pimitemflagrelation.pimitem_id in (
>           select pimitem_id
>           from pimitemflagrelation
>           left join pimitemtable
>             on pimitemflagrelation.pimitem_id = pimitemtable.id);


FYI:  (2) is better than (1).  :)

Cheers,
--
Pablo Sanchez - Blueoak Database Engineering, Inc
Ph:    819.459.1926         Blog:  http://pablo-blog.blueoakdb.com
iNum:  883.5100.0990.1054

_______________________________________________
KDE PIM users mailing list
Subscription management: https://mail.kde.org/mailman/listinfo/kdepim-users