Can't create new flags with pgsql

[marceloboeira]

Basically, I've started a pod on our cluster with sqlite, everything works well. However, when I switched to postgres nothing works anymore.

Steps to Reproduce (for bugs)

1. Use a Postgres driver
2. Start the pod
3. Try to create a new flag
4. See it fail

time="2018-03-09T15:11:14Z" level=info msg="/go/src/github.com/checkr/flagr/pkg/handler/eval_cache.go:89sql: Scan error on column index 6: Cannot scan {} into Attachment type"
time="2018-03-09T15:11:14Z" level=info msg="/go/src/github.com/checkr/flagr/pkg/handler/eval_cache.go:89sql: Scan error on column index 6: Cannot scan {} into Attachment type"
time="2018-03-09T15:11:14Z" level=info msg="/go/src/github.com/checkr/flagr/pkg/handler/eval_cache.go:89sql: Scan error on column index 6: Cannot scan {} into Attachment type"
time="2018-03-09T15:11:14Z" level=error msg="reload evaluation cache error" err="sql: Scan error on column index 6: Cannot scan {} into Attachment type; sql: Scan error on column index 6: Cannot scan {} into Attachment type; sql: Scan error on column index 6: Cannot scan {} into Attachment type; sql: Scan error on column index 6: Cannot scan {} into Attachment type"
time="2018-03-09T15:11:14Z" level=info msg="/go/src/github.com/checkr/flagr/pkg/handler/eval_cache.go:89sql: Scan error on column ind

Context

Trying to create a new flag with the Postgres driver

Your Environment

• Version used (flagr version): latest
• Operating System and version (uname -a): Linux **-846cbb9848-nd8vt 4.4.111-k8s #1 SMP Sun Jan 14 19:32:08 UTC 2018 x86_64 GNU/Linux
• Link to your project: --

[marceloboeira]

Update

I have switched the driver to mysql, with a mysql database of course, and now I don't experience that error. But still, if pgsql is supported the other issue should be fixed.

[zhouzhuojie]

Thanks for reporting, I will take a look and see how to fix it for pgsql. Currently, we are using MySQL.