Bug Report #1639331014200 - Data Manager - Rename table - PostgreSQL

Wappler General Bugs
1

OS info

  • Operating System : Mac OSX 21.1.0
  • Wappler Version : 4.4.3
  • PostgreSQL : 12.4

Problem description

Created a table named trans
Screen Shot 2021-12-12 at 11.09.56 AM

showing the detail of fields with data

Screen Shot 2021-12-12 at 11.35.47 AM
Screen Shot 2021-12-12 at 11.35.47 AM1226×351 26.6 KB

so it was in PostgreSQL
Screen Shot 2021-12-12 at 11.30.55 AM

When trying to rename the table, it does not show the name update and has errors in the sequence of execution of changes

Screen Shot 2021-12-12 at 11.43.16 AM
Screen Shot 2021-12-12 at 11.43.16 AM1301×474 32.4 KB

No error appears in Wappler for apply Database changes, but the name appears as it was not changed and access to data does not bring results

Analyzing directly in PostgreSQL I realize that it was like this
Screen Shot 2021-12-12 at 11.42.17 AM
I believe the table name change should also have been applied to trans_id_seq

This is a problem?

To solve my problem I removed the table directly in PostgreSQL and did a Rollback Latest Changes to create the previous table and managed to recover the sequence and go back to using normal.

Steps to reproduce

  1. rename table
2

Maybe the table was renamed. But you had a old open table data view as tab that you are checking?

3

Hi @George, I changed the table name from ‘trans’ to ‘translation’ and it started to give problem using the Database Manager.
Although the name changed in the Wappler database the name did not change, it continued with the name ‘trans’ and lost access to the table information.