Re: [HACKERS] Duplicate key value error

2009-08-01 Thread Tom Lane
Itagaki Takahiro writes: > Thank you for reviewing. An updated patch is attached. I applied this with some revisions. I didn't like the fact that error reports for functional indexes came out with "pg_expression_n" instead of something useful. I tweaked things to use the pg_get_indexdef code to

Re: [HACKERS] Duplicate key value error

2009-07-21 Thread Itagaki Takahiro
"Dickson S. Guedes" wrote: > Hum, for key names ok, but for values, wouldn't this worse the output when > it is greater than 512 bytes? Why do we need to cut values in 512 bytes? It might be generate larger logs before, but we don't have any limits for length of log messages. ex) ERROR: ...

Re: [HACKERS] Duplicate key value error

2009-07-21 Thread Dickson S. Guedes
Em Tue, 21 Jul 2009 02:07:47 -0300, Itagaki Takahiro escreveu: I modified the format logic to use StringInfo and don't cut off the message in 512 bytes. Key names and values will be never into '...'. I changed both both report_unique_violation() and ri_ReportViolation(). Hi Takahiro! Hum,

Re: [HACKERS] Duplicate key value error

2009-07-20 Thread Itagaki Takahiro
"Dickson S. Guedes" wrote: > Hi Takahiro, i'm the reviewer of your patch, and the following are my > comments about it: Thank you for reviewing. An updated patch is attached. > The patch was applied totalty clean to CVS HEAD and compiled in Ubuntu > 8.04, Ubuntu 8.10 and AIX 5.3, but faile

Re: [HACKERS] Duplicate key value error

2009-07-17 Thread Dickson S. Guedes
Em Fri, 03 Apr 2009 04:23:10 -0300, Itagaki Takahiro escreveu: Vlad Arkhipov wrote: Is it possible to print which key value is duplicated when 'Duplicate key value violates unique constraint' occurs? Foreign key violation error reports such kind of information. I think it is not difficult

Re: [HACKERS] Duplicate key value error

2009-04-04 Thread Tom Lane
Itagaki Takahiro writes: > Vlad Arkhipov wrote: >> Is it possible to print which key value is duplicated when 'Duplicate >> key value violates unique constraint' occurs? Foreign key violation >> error reports such kind of information. > If no objection, I'd like to submit the patch to the next

Re: [HACKERS] Duplicate key value error

2009-04-03 Thread Itagaki Takahiro
Vlad Arkhipov wrote: > Is it possible to print which key value is duplicated when 'Duplicate > key value violates unique constraint' occurs? Foreign key violation > error reports such kind of information. I think it is not difficult from a technical standpoint. The attached patch adds DETAIL

[HACKERS] Duplicate key value error

2009-03-31 Thread Vlad Arkhipov
Is it possible to print which key value is duplicated when 'Duplicate key value violates unique constraint' occurs? Foreign key violation error reports such kind of information. -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://ww