Re: dropdb --force
Amit Kapila <amit.kapila16@gmail.com>
From: Amit Kapila <amit.kapila16@gmail.com>
To: Pavel Stehule <pavel.stehule@gmail.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>, vignesh C <vignesh21@gmail.com>, Dilip Kumar <dilipbalaut@gmail.com>, Ryan Lambert <ryan@rustprooflabs.com>, Thomas Munro <thomas.munro@gmail.com>, Anthony Nowocien <anowocien@gmail.com>, PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>, Filip Rembiałkowski <filip.rembialkowski@gmail.com>
Date: 2019-11-11T08:27:40Z
Lists: pgsql-hackers
On Mon, Nov 11, 2019 at 8:45 AM Amit Kapila <amit.kapila16@gmail.com> wrote: > > On Fri, Nov 8, 2019 at 4:57 PM Pavel Stehule <pavel.stehule@gmail.com> wrote: > > > > I check it now - it has sense. the described switch can protect users against useless client killing. > > > > I have committed that patch. Please find the rebased patch attached. > Additionally, I ran the pgindent. I will wait for two days and see if > you or anyone else has more inputs on the patch, if not, then I will > take one more pass and commit it on Wednesday morning. > This patch adds a few test cases to test the syntax in /src/test/regress/sql/drop_if_exists.sql which I think is not the best place to add the tests for this feature as it is primarily testing .. IF EXISTS .. syntax. OTOH, I am not sure if there is any other better place to add those. The other option could be to add a new test file, but again I am not sure if it is worth to do so for a few tests. We can even decide not to have tests for this feature as the tests are just testing the syntax which I think can help if we want to extend the syntax in the future. Any opinions? -- With Regards, Amit Kapila. EnterpriseDB: http://www.enterprisedb.com
Commits
-
Add tests for '-f' option in dropdb utility.
- 8a7e9e9dad56 13.0 landed
-
Move pump_until to TestLib.pm.
- 290acac92b1d 13.0 landed
-
Add the support for '-f' option in dropdb utility.
- 80e05a088e4e 13.0 landed
-
Introduce the 'force' option for the Drop Database command.
- 1379fd537f9f 13.0 landed
-
Improve CREATE/DROP/RENAME DATABASE so that when failing because the source
- 4abd7b49f1e9 8.4.0 cited