Re: [HACKERS] psql: show only failed queries

2014-08-11 Thread Pavel Stehule
> >> > >> Oh, just revived that code. > > > > > > yes, It is looking well > > Ok, committed! > super thank you very much Regards Pavel > > Regards, > > -- > Fujii Masao >

Re: [HACKERS] psql: show only failed queries

2014-08-11 Thread Fujii Masao
On Tue, Aug 12, 2014 at 4:41 AM, Pavel Stehule wrote: > > > > 2014-08-11 14:59 GMT+02:00 Fujii Masao : > >> On Sat, Aug 9, 2014 at 4:16 AM, Pavel Stehule >> wrote: >> > Hi >> > >> > >> > 2014-08-08 13:58 GMT+02:00 Fujii Masao : >> > >> >> On Fri, Aug 8, 2014 at 4:31 AM, Pavel Stehule >> >> wrote

Re: [HACKERS] psql: show only failed queries

2014-08-11 Thread Pavel Stehule
2014-08-11 14:59 GMT+02:00 Fujii Masao : > On Sat, Aug 9, 2014 at 4:16 AM, Pavel Stehule > wrote: > > Hi > > > > > > 2014-08-08 13:58 GMT+02:00 Fujii Masao : > > > >> On Fri, Aug 8, 2014 at 4:31 AM, Pavel Stehule > >> wrote: > >> > > >> > > >> > > >> > 2014-08-07 7:10 GMT+02:00 Fujii Masao : > >

Re: [HACKERS] psql: show only failed queries

2014-08-11 Thread Fujii Masao
On Sat, Aug 9, 2014 at 4:16 AM, Pavel Stehule wrote: > Hi > > > 2014-08-08 13:58 GMT+02:00 Fujii Masao : > >> On Fri, Aug 8, 2014 at 4:31 AM, Pavel Stehule >> wrote: >> > >> > >> > >> > 2014-08-07 7:10 GMT+02:00 Fujii Masao : >> > >> >> On Thu, Aug 7, 2014 at 6:26 AM, Pavel Stehule >> >> wrote:

Re: [HACKERS] psql: show only failed queries

2014-08-08 Thread Pavel Stehule
Hi 2014-08-08 13:58 GMT+02:00 Fujii Masao : > On Fri, Aug 8, 2014 at 4:31 AM, Pavel Stehule > wrote: > > > > > > > > 2014-08-07 7:10 GMT+02:00 Fujii Masao : > > > >> On Thu, Aug 7, 2014 at 6:26 AM, Pavel Stehule > >> wrote: > >> > Hello > >> > > >> > updated version patch in attachment > >> >

Re: [HACKERS] psql: show only failed queries

2014-08-08 Thread Fujii Masao
On Fri, Aug 8, 2014 at 4:31 AM, Pavel Stehule wrote: > > > > 2014-08-07 7:10 GMT+02:00 Fujii Masao : > >> On Thu, Aug 7, 2014 at 6:26 AM, Pavel Stehule >> wrote: >> > Hello >> > >> > updated version patch in attachment >> >> Thanks! But ISTM you forgot to attached the patch. > > > grr .. I am sor

Re: [HACKERS] psql: show only failed queries

2014-08-07 Thread Pavel Stehule
2014-08-07 7:10 GMT+02:00 Fujii Masao : > On Thu, Aug 7, 2014 at 6:26 AM, Pavel Stehule > wrote: > > Hello > > > > updated version patch in attachment > > Thanks! But ISTM you forgot to attached the patch. > grr .. I am sorry > > >> +/* all psql known variables are included in list by defa

Re: [HACKERS] psql: show only failed queries

2014-08-06 Thread Fujii Masao
On Thu, Aug 7, 2014 at 6:26 AM, Pavel Stehule wrote: > Hello > > updated version patch in attachment Thanks! But ISTM you forgot to attached the patch. >> +/* all psql known variables are included in list by default */ >> +for (known_varname = known_varnames; *known_varname; known_varnam

Re: [HACKERS] psql: show only failed queries

2014-08-06 Thread Pavel Stehule
Hello updated version patch in attachment 2014-08-05 13:31 GMT+02:00 Fujii Masao : > On Wed, Jul 16, 2014 at 4:34 AM, Pavel Stehule > wrote: > > > > > > > > 2014-07-15 12:07 GMT+02:00 Fujii Masao : > > > >> On Tue, Jul 15, 2014 at 7:01 PM, Pavel Stehule > > >> wrote: > >> > > >> > > >> > > >>

Re: [HACKERS] psql: show only failed queries

2014-08-05 Thread Fujii Masao
On Wed, Jul 16, 2014 at 4:34 AM, Pavel Stehule wrote: > > > > 2014-07-15 12:07 GMT+02:00 Fujii Masao : > >> On Tue, Jul 15, 2014 at 7:01 PM, Pavel Stehule >> wrote: >> > >> > >> > >> > 2014-07-15 11:29 GMT+02:00 Fujii Masao : >> > >> >> On Thu, Jul 10, 2014 at 9:56 PM, Pavel Stehule >> >> >> >>

Re: [HACKERS] psql: show only failed queries

2014-07-15 Thread Pavel Stehule
2014-07-15 12:07 GMT+02:00 Fujii Masao : > On Tue, Jul 15, 2014 at 7:01 PM, Pavel Stehule > wrote: > > > > > > > > 2014-07-15 11:29 GMT+02:00 Fujii Masao : > > > >> On Thu, Jul 10, 2014 at 9:56 PM, Pavel Stehule > > >> wrote: > >> > Hello > >> > > >> > here is a proposed patch - autocomplete for

Re: [HACKERS] psql: show only failed queries

2014-07-15 Thread Fujii Masao
On Tue, Jul 15, 2014 at 7:01 PM, Pavel Stehule wrote: > > > > 2014-07-15 11:29 GMT+02:00 Fujii Masao : > >> On Thu, Jul 10, 2014 at 9:56 PM, Pavel Stehule >> wrote: >> > Hello >> > >> > here is a proposed patch - autocomplete for known psql variable content >> >> Even after applying the patch, th

Re: [HACKERS] psql: show only failed queries

2014-07-15 Thread Pavel Stehule
2014-07-15 11:29 GMT+02:00 Fujii Masao : > On Thu, Jul 10, 2014 at 9:56 PM, Pavel Stehule > wrote: > > Hello > > > > here is a proposed patch - autocomplete for known psql variable content > > Even after applying the patch, the following psql variables were not > displayed > on the tab-completion

Re: [HACKERS] psql: show only failed queries

2014-07-15 Thread Fujii Masao
On Thu, Jul 10, 2014 at 9:56 PM, Pavel Stehule wrote: > Hello > > here is a proposed patch - autocomplete for known psql variable content Even after applying the patch, the following psql variables were not displayed on the tab-completion of \set command. HISTFILE HISTSIZE HOST IGNOREEOF LASTOID

Re: [HACKERS] psql: show only failed queries

2014-07-10 Thread Pavel Stehule
Hello here is a proposed patch - autocomplete for known psql variable content Regards Pavel 2014-07-10 9:50 GMT+02:00 Pavel Stehule : > > > > 2014-07-10 7:32 GMT+02:00 Fujii Masao : > > On Wed, Jul 9, 2014 at 9:44 PM, Pavel Stehule >> wrote: >> >> Barring any objection, I will commit this pa

Re: [HACKERS] psql: show only failed queries

2014-07-10 Thread Pavel Stehule
2014-07-10 7:32 GMT+02:00 Fujii Masao : > On Wed, Jul 9, 2014 at 9:44 PM, Pavel Stehule > wrote: > >> Barring any objection, I will commit this patch except tab-completion > >> part. > > Committed. > Thank you very much > > > It can be a second discussion, but I am thinking so anywhere when we

Re: [HACKERS] psql: show only failed queries

2014-07-09 Thread Fujii Masao
On Wed, Jul 9, 2014 at 9:44 PM, Pavel Stehule wrote: >> Barring any objection, I will commit this patch except tab-completion >> part. Committed. > It can be a second discussion, but I am thinking so anywhere when we can use > autocomplete, then we should it - Although it should not to substitut

Re: [HACKERS] psql: show only failed queries

2014-07-09 Thread Pavel Stehule
2014-07-09 14:39 GMT+02:00 Fujii Masao : > On Wed, Jul 9, 2014 at 9:06 PM, Pavel Stehule > wrote: > > Hi > > > > > > 2014-07-09 7:07 GMT+02:00 Fujii Masao : > > > >> On Mon, Jun 30, 2014 at 8:33 PM, Pavel Stehule > > >> wrote: > >> > > >> > > >> > > >> > 2014-06-30 13:01 GMT+02:00 Abhijit Menon-

Re: [HACKERS] psql: show only failed queries

2014-07-09 Thread Fujii Masao
On Wed, Jul 9, 2014 at 9:06 PM, Pavel Stehule wrote: > Hi > > > 2014-07-09 7:07 GMT+02:00 Fujii Masao : > >> On Mon, Jun 30, 2014 at 8:33 PM, Pavel Stehule >> wrote: >> > >> > >> > >> > 2014-06-30 13:01 GMT+02:00 Abhijit Menon-Sen : >> > >> >> At 2014-06-30 12:48:30 +0200, pavel.steh...@gmail.com

Re: [HACKERS] psql: show only failed queries

2014-07-09 Thread Pavel Stehule
Hi 2014-07-09 7:07 GMT+02:00 Fujii Masao : > On Mon, Jun 30, 2014 at 8:33 PM, Pavel Stehule > wrote: > > > > > > > > 2014-06-30 13:01 GMT+02:00 Abhijit Menon-Sen : > > > >> At 2014-06-30 12:48:30 +0200, pavel.steh...@gmail.com wrote: > >> > > >> > + > >> > + Print a failed SQL comman

Re: [HACKERS] psql: show only failed queries

2014-07-08 Thread Fujii Masao
On Mon, Jun 30, 2014 at 8:33 PM, Pavel Stehule wrote: > > > > 2014-06-30 13:01 GMT+02:00 Abhijit Menon-Sen : > >> At 2014-06-30 12:48:30 +0200, pavel.steh...@gmail.com wrote: >> > >> > + >> > + Print a failed SQL commands to standard error output. This is >> > + equivalent to setti

Re: [HACKERS] psql: show only failed queries

2014-06-30 Thread Pavel Stehule
2014-06-30 13:01 GMT+02:00 Abhijit Menon-Sen : > At 2014-06-30 12:48:30 +0200, pavel.steh...@gmail.com wrote: > > > > + > > + Print a failed SQL commands to standard error output. This is > > + equivalent to setting the variable ECHO to > > + errors. > > No "a", just "Print fa

Re: [HACKERS] psql: show only failed queries

2014-06-30 Thread Abhijit Menon-Sen
At 2014-06-30 12:48:30 +0200, pavel.steh...@gmail.com wrote: > > + > + Print a failed SQL commands to standard error output. This is > + equivalent to setting the variable ECHO to > + errors. No "a", just "Print failed SQL commands …". > --e. > +-e. If set to

Re: [HACKERS] psql: show only failed queries

2014-06-30 Thread Pavel Stehule
2014-06-30 11:20 GMT+02:00 Rajeev rastogi : > On 30 June 2014 12:24, Pavel Stehule Wrote: > > > > >>I have reviewed this patch. Please find my review comments below: > > >>1. Command start-up option (e.g. -a/--echo-all for --ECHO=all), for > new functionality is not provided. > > >all not opt

Re: [HACKERS] psql: show only failed queries

2014-06-30 Thread Rajeev rastogi
On 30 June 2014 12:24, Pavel Stehule Wrote: >>I have reviewed this patch. Please find my review comments below: >>1. Command start-up option (e.g. -a/--echo-all for --ECHO=all), for new >>functionality is not provided. >all not options entered via psql variables has psql option and psql comm

Re: [HACKERS] psql: show only failed queries

2014-06-29 Thread Pavel Stehule
2014-06-30 8:17 GMT+02:00 Rajeev rastogi : > On 26 June 2014 11:53, Samrat Revagade Wrote: > > > > >> I am sending updated patch - buggy statement is printed via more > logical psql_error function instead printf > > > > >Thank you for updating patch, I really appreciate your efforts. > > > > >Now

Re: [HACKERS] psql: show only failed queries

2014-06-29 Thread Rajeev rastogi
On 26 June 2014 11:53, Samrat Revagade Wrote: >> I am sending updated patch - buggy statement is printed via more logical >> psql_error function instead printf >Thank you for updating patch, I really appreciate your efforts. >Now, everything is good from my side. >* it apply cleanly to the curr

Re: [HACKERS] psql: show only failed queries

2014-06-26 Thread Pavel Stehule
2014-06-26 8:22 GMT+02:00 Samrat Revagade : > > I am sending updated patch - buggy statement is printed via more logical > psql_error function instead printf > > Thank you for updating patch, I really appreciate your efforts. > > Now, everything is good from my side. > * it apply cleanly to the cu

Re: [HACKERS] psql: show only failed queries

2014-06-25 Thread Samrat Revagade
> I am sending updated patch - buggy statement is printed via more logical psql_error function instead printf Thank you for updating patch, I really appreciate your efforts. Now, everything is good from my side. * it apply cleanly to the current git master * includes necessary docs * I think It i

Re: [HACKERS] psql: show only failed queries

2014-06-25 Thread Alvaro Herrera
ECHO_HIDDEN? -- Álvaro Herrerahttp://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, 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

Re: [HACKERS] psql: show only failed queries

2014-06-25 Thread Pavel Stehule
2014-06-25 12:32 GMT+02:00 Samrat Revagade : > Hi Pavel, > > After applying patch, on error condition it displays error message two > times as follows: > > ERROR: column "abc" does not exist at character 23 > STATEMENT: insert into ax > values(abc); > psql:a.sql:7: ERROR: column "abc" does not

Re: [HACKERS] psql: show only failed queries

2014-06-25 Thread Samrat Revagade
Hi Pavel, After applying patch, on error condition it displays error message two times as follows: ERROR: column "abc" does not exist at character 23 STATEMENT: insert into ax values(abc); psql:a.sql:7: ERROR: column "abc" does not exist LINE 2: values(abc); user may confuse because of repea

Re: [HACKERS] psql: show only failed queries

2014-06-04 Thread Pavel Stehule
2014-06-04 18:16 GMT+02:00 Peter Eisentraut : > On 6/4/14, 11:54 AM, Pavel Stehule wrote: > > updated patch - only one change: query is prefixed by "QUERY: " > > In the backend server log, this is called "STATEMENT: ". > good idea updated patch Pavel commit f752566830032438739b7e5ab1f55149c73

Re: [HACKERS] psql: show only failed queries

2014-06-04 Thread Peter Eisentraut
On 6/4/14, 11:54 AM, Pavel Stehule wrote: > updated patch - only one change: query is prefixed by "QUERY: " In the backend server log, this is called "STATEMENT: ". -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgres

Re: [HACKERS] psql: show only failed queries

2014-06-04 Thread Pavel Stehule
Hello updated patch - only one change: query is prefixed by "QUERY: " current state: [pavel@localhost ~]$ src/postgresql/src/bin/psql/psql postgres -q -f data.sql psql:data.sql:6: ERROR: value too long for type character varying(3) Show only errors mode: [pavel@localhost ~]$ src/postgresql/s

Re: [HACKERS] psql: show only failed queries

2014-03-03 Thread Pavel Stehule
2014-03-04 6:35 GMT+01:00 Fabrízio de Royes Mello : > > > > On Sat, Mar 1, 2014 at 8:01 AM, Pavel Stehule > wrote: > > > > Hello > > > > I was asked, how can be showed only failed queries in psql. > > > > I am thinking, so it is not possible now. But implementation is very > simple > > > > What d

Re: [HACKERS] psql: show only failed queries

2014-03-03 Thread Fabrízio de Royes Mello
On Sat, Mar 1, 2014 at 8:01 AM, Pavel Stehule wrote: > > Hello > > I was asked, how can be showed only failed queries in psql. > > I am thinking, so it is not possible now. But implementation is very simple > > What do you think about it? > > bash-4.1$ psql postgres -v ECHO=error -f data.sql > INS