minor issue: \c without parameter disconnect current user
Hi
I expect so \c without parameters has only informational character. But \c
reset user.
postgres=# set role to tom;
SET
Time: 0.787 ms
postgres=> select current_user;
+--------------+
| current_user |
+--------------+
| tom |
+--------------+
(1 row)
Time: 0.851 ms
postgres=> \c
You are now connected to database "postgres" as user "pavel".
postgres=# select current_user;
+--------------+
| current_user |
+--------------+
| pavel |
+--------------+
(1 row)
Regards
Pavel
On Mon, Oct 17, 2016 at 12:49 AM, Pavel Stehule <pavel.stehule@gmail.com> wrote:
I expect so \c without parameters has only informational character. But \c
reset user.
Yeah, I use that feature all the time.
--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
Robert Haas wrote:
On Mon, Oct 17, 2016 at 12:49 AM, Pavel Stehule <pavel.stehule@gmail.com> wrote:
I expect so \c without parameters has only informational character. But \c
reset user.Yeah, I use that feature all the time.
And so do the regression tests.
I think what Pavel wants is \conninfo.
--
�lvaro Herrera https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
Alvaro Herrera <alvherre@2ndquadrant.com> writes:
Robert Haas wrote:
On Mon, Oct 17, 2016 at 12:49 AM, Pavel Stehule <pavel.stehule@gmail.com> wrote:
I expect so \c without parameters has only informational character. But \c
reset user.
Yeah, I use that feature all the time.
And so do the regression tests.
pg_dump relies on it too, I think.
regards, tom lane
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
2016-10-18 20:11 GMT+02:00 Alvaro Herrera <alvherre@2ndquadrant.com>:
Robert Haas wrote:
On Mon, Oct 17, 2016 at 12:49 AM, Pavel Stehule <pavel.stehule@gmail.com>
wrote:
I expect so \c without parameters has only informational character.
But \c
reset user.
Yeah, I use that feature all the time.
And so do the regression tests.
I think what Pavel wants is \conninfo.
yes - still something can new for me :)
Pavel
Show quoted text
--
Álvaro Herrera https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services