bugweb-cyradm - Bugs: bug #14279, SQL Script for PostgreSQL Does Not...

 
 

bug #14279: SQL Script for PostgreSQL Does Not Allow Multiple Alias Destinations

Submitted by:  None
Submitted on:  Wed 24 Aug 2005 06:20:53 PM UTC  
 
Category: sqlSeverity: 3 - Normal
Priority: 5 - NormalItem Group: normal bugs
Status: FixedPrivacy: Public
Assigned to: NoneOriginator Name: Federico Sevilla III
Originator Email: -unavailable-Open/Closed: Closed
Release: 0.5.4Operating System: None
Reproducibility: Every TimePlanned Release: 0.5.5
Cyrus IMAP version: 2.1.xPHP version: 4.3
Database type: PostgreSQL 7.4

Add a New Comment(Rich Markup)
   

You are not logged in

Please log in, so followups can be emailed to you.

 

Wed 24 Aug 2005 06:20:53 PM UTC, original submission:

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.

Anonymous

 

(Note: upload size limit is set to 16384 kB, after insertion of the required escape characters.)

Attach File(s):
   
   
Comment:
   

No files currently attached

 

Depends on the following items: None found

Items that depend on this one: None found

 

CC list is empty

 

Do you think this task is very important?
If so, you can click here to add your encouragement to it.
This task has 0 encouragements so far.

Only logged-in users can vote.

 

Please enter the title of George Orwell's famous dystopian book (it's a date):

 

 

Follow 4 latest changes.

Date Changed By Updated Field Previous Value => Replaced By
Sun 30 Jul 2006 08:16:50 PM UTClandmStatusNone=>Fixed
  Open/ClosedOpen=>Closed
  Planned ReleaseNone=>0.5.5
Wed 24 Aug 2005 06:20:53 PM UTCNoneCarbon-Copy-=>Added jijo --AT-- free --DOT-- net --DOT-- ph

Back to the top


Powered by Savane 3.1-cleanup1