Not sure if this is a feature or a bug, but - When I try to create a column in the supabase UI like "postIds" which is an array of uuids that are meant to reference records in another table - I'm only able to create it if I don't include a foreign key relation. Is this just just a Postgres limitation, or...?

Hello @Mike_! This thread has been automatically created from your message in #843999948717555735 a few seconds ago. We have already mentioned the @User so that they can see your message and help you as soon as possible! Want to unsubscribe from this thread? Right-click the thread in Discord (or use the ``...`` menu) and select "Leave Thread" to unsubscribe from future updates. Want to change the title? Use the ``/title`` command! We have solved your problem? Click the button below to archive it.

In other words - it seems there's no way to have an array of uuids - with foreign key relations

You are correct, you can't do that. One solution is to do a table with multiple rows with your userid and different postids.

ahhh yes - I've seen this pattern, it's clicking now, thanks Gary!

Thread was archived by @Mike_. Anyone can send a message to unarchive it.