Skip to content
This repository has been archived by the owner on Feb 8, 2022. It is now read-only.

Generated COPY statements missing EOD marker #12

Open
mfrederiksen-p44 opened this issue Oct 18, 2019 · 1 comment
Open

Generated COPY statements missing EOD marker #12

mfrederiksen-p44 opened this issue Oct 18, 2019 · 1 comment

Comments

@mfrederiksen-p44
Copy link

For two empty tables the following SQL output is generated

COPY "TableFoo" FROM STDIN;
COPY "TableBar" FROM STDIN;
\.

resulting in error

psql:tdx-dev.sql:915: ERROR:  missing data for column "column1"
CONTEXT:  COPY TableFoo, line 1: "COPY "TableBar" FROM STDIN;"

because the first COPY statement is missing the EOD marker \.

@mfrederiksen-p44
Copy link
Author

Another example showing what appears to be interleaved statements:

data	ipsum	\N	\N	lorem
COPY "Table1" FROM STDIN;
COPY "Table2" FROM STDIN;
\.

COPY "Table3" FROM STDIN;
\.

COPY "Table4" FROM STDIN;
\.

\.

data	ipsum	\N	\N	lorem

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant