Re: Strange interaction with php's pg_query

Bill Moran <wmoran(at)potentialtech(dot)com> writes:
> 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

I think your php client must be connecting to a different database
than you are connecting to when you run psql by hand. If you are
allowing the default choice of database name = user name to be taken,
this isn't real surprising...

> This really confuses me, as "sysinfo" isn't even a relation and
> why should the parser even imagine it to be a relation?

"relation" and "table" are more or less synonymous in PG error messages.
(IMHO the exact meaning of "relation" in our code is "something with a
pg_class entry", which covers also views, sequences, indexes, etc; but
you probably didn't need to know that.)

regards, tom lane