Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

ERROR: function uuid_generate_v4() does not exist (SQLSTATE 42883) #10513

Open
dfang opened this issue Jan 25, 2024 · 2 comments
Open

ERROR: function uuid_generate_v4() does not exist (SQLSTATE 42883) #10513

dfang opened this issue Jan 25, 2024 · 2 comments
Labels
bug Something isn't working

Comments

@dfang
Copy link

dfang commented Jan 25, 2024

Provide the Bytebase version you are using

v2.13.0

Describe the bug

创建schema迁移工单时,报错:
ERROR: function uuid_generate_v4() does not exist (SQLSTATE 42883)

Steps to reproduce

CREATE EXTENSION IF NOT EXISTS "uuid-ossp";
CREATE TABLE PUBLIC.bargains (
  id uuid NOT NULL DEFAULT uuid_generate_v4 (),
  CONSTRAINT bargains_pkey PRIMARY KEY (ID)
) TABLESPACE pg_default;

Expected behavior

如psql控制台下一样 可以正常执行

Provide the database you are using

PostgreSQL 15.1 (Ubuntu 15.1-1.pgdg20.04+1) on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 9.4.0-1ubuntu1~20.04.1) 9.4.0, 64-bit

Provide the version control system you are using

git

Additional context

No response

@dfang dfang added the bug Something isn't working label Jan 25, 2024
@d-bytebase
Copy link
Contributor

Does public.uuid_generate_v4() work?

@dfang
Copy link
Author

dfang commented Jan 27, 2024

nope,

ERROR: function public.uuid_generate_v4() does not exist (SQLSTATE 42883) 

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working
Projects
None yet
Development

No branches or pull requests

2 participants