BUG #14389: Duplicate rows on tables with unique index constrain

Поиск
Список
Период
Сортировка
От mahmoudhakh@gmail.com
Тема BUG #14389: Duplicate rows on tables with unique index constrain
Дата
Msg-id 20161021093200.1411.62581@wrigleys.postgresql.org
обсуждение исходный текст
Список pgsql-bugs
Дерево обсуждения 
VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJz
aXRlOgoKQnVnIHJlZmVyZW5jZTogICAgICAxNDM4OQpMb2dnZWQgYnk6ICAg
ICAgICAgIE1haG1vdWQgSGFrZWVtLUhhYmVlYgpFbWFpbCBhZGRyZXNzOiAg
ICAgIG1haG1vdWRoYWtoQGdtYWlsLmNvbQpQb3N0Z3JlU1FMIHZlcnNpb246
IDkuNC40Ck9wZXJhdGluZyBzeXN0ZW06ICAgQ2VudG9zIDYuNgpEZXNjcmlw
dGlvbjogICAgICAgIAoKSGksDQpJIGhhdmUgbm90aWNlZCBhbiBpc3N1ZSB3
aXRoIHJvd3Mgbm90IGhvbm91cmluZyB0aGUgdW5pcXVlIGluZGV4CmNvbnN0
cmFpbi4NCkkgZmlyc3QgY2FtZSBhY3Jvc3MgdGhlIGlzc3VlIHdoZW4gdXBn
cmFkaW5nIGZyb20gOS4yLjQgdG8gOS40LjQsIGkgZ290IHRoZQplcnJvciBi
ZWxvdw0KDQpwZ19yZXN0b3JlOiBbYXJjaGl2ZXIgKGRiKV0gRXJyb3Igd2hp
bGUgUFJPQ0VTU0lORyBUT0M6DQpwZ19yZXN0b3JlOiBbYXJjaGl2ZXIgKGRi
KV0gRXJyb3IgZnJvbSBUT0MgZW50cnkgNjY2NjsgMTI1OSAyOTc1OTcwMiBJ
TkRFWAppZHhkb21haW5pZCBwb3N0Z3Jlcw0KcGdfcmVzdG9yZTogW2FyY2hp
dmVyIChkYildIGNvdWxkIG5vdCBleGVjdXRlIHF1ZXJ5OiBFUlJPUjogIGNv
dWxkIG5vdApjcmVhdGUgdW5pcXVlIGluZGV4ICJpZHhkb21haW5pZCINCkRF
VEFJTDogIEtleSAoaWQsIGRvbWFpbik9KDMsIHBlb3BsZS5uZXQpIGlzIGR1
cGxpY2F0ZWQuDQogICAgQ29tbWFuZCB3YXM6IENSRUFURSBVTklRVUUgSU5E
RVggaWR4ZG9tYWluaWQgT04gZG9tYWlucyBVU0lORyB0cmVlIChpZCwKZG9t
YWluKTsNCg0KSW4gdGhlIGFib3ZlIGNhc2UgaSByb2xsZWQgYmFjayBhbmQg
ZGVsZXRlZCB0aGUgb2ZmZW5kaW5nIHJvdywgYW5kIHRoZW4KdXBncmFkZWQg
c3VjY2Vzc2Z1bGx5Lg0KDQpUaGVuIGkgc3RhcnRlZCBzZWVpbmcgbW9yZSBv
ZiB0aGUgaXNzdWUsIGR1cmluZyBteSB1cGdyYWRlIHNvIGkgc3RvcHBlZCBh
bmQKcmFuIGEgY2hlY2sgdG8gZmluZCBhbnkgZHVwbGljYXRlcyB1c2luZyAN
CkJFR0lOOw0KICBzZXQgZW5hYmxlX2luZGV4c2NhbiB0byBmYWxzZTsNCiAg
c2V0IGVuYWJsZV9iaXRtYXBzY2FuIHRvIGZhbHNlOw0KICBzZWxlY3QgY291
bnQoKiksIGlkLCBkb21haW4gZnJvbSBkb21haW5zIGdyb3VwIGJ5IGlkLCBk
b21haW4gaGF2aW5nCmNvdW50KCopID4gMTsNCiBST0xMQkFDSzsNCg0KSSBm
b3VuZCB0aGUgc2FtZSBpc3N1ZSBvbiBzZXJ2ZXJzIHJ1bm5pbmcgOS4yLjQg
YW5kIDkuNC40IGFuZCBhbHNvIGZvdW5kIGl0CmhhcHBlbmluZyBvbiBhIG51
bWJlciBvZiB0YWJsZXMuDQoNClRoZSBiZWxvdyBpcyBvbmUgaSBoYXZlIG5v
dCBmaXhlZCBhcyBpIGFtIHVzaW5nIGl0IHJlcG9ydCB0aGlzIGJ1ZyBvciBm
aW5kCnRoZSBjYXVzZS4NCkkgYWxzbyBoYXZlIGEgZmV3IG1vcmUgc2VydmVy
cyB3aXRoIHRoZSBzYW1lIGlzc3VlLg0KDQpkYj0+IHNlbGVjdCB2ZXJzaW9u
KCk7DQogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgdmVyc2lvbg0KLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t
LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t
LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tDQog
UG9zdGdyZVNRTCA5LjQuNCBvbiB4ODZfNjQtdW5rbm93bi1saW51eC1nbnUs
IGNvbXBpbGVkIGJ5IGdjYyAoR0NDKSA0LjQuNwoyMDEyMDMxMyAoUmVkIEhh
dCA0LjQuNy0xMSksIDY0LWJpdA0KKDEgcm93KQ0KDQpkYj0+IHNlbGVjdCBz
aWQsZG9tYWluLGlkIGZyb20gZG9tYWlucyB3aGVyZSBkb21haW4gPSAnbW9y
bmV0Lm5ldCcgYW5kIGlkCj0zOw0KICBzaWQgICB8IGRvbWFpbiB8IGlkDQot
LS0tLS0tLS0tKy0tLS0tLS0tLS0tLSstLS0tLS0tLS0tLQ0KIDE4NjYyMTM1
IHwgbW9ybmV0Lm5ldCB8ICAgICAgICAgMw0KDQpkYj0+IHNldCBlbmFibGVf
aW5kZXhzY2FuIHRvIGZhbHNlOw0KU0VUDQpkYj0+IHNldCBlbmFibGVfYml0
bWFwc2NhbiB0byBmYWxzZTsNClNFVA0KZGI9PiBzZWxlY3QgY291bnQoKiks
IGlkLCBkb21haW4gZnJvbSBkb21haW5zIGdyb3VwIGJ5IGlkLCBkb21haW4g
aGF2aW5nCmNvdW50KCopID4gMTsNCiBjb3VudCB8IGlkIHwgICAgIGRvbWFp
bg0KLS0tLS0tLSstLS0tLS0tLS0tLSstLS0tLS0tLS0tLS0tLS0tLS0tLS0N
CiAgICAgMiB8ICAgICAgICAgMyB8IG1vcm5ldC5uZXQNCg0KZGI9PiBzZWxl
Y3Qgc2lkLGRvbWFpbixpZCBmcm9tIGRvbWFpbnMgd2hlcmUgZG9tYWluID0g
J21vcm5ldC5uZXQnIGFuZCBpZAo9MzsNCiAgc2lkICAgfCBkb21haW4gfCBp
ZA0KLS0tLS0tLS0tLSstLS0tLS0tLS0tLS0rLS0tLS0tLS0tLS0NCiAgIDI2
NjU4MSB8IG1vcm5ldC5uZXQgfCAgICAgICAgIDMNCiAxODY2MjEzNSB8IG1v
cm5ldC5uZXQgfCAgICAgICAgIDMNCg0KZGI9PiBzZXQgZW5hYmxlX2luZGV4
c2NhbiB0byB0cnVlOw0KU0VUDQpkYj0+IHNldCBlbmFibGVfYml0bWFwc2Nh
biB0byB0cnVlOw0KU0VUDQoNCmRiPT4gc2VsZWN0IHNpZCxkb21haW4saWQg
ZnJvbSBkb21haW5zIHdoZXJlIGRvbWFpbiA9ICdtb3JuZXQubmV0JyBhbmQg
aWQKPTM7DQogIHNpZCAgIHwgZG9tYWluIHwgaWQNCi0tLS0tLS0tLS0rLS0t
LS0tLS0tLS0tKy0tLS0tLS0tLS0tDQogMTg2NjIxMzUgfCBtb3JuZXQubmV0
IHwgICAgICAgICAzDQoNCmRiPT4gXGQgZG9tYWlucw0KICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgVGFibGUgInB1YmxpYy5kb21haW5z
Ig0KICAgICBDb2x1bW4gICAgIHwgICAgICAgVHlwZSAgICAgICAgfCAgICAg
ICAgICAgICAgICAgICAgICAgIE1vZGlmaWVycw0KLS0tLS0tLS0tLS0tLS0t
LSstLS0tLS0tLS0tLS0tLS0tLS0tKy0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t
LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLQ0KIHNpZCAgICAg
ICAgICAgIHwgYmlnaW50ICAgICAgICAgICAgfCBub3QgbnVsbCBkZWZhdWx0
Cm5leHR2YWwoJ2RvbWFpbnNfc2lkX3NlcSc6OnJlZ2NsYXNzKQ0KIGlkICAg
ICAgICAgICAgIHwgYmlnaW50ICAgICAgICAgICAgfCBub3QgbnVsbA0KIGRv
bWFpbiAgICAgICAgIHwgY2hhcmFjdGVyIHZhcnlpbmcgfCBub3QgbnVsbA0K
IHNlbmRvbmx5ICAgICAgIHwgYm9vbGVhbiAgICAgICAgICAgfCBkZWZhdWx0
IGZhbHNlDQogc3BhY2Vkb21haW4gICAgfCBib29sZWFuICAgICAgICAgICB8
IGRlZmF1bHQgZmFsc2UNCiBvdXRib3VuZGNoZWNrcyB8IHNtYWxsaW50ICAg
ICAgICAgIHwgZGVmYXVsdCAwDQogbm9ybWFsaXNlZCAgICAgfCBjaGFyYWN0
ZXIgdmFyeWluZyB8DQpJbmRleGVzOg0KICAgICJkb21haW5zX3BrZXkiIFBS
SU1BUlkgS0VZLCBidHJlZSAoc2lkKQ0KICAgICJpZHhkb21haW5pZCIgVU5J
UVVFLCBidHJlZSAoaWQsIGRvbWFpbikNCg0KSWYgeW91IHJlcXVpcmUgYW55
IG1vcmUgaW5mbyBwbGVhc2UgbGV0IG1lIGtub3cgYW5kIGkgd2lsbCBwcm92
aWRlIHdoYXQgaQpjYW4uDQoNCiBUaGlzIGlzIHNpbWlsYXIgdG8gdGhlIGJ1
ZyByZXBvcnRlZCBidWcgIzEzOTM1DQoKaHR0cHM6Ly93d3cucG9zdGdyZXNx
bC5vcmcvbWVzc2FnZS1pZC9mbGF0LzIwMTYwMjA4MTYzMjIyLjI2NjEuNTE2
MDglNDB3cmlnbGV5cy5wb3N0Z3Jlc3FsLm9yZyMyMDE2MDIwODE2MzIyMi4y
NjYxLjUxNjA4QHdyaWdsZXlzLnBvc3RncmVzcWwub3JnDQpUaGFua3MsDQpN
YWhtb3VkCgo=

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Bolek Ziobrowski
Дата:
Сообщение: Re: BUG #14384: pg_dump uses excessive amounts of memory for LOBs
Следующее
От: olli.marx@web.de
Дата:
Сообщение: BUG #14390: ODBC statement_timeout > psqlODBC 09.05.0210