Re: [HACKERS] possible/feasible to specify field and value in error msg?

2013-07-04 Thread Willy-Bas Loos
On Wed, Jul 3, 2013 at 5:18 PM, Bruce Momjian br...@momjian.us wrote: On Wed, Jul 3, 2013 at 11:14:18AM -0400, Bruce Momjian wrote: We will add optional error details in Postgres 9.3: http://momjian.us/main/blogs/pgblog/2013.html#April_11_2013 I just tested this and it doesn't

Re: [HACKERS] possible/feasible to specify field and value in error msg?

2013-07-04 Thread Pavel Stehule
Hello 2013/7/4 Willy-Bas Loos willy...@gmail.com: On Wed, Jul 3, 2013 at 5:18 PM, Bruce Momjian br...@momjian.us wrote: On Wed, Jul 3, 2013 at 11:14:18AM -0400, Bruce Momjian wrote: We will add optional error details in Postgres 9.3:

[HACKERS] possible/feasible to specify field and value in error msg?

2013-07-03 Thread Willy-Bas Loos
Hi, I have some complicated query that truncates and fills a table and i get this message: ERROR: smallint out of range STATEMENT: my huge query This is in postgres 8.4 I don't know where the error is, and the query takes rather long. So it is going to be a bit cumbersome for me to debug this.

Re: [HACKERS] possible/feasible to specify field and value in error msg?

2013-07-03 Thread Bruce Momjian
On Wed, Jul 3, 2013 at 10:54:48AM +0200, Willy-Bas Loos wrote: Hi, I have some complicated query that truncates and fills a table and i get this message: ERROR: smallint out of range STATEMENT: my huge query This is in postgres 8.4 I don't know where the error is, and the query takes

Re: [HACKERS] possible/feasible to specify field and value in error msg?

2013-07-03 Thread Bruce Momjian
On Wed, Jul 3, 2013 at 11:14:18AM -0400, Bruce Momjian wrote: On Wed, Jul 3, 2013 at 10:54:48AM +0200, Willy-Bas Loos wrote: Hi, I have some complicated query that truncates and fills a table and i get this message: ERROR: smallint out of range STATEMENT: my huge query This