Thread: BUG #14327: UPSERT requires full path to column

VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJz
aXRlOgoKQnVnIHJlZmVyZW5jZTogICAgICAxNDMyNwpMb2dnZWQgYnk6ICAg
ICAgICAgIEVnb3IgUHVnaW4KRW1haWwgYWRkcmVzczogICAgICBlZ29yLnB1
Z2luQGdtYWlsLmNvbQpQb3N0Z3JlU1FMIHZlcnNpb246IDkuNS40Ck9wZXJh
dGluZyBzeXN0ZW06ICAgd2luMTAKRGVzY3JpcHRpb246ICAgICAgICAKCkhp
LA0KDQpJJ3ZlIG5vdGljZWQgdXBzZXJ0IHF1ZXJ5IHdvbid0IHdvcmsgaWYg
SSBkbyBub3Qgd3JpdGUgJ3NjaGVtYS5UQUJMRS5jb2x1bW4nCmluc3RlYWQg
b2Ygc2ltcGxlICdjb2x1bW4nIGluICdvbiBjb25mbGljdCBkbyB1cGRhdGUg
c2V0JyBxdWVyeS4NCg0KV29ya2luZzoNCg0KaW5zZXJ0IGludG8gc3RhdGlz
dGljcy4iTW9zdFBvcHVsYXJEZXBlbmRlbmNpZXMiDQooaWQsIGluZGlyZWN0
LCBkb3dubG9hZHNfd2VlaykNCnZhbHVlcyAoJDEsICQyLCAxKQ0Kb24gY29u
ZmxpY3QgKGlkLCBpbmRpcmVjdCkgZG8gdXBkYXRlDQpzZXQgZG93bmxvYWRz
X3dlZWsgPSBzdGF0aXN0aWNzLiJNb3N0UG9wdWxhckRlcGVuZGVuY2llcyIu
ZG93bmxvYWRzX3dlZWsgKwoxDQp3aGVyZSBzdGF0aXN0aWNzLiJNb3N0UG9w
dWxhckRlcGVuZGVuY2llcyIuaWQgPSAkMSBhbmQKc3RhdGlzdGljcy4iTW9z
dFBvcHVsYXJEZXBlbmRlbmNpZXMiLmluZGlyZWN0ID0gJDI7DQoNCk5vdCB3
b3JraW5nOg0KDQppbnNlcnQgaW50byBzdGF0aXN0aWNzLiJNb3N0UG9wdWxh
ckRlcGVuZGVuY2llcyINCihpZCwgaW5kaXJlY3QsIGRvd25sb2Fkc193ZWVr
KQ0KdmFsdWVzICgkMSwgJDIsIDEpDQpvbiBjb25mbGljdA0KKGlkLCBpbmRp
cmVjdCkgLS0gYWxzbyB3L291dCB0aGlzLCBpdCBkb2VzIG5vdCB3b3JrIHRv
bywgYnV0IGlzbid0IGl0Cm9wdGlvbmFsIGVsZW1lbnQ/DQpkbyB1cGRhdGUN
CnNldCBkb3dubG9hZHNfd2VlayA9IGRvd25sb2Fkc193ZWVrICsgMQ0Kd2hl
cmUgaWQgPSAkMSBhbmQgaW5kaXJlY3QgPSAkMjsNCg0KCgo=

On Mon, Sep 19, 2016 at 1:06 AM,  <egor.pugin@gmail.com> wrote:
> I've noticed upsert query won't work if I do not write 'schema.TABLE.column'
> instead of simple 'column' in 'on conflict do update set' query.

Use an alias. e.g.:

INSERT INTO statistics."MostPopularDependencies" as mpd ...

You can then reference columns using mpd.downloads_week, etc

--
Peter Geoghegan

Thanks!
But is this expected behavior and not a bug?

On 19 September 2016 at 13:06, Peter Geoghegan <pg@heroku.com> wrote:
> On Mon, Sep 19, 2016 at 1:06 AM,  <egor.pugin@gmail.com> wrote:
>> I've noticed upsert query won't work if I do not write 'schema.TABLE.column'
>> instead of simple 'column' in 'on conflict do update set' query.
>
> Use an alias. e.g.:
>
> INSERT INTO statistics."MostPopularDependencies" as mpd ...
>
> You can then reference columns using mpd.downloads_week, etc
>
> --
> Peter Geoghegan



--
Egor Pugin