[HACKERS] Problem in buidind Postgres with mingw

2006-11-14 Thread [EMAIL PROTECTED]
Hello we've some trouble with buildinq postgreSQL (8.1.4.tar.gz) from code with Mingw on a windows xp home machine. We've installed mingw 5.0.3 and msys 1.0.10. From the msys console we've typed the following command: $ LDFLAGS=-lstdc++ configure --without-zlib and that's seems ok. then we do:

[HACKERS] Segmentation fault with HEAD.

2006-11-14 Thread Rune Bromer
Hi. I just compiled the version in HEAD with no problems. I connected with template1, made some tests and quited. I got the following error: template1=# \q psql(15213) malloc: *** error for object 0x1804e00: incorrect checksum for freed object - object was probably modified after being

[HACKERS] Remove contrib version of rtree_gist --- now in core system ?

2006-11-14 Thread jorge alberto
Hello everybody!Remove contrib version of rtree_gist --- now in core system ?I have read that since version 8.1 the contrib version of rtree_gist is not in /contrib anymore, now is in core system, but where can I find it? regards Jorge

Re: [HACKERS] Problem in buidind Postgres with mingw

2006-11-14 Thread Andrew Dunstan
[EMAIL PROTECTED] wrote: Hello we've some trouble with buildinq postgreSQL (8.1.4.tar.gz) from code with Mingw on a windows xp home machine. My experience is that XP-Pro is a better platform for building postgres than XP-HE. We've installed mingw 5.0.3 and msys 1.0.10. From the msys

Re: [HACKERS] Remove contrib version of rtree_gist --- now in core system ?

2006-11-14 Thread Tom Lane
jorge alberto [EMAIL PROTECTED] writes: I have read that since version 8.1 the contrib version of rtree_gist is not in /contrib anymore, now is in core system, but where can I find it? You don't need to find it, it's built in. Just create an index. regards, tom lane

[HACKERS] Help me pack up postgresDB with my windows application.

2006-11-14 Thread du li
Dear hackers,I'm working ona windows application with C# language and use npgsql to connectpostgres DB. I'm eager to learn how to make a solo setup file which included windows application and postgres DB. My develop environment is Visual Studio 2003 and Framework 1.1I don't know if there

Re: [HACKERS] Help me pack up postgresDB with my windows application.

2006-11-14 Thread Shane Ambler
du li wrote: Dear hackers, I'm working on a windows application with C# language and use npgsql to connect postgres DB. I'm eager to learn how to make a solo setup file which included windows application and postgres DB. My develop environment is Visual Studio 2003 and Framework 1.1

Re: [HACKERS] [SQL] Case Preservation disregarding case sensitivity?

2006-11-14 Thread Bruce Momjian
beau hargis wrote: Having installed DB2 Enterprise today and taking it for a spin, it does indeed behave in a similar manner. However, after reading through both specifications, it seems that DB2 follows more of the spec than PostgreSQL. The specifications state that for purpose of

Re: [HACKERS] Segmentation fault with HEAD.

2006-11-14 Thread Alon Goldshuv
Rune, This is a readline issue of some sort. Basically this seg fault happens when you quit and the .psql_history file changes. I don't really know why it happens and what the right solution is but if you empty the contents of this file (or maybe delete it) then your seg fault will go away (until

Re: [HACKERS] TODO Item: IN(long list ...)

2006-11-14 Thread Bruce Momjian
Alvaro Herrera wrote: Josh Berkus wrote: Bruce, all: This is a longstanding performance issue which just came up again on IRC, and I can't find a TODO item for it. So I'd like it added to TODO. Suggested phrasing: -- Improve performance of queries with IN() clauses containing

Re: [HACKERS] Segmentation fault with HEAD.

2006-11-14 Thread Rune Bromer
Alon Goldshuv wrote: Rune, This is a readline issue of some sort. Basically this seg fault happens when you quit and the .psql_history file changes. I don't really know why it happens and what the right solution is but if you empty the contents of this file (or maybe delete it) then your seg

Re: [HACKERS] Segmentation fault with HEAD.

2006-11-14 Thread Alon Goldshuv
Thank you very much, I'll verify this tomorrow and return if the error persists. What led you to the conclusion that it was a readline error? I looked into it for a couple of hours, but as I'm new to the postgres source code I cound't find the error :) For the life of me I can't remember!

Re: [HACKERS] [SQL] Case Preservation disregarding case

2006-11-14 Thread Simon Riggs
On Thu, 2006-11-02 at 10:51 -0500, Tom Lane wrote: Simon Riggs [EMAIL PROTECTED] writes: We have namespaces to differentiate between two sources of object names, so anybody who creates a schema where MyColumn is not the same thing as myColumn is not following sensible rules for conceptual