postgres.git / summary / log / commit / refs

commit    dd0fa0f958afb32e4e24f25607e3e96734c33f07
Author:   Tom Lane <tgl@sss.pgh.pa.us>
Date:     Thu Oct 06 23:05:22 2005 +0000
First released in: 8.1.0

    Minor dbf2pg fixes from Martin Pitt: check for failure when issuing
    CREATE TABLE command, and translate dBase's 'M' field type to 'text'.


 contrib/dbase/dbf2pg.c | 6 +++++-
 1 file changed, 5 insertions(+), 1 deletion(-)

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));


[parent: e6b92542a39b]