Re: [BUGS] BUG #2381: LIMIT 1 very very lazy than without

2006-04-09 Thread Qingqing Zhou
""Peter Krauss"" <[EMAIL PROTECTED]> wrote > > The single query (on psql) is fary fast > (less than 1 sec) > > SELECT a,b,c,d FROM products_view WHERE > sku='0-123-0-0-6024-20' > OR lower(codfornecedor)=lower('0-123-0-0-6024-20') > OR lower(eanfor)=lower('0-123-0-0-6024-20') > OR lower(refpro

Re: [BUGS] BUG #2383: MessageBox Win32 API makes clients freeze

2006-04-09 Thread Tom Lane
"Pegasus86" <[EMAIL PROTECTED]> writes: > I have created a db which contains a function linked to a C function > contained in a dll. This function should show a message box to the users. This makes no sense whatsoever, as a C function will run in the server process, which may not even be on the sa

Re: [BUGS] BUG #2384: Can not install PostgreSQL 7.2.7 on FreeBSD6.0

2006-04-09 Thread Tom Lane
"Alaa ElGohary" <[EMAIL PROTECTED]> writes: > When Trying to install PostgreSQL 7.2.7 on FreeBSD6.0 and after ./configure > gmake ends with errors Why are you trying to use such an old PG release on such a new platform? We stopped supporting 7.2.* some time ago, and are certainly not going to upda

[BUGS] BUG #2383: MessageBox Win32 API makes clients freeze

2006-04-09 Thread Pegasus86
The following bug has been logged online: Bug reference: 2383 Logged by: Pegasus86 Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1.3 Operating system: Windows XP Professional Description:MessageBox Win32 API makes clients freeze Details: I am working on a P

Re: [BUGS] bug in windows xp

2006-04-09 Thread Martijn van Oosterhout
On Sat, Apr 08, 2006 at 12:27:19PM -0400, Tom Lane wrote: > Hmm, it seems to depend on the hardware you're using. I just tried it > on four different machines: > > A simple C program shows the same. Why isn't it being caught on > > windows? > > That still looks like a failure to trap something

[BUGS] BUG #2384: Can not install PostgreSQL 7.2.7 on FreeBSD6.0

2006-04-09 Thread Alaa ElGohary
The following bug has been logged online: Bug reference: 2384 Logged by: Alaa ElGohary Email address: [EMAIL PROTECTED] PostgreSQL version: 7.2.7 Operating system: FreeBSD 6.0 Description:Can not install PostgreSQL 7.2.7 on FreeBSD6.0 Details: When Trying to install