Displaying 1 result from an estimated 1 matches for "q_msgs".
Did you mean:
x_msgs
2009 Jan 19
0
Reject message if user is over quota. 2/3 solution for Postfix w/ PostgreSQL
...#39;%d', 10485760, 1000)
# quota limit in bytes ----------------------------^
# quota limit in messages -----------------------------------^
SQL:
CREATE OR REPLACE FUNCTION postfix_global_quota_check(
IN localpart varchar, IN the_domain varchar,
IN q_stor bigint, IN q_msgs bigint) RETURNS TEXT
AS $$
DECLARE
result text := 'DUNNO';
-- remove extenstion from localpart (user+foo -> user)
lpart varchar := (SELECT regexp_replace(localpart, E'\\+.*$', ''));
-- XXX how to handle alias addresses?
--...