I’ve connected PostgreSQL DB I’ve created for a client to his account without using Share option - normally as a external source. It recognized table links - even many to many but ordering is not working. nc_order column is present, but ordering capability is not working.
Also nc_order on some tables does not correlate with order in on the original NocoDB account - I can’t use this feature on external systems.
It aslo rises a question - will I be able to move this DB to another server, replace hostname and retain all NocoDB logic?
I have duplicated table outside NC, removed nc_order column, synced metadata on both instances and neither have working ordering on this table. nc_order was also not recreated.
AFAIK, row re-ordering is only supported for the base created directly on NocoDB. Feature not available for external data sources. For external data source table- one should not see drag-drop icon for row as well.
Row reordering is supported for external DB tables if the table was created from NocoDB. In this case, table was duplicated outside NocoDB & a meta sync was done. Row reordering is not supported for such instances currently.