Le 28/09/2016 à 11:12, Joel Bergmark a écrit : > Hi! > > This is the output from explain: > > postgres=# EXPLAIN SELECT DISTINCT main.* FROM Users main CROSS JOIN ACL > ACL_3 JOIN Principals Principals_1 ON ( Principals_1.id = main.id ) JOIN > CachedGroupMembers CachedGroupMembers_2 ON ( CachedGroupMembers_2.MemberId = > Principals_1.id ) JOIN CachedGroupMembers CachedGroupMembers_4 ON ( > CachedGroupMembers_4.MemberId = Principals_1.id ) WHERE ((ACL_3.ObjectType = > 'RT::Queue' AND ACL_3.ObjectId = 56) OR (ACL_3.ObjectType = 'RT::System' > AND ACL_3.ObjectId = 1)) AND (ACL_3.PrincipalId = > CachedGroupMembers_4.GroupId) AND (ACL_3.PrincipalType = 'Group') AND > (ACL_3.RightName = 'OwnTicket') AND (CachedGroupMembers_2.Disabled = '0') AND > (CachedGroupMembers_2.GroupId = '4') AND (CachedGroupMembers_4.Disabled = > '0') AND (Principals_1.Disabled = '0') AND (Principals_1.PrincipalType = > 'User') AND (Principals_1.id != '1') ORDER BY main.Name ASC; > ERROR: relation "users" does not exist > LINE 1: EXPLAIN SELECT DISTINCT main.* FROM Users main CROSS JOIN AC... >
seems you are not connected to the right database as the table Users is not found ;) --------- RT 4.4 and RTIR training sessions, and a new workshop day! https://bestpractical.com/training * Boston - October 24-26 * Los Angeles - Q1 2017