2 Apr
2019
2 Apr
'19
11:53 a.m.
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).