Page MenuHomePhabricator

StructuredDiscussions schema doesn't support PostgreSQL
Open, LowPublic

Description

PostgreSQL does not have the binary type modifier for varchar like MySQL and MariaDB do. Would it be safe to use bytea instead for binary and varchar binary, and bit(x) for varbinary?

Creating flow_revision table ...[160ab134f331aac20ff335b7] [no req]   Wikimedia\Rdbms\DBQueryError from line 1149 of w/includes/libs/rdbms/database/Database.php: A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?
Query: CREATE TABLE "flow_workflow" (
 workflow_id binary(11) not null,
 workflow_wiki varchar(64) binary not null,
 workflow_namespace int not null,
 workflow_page_id int unsigned not null,
 workflow_title_text varchar(255) binary not null,
 workflow_name varchar(255) binary not null,
 workflow_last_update_timestamp binary(14) not null,
 workflow_lock_state int unsigned not null,
 workflow_type varbinary(16) not null,
 PRIMARY KEY (workflow_id)
 ) /*$wgDBTableOptions*/

Function: Wikimedia\Rdbms\Database::sourceFile( w/extensions/Flow/flow.sql )
Error: 42601 ERROR:  syntax error at or near "binary"
LINE 3:  workflow_wiki varchar(64) binary not null,
                                   ^

Event Timeline

Restricted Application added a project: Collaboration-Team-Triage. · View Herald TranscriptJun 14 2018, 8:56 PM
Restricted Application added a subscriber: Aklapper. · View Herald Transcript
Reedy renamed this task from PostgreSQL is not supported at all? to StructuredDiscussions schema doesn't support PostgreSQL.Jun 14 2018, 11:47 PM
Reedy added a project: PostgreSQL.
JTannerWMF triaged this task as Low priority.Jun 26 2018, 6:18 PM
JTannerWMF moved this task from Untriaged to Flow Holding Area on the Collaboration-Team-Triage board.
Vvjjkkii renamed this task from StructuredDiscussions schema doesn't support PostgreSQL to mzaaaaaaaa.Jul 1 2018, 1:04 AM
Vvjjkkii raised the priority of this task from Low to High.
Vvjjkkii updated the task description. (Show Details)
Vvjjkkii removed a subscriber: Aklapper.
IijimaYun renamed this task from mzaaaaaaaa to StructuredDiscussions schema doesn't support PostgreSQL.Jul 1 2018, 12:39 PM
IijimaYun lowered the priority of this task from High to Low.
IijimaYun updated the task description. (Show Details)
IijimaYun added a subscriber: Aklapper.
Restricted Application added a project: Growth-Team. · View Herald TranscriptSep 12 2018, 1:27 AM