Am 12.05.2011 um 13:19 schrieb Arnt Gulbrandsen:
lower(addresses.localpart)||'@'||lower(addresses.domain) must be unique when
joined against aliases. I've not the faintest idea how to express that in
SQL, though.
Then we need a cleanup script to purge inconsistent aliases from the db
On 05/12/2011 03:12 PM, Axel Rau wrote:
A constraint on the aliases table... if pg allows us to do that?
No, just a lower(localpart) of whatever the user gave as address in aox add
alias or aox add user.
If that address is already in addresses, use it, otherwise create it.
I wrote the code,
