Re: BUG #8710: dblink dblink_get_pkey output bug, and dblink_build_sql_update bug - Mailing list pgsql-bugs

From digoal
Subject Re: BUG #8710: dblink dblink_get_pkey output bug, and dblink_build_sql_update bug
Date
Msg-id 3af1a19f.3c22.1434ce5a3a2.Coremail.digoal@126.com
Whole thread Raw
In response to Re: BUG #8710: dblink dblink_get_pkey output bug, and dblink_build_sql_update bug  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
CkhJLAogICBUaGFua3MuIGJ1dCBub3cgZGJsaW5rIGV4dGVuc2lvbiBsYWNrIHVwZGF0ZSBzcWwg
YnVpbGRpbmcgZnVuY3Rpb24gbGlrZSBpbnNlcnQgYW5kIGRlbGV0ZSwgbm90IHRoZSBjdXJyZW50
IGRibGlua19idWlsZF9zcWxfdXBkYXRlKCkuCmZvciBleHAgdGJsLgpwazoxLCBpbmZvICd0ZXN0
JyB1cGRhdGUgdG8gcGs6MiwgaW5mbzogJ25ldycKYnVpbGQgdGhlIHVwZGF0ZSBzcWw6CnVwZGF0
ZSB0Ymwgc2V0IHBrPTIsaW5mbz0nbmV3JyB3aGVyZSBwaz0xOwoKCgoKCi0tCrmr0ubKx9K7sbLX
07XEysIsSSdtIERpZ29hbCxKdXN0IERvIEl0LgoKCgoKQXQgMjAxNC0wMS0wMSAwMDowMzo1MSwi
VG9tIExhbmUiIDx0Z2xAc3NzLnBnaC5wYS51cz4gd3JvdGU6Cj5kaWdvYWxAMTI2LmNvbSB3cml0
ZXM6Cj4+IE5PVEUsIHBvc3RncmVzcWwgOS4wKyB3ZSB1c2UgZGJsaW5rX2J1aWxkKiB0byBidWls
ZCBTUUwgLCB0aGUgcHJpbWFyeSBrZXkKPj4gdXNlIHRoZSBsb2dpY2FsIG9yZGVyLiBidXQgd2Ug
Y2Fubid0IHVzZSBkYmxpbmtfZ2V0X3BrZXkgZ2V0IHRoZSBvcmRlcgo+PiBpbnQydmVjdG9yLCB3
ZSBtdXN0IHVzZSB0aGUgcGdfYXR0cmlidXRlIGNhdGFsb2cgZ2V0IHRoZSBsb2dpY2FsIG51bWJl
ci4KPj4gU28sIHRoZSBkYmxpbmtfZ2V0X3BrZXkgIGZ1bmN0aW9uIG5lZWQgY2hhbmdlIC4KPgo+
VGhhdCBkb2Vzbid0IHNvdW5kIHRvIG1lIGxpa2UgYSBidWcsIGJ1dCBhIGZlYXR1cmUgcmVxdWVz
dC4gIFRoZQo+ZG9jdW1lbnRhdGlvbiBjbGVhcmx5IHN0YXRlcyB0aGF0IGRibGlua19nZXRfcGtl
eSdzIHBvc2l0aW9uIGNvbHVtbgo+cnVucyBmcm9tIDEgdG8gTi4gIFlvdXIgcmVhbCBjb21wbGFp
bnQgc2VlbXMgdG8gYmUgIndoeSBpc24ndCBpdAo+ZWFzaWVyIHRvIGdldCB0aGUgY29sdW1uIG51
bWJlcnMgdG8gZ2l2ZSB0byBkYmxpbmtfYnVpbGRfc3FsX3VwZGF0ZQo+YW5kIGZyaWVuZHMiPwo+
Cj5JIHRoaW5rIHdlIGFjdHVhbGx5IG1hZGUgdGhpcyB3b3JzZSBpbiBQRyA5LjA6IGJlZm9yZSB0
aGF0LCBzb21lb25lCj5jb3VsZCBnZXQgdGhlIHBnX2luZGV4LmluZGtleSBhcnJheSBmb3IgdGhl
IHJlbGV2YW50IGluZGV4IGFuZCB1c2UKPnRoYXQsIGJ1dCBub3cgdGhhdCdzIHRoZSB3cm9uZyB0
aGluZyBpZiBhbnkgZHJvcHBlZCBjb2x1bW5zIGFyZSBpbnZvbHZlZC4KPgo+SSdtIHRlbXB0ZWQg
dG8gcHJvcG9zZSBvdmVybG9hZGluZyBkYmxpbmtfYnVpbGRfc3FsX3VwZGF0ZSBhbmQgZnJpZW5k
cwo+d2l0aCBuZXcgZnVuY3Rpb25zIGRlZmluZWQgbGlrZQo+Cj4gICAgIGRibGlua19idWlsZF9z
cWxfdXBkYXRlKHJlbG5hbWUgcmVnY2xhc3MsCj4gICAgIAkJCSAgICAgaW5kZXhuYW1lIHJlZ2Ns
YXNzLAo+CQkJICAgICBzcmNfcGtfYXR0X3ZhbHNfYXJyYXkgdGV4dFtdLAo+CQkJICAgICB0Z3Rf
cGtfYXR0X3ZhbHNfYXJyYXkgdGV4dFtdKQo+Cj5hbmQgbGV0dGluZyBhbGwgdGhlIGNvbHVtbiBs
b29rdXAgbWFjaGluYXRpb25zIGhhcHBlbiBpbnRlcm5hbGx5Cj50byB0aGF0Lgo+Cj4+IGFuZCB0
aGUgc2Vjb25kIGJ1ZzoKPj4gZGlnb2FsPSMgc2VsZWN0ICogZnJvbSBkYmxpbmtfYnVpbGRfc3Fs
X3VwZGF0ZSgndGJsX2RibGluaycsICc0IDcgMTAnLCAzLAo+PiAkJHsxLCBwazIsIDF9JCQsICQk
ezIscGsyLDJ9JCQpOwo+ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIAo+PiAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgIGRibGlua19idWlsZF9zcWxfdXBkYXRlCj4gICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
Cj4gICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIAo+PiAtLS0tLS0tLS0tLS0tLS0tLS0t
LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t
LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0K
Pj4gLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t
LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLQo+
PiAgVVBEQVRFIHRibF9kYmxpbmsgU0VUIGMxID0gJzEnLCBjMiA9ICcxJywgYzMgPSAndGVzdCcs
IHBrMSA9ICcyJywgYzQgPQo+PiAndGVzdCcsIGM1ID0gJzInLCBwazIgPSAncGsyJywgYzYgPSAn
dGVzdCcsIGM3ID0gJzEnLCBwazMgPSAKPj4gJzInLCBjOCA9ICcxJywgYzkgPSAndGVzdCcsIGMx
MCA9ICcyMDEzLTEyLTMxIDA4OjM5OjAxLjQwMDA3NCcgV0hFUkUgcGsxID0KPj4gJzInIEFORCBw
azIgPSAncGsyJyBBTkQgcGszID0gJzInCj4+ICgxIHJvdykKPj4gV2Ugc2VlLCB0aGUgV0hFUkUg
Y2xhdXNlIG5vdCBzcmMgcGsgYXJyYXlzLCBidXQgdGFyZ2V0IHBrIGFycmF5cy4gc28gdGhpcyBp
cwo+PiBhIGJ1Zy4KPgo+VGhhdCBhcHBlYXJzIHRvIG1lIHRvIGJlIHdvcmtpbmcgYXMgZG9jdW1l
bnRlZC4gIEl0IG1pZ2h0IGJlIGJldHRlciBpZiB0aGUKPmFyZ3VtZW50cyB3ZXJlIHJlZmVycmVk
IHRvIGFzICJsb2NhbF9wa19hdHRfdmFsc19hcnJheSIgYW5kCj4icmVtb3RlX3BrX2F0dF92YWxz
X2FycmF5Iiwgc2luY2UgdGhlIGZ1bmN0aW9uIGlzbid0IG1lYW50IHRvIGNoYW5nZSB0aGUKPlBL
IHZhbHVlcyBhcyB5b3Ugc2VlbSB0byB0aGluay4KPgo+CQkJcmVnYXJkcywgdG9tIGxhbmUK

pgsql-bugs by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: BUG #8470: 9.3 locking/subtransaction performance regression
Next
From: Alvaro Herrera
Date:
Subject: Re: BUG #8673: Could not open file "pg_multixact/members/xxxx" on slave during hot_standby