[HACKERS] psql's \d and \dt are sending their complaints to different output files

2017-06-19 Thread Oleksandr Shulgin
Hello Hackers, I wonder if it is intentional that \d complains on stderr if it cannot find relations to match, but \dt prints the message to the current output file? postgres=# \d xxx Did not find any relation named "xxx". postgres=# \dt xxx No matching relations found. I've noticed the

Re: [HACKERS] proposal: psql statements \gstore \gstore_binary (instead COPY RAW)

2016-12-09 Thread Oleksandr Shulgin
On Dec 9, 2016 18:40, "Pavel Stehule" wrote: Hi Long time I am pushing a COPY RAW - without success. Now I propose functionally similar solution - reduced to only to psql console Now we have a statement \g for execution query, \gset for exec and store result in memory

Re: [HACKERS] Danger of automatic connection reset in psql

2016-11-22 Thread Oleksandr Shulgin
On Tue, Nov 22, 2016 at 5:28 AM, Pavel Stehule <pavel.steh...@gmail.com> wrote: > > 2016-11-22 3:46 GMT+01:00 Robert Haas <robertmh...@gmail.com>: > >> On Mon, Nov 21, 2016 at 4:55 AM, Oleksandr Shulgin >> <oleksandr.shul...@zalando.de> wrote: >>

Re: [HACKERS] Danger of automatic connection reset in psql

2016-11-21 Thread Oleksandr Shulgin
On Tue, Nov 15, 2016 at 4:10 PM, Jim Nasby <jim.na...@bluetreble.com> wrote: > On 11/14/16 5:41 AM, Oleksandr Shulgin wrote: > >> Automatic connection reset is a nice feature for server development, >> IMO. Is it really useful for anything else is a good question. >

Re: [HACKERS] Danger of automatic connection reset in psql

2016-11-14 Thread Oleksandr Shulgin
On Fri, Nov 11, 2016 at 5:37 AM, Pavel Stehule wrote: > > 2016-11-11 5:14 GMT+01:00 Ashutosh Bapat > : > >> > >> > How about, instead of all this, adding an option to psql to suppress >> > the automatic reconnect behavior? When enabled,

Re: [HACKERS] Danger of automatic connection reset in psql

2016-11-08 Thread Oleksandr Shulgin
On Mon, Nov 7, 2016 at 9:31 PM, Jim Nasby <jim.na...@bluetreble.com> wrote: > On 11/4/16 4:04 AM, Oleksandr Shulgin wrote: > >> The psql process even exits with an error code 2, which might be not >> that expected. We could stop reading the file and reset

Re: [HACKERS] Danger of automatic connection reset in psql

2016-11-04 Thread Oleksandr Shulgin
On Thu, Nov 3, 2016 at 12:26 PM, Ashutosh Bapat < ashutosh.ba...@enterprisedb.com> wrote: > > A couple of doubts/suggestions: > 1. Should pset.conn_was_reset be set to false, when we make a > connection in do_connection()? Usually pset.conn_was_reset would be > initialised with 0 since it's a

Re: [HACKERS] Danger of automatic connection reset in psql

2016-10-20 Thread Oleksandr Shulgin
On Thu, Oct 20, 2016 at 12:28 PM, Oleksandr Shulgin < oleksandr.shul...@zalando.de> wrote: > > Since this is already an improvement, I'm attaching a patch. > > If on the other hand, someone is pasting into psql's terminal a block of > commands enclosed in BEGIN/COMMIT, the

Re: [HACKERS] Danger of automatic connection reset in psql

2016-10-20 Thread Oleksandr Shulgin
On Thu, Oct 20, 2016 at 12:28 PM, Oleksandr Shulgin < oleksandr.shul...@zalando.de> wrote: > > > I'm not the first one to discover that, a search in archives gives at least 3 results: > > https://www.postgresql.org/message-id/flat/1097174870.9273.8.camel%40ipso.snappymail.ca

[HACKERS] Danger of automatic connection reset in psql

2016-10-20 Thread Oleksandr Shulgin
action. Is it possible at all to protect against the latter case? How? -- Alex From 3eae5e5d91084e0882a286bac464782701e17d21 Mon Sep 17 00:00:00 2001 From: Oleksandr Shulgin <oleksandr.shul...@zalando.de> Date: Thu, 20 Oct 2016 12:24:48 +0200 Subject: [PATCH] psql: stop sending commands after connec

Re: [HACKERS] [WIP] Patches to enable extraction state of query execution from external session

2016-09-01 Thread Oleksandr Shulgin
On Tue, Aug 30, 2016 at 9:34 AM, Maksim Milyutin wrote: > On Mon, Aug 29, 2016 at 5:22 PM, maksim > > wrote: >> >> Hi, hackers! >> >> Now I complete extension that provides facility to see the

Re: [HACKERS] [WIP] Patches to enable extraction state of query execution from external session

2016-08-29 Thread Oleksandr Shulgin
On Mon, Aug 29, 2016 at 5:22 PM, maksim wrote: > Hi, hackers! > > Now I complete extension that provides facility to see the current state > of query execution working on external session in form of EXPLAIN ANALYZE > output. This extension works on 9.5 version, for 9.6

Re: [HACKERS] Stopping logical replication protocol

2016-05-06 Thread Oleksandr Shulgin
On Fri, May 6, 2016 at 5:23 PM, Vladimir Gordiychuk wrote: > Hi all, > > During implementing logical replication protocol for pgjdbc > https://github.com/pgjdbc/pgjdbc/pull/550 I faced with strange behavior > of the *walcender.c*: > >1. When WAL consumer catchup master and

Re: [HACKERS] Add jsonb_compact(...) for whitespace-free jsonb to text

2016-05-02 Thread Oleksandr Shulgin
On Mon, May 2, 2016 at 4:04 PM, Andrew Dunstan wrote: > > On 05/02/2016 04:56 AM, Shulgin, Oleksandr wrote: > >> On Sun, May 1, 2016 at 3:22 AM, Andrew Dunstan > > wrote: >> >> On 04/29/2016 06:11 PM, Merlin Moncure

Re: [HACKERS] Replication connection URI?

2015-10-30 Thread Oleksandr Shulgin
Heikki Linnakangas writes: > On 11/25/2014 05:11 PM, Heikki Linnakangas wrote: >> On 11/24/2014 06:05 PM, Alex Shulgin wrote: >>> Heikki Linnakangas writes: > > It appears that replication connection doesn't support URI but only the