Commit42d3125

committed

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

1 parentd391f6d commit42d3125Copy full SHA for 42d3125

File tree

-0

lines changed

-0

lines changed

Lines changed: 4 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -1119,6 +1119,10 @@ INSERT INTO tbl1 VALUES ($1, $2) \bind 'first value' 'second value' \g`
`1119`	`1119`	`destination, because all data must pass through the client/server`
`1120`	`1120`	`connection. For large amounts of data the <acronym>SQL</acronym>`
`1121`	`1121`	`command might be preferable.`
	`1122`	`+ Also, because of this pass-through method, <literal>\copy`
	`1123`	`+ ... from</literal> in <acronym>CSV</acronym> mode will erroneously`
	`1124`	`+ treat a <literal>\.</literal> data value alone on a line as an`
	`1125`	`+ end-of-input marker.`
`1122`	`1126`	`</para>`
`1123`	`1127`	`</tip>`
`1124`	`1128`

Lines changed: 2 additions & 0 deletions

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

Comments

(0)