https://supabase.com/ logo
gen_random_uuid() doesn't seem to work? I've looke...
# help
r
gen_random_uuid() doesn't seem to work? I've looked online (ofc) and pgcypto must be enabled which it is.. Anyone an idea? I just want the pk field to auto generate an id on each new entry..
Copy code
create table Answer(
  answer_id uuid default gen_random_uuid() not null,
  question_id uuid not null,
  enricher_id uuid not null,
  answer text not null,
  answer_timestamp timestamp default NOW() not null
)
n
Hello @Rickert! 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.
r
found it. nvm. Need to use uuid_generate_v1()
n
Thread was archived by @Rickert. Anyone can send a message to unarchive it.