aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorTom Lane <tgl@sss.pgh.pa.us>2010-04-15 21:05:11 +0000
committerTom Lane <tgl@sss.pgh.pa.us>2010-04-15 21:05:11 +0000
commit9df6127bcfac4dce26124d24a98710bef9752fb5 (patch)
tree7295190640f27f9e1b467a984b48d73ea642861c
parentb6953bc1897cff77d423d9d4d76af3a43df975f9 (diff)
downloadpostgresql-9df6127bcfac4dce26124d24a98710bef9752fb5.tar.gz
postgresql-9df6127bcfac4dce26124d24a98710bef9752fb5.zip
Fix psql's \copy to not insert spaces around dots and commas in the text of
the SELECT query in \copy (SELECT ...) commands. This is unnecessary and breaks numeric literals, as seen in bug #5411 from Vitalii Tymchyshyn. This change has already been made in passing in HEAD; backpatch to 8.2 through 8.4 (earlier releases don't have COPY (SELECT ...) at all).
-rw-r--r--src/bin/psql/copy.c4
1 files changed, 2 insertions, 2 deletions
diff --git a/src/bin/psql/copy.c b/src/bin/psql/copy.c
index 7207bb3e02d..824ccc30b9e 100644
--- a/src/bin/psql/copy.c
+++ b/src/bin/psql/copy.c
@@ -3,7 +3,7 @@
*
* Copyright (c) 2000-2009, PostgreSQL Global Development Group
*
- * $PostgreSQL: pgsql/src/bin/psql/copy.c,v 1.80.2.1 2009/08/07 20:16:16 tgl Exp $
+ * $PostgreSQL: pgsql/src/bin/psql/copy.c,v 1.80.2.2 2010/04/15 21:05:11 tgl Exp $
*/
#include "postgres_fe.h"
#include "copy.h"
@@ -146,7 +146,7 @@ parse_slash_copy(const char *args)
while (parens > 0)
{
- token = strtokx(NULL, whitespace, ".,()", "\"'",
+ token = strtokx(NULL, whitespace, "()", "\"'",
nonstd_backslash, true, false, pset.encoding);
if (!token)
goto error;