Re: RFC: "UPSERT" in PostgreSQL

2014-09-27 Thread Simon Riggs
On 28 September 2014 00:01, Peter Geoghegan wrote: > I am a PostgreSQL major contributor, currently undertaking development > of a feature sometimes called "UPSERT" for PostgreSQL. Thanks for posting this Peter. The feature is under review in the PostgreSQL community and we would like to solici

Re: RFC: "UPSERT" in PostgreSQL

2014-09-27 Thread Simon Riggs
On 28 September 2014 02:22, Shai Berger wrote: > Upon reading the docs, I was a little surprised to see that in terms of > triggers etc, the operation is always considered an INSERT. I would expect it > to be considered an insert for BEFORE INSERT or INSTEAD OF INSERT triggers, > but if conflict

Re: RFC: "UPSERT" in PostgreSQL

2014-09-27 Thread Peter Geoghegan
On Sat, Sep 27, 2014 at 6:33 PM, Peter Geoghegan wrote: > The statement-level trigger stuff (i.e. the idea that ON CONFLICT > UPDATE never fires an UPDATE statement level trigger) is for > consistency with user-defined rules, where we're really compelled to > have INSERT...ON CONFLICT UPDATE just

Re: RFC: "UPSERT" in PostgreSQL

2014-09-27 Thread Peter Geoghegan
On Sat, Sep 27, 2014 at 6:22 PM, Shai Berger wrote: > Upon reading the docs, I was a little surprised to see that in terms of > triggers etc, the operation is always considered an INSERT. I would expect it > to be considered an insert for BEFORE INSERT or INSTEAD OF INSERT triggers, > but if confl

Re: RFC: "UPSERT" in PostgreSQL

2014-09-27 Thread Peter Geoghegan
Hi Alex, On Sat, Sep 27, 2014 at 5:48 PM, Alex Gaynor wrote: > Thanks for reaching out about this! No problem. I'm not sure if you recall, but we actually met before, in San Francisco during Waza 2013. > From the docs, the syntax looks pretty reasonable, it would be nice to see > what some exam

Re: RFC: "UPSERT" in PostgreSQL

2014-09-27 Thread Shai Berger
Hi Peter, Thanks for asking! On Sunday 28 September 2014 02:01:59 Peter Geoghegan wrote: > > * Would you consider the syntax that I've proposed a good one? > Looks pretty reasonable. > * If it was available, would you use it in future versions of Django? > Do you think the plugins ecosystem c

Re: RFC: "UPSERT" in PostgreSQL

2014-09-27 Thread Alex Gaynor
Hi Peter, Thanks for reaching out about this! On Sat, Sep 27, 2014 at 7:01 PM, Peter Geoghegan wrote: > Hello, > > I am a PostgreSQL major contributor, currently undertaking development > of a feature sometimes called "UPSERT" for PostgreSQL. > > Jacob Kaplan-Moss is an acquaintance and co-work

RFC: "UPSERT" in PostgreSQL

2014-09-27 Thread Peter Geoghegan
Hello, I am a PostgreSQL major contributor, currently undertaking development of a feature sometimes called "UPSERT" for PostgreSQL. Jacob Kaplan-Moss is an acquaintance and co-worker, and I know that it's certainly something that interests him personally - presumably he has some ideas on how an

Re: Django detects HTTP Accept-Language header in case-sensitive manner

2014-09-27 Thread Ramiro Morales
On Fri, Sep 26, 2014 at 4:58 AM, Wayne Ye wrote: > I noticed on small defect here while I was testing my django website's > I18N/L10n, basically below are example Accept-Language headers sent by > Chrome and Firefox (all latest version): > > Chrome: Accept-Language: zh-TW,zh;q=0.8,en-US;q=0.6,en;