Data table 'XXXXXX' is not accessible due to: 42P01: missing FROM-clause entry for table "X".

[SkrOYC]

Having some problems with a SQL table.

AppSheet is yelling with this error for 3 tables out of 46.

The first 43 where copied automatically via copy-app and the other 3 where added manually and all table names as well as column names match without any problems.

All of this tables inside AppSheet are pointing to the right table on the SQL datasource but these 3 are showing the error mentioned on the subject of this post.

@lizlynch please tag anyone with knowledge on the back end. Thanks!

[SkrOYC]

Does anyone know about this? It's a Postgres database.

It doesn't seem to be a problem related with the database but the way AppSheet handles it, but who knows.

Support ignored my ticket presented yesterday.

I'm sorry to bother you @Steve but can you escalate it?

[lizlynch]

@SkrOYC - Does this issue still exist? Has the support team responded to your ticket?

[SkrOYC]

Hi @lizlynch, thanks for passing by.
Mark Chesters took my ticket.

I'm going to try his solution about naming conventions although the other 43 tables are working fine eventhough are named following the same rules as the 3 ones