Re: pgsql: Add a regression test for allow_system_table_mods

On 2019-11-29 16:27, Tom Lane wrote:
> Peter Eisentraut <peter(at)eisentraut(dot)org> writes:
>> Add a regression test for allow_system_table_mods
>
> Oooh ... some of the buildfarm members are pointing out that this
> didn't follow a project convention:

Um, yes, that's why it's in unsafe_tests. Is there a way around this?

>
> @@ -153,6 +153,7 @@
> ROLLBACK;
> -- reserved tablespace name
> CREATE TABLESPACE pg_foo LOCATION '/no/such/location';
> +WARNING: tablespaces created by regression test cases should have names starting with "regress_"
> ERROR: directory "/no/such/location" does not exist
> -- triggers
> CREATE TRIGGER t1 BEFORE INSERT ON pg_description EXECUTE FUNCTION tf1();
>
> regards, tom lane
>

--
Peter Eisentraut http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services