On Sun, Jan 19, 2020, at 08:47, Mark Felder wrote:
> Seeing this with info logs which I never had on in the past:
>
> Archiveopteryx[32340]: 61158/13/1 Note: Expected type string for column
> "flag", but received null
>
Actually I think it's the mailboxes table which has a flag column which can be
a string. There's no foreign key being used here, so there's no deduplication
for mailbox flags. Probably unlikely it would be needed, or just a really old
part of the codebase.
archiveopteryx=# \d mailboxes
Table "public.mailboxes"
Column | Type | Collation | Nullable | Default
--------------+---------+-----------+----------+---------------------------------------
id | integer | | not null |
nextval('mailboxes_id_seq'::regclass)
name | text | | not null |
owner | integer | | |
uidnext | integer | | not null | 1
nextmodseq | bigint | | not null | 1
first_recent | integer | | not null | 1
uidvalidity | integer | | not null | 1
deleted | boolean | | not null | false
flag | text | | |
Perhaps setting this column to "not null" fixes it or setting a default value?
--
Mark Felder
[email protected]
