Actually… I’m stuck on the query. I need to update category ID 1 to notification level of regular (1).
From rails… I’m typing
User.exec_sql("INSERT INTO category_users(category_id, user_id, notification_level) SELECT 1, u.id, 1 FROM users u LEFT JOIN category_users cu ON cu.category_id = 1 AND cu.user_id = u.id WHERE cu.user_id IS NULL;")
I get response
<PG::Result:0x000055fadb534428 status=PGRES_COMMAND_OK ntuples=0 nfields=0 cmd_tuples=0>
Via the GUI/forums, it looks like it hasn’t changed.