Re: [BUGS] upper() problem in 7.0.2

2000-07-05 Thread Tom Lane
"Christopher L. Cousins" <[EMAIL PROTECTED]> writes: > I have been able to make the backend crash using psql. I also took a dump > of the database while I had some known values that would trigger the problem. > Because of this, I can now reload the dump (to a dummy database) at any time to > repr

Re: [BUGS] upper() problem in 7.0.2

2000-07-05 Thread Christopher L. Cousins
On Wed, Jul 05, 2000 at 12:03:46PM -0400, Tom Lane wrote: > "Christopher L. Cousins" <[EMAIL PROTECTED]> writes: > > Using PHP4 or PHP3, the following query will ~sometimes~ cause the > > backend to terminate. It depends the value of $searchstr and appears > > (to me anyway) to be random. A $sea

Re: [BUGS] problem with union and outer join using a view

2000-07-05 Thread Tom Lane
Merrill Oveson <[EMAIL PROTECTED]> writes: > How soon until this is fixed? The plans are to fix it in 7.2, which might be half a year or so away. > Any suggestions? For now, don't use a view. Perhaps you can embed the query in a function or something so that you don't have to look at it ...

[BUGS] Re: [PATCHES] Patch for Linux-IA64

2000-07-05 Thread Bruce Momjian
OK, I have applied part of this patch. I skipped the changes to Makefile.shlib, and the hack to disable flock in pqcomm.c. By the time this code is released in 7.1, hopefully the Linux kernel will be fixed. The Makefile.shlib changes will have to be discussed with other Linux developers so we a

Re: [BUGS] upper() problem in 7.0.2

2000-07-05 Thread Tom Lane
"Christopher L. Cousins" <[EMAIL PROTECTED]> writes: > Using PHP4 or PHP3, the following query will ~sometimes~ cause the > backend to terminate. It depends the value of $searchstr and appears > (to me anyway) to be random. A $searchstr that causes the backend to > crash right now may work just

[BUGS] problem with union and outer join using a view

2000-07-05 Thread Merrill Oveson
Developers: I need to create a view that contains a query with an outer join. Since outer joins are not supported, I used a union. The problem, now, is that unions are not supported with views. How soon until this is fixed? Any suggestions? Merrill

[BUGS] upper() problem in 7.0.2

2000-07-05 Thread Christopher L. Cousins
Your name : Christopher L. Cousins Your email address : [EMAIL PROTECTED] System Configuration - Architecture (example: Intel Pentium) : AMD K7 (Athlon) ("AuthenticAMD" 686-class) 705 MHz Operating System (example: Linux 2.0.26 ELF) : OpenBSD

[BUGS] Patch for Linux-IA64

2000-07-05 Thread Reinhard Max
Hi, attached to this mail is a patch from a colleague that makes PostgreSQL-7.0.2 run on Linux for the Intel-IA64 architecture. It also fixes a bug in the configure scripts that caused configure to fail on the fcntl(F_SETLK) test. This fix triggered a bug in the fcntl(F_SETLK) code of the Linux