I am leaning towards solution 3 for now. But it's kind of a hack. Is there any better solution that I am missing?
pgsql-general by date:
Соглашаюсь с условиями обработки персональных данных