create_index()

static int create_index ( const char *  schema, const char *  table, const char *  column, const char *  tablespace, STRINGBUFFER *  buffer  )

static

Definition at line 1046 of file raster2pgsql.c.

  {
        char *sql = NULL;
        uint32_t len = 0;
        char *_table = NULL;
        char *_column = NULL;
 
        assert(table != NULL);
        assert(column != NULL);
 
        _table = chartrim(table, "\"");
        _column = chartrim(column, "\"");
 
        /* create index */
        len = strlen("CREATE INDEX \"__gist\" ON  USING gist (st_convexhull());") + 1;
        if (schema != NULL)
                len += strlen(schema);
        len += strlen(_table);
        len += strlen(_column);
        len += strlen(table);
        len += strlen(column);
        if (tablespace != NULL)
                len += strlen(" TABLESPACE ") + strlen(tablespace);
 
        sql = rtalloc(sizeof(char) * len);
        if (sql == NULL) {
                rterror(_("create_index: Could not allocate memory for CREATE INDEX statement"));
                rtdealloc(_table);
                rtdealloc(_column);
                return 0;
        }
        sprintf(sql, "CREATE INDEX ON %s%s USING gist (st_convexhull(%s))%s%s;",
                (schema != NULL ? schema : ""),
                table,
                column,
                (tablespace != NULL ? " TABLESPACE " : ""),
                (tablespace != NULL ? tablespace : "")
        );
        rtdealloc(_table);
        rtdealloc(_column);
 
        append_sql_to_buffer(buffer, sql);
 
        return 1;
}

References _, append_sql_to_buffer(), buffer(), chartrim(), rtalloc(), rtdealloc(), and rterror().

Referenced by process_rasters().

Here is the call graph for this function:

Here is the caller graph for this function: