C code problem

Поиск
Список
Период
Сортировка
От John Burski
Тема C code problem
Дата
Msg-id 3ADC4852.1179FFD2@911ep.com
обсуждение исходный текст
Ответы Re: C code problem  ("D. Duccini" <duccini@backpack.com>)
Список 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? +
++++++++++++++++++++++++++++++++++




В списке pgsql-novice по дате отправления:

Предыдущее
От: "Oliver Elphick"
Дата:
Сообщение: Re: createdb problem...
Следующее
От: "D. Duccini"
Дата:
Сообщение: Re: C code problem