On 02/04/2019 05:42, Richard Hector via dovecot wrote:
I'm using PostgreSQL for my auth db. I used the example CREATE TABLE
statement in the config file, but now I find the fields are too short. I
assume dovecot will be fine with 'text' type columns replacing the
varchars? Or failing that, I can change the length of the varchar fields?
ALTER TABLE $table ALTER COLUMN $column TYPE VARCHAR($newlenth);
My tables are very different from the dovecot suggested tables and it
works, just make sure the queries in dovecot-sql.conf correspond. My
tables are different because they hold additional information for
routing (the db is shared with exim).
