Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 3588A37C031 for ; Fri, 10 Oct 2008 14:30:36 -0300 (ADT) Received: from postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 50650-08 for ; Fri, 10 Oct 2008 14:30:33 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail-gx0-f16.google.com (mail-gx0-f16.google.com [209.85.217.16]) by postgresql.org (Postfix) with ESMTP id D60A337BFF5 for ; Fri, 10 Oct 2008 14:30:32 -0300 (ADT) Received: by gxk9 with SMTP id 9so338915gxk.19 for ; Fri, 10 Oct 2008 10:30:32 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to :subject:mime-version:content-type; bh=u11H0jDkS39SLSnWDQbVMzaUKdORI/7t2yfRvFEsFnY=; b=s6px8N8TS7P9uJAgpXnuIevO2XfoTFgD3IB/GTIZiaSmE77rgqgz23SGN4Xv4EwTPA mD7rP5xRZbu+RVHZUxkCLhbwmXTUCs6xQXxLsLISVvHMzaWkK76FQi6EA5haV1od44ap jNoyNJzcLJc/gyzWP3BL7/9mJm+6wKb7OovKg= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:mime-version:content-type; b=kf/vluKw9ZbbMzZSprJSCMStrX2gMlxQUaoBOYs9eLa/hvcUxbWWJqFZvd94HSbo50 +Xlzl1TbRHdCOgsBMtLI2bPONlQadNGLOY+zS/OXr/xWfO+WUXR3qXQYwpsDRjV4Jb+U eOaogHsD/1yGJ+90Mzz5N5bYNeT6M5Eq/RVNI= Received: by 10.142.140.14 with SMTP id n14mr919481wfd.164.1223659831347; Fri, 10 Oct 2008 10:30:31 -0700 (PDT) Received: by 10.143.156.2 with HTTP; Fri, 10 Oct 2008 10:30:31 -0700 (PDT) Message-ID: Date: Fri, 10 Oct 2008 13:30:31 -0400 From: Sean To: pgsql-php@postgresql.org Subject: ERROR: relation "userroles" does not exist MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_130355_4313784.1223659831206" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=1.5 tagged_above=0 required=5 tests=HTML_MESSAGE=0.001, WEIRD_PORT=1.499 X-Spam-Level: * X-Archive-Number: 200810/5 X-Sequence-Number: 3902 ------=_Part_130355_4313784.1223659831206 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline *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]: 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 ------=_Part_130355_4313784.1223659831206 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline
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]: 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



------=_Part_130355_4313784.1223659831206--