postgres.git / summary / log / commit / refs

commit    cf4cee1b17d71f59efb0b47c79357e102f542257
Author:   Bruce Momjian <bruce@momjian.us>
Date:     Thu Mar 20 07:05:21 2003 +0000
First released in: 7.4

    At present, dates are put into a dump in the format specified by the
    default datestyle.  This is not portable between installations.
    
    This patch sets DATESTYLE to ISO at the start of a pg_dump, so that the
    dates written into the dump will be restorable onto any database,
    regardless of how its default datestyle is set.
    
    Oliver Elphick


 src/bin/pg_dump/pg_dump.c | 9 ++++++++-
 1 file changed, 8 insertions(+), 1 deletion(-)

diff --git a/src/bin/pg_dump/pg_dump.c b/src/bin/pg_dump/pg_dump.c
index 0c67b113bfd..d51f5f544da 100644
--- a/src/bin/pg_dump/pg_dump.c
+++ b/src/bin/pg_dump/pg_dump.c
@@ -12,7 +12,7 @@
  *	by PostgreSQL
  *
  * IDENTIFICATION
- *	  $Header: /cvsroot/pgsql/src/bin/pg_dump/pg_dump.c,v 1.321 2003/03/20 06:26:30 momjian Exp $
+ *	  $Header: /cvsroot/pgsql/src/bin/pg_dump/pg_dump.c,v 1.322 2003/03/20 07:05:21 momjian Exp $
  *
  *-------------------------------------------------------------------------
  */
@@ -548,6 +548,13 @@ main(int argc, char **argv)
 					  PQerrorMessage(g_conn));
 	PQclear(res);
 
+    /* Set the datestyle to ISO to ensure the dump's portability */
+    res = PQexec(g_conn, "SET DATESTYLE = ISO");
+    if (!res || PQresultStatus(res) != PGRES_COMMAND_OK)
+            exit_horribly(g_fout, NULL, "could not set datestyle to ISO: %s",
+                                      PQerrorMessage(g_conn));
+    PQclear(res);
+
 	/*
 	 * If supported, set extra_float_digits so that we can dump float data
 	 * exactly (given correctly implemented float I/O code, anyway)


[parent: 5f65225fa37b]