There is the following constraint on the posts table
alter table public.posts add constraint posts_status_check check (((status)::text = any ((array['Public'::character varying, 'Unlisted'::character varying, 'Private'::character varying])::text[])));
Because of the values in these select fields being lowercase, the constraint fails when these values get used as the 'status' column in the insert statement.
I am not sure about how(and from where) this application is deployed, but on goldfish.social these values are uppercase and posting works.
There is the following constraint on the posts table
alter table public.posts add constraint posts_status_check check (((status)::text = any ((array['Public'::character varying, 'Unlisted'::character varying, 'Private'::character varying])::text[])));Because of the values in these select fields being lowercase, the constraint fails when these values get used as the 'status' column in the insert statement.
I am not sure about how(and from where) this application is deployed, but on goldfish.social these values are uppercase and posting works.