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

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

Bugs item #3057081, was opened at 2010-09-01 00:03
Message generated for change (Tracker Item Submitted) made by n0d3
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... ^ 

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

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