Bug #1339
Migration to PostgreSQL fails because of long sender identities inside table sender
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 almost 10 years ago
-- Made a pull-request: https://github.com/quassel/quassel/pull/112