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

2001-01-14 Thread Hiroshi Inoue
> -Original Message- > From: Tom Lane > > I have just finished trudging through a bunch of code and trying to make > it secure against being interrupted by die() at arbitrary instants. It seems that START/END_CRIT_SECTION() is called in both existent and newly added places. Isn't it appro

[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 in

[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 remembe

[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 : /deliveries/external/SNMP++/3.4Patched/snmp++/include/oid.h:

[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 handle

[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

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

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_SE

[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 -

[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 m

[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 or end of line there is word that has a non-standard letter like

Re: [HACKERS] Must implement PQnotifyFree()

2001-01-14 Thread Tom Lane
"Steve Howe" <[EMAIL PROTECTED]> writes: > [ doesn't want to assume he knows which malloc() libpq is using ] You have a point. This plea would be more compelling if it came complete with a code and documentation patch against current sources, however ;-). I doubt anyone else will see it as a hi

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 t

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 shut

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: [HAC

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 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 reproduce

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

Re: [HACKERS] copy from stdin; bug?

2001-01-14 Thread Rehak Tamas
Hi On Sun, 14 Jan 2001, Tom Lane wrote: > Sounds to me like a multibyte-character translation problem. What > encoding do you have set for the database? What have you told it the > client encoding is? sorry, i forgot to write: i use debian potato, i use the standard debian packege. version 6.5

Re: [HACKERS] copy from stdin; bug?

2001-01-14 Thread Tatsuo Ishii
> On Sun, 14 Jan 2001, Tom Lane wrote: > > Sounds to me like a multibyte-character translation problem. What > > encoding do you have set for the database? What have you told it the > > client encoding is? > > sorry, i forgot to write: > i use debian potato, i use the standard debian packege. >

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 eno

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

[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 the