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

schema immediately out of sync on postgres when creating table, columns #1753

Closed
tlonic opened this issue Apr 19, 2022 · 3 comments
Closed
Assignees
Labels
🐛 Type: Bug Something is broken or incorrect unexpectedly. 🕊️ Type: Migration Migration issues related to 0.90 Upgrade

Comments

@tlonic
Copy link

tlonic commented Apr 19, 2022

please provide the following details :
NocoDB used as docker : true
NocoDB version : 0.90.3
Database used in NC_DB URL : pg
Project was created by clicking : New Project by connecting to external database
Database on which spreadsheet is created : pg

Steps To Reproduce

  1. Create new table
  2. Go to Metadata
  3. See that metadata associated with system fields is already out of sync:
    "Column type changed(id), Column type changed(created_at), Column type changed(updated_at)"
  4. Create new column
  5. See that metadata associated with new column is out of sync,
    "Column type changed(newcolumn)"

Expected behavior
Column type should already be synced on creating a table and a column

Screenshots
image

@wingkwong
Copy link
Member

Able to reproduce. It seems this issue only exists in Postgres.

@tlonic tlonic changed the title schema immediately out of sync when creating table, columns schema immediately out of sync on postgres when creating table, columns Apr 19, 2022
@wingkwong wingkwong added the 🐛 Type: Bug Something is broken or incorrect unexpectedly. label Apr 19, 2022
pranavxc added a commit that referenced this issue Apr 19, 2022
…quest payload

re #1753

Signed-off-by: Pranav C <pranavxc@gmail.com>
pranavxc added a commit that referenced this issue Apr 19, 2022
…quest payload

re #1753

Signed-off-by: Pranav C <pranavxc@gmail.com>
@wingkwong wingkwong added the 🕊️ Type: Migration Migration issues related to 0.90 Upgrade label Apr 20, 2022
@github-actions
Copy link
Contributor

github-actions bot commented Apr 23, 2022

Fixed in v0.90.7.

@rajeshdhanda
Copy link

still facing the issue, updated data in postgres via psql command line, not able to sync in nocodb. also modifying table from UI doesn't update the swagger UI and CRUD endpoints. i.e. dropped a column and added a new column via psql did not reflect the changes in UI and creates Internal server error in CRUD endpoints.
docker used : nocodb/nocodb:latest

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
🐛 Type: Bug Something is broken or incorrect unexpectedly. 🕊️ Type: Migration Migration issues related to 0.90 Upgrade
Projects
None yet
Development

No branches or pull requests

5 participants