iterate_query with static userdb ?

[Laura Smith]

Hi,

Going by the "static userdb" example  on this page (https://wiki.dovecot.org/VirtualUsers#homedirs), tried to achieve a similar setup in conjunction with pgsql for passdb.

However I get an error "auth: Warning: sql: Ignoring changed iterate_query in /etc/dovecot/local_sql_users.conf, because userdb sql not used. (If this is intentional, set userdb_warning_disable=yes)"

Does this mean the following is not a valid config ? Or at least I will not be able to achieve iteration ?

mail_location = maildir:/foobar/mail/%d/%n/Maildir
passdb {
  driver = sql
  args = /etc/dovecot/local_sql_users.conf
}
userdb {
  driver = static
  args = uid=foo gid=bar home=/foobar/mail/%d/%n
}