Use the ::uuid cast to convert the bigint to uuid.

why does that happen, user_id is uuid type. and auth.uid is also a uuid, or whats happening in here ?

vick•1/15/24, 10:52 PM

because an integer is not enough bits to make a UUID. Try converting it using the uuid_generate_v5()uuid_generate_v5() function.

QuickOP•1/15/24, 10:53 PM

but why does this happening if both have the same type ?

QuickOP•1/15/24, 10:53 PM

aren't they ?

QuickOP•1/15/24, 10:55 PM

"CompanyAuthor".user_id is a type of uuid does comparing it against auth.uid() need casting ?

vick•1/15/24, 10:55 PM

are your

user_id

user_id

and author_idauthor_id all UUID type?

QuickOP•1/15/24, 10:55 PM

yes

vick•1/15/24, 10:55 PM

nothing should need a cast. but something there is an integer.

QuickOP•1/15/24, 10:56 PM

I will send a schema visualizer

QuickOP•1/15/24, 10:56 PM

vick•1/15/24, 10:57 PM

so companies.author_id is not a uuid.

QuickOP•1/15/24, 10:57 PM

lemme see if changing that solves it

QuickOP•1/15/24, 10:59 PM

the reason is i have a relation between companies.author_id and companyAuthor

QuickOP•1/15/24, 11:00 PM

to make the foreign key, it has to be an int8

QuickOP•1/15/24, 11:02 PM

QuickOP•1/15/24, 11:04 PM

i think i will reference "user_id" column since that has a value of uuid, because by default "CompanyAuthor".id is a int8

QuickOP•1/15/24, 11:05 PM

and opps