ERROR: relation "userroles" does not exist

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

Responses

Browse pgsql-php by date

  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.