[HACKERS] R-Tree implementation using GiST

2001-01-14 Thread Oleg Bartunov
Hi, I've put R-Tree realization using GiST (yet another test of our changes in gist code )on my gist page http://www.sai.msu.su/~megera/postgres/gist/ Also, I've put some GiST related papers for interested readers. The package( contrib-rtree_box_gist.tar.gz ) is built for 7.1. If you find it's

[HACKERS] MS Access vs IS NULL (was Re: [BUGS] Bug in SQL functions that use a NULL parameter directly)

2001-01-14 Thread Tom Lane
Stephan Szabo [EMAIL PROTECTED] writes: Because of Access's brokenness, the parser or some other layer of the code "fixes" explicit = NULL (ie, in the actually query string) into IS NULL which is the correct way to check for nulls. Because your original query was = $1, it doesn't do the

RE: [HACKERS] MS Access vs IS NULL (was Re: [BUGS] Bug in SQL functions that use a NULL parameter directly)

2001-01-14 Thread Mike Mascari
I don't have Office 2000, but I can confirm Access 97 generates such queries. The query-builder doesn't generate the 'key = NULL' query, but the use of the Forms interface does. Mike Mascari [EMAIL PROTECTED] -Original Message- From: Tom Lane [SMTP:[EMAIL PROTECTED]] Sent: Sunday,

Re: [HACKERS] MS Access vs IS NULL (was Re: [BUGS] Bug in SQL functions that use a NULL parameter directly)

2001-01-14 Thread Tom Lane
Mike Mascari [EMAIL PROTECTED] writes: I don't have Office 2000, but I can confirm Access 97 generates such queries. The query-builder doesn't generate the 'key = NULL' query, but the use of the Forms interface does. Yes, it was broken as of a couple years ago. What I thought I remembered

[HACKERS] conflicting types for `struct Oid'

2001-01-14 Thread Corrado Giacomini
Dear All, I currently developing a project using SNMP++ and posgresql (7.0.3) libpq++ Since both SNMP and posgresql define an Oid type typedef unsigned int Oid (postgresql) struct Oid (SNMP++) At compilation time I get this error :

[HACKERS] Must implement PQnotifyFree()

2001-01-14 Thread Steve Howe
Hi folks, I'm co-developer of Delphi and Borland C++ Builder Zeos library (http://www.zeos.dn.ua) by Sergey Seroukhov which includes support for PostgreSQL. In fact, I'm dedicated Zeos PostgreSQL developer. We've run into a problem that we can't properly free the PPGnotify

[HACKERS] Re: FWD: bizarre behavior of 'time' data entry

2001-01-14 Thread Barry Stewart
Check out Trustix at www.trustix.net. I'm using the RPM that was installed with the distro. ps shows postgresql running: /usr/bin/pg_ctl -D /var/lib/pgsql/data -p /usr/bin/postmaster start /usr/bin/postmaster -i I can poke a hole in my firewall and let you connect to the database if you would

Re: [HACKERS] pgaccess: russian fonts SQL window???

2001-01-14 Thread Len Morgan
1. I cannot view russian text in russian when I use pgaccess. I set all the fonts in 'Preferences' to -cronyx-helvetica-*-*-*-*-17-*-*-*-*-*-koi8-* , but don't see russian letters in 'tables' and others windows. The texts are really in russian, DBENCODING is KOI8. Hm. We've had a couple of

Re: [HACKERS] SIGTERM - elog(FATAL) - proc_exit() is probably a bad idea

2001-01-14 Thread Tom Lane
"Hiroshi Inoue" [EMAIL PROTECTED] writes: Isn't it appropriate to call a diffrent macro using a separate CriticalSectionCount variable in newly added places ? Why? What difference do you see in the nature of the critical sections? They all look the same to me: hold off cancel/die response.

RE: [HACKERS] SIGTERM - elog(FATAL) - proc_exit() is probably a bad idea

2001-01-14 Thread Hiroshi Inoue
-Original Message- From: Tom Lane [mailto:[EMAIL PROTECTED]] "Hiroshi Inoue" [EMAIL PROTECTED] writes: Isn't it appropriate to call a diffrent macro using a separate CriticalSectionCount variable in newly added places ? Why? What difference do you see in the nature of the

Re: [HACKERS] SIGTERM - elog(FATAL) - proc_exit() is probably a bad idea

2001-01-14 Thread Tom Lane
"Hiroshi Inoue" [EMAIL PROTECTED] writes: Why? What difference do you see in the nature of the critical sections? They all look the same to me: hold off cancel/die response. I've thought that the main purpose of CRIT_SECTION is to force redo recovery for any errors during the CRIT_SECTION

[HACKERS] Re: FWD: bizarre behavior of 'time' data entry

2001-01-14 Thread Barry Stewart
See attached tmpfile.txt. I'm going to try rebuilding the 7.0.2 SRPM first. If that doesn't work, I'll try building the 7.0.3 tar source file. Wish me luck! Barry On 2001.01.13 10:34:55 -0500 Thomas Lockhart wrote: ps shows postgresql running: /usr/bin/pg_ctl -D /var/lib/pgsql/data -p

[HACKERS] SUCCESS!!: bizarre behavior of 'time' data entry

2001-01-14 Thread Barry Stewart
FIXED! I had already started to rebuild the SRPM when your latest email arrived. After installing the resulting RPMS, the problem still existed. I downloaded the Mandrake .rpmrc file, rebuilt, and the problem is gone (yea!). Interestingly enough, the existing time entries in my test database

[HACKERS] copy from stdin; bug?

2001-01-14 Thread Rehak Tamas
Hello i don't know, whether it is a real bug or what, has been fixed or not, but i can't find any info about it: i try to fill my table from a file using copy from stdin and postgresql corrupt the table. This happen if before the tab or end of line there is word that has a non-standard letter

Re: [HACKERS] SIGTERM - elog(FATAL) - proc_exit() is probably a bad idea

2001-01-14 Thread Hiroshi Inoue
Hmm, I've seen neither my posting nor your reply on hackers ML. Tom Lane wrote: "Hiroshi Inoue" [EMAIL PROTECTED] writes: Why? What difference do you see in the nature of the critical sections? They all look the same to me: hold off cancel/die response. I've thought that the main

Re: [HACKERS] SIGTERM - elog(FATAL) - proc_exit() is probably a bad idea

2001-01-14 Thread Tom Lane
Hiroshi Inoue [EMAIL PROTECTED] writes: I've thought that the main purpose of CRIT_SECTION is to force redo recovery for any errors during the CRIT_SECTION to complete the critical operation e.g. bt_split(). How could it force redo? Doesn't proc_exit(non-zero) force shuttdown recovery ?

RE: [HACKERS] primary keys

2001-01-14 Thread Christopher Kings-Lynne
Here is a code extract from phpPgAdmin that dumps UNIQUE and PRIMARY constraints. Feel free to use the query... -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Felipe Diaz Cardona Sent: Sunday, January 14, 2001 7:17 AM To: [EMAIL PROTECTED] Subject:

Re: [HACKERS] copy from stdin; bug?

2001-01-14 Thread Tom Lane
Rehak Tamas [EMAIL PROTECTED] writes: i try to fill my table from a file using copy from stdin and postgresql corrupt the table. This happen if before the tab or end of line there is word that has a non-standard letter like o with accent and then an ordinary lette [a-z]. and now i reproduced

Re: [HACKERS] SIGTERM - elog(FATAL) - proc_exit() is probably a bad idea

2001-01-14 Thread Hiroshi Inoue
Tom Lane wrote: Hiroshi Inoue [EMAIL PROTECTED] writes: I've thought that the main purpose of CRIT_SECTION is to force redo recovery for any errors during the CRIT_SECTION to complete the critical operation e.g. bt_split(). How could it force redo? Doesn't proc_exit(non-zero)

Re: [HACKERS] Re: AW: Re: GiST for 7.1 !!

2001-01-14 Thread selkovjr
Tom Lane writes: [EMAIL PROTECTED] writes: ... SunOS typhoon 5.7 Generic_106541-10 sun4u sparc SUNW,Ultra-1 on which configure didn't detect the absence of libz.so Really? Details please. It's hard to see how it could have messed up on that. Tom, I didn't look well enough -- I

Re: [HACKERS] Re: AW: Re: GiST for 7.1 !!

2001-01-14 Thread Tom Lane
[EMAIL PROTECTED] writes: on which configure didn't detect the absence of libz.so Really? Details please. It's hard to see how it could have messed up on that. I didn't look well enough -- I apologize. The library is there, but ld.so believes it is not: typhoon postmaster ld.so.1:

[HACKERS] RPMS for 7.1beta3 being uploaded.

2001-01-14 Thread Lamar Owen
Ok, I have a first set of 7.1beta3 RPMs uploading now. These RPMs pass regression on my home RedHat 6.2 machine, which has all locale environment variables disabled (/etc/sysconfig/i18n deleted and a reboot). It may take a few minutes to a few hours for the changes I uploaded to propagate to