C code problem - Mailing list pgsql-novice

I'm running PostgreSQL 7.0.3 on a Red Hat 6.1 box and am having a bit of
trouble with some C code.

I'm able to connect to the database OK (host = localhost, hostaddr =
127.0.0.1, dbname = template1, user = postgres (the superuser), password
= whatever), but a PGRES_NONFATAL_ERROR status results from the
following query:

     result = PQexec ( dbc, "SELECT * FROM pg_user" );

If I run the query from an interactive session it works fine.  I've
other programs that work fine, but none of them connect to "template1"
or attempt to access the system tables.  Is there some sort of access
restriction related to the system tables?

Thanks.

--
John Burski
I.T. Manager
911 Emergency Products
25 Sixth Avenue North
St. Cloud, MN  56303
(320) 656 0076       www.911ep.com

++++++++++++++++++++++++++++++++++
+ How's your cheese holding out? +
++++++++++++++++++++++++++++++++++