https://bugzilla.wikimedia.org/show_bug.cgi?id=33689

Marcin Cieślak <[email protected]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|RESOLVED                    |REOPENED
         Resolution|WORKSFORME                  |

--- Comment #6 from Marcin Cieślak <[email protected]> 2012-03-28 
19:58:34 UTC ---
I think I nailed it down when testing for gerrit change 3841. It happens when
updater invokes

array( 'changeFkeyDeferrable', 'externallinks',    'el_from',        
'page(page_id) ON DELETE CASCADE' ),

but there is no foreign key constraint on el_from.

It's strange since I could trace this definition:

  el_from   INTEGER NOT NULL REFERENCES page(page_id) ON DELETE CASCADE,

back to this commit:

commit 6832afd9ea7d280e0e63648424de26e6ead6bf56
Author: Brion Vibber <[email protected]>
Date:   Sun Apr 30 17:36:16 2006 +0000

    Somehow managed to forget to check this in...

So it seems like the constraint should always be there. 

There is a small issue though with PostgresUpdater::changeFkeyDeferrable and
DatabasePostgres::FieldInfo::conname()

conname() returns empty string instead of NULL because of  
COALESCE(conname, '') AS conname

easy fix...

-- 
Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
You are on the CC list for the bug.
_______________________________________________
Wikibugs-l mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l

Reply via email to