I dumped an existing PostgrSQL database (generating "Insert" statements), and imported it on another computer. The source runs Debian (UK) OS, the target Mint (FR) OS.
For some tables, when I try to visualise in Squirrel SQL, I get the following:
- Squirrel "Row count" tab displays 351
- Squirrel "Content" does not show anything
- but executing the query "select * from myTable" returns all the lines
For the same table, when ruby tries to extract one record, it does not find it. But I can check that the record exists in Squirrel.
All indexes were rebuilt, no transaction pending. The same data base is accessed with Ruby and Squirrel, with the same user.
What could be the reason, how to solve this blocking issue ?