From: Nikolay Shaplov <dhyan@nataraj.su>
To: Alvaro Herrera <alvherre@alvh.no-ip.org>
To: Michael Paquier <michael.paquier@gmail.com>
To: PostgreSQL mailing lists <pgsql-hackers@postgresql.org>
To: Andres Freund <andres@anarazel.de>
Subject: Re: [PATCH] Tests for reloptions
Date: Sun, 29 Oct 2017 17:08:29 +0300
Message-ID: <35939314.PpRHriQSIJ@x200m> (raw)
In-Reply-To: <20171019122052.f3cychhfktrfwqdk@alvherre.pgsql>
References: <20171019122052.f3cychhfktrfwqdk@alvherre.pgsql>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-hackers>
В письме от 19 октября 2017 14:20:52 Вы написали:
> Yeah, it would perhaps be good idea to ensure we don't break things that
> are documented to work. If the tests don't take too long, I'm not
> opposed to testing every single option. As you say, code coverage is
> important but it's not the only goal.
>
> I'm hesitant to hardcode things like the number of bits in bloom, as you
> had in the original. If I understand correctly, that number could
> change with compile options (different blocksize?), so I removed that
> part. I also fixed a few spelling errors.
>
> And pushed. Let's see what the buildfarm says about this.
While merging this commit to my branch, I found two issues that as I think
needs fixing. Hope this does not require creating new commit request...
First is missing tab.
Second i think it is better to write "The OIDS option is not stored as
_reloption_" otherwise it cat be read as if it is not stored at all.
See patch in the attachment.
Thank you again for your work with the patch. I've seen how much you have
change it.
PS do I get right that 80 character code width rule is applied to SQL tests
too?
--
Do code for fun. Can do it for money (Perl & C/C++ ~10h/week)=
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackersAttachments:reloptions.sql.diff (text/x-patch, 867B) downloaddiff --git a/src/test/regress/sql/reloptions.sql b/src/test/regress/sql/reloptions.sqlindex c9119fd..21a315b 100644--- a/src/test/regress/sql/reloptions.sql+++ b/src/test/regress/sql/reloptions.sql@@ -47,12 +47,12 @@ SELECT reloptions FROM pg_class WHERE oid = 'reloptions_test'::regclass;
ALTER TABLE reloptions_test RESET (autovacuum_enabled,
autovacuum_analyze_scale_factor);
SELECT reloptions FROM pg_class WHERE oid = 'reloptions_test'::regclass AND
-reloptions IS NULL;+ reloptions IS NULL;
-- RESET fails if a value is specified
ALTER TABLE reloptions_test RESET (fillfactor=12);
--- The OIDS option is not stored+-- The OIDS option is not stored as reloption
DROP TABLE reloptions_test;
CREATE TABLE reloptions_test(i INT) WITH (fillfactor=20, oids=true);
SELECT reloptions, relhasoids FROM pg_class WHERE oid = 'reloptions_test'::regclass;
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-hackers@postgresql.org
Cc: dhyan@nataraj.su, alvherre@alvh.no-ip.org, michael.paquier@gmail.com, andres@anarazel.de
Subject: Re: [PATCH] Tests for reloptions
In-Reply-To: <35939314.PpRHriQSIJ@x200m>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox