Strange interaction with php's pg_query

From: Bill Moran <wmoran(at)potentialtech(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Strange interaction with php's pg_query
Date: 2002-05-14 03:08:48
Message-ID: 3CE07FC0.5020308@potentialtech.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I'm a little burned out right now, so I figured I'll ask the
question before calling quits for tonight, and (hopefully) the
answer will be in my inbox come morning. ;)

I'm building a web app in php with Postgre as the backend db.
I'm pretty new to Postgre, but I've done a lot of work with
php+MySQL.

I have a simple table as follows:

create table sysinfo (
attname char(30) primary key,
attvalue text
) without oids

And if I start psql and enter:
"select * from sysinfo"
I get the expected list of name/value pairs that were entered
into the table at an earlier operation.

However, if I execute the same query using pg_query() in php,
I get the error:
Warning: pg_query() query failed: ERROR: Relation "sysinfo" does not exist in /usr/home/group/webpages/epd/class/base.class.php on line 44

This really confuses me, as "sysinfo" isn't even a relation and
why should the parser even imagine it to be a relation? I've
tried rearranging the SELECT statement (with and without WHERE
clauses, with and without FROM clause). Every incarnation I try
works fine in the psql program, but gives the same error (as above)
in php.

I'm using FreeBSD 4.5-STABLE as of April 23rd, Postgres 7.2.1_1,
mod_php4-4.2.0, and apache-1.3.24_7 all installed from FreeBSD
ports collection.

Any advice is much welcome.

--
Bill Moran
Potential Technology
http://www.potentialtech.com

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2002-05-14 03:31:51 Re: Strange interaction with php's pg_query
Previous Message Tom Lane 2002-05-14 02:34:33 Re: restoreing dumps fail