From discord

@fooware

Since relationships with composite keys turned out to be unsupported according to the electrification error, I instead tried to manually do it for an important table by changing it's UUID primary key to TEXT, but keep all other PKs as UUID.

But then I got this very odd error when trying to add a relationship, which I guess is because the junction tables now have a (non-relational) composite primary key with one UUID and TEXT?

psql:sql/seed_data.sql:54: ERROR: ARRAY types uuid and text cannot be matched
LINE 1: serialized_pk := ARRAY[this_row.id, this_row.user_id]:...
^
QUERY: serialized_pk := ARRAY[this_row.id, this_row.user_id]::text
CONTEXT: PL/pgSQL function electric.send_self_trigger_publicproject_owner() line 9 at assignment

Is this considered a fundamental limitation, temporary limitation or a bug in Electric?

@alco

Looks like a bug to me. PK values should have been casted to text before being put into ARRAY[...]. This is Electric's internal SQL code.