We're happy to Announce Thin Backend - a blazing fast, universal web app backend for making realtime SPAs

unrecognized configuration parameter "rls.ihp_user_id"

Manborough
Hi everyone, I'm getting an issue when I try to create a post with a foreign key relationship to the users table. The user_id column has a default value of ihp_user_id(). I can create posts again when I remove the column. This is the error: unrecognized configuration parameter "rls.ihp_user_id" I'm also getting this error now when trying to run a migration with a policy that uses the ihp_user_id() function. Is there somewhere I need to add this function or enable it?
marc PRO

Can you remove the default value ihp_user_id()?

Manborough
I could, but I thought this was a function provided by IHP to access the current user id. This is from the docs. The ihp_user_id() is a database function provided by IHP that returns the user id of the logged in user of the IHP application.
marc PRO

Yeah, but you're very likely not using Row level security for authentication, so then this function will not work as expected, even if it was defined :)

Manborough
I assume there's more to be done besides adding ensureAuthenticatedRoleExists to the FrontController and ALTER TABLE posts ENABLE ROW LEVEL SECURITY in my migrations? Or do I need to define the ihp_user_id function myself? I couldn't see any sql statements in the DataSync.Role module. Thanks for your help so far.