URL:
<http://savannah.nongnu.org/bugs/?func=detailitem&item_id=14279>
Summary: SQL Script for PostgreSQL Does Not Allow Multiple
Alias Destinations
Project: web-cyradm
Submitted by: None
Submitted on: Wed 08/24/05 at 18:20
Category: sql
Severity: 3 - Normal
Priority: 5 - Normal
Item Group: normal bugs
Status: None
Privacy: Public
Assigned to: None
Originator Name: Federico Sevilla III
Originator Email: [EMAIL PROTECTED]
Open/Closed: Open
Release: 0.5.4
Platform Version: None
Reproducibility: Every Time
Planned Release: None
Cyrus IMAP version: 2.1.x
PHP version: 4.3
Database type: PostgreSQL 7.4
_______________________________________________________
Details:
The SQL script provided for PostgreSQL does not allow multiple alias
destinations, but the web interface "advertises" that this is supported. This
is caused by the fact that the alias field in the virtual table is set as a
primary key. The revised CREATE TABLE snippet for the virtual table that
properly supports multiple alias destinations is:
CREATE TABLE virtual (
alias varchar(255) NOT NULL,
dest varchar(255) NOT NULL,
username varchar(255) NOT NULL default '',
status int NOT NULL default '1',
PRIMARY KEY (alias, dest)
);
This also removes the need to create a separate UNIQUE INDEX on
virtual(alias,dest).
However, this support for multiple alias destinations also opens up a bug in
removing email addresses that match aliases or other supplementary email
addresses. A new bug report will be opened for that after this.
_______________________________________________________
Carbon-Copy List:
CC Address | Comment
------------------------------------+-----------------------------
jijo --AT-- free --DOT-- net --DOT-- ph | Originator Email
_______________________________________________________
Reply to this item at:
<http://savannah.nongnu.org/bugs/?func=detailitem&item_id=14279>
_______________________________________________
Message sent via/by Savannah
http://savannah.nongnu.org/
_______________________________________________
This mailing list is hosted and supported
by bit-heads GmbH | http://www.bit-heads.ch
_______________________________________________
Web-cyradm mailing list
[email protected]
http://www.web-cyradm.org/mailman/listinfo/web-cyradm
