[HACKERS] SIGSEGV in postgres 7.0.0 for QNX

2000-09-16 Thread Maurizio



Hi,


I am tring to use the qnx version of postgresql 
7.0.0

I have qnx 4.25 and TCP/IP


Ihave compiled postgres using 
gcc
I have installed it.


then I have started postgres with -D and -i 
options.

The only commad that I can execute is initdb.

When I execute any other commandI have a 
SIGSEGV error.

I don't understand why.

Could someone help me?
Have I to change the configuration of  QNX kernel, TCP/IP or postgresql 
?

Attached is a log file with the error.


Thanks.

Regards

DREAMTECH
Maurizio Cauci









Re: [HACKERS] broken locale in 7.0.2 without multibyte support (FreeBSD 4.1-RELEASE) ?

2000-09-16 Thread Oleg Bartunov

On Sat, 16 Sep 2000, Tom Lane wrote:

 Date: Sat, 16 Sep 2000 11:23:33 -0400
 From: Tom Lane [EMAIL PROTECTED]
 To: Oleg Bartunov [EMAIL PROTECTED]
 Cc: [EMAIL PROTECTED], [EMAIL PROTECTED]
 Subject: Re: [HACKERS] broken locale in 7.0.2 without multibyte support (FreeBSD 
4.1-RELEASE) ? 
 
 Oleg Bartunov [EMAIL PROTECTED] writes:
  It's clear that we must use 'unsigned char' instead of 'char'
  and corrected version runs ok on both systems. That's why I suspect
  that gcc 2.95.2 has different default under FreeBSD which could
  cause problem with LC_CTYPE in 7.0.2 
  I didn't test current CVS under FreeBSD but probably will check it.
 
 I think Peter recently went around and inserted explicit casts to
 fix this problem.  Please do see if it's fixed in CVS.

ok. will check this. I've recompile 7.0.2 on freebsd with -funsigned-char
and the problem has gone away. This prove my suggestion. I also 
checked 6.5 and it has the same probelm on FreeBSD. Also,
this makes clear many complains about broken locale under FreeBSD
I got from people. 
Hmm, current cvs has the same problem :-(

Regards,
Oleg



 
   regards, tom lane
 

_
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University (Russia)
Internet: [EMAIL PROTECTED], http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83





Re: [HACKERS] broken locale in 7.0.2 without multibyte support (FreeBSD 4.1-RELEASE) ?

2000-09-16 Thread Tom Lane

Oleg Bartunov [EMAIL PROTECTED] writes:
 It's clear that we must use 'unsigned char' instead of 'char'
 and corrected version runs ok on both systems. That's why I suspect
 that gcc 2.95.2 has different default under FreeBSD which could
 cause problem with LC_CTYPE in 7.0.2 
 
 I think Peter recently went around and inserted explicit casts to
 fix this problem.  Please do see if it's fixed in CVS.

 Hmm, current cvs has the same problem :-(

Now that I look at it, what Peter was doing was just trying to eliminate
compiler warnings on some platform or other, and he made changes like
these (this example is interfaces/ecpg/preproc/pgc.l):

@@ -491,7 +491,7 @@
/* this should leave the last byte set to '\0' */
strncpy(lower_text, yytext, NAMEDATALEN-1);
for(i = 0; lower_text[i]; i++)
-   if (isascii((unsigned char)lower_text[i])  isupper(lower_text[i]))
+   if (isascii((int)lower_text[i])  isupper((int) lower_text[i]))
lower_text[i] = tolower(lower_text[i]);
 
if (i = NAMEDATALEN)
@@ -682,7 +682,7 @@
 
/* skip the ";" and trailing whitespace. Note that yytext contains
   at least one non-space character plus the ";" */
-   for ( i = strlen(yytext)-2; i  0  isspace(yytext[i]); i-- ) {}
+   for ( i = strlen(yytext)-2; i  0  isspace((int) yytext[i]); i-- ) {}
yytext[i+1] = '\0';
 
for ( defptr = defines; defptr != NULL 
@@ -754,7 +754,7 @@
 
  /* skip the ";" and trailing whitespace. Note that yytext contains
 at least one non-space character plus the ";" */
- for ( i = strlen(yytext)-2; i  0  isspace(yytext[i]); i-- ) {}
+ for ( i = strlen(yytext)-2; i  0  isspace((int) yytext[i]); i-- ) {}
  yytext[i+1] = '\0';
 
  yyin = NULL;

Peter, I suppose what you were trying to clean up is a "char used as
array subscript" kind of warning?  These changes wouldn't help Oleg's
problem, in fact the first change in this file would have broken code
that was previously not broken for him.

I think that the correct coding convention is to be careful to call the
ctype.h macros only with values that are either declared as or casted
to "unsigned char".  I would like to think that your compiler will not
complain about
  if (isascii((unsigned char)lower_text[i]) ...
If it does we'd have to write something as ugly as
  if (isascii((int)(unsigned char)lower_text[i]) ...
which I can see no value in from a portability standpoint.

regards, tom lane



Re: [HACKERS] Patch for TNS services

2000-09-16 Thread Peter Eisentraut

Bruce Momjian writes:

 Sounds like people want it.  Can you polish it off, add SGML docs and
 send it over?

  There's a config file /etc/pg_service.conf, having an entry like:

Please check that the final patch uses a file in ${sysconfdir} that was
specified at configure time, and not "/etc". Something like
src/backend/libpq does for the Kerberos files.


-- 
Peter Eisentraut  [EMAIL PROTECTED]   http://yi.org/peter-e/