Re: [BUGS] unicode strings are not sorted alphabetically

2004-08-05 Thread Stephan Szabo
On Sat, 31 Jul 2004, Volodymyr Kostyrko wrote: >This applies to non-english strings (in my case - russian). I've > stumbled upon it on version 7.3.4. ( PostgreSQL 7.4.3 on > i386-portbld-freebsd5.2.1, compiled by GCC cc (GCC) 3.3.3 [FreeBSD] > 20031106) What locale and server encoding was the

[BUGS] could not create shared memory segment - i386

2004-08-05 Thread Bill Hernandez
[EMAIL PROTECTED]:~] # su - postgres [EMAIL PROTECTED]:/home/postgres] $ /usr/local/pgsql/bin/initdb -d -D -n /usr/local/pgsql/data Running in debug mode. initdb: internal variables: PGDATA=/usr/local/pgsql/data datadir=/usr/local/pgsql//share PGPATH=/usr/local/pgsql/bin ENCODING= ENCODI

Re: [BUGS] Problem with sequence et rule

2004-08-05 Thread Marc Boucher
At 21:28 31/07/2004 -0400, Tom Lane wrote: >>> Now my questions are: >>> - Is this an expected behavior ? > It is. Rules are essentially macros and so you have all the usual > potential gotchas with multiple evaluations of their input arguments. I've understood what was done by the evaluation proc

[BUGS] PROBLEMS!!!

2004-08-05 Thread liz gonzalez
Dear Sr. or Madam, I am writting to you because I am having problems with the configuration of PostgreSQL v. 7.4 on LINUX, I want to configurate it in JAVA , I set: $./configure --with-java The response was: [EMAIL PROTECTED] postgresql-7.4]$ ./configure --with-java checking build system type.

Re: [BUGS] INDEX_MAX_KEYS too small, need 36 parameters

2004-08-05 Thread Hans Schou
On Fri, 30 Jul 2004, Peter Eisentraut wrote: > Hans Schou wrote: > > I needed to have 36 function parameters. > > PostgreSQL only allows 32. > > If you index more than three or four columns you're doing something > wrong. Could be. > Please explain in more detail why a practical application wo

[BUGS] problem installing on Solaris 9 SPARC

2004-08-05 Thread Jonathan Wynett
Not sure if I am writing to the correct list but this was the address it gave at the top of the "Supported Platforms" in the docs. when I run: ./configure --without-readline, I get the following error that aborts the config process: "checking types of arguments for accept()... configure: error: c

[BUGS] unicode strings are not sorted alphabetically

2004-08-05 Thread Volodymyr Kostyrko
This applies to non-english strings (in my case - russian). I've stumbled upon it on version 7.3.4. ( PostgreSQL 7.4.3 on i386-portbld-freebsd5.2.1, compiled by GCC cc (GCC) 3.3.3 [FreeBSD] 20031106) The attached files where created with: pg_dump -U lib lib > database_dump psql lib lib -c "

Re: [BUGS] BUG #1206: sig fault 12 and core dumps using conflux

2004-08-05 Thread Tom Lane
"PostgreSQL Bugs List" <[EMAIL PROTECTED]> writes: > Aug 5 11:40:52 furby kernel: pid 75103 (postgres), uid 70: exited on >> signal 12 (core dumped) Hmm. What is signal 12 on your machine? (/usr/include/signal.h or /usr/include/sys/signal.h are likely places to look for the answer.) Can you pro

[BUGS] BUG #1206: sig fault 12 and core dumps using conflux

2004-08-05 Thread PostgreSQL Bugs List
The following bug has been logged online: Bug reference: 1206 Logged by: Ertan Kucukoglu Email address: [EMAIL PROTECTED] PostgreSQL version: 7.4 Operating system: FreeBSD 5.2-CURRENT (port build) Description:sig fault 12 and core dumps using conflux Details: I