Thread: BUG #14179: Not enough info in error message

VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJz
aXRlOgoKQnVnIHJlZmVyZW5jZTogICAgICAxNDE3OQpMb2dnZWQgYnk6ICAg
ICAgICAgIERhbmllbCBNaWdvd3NraQpFbWFpbCBhZGRyZXNzOiAgICAgIGRt
aWdvd3NraUBpa29mZmljZS5kZQpQb3N0Z3JlU1FMIHZlcnNpb246IDkuNS4y
Ck9wZXJhdGluZyBzeXN0ZW06ICAgYWxsCkRlc2NyaXB0aW9uOiAgICAgICAg
CgpIZWxsbywNCg0KSSBvZnRlbiBnZXQgc29tZSBlcnJvciBsaWtlOiB2YWx1
ZSB0b28gbG9uZyBmb3IgdHlwZSBjaGFyYWN0ZXIgdmFyeWluZygxNjApLgpO
b3QgaXQgaXMgaGFyZCBmb3IgbWUgdG8gY2hlY2sgd2hpY2ggY29sdW1uIGNv
bnRhaW5lZCB0aGUgY29uc3RyYWludC4NCg0KSSB3b3VsZCBsb3ZlIHRvIHNl
ZSBzb21ldGhpbmcgbGlrZTogInZhbHVlIHRvbyBsb25nIGZvciB0eXBlIGNo
YXJhY3Rlcgp2YXJ5aW5nKDE2MCkgaW4gY29sdW1uIG15dGFibGUubXljb2x1
bW4iDQoNClRoaXMgd291bGQgaGF2ZSBzYWZlZCBtZSBhdCBsZWFzdCAyMCBo
b3VycyBkdXJpbmcgdGhlIGxhc3QgeWVhcnMhIA0KDQpJZiB5b3UgZml4IHRo
aXMsIHBsZWFzZSBiYWNrcG9ydCB0byA5LjUsIGFuZCBJIHdvdWxkIGltbWVk
aWF0ZWx5IHVwZ3JhZGUgYWxsCm91ciBzZXJ2ZXJzLiBUaGFua3MgYSBsb3Qg
aW4gYWR2YW5jZS4KCg==

On Tue, Jun 7, 2016 at 3:50 AM, <dmigowski@ikoffice.de> wrote:

> The following bug has been logged on the website:
>
> Bug reference:      14179
> Logged by:          Daniel Migowski
> Email address:      dmigowski@ikoffice.de
> PostgreSQL version: 9.5.2
> Operating system:   all
> Description:
>
> Hello,
>
> I often get some error like: value too long for type character
> varying(160).
> Not it is hard for me to check which column contained the constraint.
>
>
=E2=80=8BThis is a frequent complaint with no easy, and in some queries no
possible, solution.=E2=80=8B


> I would love to see something like: "value too long for type character
> varying(160) in column mytable.mycolumn"=E2=80=8B
>

=E2=80=8BCREATE TABLE sample (col text CHECK (length(col) <=3D 160));=E2=80=
=8B

This would have safed me at least 20 hours during the last years!
>
> If you fix this, please backport to 9.5, and I would immediately upgrade
> all
> our servers.


=E2=80=8BEven if this was improved upon it would never be back-ported.  It =
is not a
bug.

=E2=80=8BThere is more in-depth discussion out there on these lists but I d=
o not
have the time at the moment to search around for it.=E2=80=8B

I did check the FAQ and this topic does not appear there :(  Maybe it will
in the future...

David J.

SGVsbG8gRGF2aWQsDQoNCnRoYW5rcyBmb3IgeW91IGRldGFpbGVkIGFuc3dlci4gTWF5YmUgSSBj
aGVjayB0aGUgbGlzdHMgd2hlbiB0aGUgZmVhdHVyZSBiZWNvbWVzIHNvIHVyZ2VudCB0aGF0IEkg
bmVlZCB0byBmaXggaXQgbXlzZWxmLg0KDQpSZWdhcmRzLA0KRGFuaWVsIE1pZ293c2tpDQoNCk9u
IFR1ZSwgSnVuIDcsIDIwMTYgYXQgMzo1MCBBTSwgPGRtaWdvd3NraUBpa29mZmljZS5kZTxtYWls
dG86ZG1pZ293c2tpQGlrb2ZmaWNlLmRlPj4gd3JvdGU6DQpUaGUgZm9sbG93aW5nIGJ1ZyBoYXMg
YmVlbiBsb2dnZWQgb24gdGhlIHdlYnNpdGU6DQoNCkJ1ZyByZWZlcmVuY2U6ICAgICAgMTQxNzkN
CkxvZ2dlZCBieTogICAgICAgICAgRGFuaWVsIE1pZ293c2tpDQpFbWFpbCBhZGRyZXNzOiAgICAg
IGRtaWdvd3NraUBpa29mZmljZS5kZTxtYWlsdG86ZG1pZ293c2tpQGlrb2ZmaWNlLmRlPg0KUG9z
dGdyZVNRTCB2ZXJzaW9uOiA5LjUuMg0KT3BlcmF0aW5nIHN5c3RlbTogICBhbGwNCkRlc2NyaXB0
aW9uOg0KDQpIZWxsbywNCg0KSSBvZnRlbiBnZXQgc29tZSBlcnJvciBsaWtlOiB2YWx1ZSB0b28g
bG9uZyBmb3IgdHlwZSBjaGFyYWN0ZXIgdmFyeWluZygxNjApLg0KTm90IGl0IGlzIGhhcmQgZm9y
IG1lIHRvIGNoZWNrIHdoaWNoIGNvbHVtbiBjb250YWluZWQgdGhlIGNvbnN0cmFpbnQuDQoNCuKA
i1RoaXMgaXMgYSBmcmVxdWVudCBjb21wbGFpbnQgd2l0aCBubyBlYXN5LCBhbmQgaW4gc29tZSBx
dWVyaWVzIG5vIHBvc3NpYmxlLCBzb2x1dGlvbi7igIsNCg0KSSB3b3VsZCBsb3ZlIHRvIHNlZSBz
b21ldGhpbmcgbGlrZTogInZhbHVlIHRvbyBsb25nIGZvciB0eXBlIGNoYXJhY3Rlcg0KdmFyeWlu
ZygxNjApIGluIGNvbHVtbiBteXRhYmxlLm15Y29sdW1uIuKAiw0KDQrigItDUkVBVEUgVEFCTEUg
c2FtcGxlIChjb2wgdGV4dCBDSEVDSyAobGVuZ3RoKGNvbCkgPD0gMTYwKSk74oCLDQoNClRoaXMg
d291bGQgaGF2ZSBzYWZlZCBtZSBhdCBsZWFzdCAyMCBob3VycyBkdXJpbmcgdGhlIGxhc3QgeWVh
cnMhDQoNCklmIHlvdSBmaXggdGhpcywgcGxlYXNlIGJhY2twb3J0IHRvIDkuNSwgYW5kIEkgd291
bGQgaW1tZWRpYXRlbHkgdXBncmFkZSBhbGwNCm91ciBzZXJ2ZXJzLg0KDQrigItFdmVuIGlmIHRo
aXMgd2FzIGltcHJvdmVkIHVwb24gaXQgd291bGQgbmV2ZXIgYmUgYmFjay1wb3J0ZWQuICBJdCBp
cyBub3QgYSBidWcuDQoNCuKAi1RoZXJlIGlzIG1vcmUgaW4tZGVwdGggZGlzY3Vzc2lvbiBvdXQg
dGhlcmUgb24gdGhlc2UgbGlzdHMgYnV0IEkgZG8gbm90IGhhdmUgdGhlIHRpbWUgYXQgdGhlIG1v
bWVudCB0byBzZWFyY2ggYXJvdW5kIGZvciBpdC7igIsNCg0KSSBkaWQgY2hlY2sgdGhlIEZBUSBh
bmQgdGhpcyB0b3BpYyBkb2VzIG5vdCBhcHBlYXIgdGhlcmUgOiggIE1heWJlIGl0IHdpbGwgaW4g
dGhlIGZ1dHVyZS4uLg0KDQpEYXZpZCBKLg0KDQo=