Re: [GENERAL] - Regarding Schema ROLLBACK - Mailing list pgsql-general

From David G. Johnston
Subject Re: [GENERAL] - Regarding Schema ROLLBACK
Date
Msg-id CAKFQuwYZWOkefGwDDcxibfKcS1e5C4AvdpTNOwuJs9tiEG9A8g@mail.gmail.com
Whole thread Raw
In response to [GENERAL] - Regarding Schema ROLLBACK  (VENKTESH GUTTEDAR <venkteshguttedar@gmail.com>)
Responses Re: [GENERAL] - Regarding Schema ROLLBACK  (Alban Hertroys <haramrae@gmail.com>)
List pgsql-general
On Tue, Nov 28, 2017 at 5:23 AM, VENKTESH GUTTEDAR < venkteshguttedar@gmail.com> wrote: > I have run CREATE SCHEMA xyz accidentally, and it replaced my existing > schema (xyz) with tables, and i have lost all my data. > ​As far as I know "CREATE SCHEMA" by itself cannot "drop" data nor would it successfully execute if a schema of the same name already exist... As Melvin says if you've truly dropped the data you will need to resort to backups of some form.​ David J.

pgsql-general by date:

Previous
From: Melvin Davidson
Date:
Subject: Re: [GENERAL] - Regarding Schema ROLLBACK
Next
From: Robert Haas
Date:
Subject: Re: ERROR: too many dynamic shared memory segments