Getting error 'null value in column' even though I set a value in the field

[Hertzole]

I have a table on Supabase with 3 columns:

• transaction_id - Primary key, connected to another table's id field, not nullable
• tag_id - Primary key, connected to another table's id field, not nullable
• user_id - Connected to user ids, not nullable

Then in my class

[Table("transaction_tags")]
internal sealed class DbTransactionTag : BaseModel
{
    [PrimaryKey("transaction_id")]
    public Guid TransactionId { get; set; }
    [PrimaryKey("tag_id")]
    public Guid TagId { get; set; }
    [Column("user_id")]
    public Guid UserId { get; set; }
}

And then I try to insert it

var dbTag = new DbTransactionTag
{
    TagId = tag.Id,
    TransactionId = transaction.Id, // This is 100% not null, I've checked multiple scenarios with the debugger
    UserId = UserId
};

await supabase.From<DbTransactionTag>().Insert(dbTag, minimalQueryOptions, cancellationToken);

But no matter what, I just get
Supabase.Postgrest.Exceptions.PostgrestException: {"code":"23502","details":null,"hint":null,"message":"null value in column \"transaction_id\" of relation \"transaction_tags\" violates not-null constraint"}

Am I missing something obvious here? I'm clearly setting the transaction_id field.

[Hertzole]

I managed to solve it by changing PrimaryKey("") to PrimaryKey("", true). There's a hidden shouldInsert parameter there that should be true.

So my class would be

[Table("transaction_tags")]
internal sealed class DbTransactionTag : BaseModel
{
-   [PrimaryKey("transaction_id")]
+   [PrimaryKey("transaction_id", true)]
    public Guid TransactionId { get; set; }
-   [PrimaryKey("tag_id")]
+   [PrimaryKey("tag_id", true)]
    public Guid TagId { get; set; }
    [Column("user_id")]
    public Guid UserId { get; set; }
}