Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-php by date

Next:From: Raymond O'DonnellDate: 2008-10-10 18:17:08
Subject: Re: ERROR: relation "userroles" does not exist
Previous:From: Frank BaxDate: 2008-10-10 16:26:47
Subject: Re: store data files encryptypted in database.

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group