dovecot - Apr 2019 - sql table definitions

Hi all,

Trivial question ...

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?

Cheers,
Richard

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).