Re: [BUGS] PROBLEMS!!!

2004-08-06 Thread Kris Jurka
On Fri, 30 Jul 2004, [iso-8859-1] liz gonzalez wrote: > Dear Sr. or Madam, > > I am writting to you because I am having problems with > the configuration of PostgreSQL v. 7.4 on LINUX, I > want to configurate it in JAVA , I set: > > $./configure --with-java > > checking whether to build Java

[BUGS] Notifications in JDBC driver not correct for V3 protocol

2004-08-06 Thread Donald Fraser
PostgreSQL version 7.4.3 JDBC Driver The notifcations for the version 3 protocol are not being decoded at all in the jdbc driver. Here is the unix diff. which will correct this bug. File: /cvsroot/pgsql-server/src/interfaces/jdbc/org/postgresql/core/QueryExecutor.jav a 167c167,168 < statement.ad

[BUGS] Regex bug

2004-08-06 Thread David Fetter
Kind people, Here's a symptom as reported by John Hansen aka applejack: SELECT 'r'||'\000\125'||'hello' ~ '^.hello' AS "OMG"; OMG - t (1 row) I have produced this behavior in 7.4.3 and CVS tip. This should be false, shouldn't it? Cheers, D -- David Fetter [EMAIL PROTECTED] http://fette

Re: [BUGS] Regex bug

2004-08-06 Thread Tom Lane
David Fetter <[EMAIL PROTECTED]> writes: > Here's a symptom as reported by John Hansen aka applejack: > SELECT 'r'||'\000\125'||'hello' ~ '^.hello' AS "OMG"; This is not a regex bug: it has to do with the fact that we don't support embedded nulls in text values. This may enlighten you a bit as t

Re: [BUGS] Regex bug

2004-08-06 Thread Tom Lane
David Fetter <[EMAIL PROTECTED]> writes: > On Fri, Aug 06, 2004 at 01:32:32PM -0400, Tom Lane wrote: >> regression=# select length ('\000\125'); >> length >> >> 0 >> (1 row) > Ah, right. John was testing his unicode patch, so there must be some > magick underneath that distinguishes char

Re: [BUGS] Regex bug

2004-08-06 Thread David Fetter
On Fri, Aug 06, 2004 at 01:32:32PM -0400, Tom Lane wrote: > David Fetter <[EMAIL PROTECTED]> writes: > > Here's a symptom as reported by John Hansen aka applejack: > > > SELECT 'r'||'\000\125'||'hello' ~ '^.hello' AS "OMG"; > > This is not a regex bug: it has to do with the fact that we don't > s