Author: olleg_s

Description:

• MediaWiki: 1.9.3
• PHP: 5.2.0-8+etch1 (apache2handler)
• PostgreSQL: PostgreSQL 8.1.8 on x86_64-pc-linux-gnu, compiled by GCC cc (GCC)

4.1.2 20061115 (prerelease) (Debian 4.1.1-21)

Delete article and restore it. Warning on html page:

<b>Warning</b>: pg_query() [<a href='function.pg-query'>function.pg-query</a>]:
Query failed: ERROR: cannot delete from a view
HINT: You need an unconditional ON DELETE DO INSTEAD rule. in
<b>/usr/share/mediawiki1.9/includes/DatabasePostgres.php</b> on line <b>389</b>

Error in postgresql log:
2007-03-15 21:34:28 MSK ERROR: cannot delete from a view
2007-03-15 21:34:28 MSK HINT: You need an unconditional ON DELETE DO INSTEAD rule.
2007-03-15 21:34:28 MSK STATEMENT: DELETE /* PageArchive::undeleteRevisions */
FROM archive WHERE ar_namespace = '0' AND ar_title = 'Main_Page' AND (1 = 1)

Version: 1.9.x
Severity: normal