validate_shape_column_against_pg_column()

static int validate_shape_column_against_pg_column ( int  dbf_fieldtype, char *  pg_fieldtype  )

static

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

{
        switch (dbf_fieldtype)
        {
                case FTString:
                        /* Only varchar */
                        if (!strcmp(pg_fieldtype, "varchar"))
                                return -1;
                        break;
 
                case FTDate:
                        /* Only date */
                        if (!strcmp(pg_fieldtype, "date"))
                                return -1;
                        break;
 
                case FTInteger:
                        /* Tentatively allow int2, int4 and numeric */
                        if (!strcmp(pg_fieldtype, "int2") || !strcmp(pg_fieldtype, "int4") || !strcmp(pg_fieldtype, "numeric"))
                                return -1;
                        break;
 
                case FTDouble:
                        /* Only float8/numeric */
                        if (!strcmp(pg_fieldtype, "float8") || !strcmp(pg_fieldtype, "numeric"))
                                return -1;
                        break;
 
                case FTLogical:
                        /* Only boolean */
                        if (!strcmp(pg_fieldtype, "boolean"))
                                return -1;
                        break;
        }
 
        /* Otherwise we can't guarantee this (but this is just a warning anyway) */
        return 0;
}

References FTDate, FTDouble, FTInteger, FTLogical, and FTString.

Referenced by validate_remote_loader_columns().

Here is the caller graph for this function: