Re: [BUGS] BUG #2895: Private Use Unicode character crashes server when using ILIKE

2007-01-23 Thread Tom Lane
I wrote: > I'm surprised we've not seen reports of other problems. The lack of > crash in 8.2 is because iwchareq went away completely, but that's > certainly not the only place doing conversions to pg_wchar and expecting > the result to fit in a prespecified buffer ... Actually, it looks like al

Re: [BUGS] BUG #2895: Private Use Unicode character crashes server when using ILIKE

2007-01-23 Thread Tom Lane
Michael Fuhr <[EMAIL PROTECTED]> writes: > The crash seems to happen only with code points that have UTF-8 > byte sequences of more than three bytes (U+1 and higher). > Here's an example that segfaults in 8.1.6 on the Linux box: > select e'\360\220\200\200' ilike e'%\342\204\242'; Well, traci

Re: [BUGS] BUG #2895: Private Use Unicode character crashes server when using ILIKE

2007-01-23 Thread Michael Fuhr
On Tue, Jan 23, 2007 at 09:09:52PM -0500, Tom Lane wrote: > "James Russell" <[EMAIL PROTECTED]> writes: > > If a text field contains a such a character, and if the search term contains > > certain Unicode characters, then queries using ILIKE will crash the server. > > I can't reproduce this with y

Re: [BUGS] BUG #2895: Private Use Unicode character crashes server when using ILIKE

2007-01-23 Thread Tom Lane
"James Russell" <[EMAIL PROTECTED]> writes: > If a text field contains a such a character, and if the search term contains > certain Unicode characters, then queries using ILIKE will crash the server. I can't reproduce this with your example, so I suppose there's some critical bit of information y

Re: [BUGS] BUG #2905: min and max return incorrect text type

2007-01-23 Thread Bruce Momjian
Alvaro Herrera wrote: > Adriaan van Os wrote: > > Tom Lane wrote: > > >Bruce Momjian <[EMAIL PROTECTED]> writes: > > >>Peter Eisentraut wrote: > > >>>Aside from the apparent discrepancy between the documentation and the > > >>>actual behavior, is there an actual use case where this is a problem? >

Re: [BUGS] BUG #2905: min and max return incorrect text type

2007-01-23 Thread Alvaro Herrera
Adriaan van Os wrote: > Tom Lane wrote: > >Bruce Momjian <[EMAIL PROTECTED]> writes: > >>Peter Eisentraut wrote: > >>>Aside from the apparent discrepancy between the documentation and the > >>>actual behavior, is there an actual use case where this is a problem? > > > >>No, I don't think so, and I

Re: [BUGS] BUG #2905: min and max return incorrect text type

2007-01-23 Thread Adriaan van Os
Tom Lane wrote: Bruce Momjian <[EMAIL PROTECTED]> writes: Peter Eisentraut wrote: Aside from the apparent discrepancy between the documentation and the actual behavior, is there an actual use case where this is a problem? No, I don't think so, and I am reluctant to adjust the documentation t

[BUGS] BUG #2924: pg_ctl reports 'server starting' after fatal error

2007-01-23 Thread Dave Page
The following bug has been logged online: Bug reference: 2924 Logged by: Dave Page Email address: [EMAIL PROTECTED] PostgreSQL version: 8.3dev Operating system: XP Pro Description:pg_ctl reports 'server starting' after fatal error Details: In case someone gets an ur