Re: C code problem

here's some code i wrote for generically dealing with postgres in C

--> modify the 'connect' as you see fit -- mine was based on SUID user
processing for some daemons we were using

void SQLShutdown(PGconn *conn)
{
PQfinish(conn);
}

int SQLString(char *is, char *os)
{
char *ch=is,
*ch2=os;

while (*ch) {
if (*ch == '\'')
*ch2++ = '\'';
*ch2++ = *ch++;
}
*ch2 = 0;
return(0);
}

PGconn *SQLConnect(void)
{
PGconn *conn;
char *dbName = "",
*pghost = NULL, /* host name of the backend server */
*pgport = NULL, /* port of the backend server */
*pgoptions = NULL, /* special options to start up the backend
server
*/
*pgtty = NULL; /* debugging tty for the backend server */

Debugf("SQLConnect()\n");

conn = PQsetdb(pghost, pgport, pgoptions, pgtty, dbName);
if (PQstatus(conn) == CONNECTION_BAD) {
printf("Connection to database '%s' failed.\n", dbName);
printf("%s",PQerrorMessage(conn));
return(NULL);
}
return(conn);
}

int SQLDisconnect(PGconn *conn)
{
PQfinish(conn);
}

PGresult *SQLExecute(PGconn *conn, char *xBuf, int resultOK)
{
PGresult *res;

printf("%s\n", xBuf);

res = PQexec(conn, xBuf);
if (PQresultStatus(res) != resultOK) {
printf("PQresultStatus(res) : %d\n", PQresultStatus(res));
printf("! Command failed\n");
PQclear(res);
return(NULL);
}
else
return(res);
}

PGresult *SQLExecuteQuietly(PGconn *conn, char *xBuf, int resultOK)
{
PGresult *res;

res = PQexec(conn, xBuf);
if (PQresultStatus(res) != resultOK) {
printf("PQresultStatus(res) : %d\n", PQresultStatus(res));
printf("! Command failed\n");
PQclear(res);
return(NULL);
}
else
return(res);
}

-duck

On Tue, 17 Apr 2001, John Burski wrote:

> 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? +
> ++++++++++++++++++++++++++++++++++
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>

-----------------------------------------------------------------------------
david(at)backpack(dot)com BackPack Software, Inc. www.backpack.com
+1 651.645.7550 voice "Life is an Adventure.
+1 651.645.9798 fax Don't forget your BackPack!"
-----------------------------------------------------------------------------