Small bug on CREATE EXTENSION pgq...

From: Jerry Sievers <gsievers19(at)comcast(dot)net>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Small bug on CREATE EXTENSION pgq...
Date: 2015-01-29 03:20:35
Message-ID: 86vbjqjmrg.fsf@jerry.enova.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hackers; I noticed this trying to import a large pg_dump file with
warnings supressed.

It seems loading pgq sets client_min_messages to warning and leaves it
this way which defeats an attempt to change the setting prior and have
it stick.

I tested with several other extensions in same DB and only pgq has the
problem.

Sorry if this is known/fixed already.

Thanks

sj$ cat q
select version();

create database foo template template0;
\c foo

show client_min_messages;

create extension pgq;

show client_min_messages;
reset client_min_messages;
show client_min_messages;

create extension pgq_node;

show client_min_messages;

\c postgres

drop database foo;

sj$ /usr/local/postgresql-9.3/bin/psql -ef q --no-psqlrc
select version();
version
----------------------------------------------------------------------------------------------
PostgreSQL 9.3.4 on x86_64-unknown-linux-gnu, compiled by gcc (Debian 4.7.2-5) 4.7.2, 64-bit
(1 row)

create database foo template template0;
CREATE DATABASE
psql (9.3.5, server 9.3.4)
You are now connected to database "foo" as user "jsievers".
show client_min_messages;
client_min_messages
---------------------
notice
(1 row)

create extension pgq;
CREATE EXTENSION
show client_min_messages;
client_min_messages
---------------------
warning
(1 row)

reset client_min_messages;
RESET
show client_min_messages;
client_min_messages
---------------------
notice
(1 row)

create extension pgq_node;
CREATE EXTENSION
show client_min_messages;
client_min_messages
---------------------
notice
(1 row)

psql (9.3.5, server 9.3.4)
You are now connected to database "postgres" as user "jsievers".
drop database foo;
DROP DATABASE
sj$
--
Jerry Sievers
Postgres DBA/Development Consulting
e: postgres(dot)consulting(at)comcast(dot)net
p: 312.241.7800

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message David G Johnston 2015-01-29 03:24:43 Re: Small bug on CREATE EXTENSION pgq...
Previous Message Stephen Frost 2015-01-29 03:19:18 Re: Possible typo in create_policy.sgml