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: (view raw, whole thread or download thread mbox)
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()
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


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-2017 The PostgreSQL Global Development Group