[Pkg-mediawiki-devel] Bug#517237: mediawiki: cannot delete a page

[Marc Dequènes]

Package: mediawiki
Version: 1:1.12.0-2lenny3

I'm using a postgresql database, and deleting a page causes an SQL  
error, due to a mismatch between constraints on the 'recentchanges'  
table in /usr/share/mediawiki/maintenance/postgres/tables.sql and the  
one in my base after successive upgrades over time. The bug was  
probably present a while back, but we are not deleting pages very often.

Here is the missed upgrade path:
ALTER TABLE recentchanges DROP CONSTRAINT recentchanges_rc_cur_id_fkey;
ALTER TABLE recentchanges ADD FOREIGN KEY (rc_cur_id) REFERENCES  
page(page_id) ON DELETE SET NULL;
As the "ON DELETE SET NULL" was missing, this triggered the bug.

Thanks.

-- 
Marc Dequènes
Homepage: http://www.proformatique.com/
Proformatique - 67 rue Voltaire - 92800 Puteaux
Tel. : 01 41 38 99 64 - Fax. : 01 41 38 99 70
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 197 bytes
Desc: PGP Digital Signature
Url : http://lists.alioth.debian.org/pipermail/pkg-mediawiki-devel/attachments/20090226/4dd78847/attachment.pgp