Re: dropdb --force

From: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
To: Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, vignesh C <vignesh21(at)gmail(dot)com>, Dilip Kumar <dilipbalaut(at)gmail(dot)com>, Ryan Lambert <ryan(at)rustprooflabs(dot)com>, Thomas Munro <thomas(dot)munro(at)gmail(dot)com>, Anthony Nowocien <anowocien(at)gmail(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>, Filip Rembiałkowski <filip(dot)rembialkowski(at)gmail(dot)com>
Subject: Re: dropdb --force
Date: 2019-11-08 10:42:59
Message-ID: CAFj8pRCk1YSq96XWjytn8D1pZq9uyx4zN9dGQF6qBmyBT5XeYg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

pá 8. 11. 2019 v 6:40 odesílatel Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
napsal:

>
>
> pá 8. 11. 2019 v 6:39 odesílatel Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>
> napsal:
>
>> On Thu, Nov 7, 2019 at 11:29 AM Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
>> wrote:
>> > čt 7. 11. 2019 v 6:56 odesílatel Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>
>> napsal:
>> >>
>> >> Okay, no problem. I will pick the previous version and do this. I
>> >> will post the patch in a day or so for your review.
>> >
>> >
>> > Thank you very much
>> >
>>
>> Did you get a chance to look at the other related patch posted by me
>> [1]? I have asked it before as well because I think that need to go
>> before this. We need to avoid errors to happen after terminating the
>> connections as otherwise, the termination of other databases will go
>> be of no use.
>>
>> I have added the comment and changed one condition in tab-completion
>> as otherwise, it was allowing tab completion for the following syntax:
>> "drop database db1 , FORCE" which doesn't make sense to me. Please,
>> find the result attached. Let me know what you think?
>>
>> [1] -
>> https://www.postgresql.org/message-id/CAA4eK1%2BqhLkCYG2oy9xug9ur_j%3DG2wQNRYAyd%2B-kZfZ1z42pLw%40mail.gmail.com
>
>
> I'll check it today
>

I checked it for 800 active clients, and it is working without problems. I
run "check-world" without problem too.

The patch looks well, I have not any comments.

Regards

Pavel

> Pavel
>
>>
>>
>> --
>> With Regards,
>> Amit Kapila.
>> EnterpriseDB: http://www.enterprisedb.com
>>
>

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Amit Kapila 2019-11-08 10:50:11 Re: dropdb --force
Previous Message Mahendra Singh 2019-11-08 10:03:12 Re: [HACKERS] Block level parallel vacuum