Commit930bc76

committed

doc: \copy can get data values \. and end-of-input confused

1 parent54af107 commit930bc76Copy full SHA for 930bc76

File tree

-0

lines changed

-0

lines changed

Lines changed: 4 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -1060,6 +1060,10 @@ testdb=>`
`1060`	`1060`	`destination, because all data must pass through the client/server`
`1061`	`1061`	`connection. For large amounts of data the <acronym>SQL</acronym>`
`1062`	`1062`	`command might be preferable.`
	`1063`	`+ Also, because of this pass-through method, <literal>\copy`
	`1064`	`+ ... from</literal> in <acronym>CSV</acronym> mode will erroneously`
	`1065`	`+ treat a <literal>\.</literal> data value alone on a line as an`
	`1066`	`+ end-of-input marker.`
`1063`	`1067`	`</para>`
`1064`	`1068`	`</tip>`
`1065`	`1069`

Lines changed: 1 addition & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -633,6 +633,7 @@ handleCopyIn(PGconn conn, FILE copystream, bool isbinary, PGresult **res)`
`633`	`633`	`* This code erroneously assumes '\.' on a line alone`
`634`	`634`	`* inside a quoted CSV string terminates the \copy.`
`635`	`635`	`* http://www.postgresql.org/message-id/E1TdNVQ-0001ju-GO@wrigleys.postgresql.org`
	`636`	`+ * https://www.postgresql.org/message-id/bfcd57e4-8f23-4c3e-a5db-2571d09208e2@beta.fastmail.com`
`636`	`637`	`*/`
`637`	`638`	`if (strcmp(buf,"\\.\n")==0\|\|`
`638`	`639`	`strcmp(buf,"\\.\r\n")==0)`

Comments

(0)