Project

General

Profile

Bug #1339

Migration to PostgreSQL fails because of long sender identities inside table sender

Added by deas about 9 years ago. Updated about 9 years ago.

Status:
New
Priority:
Normal
Assignee:
-
Category:
-
Target version:
-
Start date:
02/17/2015
Due date:
% Done:

0%

Estimated time:
Version:
0.10.0
OS:
Any

Description

I suggest bumping the table column for varchar to atleast 255, which is somewhat standard for a varchar and would avoid problems in the future.
(I had to truncate several rows of senders who for some reason decided to have almost 200 underscores in their nick.)

if i'm typing this so bad that you don't understand, let me put it in cleartext:

bump 'quassel/src/core/SQL/PostgreSQL/16/setup_010_sender.sql' to
CREATE TABLE sender ( -- THE SENDER OF IRC MESSAGES
senderid serial NOT NULL PRIMARY KEY,
sender varchar(255) UNIQUE NOT NULL
)

History

#1 Updated by deas about 9 years ago

Also available in: Atom PDF