Re: [BUGS] Duplicate primary key record

2003-11-15 Thread Stephan Szabo
On Sun, 16 Nov 2003, Joel Jacobson wrote: > Please enter a FULL description of your problem: > > I have simple table with a primary key. > Somehow two records with the SAME primary key has managed to get into the > table. > This should as far as I k

Re: [BUGS] RC2 will not make check on OSX 10.3

2003-11-15 Thread Neil Conway
Theodore Petrosky <[EMAIL PROTECTED]> writes: > I find it difficult to understand exactally what > reasonable values are. This page in the documentation includes a table that specifies "reasonable values" for all of the SysV IPC settings: http://candle.pha.pa.us/main/writings/pgsql/sgml/kernel-r

Re: [BUGS] RC2 will not make check on OSX 10.3

2003-11-15 Thread Theodore Petrosky
BTW, I find it difficult to understand exactally what reasonable values are. Is it possible in the docs to explain a little what these values should be. Or how to calculate them. I felt totally in the dark. If I hadn't fallen across an email on one of the sites that suggested values, I think I w

Re: [BUGS] RC2 will not make check on OSX 10.3

2003-11-15 Thread Tom Lane
Neil Conway <[EMAIL PROTECTED]> writes: > Should we update the documentation's advice? Looks that way. On my 10.3 beta installation, the "SystemTuning" file is present but it's just a stub ("exit 0"). The shmem sysctl calls have been moved into /etc/rc. I presume this is deliberate, so we shoul

[BUGS] Duplicate primary key record

2003-11-15 Thread Joel Jacobson
Your name : Joel Jacobson Your email address : [EMAIL PROTECTED] System Configuration - Architecture (example: Intel Pentium) : Intel(R) Pentium(R) III Operating System (example: Linux 2.0.26 ELF) : Linux 2.4.21 PostgreSQL versio

Re: [BUGS] RC2 will not make check on OSX 10.3

2003-11-15 Thread Theodore Petrosky
Neil, I posted to the apple site asking if anyone could recommend the 'correct' place to edit these settings. I don't think a change like this would survive a system update. But it was the only way I got the settings to 'take'. It deserves to be mentioned in the docs that this is necessary a

Re: [BUGS] RC2 will not make check on OSX 10.3

2003-11-15 Thread Neil Conway
Theodore Petrosky <[EMAIL PROTECTED]> writes: > After about two hours of hunting pecking and anything > else I found where you control this in OSX 10.3 > > you must edit the /etc/rc file. > > /System/Library/StartupItems/SystemTuning/SystemTuning > does nothing Should we update the document

Re: [BUGS] RC2 will not make check on OSX 10.3

2003-11-15 Thread Theodore Petrosky
After about two hours of hunting pecking and anything else I found where you control this in OSX 10.3 you must edit the /etc/rc file. /System/Library/StartupItems/SystemTuning/SystemTuning does nothing now.. 7.4 RC2 make check only fails on the geometry test type_sanity

Re: [BUGS] lower('Å') or upper('å') gives imp

2003-11-15 Thread Tom Lane
Peter Eisentraut <[EMAIL PROTECTED]> writes: > Neha Kasat writes: >> PostGRESql doesn't convert the special characters like Å, Ò, etc into >> their lower case when using function lower and vice-versa when using >> upper. > It does if you select the right locale. ... and character set. We don't h

Re: [BUGS] lower('Å') or upper('å') gives imp

2003-11-15 Thread Peter Eisentraut
Neha Kasat writes: > PostGRESql doesn't convert the special characters like Å, Ò, etc into > their lower case when using function lower and vice-versa when using > upper. It does if you select the right locale. -- Peter Eisentraut [EMAIL PROTECTED] ---(end of broadca

[BUGS] lower('Å') or upper('å') gives improper results.

2003-11-15 Thread Neha Kasat
Hi, Please find the output of the simple query : sfa_db=> select upper('å'); upper --- å (1 row) PostGRESql doesn't convert the special characters like Å, Ò, etc into their lower case when using function lower and vice-versa when using upper. Neha ---(end of bro

Re: [BUGS] Failure in "make check" with 7.4RC2

2003-11-15 Thread Wolfgang Drotschmann
Hallo Tom! Sorry for being late on this... Short version: Problem solved, reason remains a mystery. Hmm. get_progname() should be getting linked into the createdb executable by way of libpgport.a from the src/port/ directory. Can you look at the build process in src/port/ and src/bin/scripts/ a

Re: [BUGS] Failure in "make check" with 7.4RC2

2003-11-15 Thread Tom Lane
Wolfgang Drotschmann <[EMAIL PROTECTED]> writes: > In an effort to answer your question above, I started again from scratch on > the same machine... And you guess it - the checks went through. > I don't know what happend that day. > I'm sorry if I raised some dust! Well, there's something odd go