Page MenuHomePhabricator

PostgreSQL:Forgotten to ALTER type of oi_metadata to bytea in updaters.inc
Closed, ResolvedPublic

Description

Author: hansm

Description:
You seem to have forgotten to ALTER the type of oi_metadata to BYTEA in updaters.inc.

By the way: In maintenance/postgres/tables.sql, there is an inconsistency between the definitions of tables "image" and "oldimage". oi_bits, oi_timestamp, oi_major_mime and oi_minor_mime are defined as NOT NULL while the corresponding fields in table "image" have no NOT NULL restriction. This might cause troubles when copying rows from image to oldimage.


Version: 1.14.x
Severity: normal
URL: http://www.wikivoyage.org/de/Benutzer:Hansm

Details

Reference
bz15815

Related Objects

View Standalone Graph
This task is connected to more than 200 other tasks. Only direct parents and subtasks are shown here. Use View Standalone Graph to show more of the graph.

Event Timeline

bzimport raised the priority of this task from to Medium.Nov 21 2014, 10:21 PM
bzimport set Reference to bz15815.
bzimport added a subscriber: Unknown Object (MLST).

Thanks, fixed the oi_metadata in r41942. Will keep this bug open until I can look at the other image/oldimage problems in more detail.

Thanks, just made oldimage match image in r48354. Will work on getting that into updaters.inc as well.

Jdforrester-WMF subscribed.

Migrating from the old tracking task to a tag for PostgreSQL-related tasks.