Re: Set COLLATE on a session level - Mailing list pgsql-general

From Peter Eisentraut
Subject Re: Set COLLATE on a session level
Date
Msg-id 67253506-9381-44ac-0bbd-5b4aea29cc19@enterprisedb.com
Whole thread Raw
In response to Re: Set COLLATE on a session level  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Set COLLATE on a session level  (Laurenz Albe <laurenz.albe@cybertec.at>)
List pgsql-general
On 2020-12-04 17:18, Tom Lane wrote:
>> There is a SET COLLATION command in the SQL standard that does this.
>> Someone just has to implement it.  It wouldn't be terribly difficult, I
>> think.
> 
> [ squint... ]  Just because it's in the standard doesn't mean it's a
> good idea.  It sounds like this is morally equivalent to a GUC that
> changes query semantics.  We have learned painfully that such behaviors
> are best avoided, because they break things you didn't expect to break.

I think it would be analogous to the schema search path.



pgsql-general by date:

Previous
From: Alban Hertroys
Date:
Subject: Re: Accessing Postgres Server and database from other Machine
Next
From: Karsten Hilbert
Date:
Subject: Aw: Re: Set COLLATE on a session level