Re: [HACKERS] select like...not using index

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Magnus Hagander" <mha(at)sollentuna(dot)net>
Cc: "Merlin Moncure" <merlin(dot)moncure(at)rcsonline(dot)com>, pgsql(at)mohawksoft(dot)com, "PgSql-Win32" <pgsql-hackers-win32(at)postgresql(dot)org>, pgsql-patches(at)postgresql(dot)org
Subject: Re: [HACKERS] select like...not using index
Date: 2004-06-07 20:16:26
Message-ID: 10996.1086639386@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers-win32 pgsql-patches

"Magnus Hagander" <mha(at)sollentuna(dot)net> writes:
> It certainly doesn't. There still was a bug with the locale stuff,
> though - the GUC variable was not set in the child processes. So "show
> lc_collate" would *always* return "C", for example. attached patch fixes
> this.

Hm. Why were these vars not propagated by the regular mechanism for GUC
variables (write_nondefault_variables or whatever it's called)? If the
problem is that it's not accepting PGC_INTERNAL values, then we need to
fix it there not here, because otherwise we'll have to pass all the
PGC_INTERNAL variables through the backend_variables file, which seems
like a recipe for more of the same sort of bug.

regards, tom lane

In response to

Browse pgsql-hackers-win32 by date

  From Date Subject
Next Message Magnus Hagander 2004-06-07 21:04:29 Re: [HACKERS] select like...not using index
Previous Message Magnus Hagander 2004-06-07 19:24:55 Re: [HACKERS] select like...not using index

Browse pgsql-patches by date

  From Date Subject
Next Message Bruce Momjian 2004-06-07 20:36:03 pg_dump/pg_dumpall start/stop times
Previous Message Magnus Hagander 2004-06-07 20:14:01 pgpipe error reporting