[ postfixadmin-Bugs-3057081 ] Quta's stored as integers, should be bigint.

[SourceForge.net <no...@so...>]

Bugs item #3057081, was opened at 2010-09-01 02:03
Message generated for change (Comment added) made by christian_boltz
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=937964&aid=3057081&group_id=191583

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: Database
Group: v2.3.1
Status: Open
Resolution: None
Priority: 5
Private: No
Submitted By: oliver (n0d3)
Assigned to: Nobody/Anonymous (nobody)
Summary: Quta's stored as integers, should be bigint.

Initial Comment:
This is a copy (re-opening) of 2986880.

I"m opening a new ticket because I can't seem to find an edit button.

>From there:
"If you disagree or still have "small" integer quota fields with 2.3 or the
upcoming 2.3.1 release (don't forget to run setup.php after upgrade), feel
free to reopen this ticket ;-)"

I just did a fresh install of 2.3.2 and the issue is still not fixed (for pgsql).
postfix_new=> \d mailbox;
                             Table "public.mailbox"
   Column   |           Type           |               Modifiers                
------------+--------------------------+----------------------------------------
 username   | character varying(255)   | not null
 password   | character varying(255)   | not null default ''::character varying
 name       | character varying(255)   | not null default ''::character varying
 maildir    | character varying(255)   | not null default ''::character varying
 quota      | integer                  | not null default 0
 created    | timestamp with time zone | default now()
 modified   | timestamp with time zone | default now()
 active     | boolean                  | not null default true
 domain     | character varying(255)   | 
 local_part | character varying(255)   | not null
Indexes:
    "mailbox_key" PRIMARY KEY, btree (username)
    "mailbox_domain_idx" btree (domain)
    "mailbox_username_active" btree (username, active)
Foreign-key constraints:
    "mailbox_domain_fkey1" FOREIGN KEY (domain) REFERENCES domain(domain)

Adding a user with anything over a 4GiB mailbox gives the following error:

DEBUG INFORMATION:
Invalid query: ERROR: value "8589934592" is out of range for type integer LINE 1: ...','test','test.tld/te...@te.../','test.tld','858993459... ^ 

----------------------------------------------------------------------

>Comment By: Christian Boltz (christian_boltz)
Date: 2011-02-17 22:36

Message:
Ah, PostgreSQL - that explains it. My fix was for MySQL...

David, can you give me an ALTER TABLE query to change the quota field in
the mailbox table to bigint?
(I'll then handle the needed changes in upgrade.php.)

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=937964&aid=3057081&group_id=191583