Skip site navigation (1) Skip section navigation (2)

BUG #14587: Foreign constraint with newline blows up pg_restore catalogue

From: milos(dot)urbanek(at)email(dot)cz
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #14587: Foreign constraint with newline blows up pg_restore catalogue
Date: 2017-03-10 15:53:18
Message-ID: 20170310155318.1425.30483@wrigleys.postgresql.org (view raw, whole thread or download thread mbox)
Thread:
Lists: pgsql-bugs
The following bug has been logged on the website:

Bug reference:      14587
Logged by:          Milos Urbanek
Email address:      milos(dot)urbanek(at)email(dot)cz
PostgreSQL version: 9.6.2
Operating system:   Windows
Description:        

As repoted in https://trac.osgeo.org/postgis/ticket/3727

If there is some newline in e.g. foreign key contraint, the second command
below fails:

pg_restore -l test.backup > test.backup.lst

pg_restore -L test.backup.lst > test2.out

With error like:

pg_restore: [archiver] could not find entry for ID 6


Responses

pgsql-bugs by date

Next:From: Tom LaneDate: 2017-03-10 16:23:34
Subject: Re: BUG #14587: Foreign constraint with newline blows up pg_restore catalogue
Previous:From: markusDate: 2017-03-10 08:00:45
Subject: BUG #14586: Permissions of recovery.conf are different in plain and tar-format

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group