can't support create database for pg12.06

[xiaods]

Provide the MySQL version you are using (if related with instance/database operation)

Provide the GitLab version you are using (if related with VCS integration)

Provide the Bytebase version you are using

The version info is shown on the bottom left of the console.

Describe the bug

A clear and concise description of what the bug is.

Steps or screenshots to reproduce the behavior

1. Go to 'database'
2. Click on 'create database'
3. See error

If the error is not obvious, you can enable the --debug option on startup and attach the console message here

Expected behavior

A clear and concise description of what you expected to happen.

Desktop (please complete the following information):

• Browser [e.g. chrome, safari]
• Version [e.g. 22]

Additional context

Add any other context about the problem here.

[spinningbot]

It looks like you have some views without definitions for some reasons. We're providing a fix to exclude views with NULL view definition from schema dumps.

https://www.postgresql.org/docs/12/sql-createview.html

[xiaods]

thanks for your patch

[spinningbot]

Hi xiaods@, did you also grant bytebase enough permission to get all the views? I was thinking how we get to a spot with empty view definition which is almost required.

There are some instructions on adding an instance.
"Below is an example to create user 'bytebase' with password YOUR_DB_PWD and grant the user with the needed privileges. If the connecting instance is self-hosted, then you can grant SUPERUSER."

[xiaods]

Hi xiaods@, did you also grant bytebase enough permission to get all the views? I was thinking how we get to a spot with empty view definition which is almost required.

There are some instructions on adding an instance. "Below is an example to create user 'bytebase' with password YOUR_DB_PWD and grant the user with the needed privileges. If the connecting instance is self-hosted, then you can grant SUPERUSER."

I use a normal user without superuser permission. let me double check it.

[spinningbot]

Hi xiaods@, would you mind sharing us the story for closing the bug? Just curious and wanna learn something. Thanks!

[xiaods]

Hi xiaods@, would you mind sharing us the story for closing the bug? Just curious and wanna learn something. Thanks!

As you designed it, this SQL editor is for querying SQL and not for managing DML. As I am new to SQL editor, I did not know the process, so I executed the wrong SQL directly inside SQL editor to report an error. After your reminder, I have known the process. I have used the DML language in Alter Schema and it works fine, so I closed the issue