Commit36726b7

committed

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

1 parent0193177 commit36726b7Copy full SHA for 36726b7

File tree

-0

lines changed

-0

lines changed

Lines changed: 4 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -1076,6 +1076,10 @@ testdb=>`
`1076`	`1076`	`destination, because all data must pass through the client/server`
`1077`	`1077`	`connection. For large amounts of data the <acronym>SQL</acronym>`
`1078`	`1078`	`command might be preferable.`
	`1079`	`+ Also, because of this pass-through method, <literal>\copy`
	`1080`	`+ ... from</literal> in <acronym>CSV</acronym> mode will erroneously`
	`1081`	`+ treat a <literal>\.</literal> data value alone on a line as an`
	`1082`	`+ end-of-input marker.`
`1079`	`1083`	`</para>`
`1080`	`1084`	`</tip>`
`1081`	`1085`

Lines changed: 1 addition & 0 deletions

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

Comments

(0)