Re: [HACKERS] Setting locale per connection

2003-07-02 Thread Tom Lane
Behdad Esfahbod <[EMAIL PROTECTED]> writes: > So, assuming I want to go for the right way, I've just seen the > column-based LC_COLLATE in the TODO list. Is there any more > information about that? If you troll the pghackers archives you will find several past discussions about it. A reasonabl

Re: [HACKERS] Setting locale per connection

2003-07-02 Thread Behdad Esfahbod
On Wed, 2 Jul 2003, Tom Lane wrote: > > On Wed, 2 Jul 2003, Behdad Esfahbod wrote: > >> so I have wrote my 10lines function as a wrapper around > >> setlocale, that is attached. > > Indeed, this is exactly why Postgres goes out of its way to prevent you > from changing the backend's collation set

Re: [HACKERS] Setting locale per connection

2003-07-01 Thread Tom Lane
Stephan Szabo <[EMAIL PROTECTED]> writes: > On Wed, 2 Jul 2003, Behdad Esfahbod wrote: >> so I have wrote my 10lines function as a wrapper around >> setlocale, that is attached. > Hmm, I'd think there'd be some potential for danger there. I don't play > with the locale stuff, but if the collation

Re: [HACKERS] Setting locale per connection

2003-07-01 Thread Stephan Szabo
On Wed, 2 Jul 2003, Behdad Esfahbod wrote: > On Tue, 1 Jul 2003, Stephan Szabo wrote: > > > > > On Wed, 2 Jul 2003, Behdad Esfahbod wrote: > > > > > I'm new to the list, so don't flame at the first date ;). > > > > > > I usually use PostgreSQL for multiple languages, so I needed to > > > set local

Re: [HACKERS] Setting locale per connection

2003-07-01 Thread Behdad Esfahbod
On Tue, 1 Jul 2003, Stephan Szabo wrote: > > On Wed, 2 Jul 2003, Behdad Esfahbod wrote: > > > I'm new to the list, so don't flame at the first date ;). > > > > I usually use PostgreSQL for multiple languages, so I needed to > > set locale per connection, or can change the locale on the fly. > >

Re: [HACKERS] Setting locale per connection

2003-07-01 Thread Stephan Szabo
On Wed, 2 Jul 2003, Behdad Esfahbod wrote: > I'm new to the list, so don't flame at the first date ;). > > I usually use PostgreSQL for multiple languages, so I needed to > set locale per connection, or can change the locale on the fly. > I don't know if there is any such ability integrated in or

Re: [HACKERS] Setting locale per connection

2003-07-01 Thread Christopher Kings-Lynne
> I usually use PostgreSQL for multiple languages, so I needed to > set locale per connection, or can change the locale on the fly. > I don't know if there is any such ability integrated in or not, > so I have wrote my 10lines function as a wrapper around > setlocale, that is attached. So what I d

Re: [HACKERS] Setting locale per connection

2003-07-01 Thread Alvaro Herrera
On Wed, Jul 02, 2003 at 07:22:51AM +0430, Behdad Esfahbod wrote: > Another silly question, isn't any way to get rid of seqscan, when > doing 'SELECT count(*) FROM tab;'? No :-( If you want to do that frequently, you should try to find another way to keep the count. -- Alvaro Herrera () "Crear

[HACKERS] Setting locale per connection

2003-07-01 Thread Behdad Esfahbod
Hi all, I'm new to the list, so don't flame at the first date ;). I usually use PostgreSQL for multiple languages, so I needed to set locale per connection, or can change the locale on the fly. I don't know if there is any such ability integrated in or not, so I have wrote my 10lines function a