Re: Duplicate key value error - Mailing list pgsql-hackers

From Itagaki Takahiro
Subject Re: Duplicate key value error
Date
Msg-id 20090722100135.A05D.52131E4D@oss.ntt.co.jp
Whole thread Raw
In response to Re: Duplicate key value error  ("Dickson S. Guedes" <listas@guedesoft.net>)
List pgsql-hackers
"Dickson S. Guedes" <listas@guedesoft.net> 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:  ...   STATEMENT:  (very long query without length-limit)

Also, we cannot use so long keys because length of key must be less then
BLCKSZ. Error messages is 256kB at longest (INDEX_MAX_KEYS=32 * BLKCSZ=8kB),
so I think it is not so dangerous.

Regards,
---
ITAGAKI Takahiro
NTT Open Source Software Center




pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: revised hstore patch
Next
From: Andrew Dunstan
Date:
Subject: Re: revised hstore patch