Re: [BUGS] Bug#372115: Last security update of postgresql-contrib

2006-07-05 Thread Bruce Momjian
Patch applied. Thanks. Backpatched back to 7.3.X. --- Martin Pitt wrote: -- Start of PGP signed section. > Hi PostgreSQL gurus, hi Olivier, > > Martin Pitt [2006-06-16 0:15 +0200]: > > Upstream confirmed my reply in the

Re: [BUGS] Fwd: [JDBC] Diffrence between 8.0.3 and 8.1.3

2006-07-05 Thread Kris Jurka
On Wed, 5 Jul 2006, Yann PICHOT wrote: When i use this SQL request : SELECT col1, cast(' ' as varchar(3)) as mycol FROM mytable, getColumnDisplaySize return -5. When i use this SQL request : SELECT col1, cast(' ' as varchar(3)) as mycol, getColumnDisplaySize return 3 OK, I misunderstoo

Re: [BUGS] query very slow when enable_seqscan=on

2006-07-05 Thread Tomasz Ostrowski
On Tue, 04 Jul 2006, Tom Lane wrote: > Tomasz Ostrowski <[EMAIL PROTECTED]> writes: > > So why estimate regex expressions if there is no estimation possible? > > Let's set this estimate to be pessimistic (match everything or > > everything not null) and it will choose better plans. > > Better pla