Different Data Is Displayed for the Same Table Queried By Multiple Users
Symptom
Two users log in to the same database human_resource and run the select count(*) from areas statement separately to query the areas table, but obtain different results.
Cause Analysis
Check whether the two users really query the same table. In a relational database, a table is identified by three elements: database, schema, and table. In this issue, database is human_resource and table is areas. Then, check schema. Log in as users dbadmindbadmin and user01 separately. It is found that search_path is public for dbadmin and $user for user01. By default, a schema having the same name as user dbadmin, the cluster administrator, is not created. That is, all tables will be created in public if no schema is specified. However, when a common user, such as user01, is created, the same-name schema (user01) is created by default. That is, all tables are created in user01 if the schema is not specified. In conclusion, because both users performed operations on the table, there are now two different tables with the same name.
Solution
Use schema.table to determine a table for query.
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.
