ERROR: relation "userroles" does not exist

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Hello All,

I keep receiving the following when trying to select from a table in my database. the Tables are there i see them in pgAdmin...

Warning: pg_query_params() []: Query failed: ERROR: relation "userroles" does not exist

The query I'm running is

SELECT userPassword, salt, roleName
            FROM User u,  UserRoles ur, Roles r
            where = ur.user_id
            and = ur.role_id
            and u.username = $1
            and = true

[Index of Archives]     [Postgresql General]     [Postgresql Admin]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Yosemite Backpacking]     [Postgresql Jobs]

  Powered by Linux