Re: Fixes for missing schema qualifications

On Thu, Nov 29, 2018 at 10:29:04PM -0800, Noah Misch wrote:
> This patch provides no meaningful increment in security or reliability, but it
> does improve stylistic consistency. Fine to proceed on those grounds, but
> this description doesn't fit.

Indeed, you are right. I agree.

> > --- a/src/test/modules/worker_spi/worker_spi.c
> > +++ b/src/test/modules/worker_spi/worker_spi.c
> > @@ -115,7 +115,9 @@ initialize_worker_spi(worktable *table)
> >
> > /* XXX could we use CREATE SCHEMA IF NOT EXISTS? */
> > initStringInfo(&buf);
> > - appendStringInfo(&buf, "select count(*) from pg_namespace where nspname = '%s'",
> > + appendStringInfo(&buf,
> > + "select pg_catalog.count(*) "
> > + "from pg_catalog.pg_namespace where nspname = '%s'",
> > table->schema);
>
> Remove this change. The rest of the file doesn't schema-qualify, which is
> appropriate for code implementing a test case.

No problem with that either. Thanks Noah for the lookup.
--
Michael