| From: | Sean <sean712(at)gmail(dot)com> |
|---|---|
| To: | pgsql-php(at)postgresql(dot)org |
| Subject: | ERROR: relation "userroles" does not exist |
| Date: | 2008-10-10 17:30:31 |
| Message-ID: | d953ccea0810101030r285012bdv9029c5763d6955cc@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-php |
*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()
[function.pg-query-params<http://localhost:8888/HH/function.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 u.id = ur.user_id
and r.id = ur.role_id
and u.username = $1
and u.active = true
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Raymond O'Donnell | 2008-10-10 18:17:08 | Re: ERROR: relation "userroles" does not exist |
| Previous Message | Frank Bax | 2008-10-10 16:26:47 | Re: store data files encryptypted in database. |