Error invalid input syntax for type bigint
Hi,
I have a many-to-one relationship, both using generated UUIDs as the primary keys, and the foreign key.
Using the JS library I'm doing this to get the foreign elements:
await supabase.from('invoice_item').select('*').eq('invoice_id', sInvoiceID);
But I'm getting this JS error:
invalid input syntax for type bigint: "89d3477e-6044-42ae-bc6f-de1d9a763fg8"
I've double checked that the primary keys and foreign key are all UUID type and valid.
Any ideas?
Thanks.
I have a many-to-one relationship, both using generated UUIDs as the primary keys, and the foreign key.
Using the JS library I'm doing this to get the foreign elements:
await supabase.from('invoice_item').select('*').eq('invoice_id', sInvoiceID);
But I'm getting this JS error:
invalid input syntax for type bigint: "89d3477e-6044-42ae-bc6f-de1d9a763fg8"
I've double checked that the primary keys and foreign key are all UUID type and valid.
Any ideas?
Thanks.
