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