| From: | Alban Hertroys <haramrae(at)gmail(dot)com> |
|---|---|
| To: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
| Cc: | VENKTESH GUTTEDAR <venkteshguttedar(at)gmail(dot)com>, PostgreSQL mailing lists <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: [GENERAL] - Regarding Schema ROLLBACK |
| Date: | 2017-11-28 18:50:11 |
| Message-ID: | 9BD3B458-217C-4349-AD41-D405D329CD9A@gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
> On 28 Nov 2017, at 16:43, David G. Johnston <david(dot)g(dot)johnston(at)gmail(dot)com> wrote:
>
> On Tue, Nov 28, 2017 at 5:23 AM, VENKTESH GUTTEDAR <venkteshguttedar(at)gmail(dot)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.
Just what I was thinking. Are you looking in the correct database?
Alban Hertroys
--
If you can't see the forest for the trees,
cut the trees and you'll find there is no forest.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Rakesh Kumar | 2017-11-28 18:58:23 | Re: [GENERAL] - Regarding Schema ROLLBACK |
| Previous Message | Tomas Vondra | 2017-11-28 18:38:37 | Re: large numbers of inserts out of memory strategy |