Package: vmm
Version: 0.6.2-1
Severity: minor

I should not be messing with the database directly, but sometimes
that's necessary, as vmm does not provide a means to rename
a domain — and if it would, then it'd have this problem too:

  mailsys=> update domain_name set domainname = 'example.org'
            where domainname = 'example.com' returning gid;
  → ERROR:  There can only be one domain marked as primary.

The only way to fix this is by using OLD in the trigger, which
requires a separate trigger function for UPDATE than INSERT (as
INSERT queries don't make OLD available).

-- System Information:
Debian Release: stretch/sid
  APT prefers unstable
  APT policy: (500, 'unstable'), (1, 'experimental')
Architecture: amd64 (x86_64)
Foreign Architectures: i386

Kernel: Linux 4.2.0-1-amd64 (SMP w/4 CPU cores)
Locale: LANG=en_NZ, LC_CTYPE=en_NZ.UTF-8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/dash
Init: systemd (via /run/systemd/system)


-- 
 .''`.   martin f. krafft <madduck@d.o> @martinkrafft
: :'  :  proud Debian developer
`. `'`   http://people.debian.org/~madduck
  `-  Debian - when you have better things to do than fixing systems

Attachment: digital_signature_gpg.asc
Description: Digital signature (see http://martin-krafft.net/gpg/sig-policy/999bbcc4/current)

Reply via email to