equal
deleted
inserted
replaced
286 gid bigint, |
286 gid bigint, |
287 home text, |
287 home text, |
288 mail text |
288 mail text |
289 ); |
289 ); |
290 -- --- |
290 -- --- |
291 -- Data type for function dovecotquotauser(varchar, varchar) |
291 -- Data type for function dovecotquotauser(varchar, varchar) |
292 -- --- |
292 -- --- |
293 CREATE TYPE dovecotquotauser AS ( |
293 CREATE TYPE dovecotquotauser AS ( |
294 userid varchar(320), |
294 userid varchar(320), |
295 uid bigint, |
295 uid bigint, |
296 gid bigint, |
296 gid bigint, |
408 record dovecotpassword; |
408 record dovecotpassword; |
409 userid varchar(320) := localpart || '@' || the_domain; |
409 userid varchar(320) := localpart || '@' || the_domain; |
410 BEGIN |
410 BEGIN |
411 FOR record IN |
411 FOR record IN |
412 SELECT userid, passwd, smtp, pop3, imap, managesieve |
412 SELECT userid, passwd, smtp, pop3, imap, managesieve |
413 FROM users |
413 FROM users, service_set |
414 WHERE gid = (SELECT gid |
414 WHERE gid = (SELECT gid |
415 FROM domain_name |
415 FROM domain_name |
416 WHERE domainname = the_domain) |
416 WHERE domainname = the_domain) |
417 AND local_part = localpart |
417 AND local_part = localpart |
418 LOOP |
418 AND service_set.ssid = users.ssid |
419 RETURN NEXT record; |
419 LOOP |
420 END LOOP; |
420 RETURN NEXT record; |
421 RETURN; |
421 END LOOP; |
422 END; |
422 RETURN; |
423 $$ LANGUAGE plpgsql STABLE |
423 END; |
424 RETURNS NULL ON NULL INPUT |
424 $$ LANGUAGE plpgsql STABLE |
425 EXTERNAL SECURITY INVOKER; |
425 RETURNS NULL ON NULL INPUT |
|
426 EXTERNAL SECURITY INVOKER; |