citusdata / citusdata/pgconfus-tutorial-multi-tenant

Create Table ERROR: function uuid_generate_v4() does not exist

Open
#5 0 comments 0 reactions 0 assignees View on GitHub
Dominant language
Ruby
Stars
9
Forks
7
PR merge metrics
No merged PRs in 30d

Description

Unable to create table `tutorial.users`

-- DDL
```
CREATE TABLE tutorial.users (
user_id uuid NOT NULL DEFAULT uuid_generate_v4(),
email text NOT NULL UNIQUE,
encrypted_password text NOT NULL ,
created_at timestamptz NOT NULL DEFAULT now(),
updated_at timestamptz NOT NULL DEFAULT now(),
PRIMARY KEY (user_id)
);
```
-- ERROR
```
SQL Error [42883]: ERROR: function uuid_generate_v4() does not exist
Hint: No function matches the given name and argument types. You might need to add explicit type casts.
Position: 64
```

- Is there an option to try this on my local postgres instance?
- Alternative, how can I test this in Citus Cloud Formation?

Contributor guide

No contributing guide indexed for this repository

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.