diff options
| author | Tom Lane <tgl@sss.pgh.pa.us> | 2005-10-06 23:05:22 +0000 |
|---|---|---|
| committer | Tom Lane <tgl@sss.pgh.pa.us> | 2005-10-06 23:05:22 +0000 |
| commit | dd0fa0f958afb32e4e24f25607e3e96734c33f07 (patch) | |
| tree | e75b8464e5b8a83523339d5b21a8cb5c7653658b | |
| parent | e6b92542a39b50d0c02f90ef56aa6930e26eca81 (diff) | |
| download | postgresql-dd0fa0f958afb32e4e24f25607e3e96734c33f07.tar.gz postgresql-dd0fa0f958afb32e4e24f25607e3e96734c33f07.zip | |
Minor dbf2pg fixes from Martin Pitt: check for failure when issuing
CREATE TABLE command, and translate dBase's 'M' field type to 'text'.
| -rw-r--r-- | contrib/dbase/dbf2pg.c | 6 |
1 files changed, 5 insertions, 1 deletions
diff --git a/contrib/dbase/dbf2pg.c b/contrib/dbase/dbf2pg.c index 8acb65c557a..c3e50dc4ac2 100644 --- a/contrib/dbase/dbf2pg.c +++ b/contrib/dbase/dbf2pg.c @@ -301,6 +301,9 @@ do_create(PGconn *conn, char *table, dbhead * dbh) case 'L': strcat(query, " char"); break; + case 'M': + strcat(query, " text"); + break; } } @@ -312,7 +315,8 @@ do_create(PGconn *conn, char *table, dbhead * dbh) printf("%s\n", query); } - if ((res = PQexec(conn, query)) == NULL) + if ((res = PQexec(conn, query)) == NULL || + PQresultStatus(res) != PGRES_COMMAND_OK) { fprintf(stderr, "Error creating table!\n"); fprintf(stderr, "Detailed report: %s\n", PQerrorMessage(conn)); |