getMaxFieldSize()

static int getMaxFieldSize ( PGconn *  conn, char *  schema, char *  table, char *  fname  )

static

Definition at line 534 of file pgsql2shp-core.c.

References _, free(), LWDEBUGF, malloc(), and window::res.

Referenced by ShpDumperOpenTable().

{
        int size;
        char *query;
        PGresult *res;

        /*( this is ugly: don't forget counting the length  */
        /* when changing the fixed query strings ) */

        if ( schema )
        {
                query = (char *)malloc(strlen(fname)+strlen(table)+
                                       strlen(schema)+46);
                sprintf(query,
                        "select max(octet_length(\"%s\"::text)) from \"%s\".\"%s\"",
                        fname, schema, table);
        }
        else
        {
                query = (char *)malloc(strlen(fname)+strlen(table)+46);
                sprintf(query,
                        "select max(octet_length(\"%s\"::text)) from \"%s\"",
                        fname, table);
        }

        LWDEBUGF(4, "maxFieldLenQuery: %s\n", query);

        res = PQexec(conn, query);
        free(query);
        if ( ! res || PQresultStatus(res) != PGRES_TUPLES_OK )
        {
                printf( _("Querying for maximum field length: %s"),
                        PQerrorMessage(conn));
                return -1;
        }

        if (PQntuples(res) <= 0 )
        {
                PQclear(res);
                return -1;
        }
        size = atoi(PQgetvalue(res, 0, 0));
        PQclear(res);
        return size;
}

Here is the call graph for this function:

Here is the caller graph for this function: