pgui_exec()

static int pgui_exec ( const char *  sql )

static

Definition at line 302 of file shp2pgsql-gui.c.

{
        PGresult *res = NULL;
        ExecStatusType status;
        char sql_trunc[256];
 
        /* We need a connection to do anything. */
        if ( ! pg_connection ) return 0;
        if ( ! sql ) return 0;
 
        res = PQexec(pg_connection, sql);
        status = PQresultStatus(res);
        PQclear(res);
 
        /* Did something unexpected happen? */
        if ( ! ( status == PGRES_COMMAND_OK || status == PGRES_TUPLES_OK ) )
        {
                /* Log notices and return success. */
                if ( status == PGRES_NONFATAL_ERROR )
                {
                        pgui_logf("%s", PQerrorMessage(pg_connection));
                        return 1;
                }
 
                /* Log errors and return failure. */
                snprintf(sql_trunc, 255, "%s", sql);
                pgui_logf("Failed SQL begins: \"%s\"", sql_trunc);
                pgui_logf("Failed in pgui_exec(): %s", PQerrorMessage(pg_connection));
                return 0;
        }
 
        return 1;
}

References pg_connection, and pgui_logf().

Referenced by pgui_action_import().

Here is the call graph for this function:

Here is the caller graph for this function: