pg_dump - foreign table - server name is not quoted - Mailing list pgsql-bugs

From Ronan Dunklau
Subject pg_dump - foreign table - server name is not quoted
Date
Msg-id 4ED38CE3.5060503@gmail.com
Whole thread Raw
Responses Re: pg_dump - foreign table - server name is not quoted
List pgsql-bugs
Hello.

I noticed what I think is a bug in pg_dump.

When dumping foreign tables, the server name is not properly quoted,
which leads to unrestorable dumps.

eg, a foreign table attached to a foreign server named "file-test" is
dumped as:

CREATE FOREIGN TABLE "test-table" (
    col1 integer
)
SERVER file-test
OPTIONS (filename '/tmp/test');


Please look at the attached test case and the proposed patch.

Thank you.

--
Ronan Dunklau

Attachment

pgsql-bugs by date:

Previous
From: Simon Riggs
Date:
Subject: Re: BUG #6307: intarray extention gin index does not work with Hot standby
Next
From: "Thomas Goerner"
Date:
Subject: Re: BUG #6308: Problem w. encoding in client