From fd84cafb696326326397004d34fbbc650daf8f82 Mon Sep 17 00:00:00 2001 From: "Marc G. Fournier" Date: Sun, 9 Feb 1997 03:00:09 +0000 Subject: [PATCH] |I took a look at this and I think pg_dump mishandles arrays of ints and floats |by neglecting to quote them. | |I have made a minor change to pg_dump.c that will fix this. | |Dates are dumped and restored OK with pg_dump in V6 | |We'll still need to fix the dump in both cases if the original dump is from V1.09. From Keith Parks --- src/bin/pg_dump/pg_dump.c | 9 ++++++--- 1 file changed, 6 insertions(+), 3 deletions(-) diff --git a/src/bin/pg_dump/pg_dump.c b/src/bin/pg_dump/pg_dump.c index 47706dac16..52f8baa4b7 100644 --- a/src/bin/pg_dump/pg_dump.c +++ b/src/bin/pg_dump/pg_dump.c @@ -20,7 +20,7 @@ * * * IDENTIFICATION - * $Header: /cvsroot/pgsql/src/bin/pg_dump/pg_dump.c,v 1.22 1997/01/07 00:04:16 scrappy Exp $ + * $Header: /cvsroot/pgsql/src/bin/pg_dump/pg_dump.c,v 1.23 1997/02/09 03:00:09 scrappy Exp $ * * Modifications - 6/10/96 - dave@bensoft.com - version 1.13.dhb * @@ -284,12 +284,15 @@ dumpClasses_dumpData(FILE *fout, const char *classname, switch(PQftype(res,field)) { case 21: case 22: case 23: /* int types */ case 810: case 910: /* oldint types */ - case 1005: case 1006: case 1007: /* _int types */ case 700: case 701: /* float types */ - case 1021: case 1022: /* _float types */ fprintf(fout, "%s", PQgetvalue(res,tuple,field)); break; + case 1005: case 1006: case 1007: /* _int types */ + case 1021: case 1022: /* _float types */ + fprintf(fout, "'%s'", + PQgetvalue(res,tuple,field)); + break; default: { char *expsrc,*expdest; -- 2.11.0