by wolfspiritm
Hi. I'm following: https://supabase.com/docs/guides/database/migrating-to-pg-partman
If I do exactly that then I get an error when copying existing messages cause there is no underlying table (I forgot the exact error). So I'm pretty sure I have to set up partman before copying the data over so the tables are created.
Now after setting up partman like in the example which is marked optional it creates the tables HOWEVER they are all "UNRESTRICTED" cause they don't have any RLS restriction enabled. If I now copy my data everyone can access it. Am I missing something or is that migration doc just dangerous? How can I tell partman to create RLS restriction for that ables?
The user is following the Supabase guide for migrating to pg_partman but encounters issues with missing tables and unrestricted access due to lack of RLS. They suspect the guide is incomplete or incorrect and seek advice on setting up RLS with partman.
I don't think anyone here is going to be able to help. There have never been any partman discussions here that I can find.
Here is claude's view of what has to be done: https://claude.ai/share/80a91f9f-a30b-4de0-b461-3f2d312feab4
There is this link on native partitions (but that won't help with partman). https://discord.com/channels/839993398554656828/1006358244786196510