The following issue has been SUBMITTED.
======================================================================
http://www.dbmail.org/mantis/view.php?id=504
======================================================================
Reported By: morruth
Assigned To:
======================================================================
Project: DBMail
Issue ID: 504
Category: Database layer
Reproducibility: always
Severity: major
Priority: normal
Status: new
target:
======================================================================
Date Submitted: 07-Feb-07 15:45 CET
Last Modified: 07-Feb-07 15:45 CET
======================================================================
Summary: error in postgresql database creation script
Description:
in creation of dbmail_headername in create_tables.pgsql makes unique index
CREATE UNIQUE INDEX dbmail_headername_1 on
dbmail_headername(lower(headername));
so it's case insensitive (in sqlite &mysql scripts this index is case
sensitive)
BUT check of existance header in function _header_get_id (file
dbmail_message.c)
is case sensitive
g_string_printf(q, "SELECT id FROM %sheadername WHERE headername='%s'",
DBPFX, safe_header);
so if dbmail receives 2 letter contains headers in different cases
for example Message-Id: and Message-ID: the second letter will NOT be
received
with error in error log
Error query failed [INSERT INTO dbmail_headername (headername) VALUES
('Message-ID')] : [ERROR: secondary key violates constraint UNIQUE
"dbmail_headername_1"
]
right now I simple remove lower from index
CREATE UNIQUE INDEX dbmail_headername_1 on dbmail_headername(headername)
as in mysql/sqlite scripts
I don't know, may be 'll better change headername='%s' on
headername=lower('%s')? (don't sure that function lower() exists in sqlite
or mysql)
======================================================================
Issue History
Date Modified Username Field Change
======================================================================
07-Feb-07 15:45 morruth New Issue
======================================================================
_______________________________________________
Dbmail-dev mailing list
[email protected]
http://twister.fastxs.net/mailman/listinfo/dbmail-dev
