Re: [HACKERS] Re: Call for platforms

2001-04-22 Thread Patrick Welche

On Mon, Apr 09, 2001 at 11:41:55AM -0700, Henry B. Hotz wrote:
 At 1:50 AM -0400 4/6/01, Tom Lane wrote:
...
 What version of libreadline do you have installed, and how does it
 declare completion_matches()?
 
 I have whatever is standard on NetBSD 1.5.  I noticed that configure 
 found a readline.h include file, but NetBSD doesn't integrate the 
 current GNU implementation.  I did not do a test of psql to see if 
 the feature worked.
 
 I'm sure you could "fix" this problem if you installed GNU readline 
 and referenced it in the build.  Since Solaris had even worse issues 
 with needing GNU support utilities installed this didn't seem like a 
 big deal to me.  OTOH it could confuse a new user.

Odd: I am using the standard NetBSD readline found in -ledit and it is
fine.. Can it be a -1.5 vs -current difference?


I have just stumbled across something which is broken though:

NetBSD-1.5S/arm32:
% ldd `which psql`
/usr/local/pgsql/bin/psql:
-lpq.2 = /usr/local/pgsql/lib/libpq.so.2.1 (0x2003b000)
-lz.0 = /usr/lib/libz.so.0.2 (0x20048000)
-lcrypt.0 = /usr/lib/libcrypt.so.0.0 (0x20056000)
-lresolv.1 = /usr/lib/libresolv.so.1.0 (0x2005c000)
-lm.0 = /usr/lib/libm.so.0.1 (0x20065000)
-lutil.5 = /usr/lib/libutil.so.5.5 (0x2008b000)
-ledit.2 = /usr/lib/libedit.so.2.5 (0x20096000)
-lc.12 = /usr/lib/libc.so.12.74 (0x200ae000)

NetBSD-1.5U/i386:
% ldd `which psql`
/usr/local/pgsql/bin/psql:
 -lcrypt.0 = /usr/lib/libcrypt.so.0
 -lresolv.1 = /usr/lib/libresolv.so.1
 -lpq.2 = /usr/local/pgsql/lib/libpq.so.2
 -lz.0 = /usr/lib/libz.so.0
 -lm.0 = /usr/lib/libm387.so.0
 -lm.0 = /usr/lib/libm.so.0
 -lutil.5 = /usr/lib/libutil.so.5
 -ledit.2 = /usr/lib/libedit.so.2
 -ltermcap.0 = /usr/lib/libtermcap.so.0
 -lc.12 = /usr/lib/libc.so.12

-ltermcap is missing from arm32 - it's necessary if libedit is going to
find _tgetent..

Investigating now..

Cheers,

Patrick

---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]



[HACKERS] Re: Call for platforms

2001-04-13 Thread Thomas Lockhart

 Did we decide that "most NetBSD/i386 users have fpus" in which case Marko's
 patch should be applied?

I'm unclear on what y'all mean by "i386 + fpu", especially since NetBSD
seems to insist on calling every Intel processor a "i386". In this case,
are you suggesting that this patch covers all NetBSD installations on
every Intel processor from i386 + fpu forward to i486, i586, etc etc? Or
is this specifically for the i386 with the 80387 coprocessor which is
how any reasonable person would interpret "i386+fpu"? ;)

   - Thomas

  Index: src/test/regress/resultmap
  ===
  RCS file: /home/projects/pgsql/cvsroot/pgsql/src/test/regress/resultmap,v
  retrieving revision 1.45
  diff -u -r1.45 resultmap
  --- src/test/regress/resultmap2001/03/22 15:13:18 1.45
  +++ src/test/regress/resultmap2001/03/22 17:29:49
  @@ -17,6 +17,7 @@
   geometry/.*-openbsd=geometry-positive-zeros-bsd
   geometry/.*-irix6=geometry-irix
   geometry/.*-netbsd=geometry-positive-zeros
  +geometry/i.86-.*-netbsdelf1.5=geometry-positive-zeros-bsd
   geometry/.*-sysv5uw7.*:cc=geometry-uw7-cc
   geometry/.*-sysv5uw7.*:gcc=geometry-uw7-gcc
   geometry/alpha.*-dec-osf=geometry-alpha-precision

---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly



[HACKERS] Re: Call for platforms

2001-04-13 Thread Patrick Welche

On Fri, Apr 13, 2001 at 01:25:45PM +, Thomas Lockhart wrote:
  Did we decide that "most NetBSD/i386 users have fpus" in which case Marko's
  patch should be applied?
 
 I'm unclear on what y'all mean by "i386 + fpu", especially since NetBSD
 seems to insist on calling every Intel processor a "i386".

History ;-)

 In this case,
 are you suggesting that this patch covers all NetBSD installations on
 every Intel processor from i386 + fpu forward to i486, i586, etc etc?

Yes! It's simply, if the peecee type thing has a fpu (as in the sysctl
machdep.fpu_present returns 1), then libm387.so is used, and you get
differences in the (from memory 44th insignificant figure?) otherwise it
just uses libm.so and you get what is currently correct in resultmap.

Cheers,

Patrick

---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]



Re: [HACKERS] Re: Call for platforms

2001-04-10 Thread Giles Lean


 At 1:50 AM -0400 4/6/01, Tom Lane wrote:
 "Henry B. Hotz" [EMAIL PROTECTED] writes:
   Bottom line:  7.1RC1 passes most of the regression tests on
   NetBSD/macppc.
 
 The only thing that surprised me here was all of the warnings from
 libreadline calls:
 
   tab-complete.c: In function `initialize_readline':
   tab-complete.c:103: warning: assignment from incompatible pointer type
   tab-complete.c: In function `psql_completion':
   tab-complete.c:292: warning: passing arg 2 of `completion_matches'
   from incompatible pointer type
   tab-complete.c:296: warning: passing arg 2 of `completion_matches'
   from incompatible pointer type
 
 What version of libreadline do you have installed, and how does it
 declare completion_matches()?

$ uname -srm
NetBSD 1.5 i386
$ grep CPFunction /usr/include/readline.h
typedef char   *CPFunction __P((const char *, int));
extern CPFunction  *rl_completion_entry_function;
char **completion_matches __P((const char *, CPFunction *));

Putting the 'const' in the relevant PostgreSQL functions (diff against
7.1RC3 below) removes these warnings.  I don't know what that does on
a machine using GNU readline ... I can check that in a day or two if
anyone's interested.

The NetBSD libedit-emulating-readline works just fine with psql even
without the warnings fixed -- they're harmless in this case.

Regards,

Giles

*** src/bin/psql/tab-complete.c-origMon Apr  2 05:17:32 2001
--- src/bin/psql/tab-complete.c Tue Apr 10 19:51:21 2001
***
*** 70,80 
  
  
  /* Forward declaration of functions */
! static char **psql_completion(char *text, int start, int end);
! static char *create_command_generator(char *text, int state);
! static char *complete_from_query(char *text, int state);
! static char *complete_from_const(char *text, int state);
! static char *complete_from_list(char *text, int state);
  
  static PGresult *exec_query(char *query);
  char *quote_file_name(char *text, int match_type, char *quote_pointer);
--- 70,80 
  
  
  /* Forward declaration of functions */
! static char **psql_completion(const char *text, int start, int end);
! static char *create_command_generator(const char *text, int state);
! static char *complete_from_query(const char *text, int state);
! static char *complete_from_const(const char *text, int state);
! static char *complete_from_list(char const *text, int state);
  
  static PGresult *exec_query(char *query);
  char *quote_file_name(char *text, int match_type, char *quote_pointer);
***
*** 177,183 
 libraries completion_matches() function, so we don't have to worry about it.
  */
  static char **
! psql_completion(char *text, int start, int end)
  {
/* This is the variable we'll return. */
char  **matches = NULL;
--- 177,183 
 libraries completion_matches() function, so we don't have to worry about it.
  */
  static char **
! psql_completion(const char *text, int start, int end)
  {
/* This is the variable we'll return. */
char  **matches = NULL;
***
*** 796,802 
 as defined above.
  */
  static char *
! create_command_generator(char *text, int state)
  {
static int  list_index,
string_length;
--- 796,802 
 as defined above.
  */
  static char *
! create_command_generator(const char *text, int state)
  {
static int  list_index,
string_length;
***
*** 829,835 
 etc.
  */
  static char *
! complete_from_query(char *text, int state)
  {
static int  list_index,
string_length;
--- 829,835 
 etc.
  */
  static char *
! complete_from_query(const char *text, int state)
  {
static int  list_index,
string_length;
***
*** 877,883 
 SQL words that can appear at certain spot.
  */
  static char *
! complete_from_list(char *text, int state)
  {
static int  string_length,
list_index;
--- 877,883 
 SQL words that can appear at certain spot.
  */
  static char *
! complete_from_list(const char *text, int state)
  {
static int  string_length,
list_index;
***
*** 911,917 
 The string to be passed must be in completion_charp.
  */
  static char *
! complete_from_const(char *text, int state)
  {
(void) text;/* We don't care about what was entered
 * already. */
--- 911,917 
 The string to be passed must be in completion_charp.
  */
  static char *
! complete_from_const(const char *text, int state)
  {
(void) text;/* We don't care about what was entered
 * already. */



---(end of 

Re: [HACKERS] Re: Call for platforms

2001-04-09 Thread Henry B. Hotz

At 1:50 AM -0400 4/6/01, Tom Lane wrote:
"Henry B. Hotz" [EMAIL PROTECTED] writes:
  Bottom line:  7.1RC1 passes most of the regression tests on
  NetBSD/macppc.

The only thing that surprised me here was all of the warnings from
libreadline calls:

  tab-complete.c: In function `initialize_readline':
  tab-complete.c:103: warning: assignment from incompatible pointer type
  tab-complete.c: In function `psql_completion':
  tab-complete.c:292: warning: passing arg 2 of `completion_matches'
  from incompatible pointer type
  tab-complete.c:296: warning: passing arg 2 of `completion_matches'
  from incompatible pointer type

What version of libreadline do you have installed, and how does it
declare completion_matches()?

I have whatever is standard on NetBSD 1.5.  I noticed that configure 
found a readline.h include file, but NetBSD doesn't integrate the 
current GNU implementation.  I did not do a test of psql to see if 
the feature worked.

I'm sure you could "fix" this problem if you installed GNU readline 
and referenced it in the build.  Since Solaris had even worse issues 
with needing GNU support utilities installed this didn't seem like a 
big deal to me.  OTOH it could confuse a new user.


Signature held pending an ISO 9000 compliant
signature design and approval process.
[EMAIL PROTECTED], or [EMAIL PROTECTED]

---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster



Re: [HACKERS] Re: Call for platforms

2001-04-07 Thread Tom Ivar Helbekkmo

Giles Lean [EMAIL PROTECTED] writes:

 It is still necessary to add -ltermcap after -ledit in
 src/Makefile.global to have functional history editing in psql.

This is a weakness in the configure script: it goes through a loop
where it tries to link a program that calls readline() with, in order,
"-lreadline", "-lreadline -ltermcap", "-lreadline -lncurses",
"-lreadline -lcurses", "-ledit", "-ledit -ltermcap", "-ledit
-lncurses" and "-ledit -lcurses".  The first link that succeeds wil
determine which libraries are used.  However, on some platforms with
dynamic libraries, the link will succeed as soon as readline() is
present -- but the shared library that contains it doesn't contain a
complete specification of all other libraries it needs at run-time
(the executable is expected to hold this information), and the program
fails at run-time even though it linked without any error message.

I don't know how the situation could best be improved, though...

-tih
-- 
The basic difference is this: hackers build things, crackers break them.

---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])



Re: [HACKERS] Re: Call for platforms

2001-04-07 Thread Peter Eisentraut

Tom Ivar Helbekkmo writes:

 Giles Lean [EMAIL PROTECTED] writes:

  It is still necessary to add -ltermcap after -ledit in
  src/Makefile.global to have functional history editing in psql.

 This is a weakness in the configure script: it goes through a loop
 where it tries to link a program that calls readline() with, in order,
 "-lreadline", "-lreadline -ltermcap", "-lreadline -lncurses",
 "-lreadline -lcurses", "-ledit", "-ledit -ltermcap", "-ledit
 -lncurses" and "-ledit -lcurses".  The first link that succeeds wil
 determine which libraries are used.  However, on some platforms with
 dynamic libraries, the link will succeed as soon as readline() is
 present -- but the shared library that contains it doesn't contain a
 complete specification of all other libraries it needs at run-time
 (the executable is expected to hold this information), and the program
 fails at run-time even though it linked without any error message.

On such a platform it would hardly be possible to detect anything with any
reliably.  A linker that links a program "succesfully" while the program
really needs more libraries to be runnable isn't very useful.

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


---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]



Re: [HACKERS] Re: Call for platforms

2001-04-07 Thread Tom Ivar Helbekkmo

Peter Eisentraut [EMAIL PROTECTED] writes:

 On such a platform it would hardly be possible to detect anything with any
 reliably.  A linker that links a program "succesfully" while the program
 really needs more libraries to be runnable isn't very useful.

You're right, of course -- it's a bug in the linkage loader on the
platform in question.  NetBSD/vax has it:

$ uname -a
NetBSD varg.i.eunet.no 1.5T NetBSD 1.5T (VARG) #4: Thu Apr 5 23:38:04 CEST 2001
 [EMAIL PROTECTED]:/usr/src/sys/arch/vax/compile/VARG vax
$ cat  foo.c
int main (int argc, char **argv) { readline(); }
$ cc -o foo foo.c
/tmp/ccFTO4Mu.o: Undefined symbol `_readline'referenced from text segment
collect2: ld returned 1 exit status
$ cc -o foo foo.c -ledit
$ echo $?
0
$ ./foo
/usr/libexec/ld.so: Undefined symbol "_tputs"in foo:/usr/lib/libedit.so.2.5
$ echo $?
1
$ ldd foo
foo:
-ledit.2 = /usr/lib/libedit.so.2.5 (0x181b000)
-lc.12 = /usr/lib/libc.so.12.74 (0x182d000)
$

-tih
-- 
The basic difference is this: hackers build things, crackers break them.

---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])



[HACKERS] Re: Call for platforms

2001-04-06 Thread Giles Lean


 Thanks! I'm not too worried about 1.4.2, but be sure to let us know what
 the problem was; it may help out someone else...

NetBSD-1.4.2/i386 passes all tests with 7.1RC3.

My previous test failure on this platform was due to the timezone
information on the test system not being standard; once that was
corrected all tests pass.

It is still necessary to add -ltermcap after -ledit in
src/Makefile.global to have functional history editing in psql.

Regards,

Giles



---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly



[HACKERS] Re: Call for platforms

2001-04-01 Thread Tom Ivar Helbekkmo

Tom Ivar Helbekkmo [EMAIL PROTECTED] writes:

  We need some NetBSD folks to speak up!
 
 I've once again got a VAX that should be able to run PostgreSQL on
 NetBSD/vax, so I hope to be able to help revitalize that port soon...

It still works.  RC1 configures, compiles and runs on my VAX 4000/500
with NetBSD-current -- but the regression tests give a lot of failures
because the VAX doesn't have IEEE math, leading to different rounding
and erroneous assumptions about the limits of floating point values.
I'll be looking at this more closely.

Also, dynamic loading now works on NetBSD/vax, so my old #ifdef for
that in the backend/port/bsd.c file, which has since propagated into
the new *bsd.c files, can go away (actually, I'm suspicious of the
MIPS part of those, too, but I didn't put that in, and I don't have 
any MIPS-based machines):

Index: src/backend/port/dynloader/freebsd.c
===
RCS file: /home/projects/pgsql/cvsroot/pgsql/src/backend/port/dynloader/freebsd.c,v
retrieving revision 1.9
diff -c -r1.9 freebsd.c
*** src/backend/port/dynloader/freebsd.c2001/02/10 02:31:26 1.9
--- src/backend/port/dynloader/freebsd.c2001/04/01 08:01:20
***
*** 63,69 
  void *
  BSD44_derived_dlopen(const char *file, int num)
  {
! #if defined(__mips__) || (defined(__NetBSD__)  defined(__vax__))
sprintf(error_message, "dlopen (%s) not supported", file);
return NULL;
  #else
--- 63,69 
  void *
  BSD44_derived_dlopen(const char *file, int num)
  {
! #if defined(__mips__)
sprintf(error_message, "dlopen (%s) not supported", file);
return NULL;
  #else
***
*** 78,84 
  void *
  BSD44_derived_dlsym(void *handle, const char *name)
  {
! #if defined(__mips__) || (defined(__NetBSD__)  defined(__vax__))
sprintf(error_message, "dlsym (%s) failed", name);
return NULL;
  #else
--- 78,84 
  void *
  BSD44_derived_dlsym(void *handle, const char *name)
  {
! #if defined(__mips__)
sprintf(error_message, "dlsym (%s) failed", name);
return NULL;
  #else
***
*** 101,107 
  void
  BSD44_derived_dlclose(void *handle)
  {
! #if defined(__mips__) || (defined(__NetBSD__)  defined(__vax__))
  #else
dlclose(handle);
  #endif
--- 101,107 
  void
  BSD44_derived_dlclose(void *handle)
  {
! #if defined(__mips__)
  #else
dlclose(handle);
  #endif
Index: src/backend/port/dynloader/netbsd.c
===
RCS file: /home/projects/pgsql/cvsroot/pgsql/src/backend/port/dynloader/netbsd.c,v
retrieving revision 1.3
diff -c -r1.3 netbsd.c
*** src/backend/port/dynloader/netbsd.c 2001/02/10 02:31:26 1.3
--- src/backend/port/dynloader/netbsd.c 2001/04/01 08:01:20
***
*** 63,69 
  void *
  BSD44_derived_dlopen(const char *file, int num)
  {
! #if defined(__mips__) || (defined(__NetBSD__)  defined(__vax__))
sprintf(error_message, "dlopen (%s) not supported", file);
return NULL;
  #else
--- 63,69 
  void *
  BSD44_derived_dlopen(const char *file, int num)
  {
! #if defined(__mips__)
sprintf(error_message, "dlopen (%s) not supported", file);
return NULL;
  #else
***
*** 78,84 
  void *
  BSD44_derived_dlsym(void *handle, const char *name)
  {
! #if defined(__mips__) || (defined(__NetBSD__)  defined(__vax__))
sprintf(error_message, "dlsym (%s) failed", name);
return NULL;
  #elif defined(__ELF__)
--- 78,84 
  void *
  BSD44_derived_dlsym(void *handle, const char *name)
  {
! #if defined(__mips__)
sprintf(error_message, "dlsym (%s) failed", name);
return NULL;
  #elif defined(__ELF__)
***
*** 101,107 
  void
  BSD44_derived_dlclose(void *handle)
  {
! #if defined(__mips__) || (defined(__NetBSD__)  defined(__vax__))
  #else
dlclose(handle);
  #endif
--- 101,107 
  void
  BSD44_derived_dlclose(void *handle)
  {
! #if defined(__mips__)
  #else
dlclose(handle);
  #endif
Index: src/backend/port/dynloader/openbsd.c
===
RCS file: /home/projects/pgsql/cvsroot/pgsql/src/backend/port/dynloader/openbsd.c,v
retrieving revision 1.3
diff -c -r1.3 openbsd.c
*** src/backend/port/dynloader/openbsd.c2001/02/10 02:31:26 1.3
--- src/backend/port/dynloader/openbsd.c2001/04/01 08:01:20
***
*** 63,69 
  void *
  BSD44_derived_dlopen(const char *file, int num)
  {
! #if defined(__mips__) || (defined(__NetBSD__)  defined(__vax__))
sprintf(error_message, "dlopen (%s) not supported", file);
return NULL;
  #else
--- 63,69 
  void *
  BSD44_derived_dlopen(const char *file, int num)
  {
! #if defined(__mips__)
sprintf(error_message, "dlopen (%s) not supported", file);
return NULL;
  #else
***
*** 78,84 
  void *
  

Re: [HACKERS] Re: Call for platforms

2001-03-28 Thread Mark Knox

At 12:27 AM 3/28/01 -0500, Tom Lane wrote:

That would fix it for ARM but not for anyplace else with similar
alignment behavior.  Would you try this patch instead to see what
happens?

I don't think this solution would be valid on many other platforms. It forces the 
structure to not be padded, and assumes that the cpu will be able to fetch from 
unaligned boundaries. The only reason this works is that the arm linux kernel contains 
an alignment trap handler that catches the fault and does a fixup on the access. 
Otherwise it would crash with SIGBUS.

  static FormData_pg_attribute a1 = {
!   0x, {"ctid"}, TIDOID, 0, SizeOfIptrData,
SelfItemPointerAttributeNumber, 0, -1, -1, '\0', 'p', '\0', 'i', '\0', '\0'
  }; 

Well, this patch seems to produce attlens of 6 as desired, but it causes many (13) of 
the regression tests to fail. Do you want to see the regression.diffs? 


---(end of broadcast)---
TIP 6: Have you searched our list archives?

http://www.postgresql.org/search.mpl



[HACKERS] Re: Call for platforms

2001-03-27 Thread Tatsuo Ishii

 mklinux PPC750 7.0 2000-04-13, Tatsuo Ishii
 
 Any luck with RC1?

I will try today or tomorrow...
--
Tatsuo Ishii

---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly



Re: [HACKERS] Re: Call for platforms

2001-03-27 Thread D'Arcy J.M. Cain

Thus spake Tom Ivar Helbekkmo
  We need some NetBSD folks to speak up!

I have successfully compiled it from CVS sources on my NetBSD -current but
I can't find the tar file for RC1 to try it with the package system.  Can
someone point me to it please.

-- 
D'Arcy J.M. Cain darcy@{druid|vex}.net   |  Democracy is three wolves
http://www.druid.net/darcy/|  and a sheep voting on
+1 416 425 1212 (DoD#0082)(eNTP)   |  what's for dinner.

---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly



Re: [HACKERS] Re: Call for platforms

2001-03-27 Thread Mathijs Brands

On Tue, Mar 27, 2001 at 06:36:37AM -0500, D'Arcy J.M. Cain allegedly wrote:
 Thus spake Tom Ivar Helbekkmo
   We need some NetBSD folks to speak up!
 
 I have successfully compiled it from CVS sources on my NetBSD -current but
 I can't find the tar file for RC1 to try it with the package system.  Can
 someone point me to it please.

It's probably in /pub/dev (or something similar) on the ftp
server...

Mathijs
-- 
It's not that perl programmers are idiots, it's that the language
rewards idiotic behavior in a way that no other language or tool has
ever done.
Erik Naggum

---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster



Re: [HACKERS] Re: Call for platforms

2001-03-27 Thread Bruce Momjian


We just fixed that yesterday.  Can you grab the most recent CVS and give
it a try?

 One that didn't compilei RC1:
 
  BIGBOY 71# uname -a
 IRIX BIGBOY 6.5 05190003 IP22
 
 On an Indigo2 (R4000), gcc 2.95.2 , with the following error:
 
 gcc  -Wall -Wmissing-prototypes -Wmissing-declarations
 -I../../../../src/include  -U_NO_XOPEN4  -c s_lock.c -o s_lock.o
 s_lock.c: In function `s_lock':
 s_lock.c:134: warning: passing arg 1 of pointer to function discards
 qualifiers from pointer target type
 s_lock.c: In function `tas_dummy':
 s_lock.c:235: parse error before `_volatile__'
 s_lock.c: At top level:
 s_lock.c:234: warning: `tas_dummy' defined but not used
 gmake[4]: *** [s_lock.o] Error 1
 gmake[4]: Leaving directory
 `/usr/people/telmnstr/pg/postgresql-7.1RC1/src/backend/storage/buffer'
 gmake[3]: *** [buffer-recursive] Error 2
 gmake[3]: Leaving directory
 `/usr/people/telmnstr/pg/postgresql-7.1RC1/src/backend/storage'
 gmake[2]: *** [storage-recursive] Error 2
 gmake[2]: Leaving directory
 `/usr/people/telmnstr/pg/postgresql-7.1RC1/src/backend'
 gmake[1]: *** [all] Error 2
 gmake[1]: Leaving directory
 `/usr/people/telmnstr/pg/postgresql-7.1RC1/src'
 gmake: *** [all] Error 2
 *** Error code 2 (bu21)
 
 Jeff
 
 
 
 ---(end of broadcast)---
 TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
 


-- 
  Bruce Momjian|  http://candle.pha.pa.us
  [EMAIL PROTECTED]   |  (610) 853-3000
  +  If your life is a hard drive, |  830 Blythe Avenue
  +  Christ can be your backup.|  Drexel Hill, Pennsylvania 19026

---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly



Re: [HACKERS] Re: Call for platforms

2001-03-27 Thread Tom Lane

Jeff Duffy [EMAIL PROTECTED] writes:
 s_lock.c:235: parse error before `_volatile__'

That typo is fixed in current sources (should be OK in last night's
snapshot) but there's still some doubt as to how well the MIPS assembly
code works ...

regards, tom lane

---(end of broadcast)---
TIP 6: Have you searched our list archives?

http://www.postgresql.org/search.mpl



Re: Regression test on FBSD 3.3 4.2, IRIX 6.5 (was Re: [HACKERS]Re: Call for platforms)

2001-03-27 Thread Peter Eisentraut

Mathijs Brands writes:

 I just tried to compile 7.1RC1 on my IRIX 6.5 box using gcc 2.95.2.

According to the information at
http://freeware.sgi.com/shared/howto.html#b1 it probably won't work to
compile PostgreSQL with GCC on Irix.  Or it might work and crash when run.
Be warned.  (I think it is not accidental that no one ever successfully
used a PostgreSQL/GCC/Irix combo.)

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


---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster



RE: [HACKERS] Re: Call for platforms

2001-03-27 Thread Mayers, Philip J

I've already reported this to the webpage, but I got a fail on the random
test:

 random   ... failed (ignored)

This is on a stock RedHat 7.0 kernel box with the SMP kernel (but running a
single processor):

[pjm3@localhost regress]$ less regression.diffs
*** ./expected/random.out   Thu Jan  6 06:40:54 2000
--- ./results/random.outTue Mar 27 15:07:16 2001
***
*** 25,31 
GROUP BY random HAVING count(random)  1;
   random | count
  +---
! (0 rows)

  SELECT random FROM RANDOM_TBL
WHERE random NOT BETWEEN 80 AND 120;
--- 25,32 
GROUP BY random HAVING count(random)  1;
   random | count
  +---
!  99 | 2
! (1 row)

  SELECT random FROM RANDOM_TBL
WHERE random NOT BETWEEN 80 AND 120;

==

Regards,
Phil

+--+
| Phil Mayers, Network Support |
| Centre for Computing Services|
| Imperial College |
+--+  

---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html



Re: [HACKERS] Re: Call for platforms

2001-03-27 Thread Tom Lane

"Mayers, Philip J" [EMAIL PROTECTED] writes:
 I've already reported this to the webpage, but I got a fail on the random
 test:
  random   ... failed (ignored)

See
http://www.postgresql.org/devel-corner/docs/postgres/regress.html
especially the last item ...

regards, tom lane

---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]



Re: [HACKERS] Re: Call for platforms

2001-03-27 Thread Tom Lane

Mathijs Brands [EMAIL PROTECTED] writes:
 Even if you fix this it won't work (I tried it). Robert mailed
 why. Check the URL below for more information. It crashes on semctl :(

 http://freeware.sgi.com/shared/howto.html#b1

Ugh.  Given the semctl compatibility problem, I suspect we'd better note
in the platform list that IRIX is only supported for cc, not gcc.

The other uncomfy-looking thing on that page is the very first item,
about configure scripts picking up libraries that they'd best not.
(I have seen similar issues on HPUX, although they were relatively
easy to get around.)  We might need to do some more hacking on our
configure script to make it play nice on IRIX.

regards, tom lane

---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]



Re: [HACKERS] Re: Call for platforms

2001-03-27 Thread thomas graichen

Tom Ivar Helbekkmo [EMAIL PROTECTED] wrote:
 Thomas Lockhart [EMAIL PROTECTED] writes:

 NetBSD Sparc   7.0 2000-04-13, Tom I. Helbekkmo

 Fetching the latest source kit now -- hope to have regression tests
 run and a report back to you within a day or two.

 We need some NetBSD folks to speak up!

 I've once again got a VAX that should be able to run PostgreSQL on
 NetBSD/vax, so I hope to be able to help revitalize that port soon...

it might also be a good idea to ask on the NetBSD ports lists - i
think there will most probably some people trying things out - the
name of the list is

  [EMAIL PROTECTED]

where arch is the corresponding NetBSD port name (pmax, macppc, sparc,
i386, arm32, ...)

this might also be a good idea for the mips test-and-set thing (on
the port-pmax list - there are a lot of people knowing all that
stuff very well)

also it might be worth to eventually ask on the [EMAIL PROTECTED]
list for someone willing to play with PostgreSQL on FreeBSD/alpha

just some ideas ...

t

-- 
thomas graichen [EMAIL PROTECTED] ... perfection is reached, not
when there is no longer anything to add, but when there is no
longer anything to take away. --- antoine de saint-exupery

---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster



Re: [HACKERS] Re: Call for platforms

2001-03-27 Thread Tatsuo Ishii

  mklinux PPC750 7.0 2000-04-13, Tatsuo Ishii
  
  Any luck with RC1?
 
 I will try today or tomorrow...

In summary no, improvemnets seen.

If compiled with -O2 or -O2 -g, I got 10 tests FAILED. misc test
failed due to a backend crash. The SQL caused the crash was:

select i, length(t), octet_length(t), oldstyle_length(i,t) from
oldstyle_test;

#0  ExecReplace (slot=0x1a4a7d0, tupleid=0x0, estate=0x1a4a708)
at execMain.c:1408
1408resultRelationDesc = resultRelInfo-ri_RelationDesc;
(gdb) where
#0  ExecReplace (slot=0x1a4a7d0, tupleid=0x0, estate=0x1a4a708)
at execMain.c:1408
#1  0x188471c in ExecutePlan (estate=0x0, plan=0x1a4a410, 
operation=CMD_SELECT, numberTuples=0, direction=27567836, 
destfunc=0x1a4adf8) at execMain.c:1127
#2  0x188471c in ExecutePlan (estate=0x0, plan=0x1a4a410, 
operation=CMD_SELECT, numberTuples=0, direction=27567836, 
destfunc=0x1a4adf8) at execMain.c:1127
#3  0x18838b8 in ExecutorRun (queryDesc=0x1a4a7d0, estate=0x1a4a708, 
feature=27567784, count=0) at execMain.c:233
#4  0x18e7784 in ProcessQuery (parsetree=0x1a4a708, plan=0x1a4a6a8, dest=None)
at pquery.c:295
#5  0x18e5c38 in pg_exec_query_string (query_string=0x1a4a410 "", dest=None, 
parse_context=0x1) at postgres.c:806
#6  0x18e70b8 in PostgresMain (argc=1, argv=0x0, real_argc=4, real_argv=0x0, 
username=0x0) at postgres.c:1902
#7  0x18c92ec in DoBackend (port=0x1a4a6a8) at postmaster.c:2111
#8  0x18c8e10 in BackendStartup (port=0x1a4a708) at postmaster.c:1894
#9  0x18c7c08 in ServerLoop () at postmaster.c:992
#10 0x18c74f4 in PostmasterMain (argc=0, argv=0x1a4a6a8) at postmaster.c:682
#11 0x1899a5c in main (argc=27567784, argv=0x1a4a708) at main.c:147
#12 0x181c400 in _start ()
(gdb) 

---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster



Re: [HACKERS] Re: Call for platforms

2001-03-27 Thread Mark Knox

-BEGIN PGP SIGNED MESSAGE-

On 26 Mar 2001, at 23:14, Tom Lane wrote:

 "Mark Knox" [EMAIL PROTECTED] writes:
  On 25 Mar 2001, at 16:07, Tom Lane wrote:
  Does that database have any user-created relations in it, or is it
  just a virgin database?
 
  Totally virgin. I created it just for that select you wanted.
 
 Okay.   Would you create a couple of random tables in it and do the
 select again?  I want to see what ctid looks like in a user-created
 table.

Sure. I created two tables called 'test1' and 'test2'. Test1 has a 
single field 'field1' of type int4. Test2 has two fields 'field1' and 
'field2' of types char(200) and int4 respectively. 

Here are the results:

postgres= select 
p1.oid,attrelid,relname,attname,attlen,attalign,attbyval from 
pg_attribute p1, pg_class p2 where atttypid = 27 and p2.oid = 
attrelid order by 1;
  oid|attrelid|relname   |attname|attlen|attalign|attbyval
- -++--+---+--++
16401|1247|pg_type   |ctid   | 6|i   |f   
16415|1262|pg_database   |ctid   | 6|i   |f   
16439|1255|pg_proc   |ctid   | 6|i   |f   
16454|1260|pg_shadow |ctid   | 6|i   |f   
16464|1261|pg_group  |ctid   | 6|i   |f   
16486|1249|pg_attribute  |ctid   | 6|i   |f   
16515|1259|pg_class  |ctid   | 6|i   |f   
16526|1215|pg_attrdef|ctid   | 6|i   |f   
16537|1216|pg_relcheck   |ctid   | 6|i   |f   
16557|1219|pg_trigger|ctid   | 6|i   |f   
16572|   16567|pg_inherits   |ctid   | 8|i   |f   
16593|   16579|pg_index  |ctid   | 8|i   |f   
16610|   16600|pg_statistic  |ctid   | 8|i   |f   
16635|   16617|pg_operator   |ctid   | 8|i   |f   
16646|   16642|pg_opclass|ctid   | 8|i   |f   
16678|   16653|pg_am |ctid   | 8|i   |f   
16691|   16685|pg_amop   |ctid   | 8|i   |f   
16873|   16867|pg_amproc |ctid   | 8|i   |f   
16941|   16934|pg_language   |ctid   | 8|i   |f   
16953|   16948|pg_largeobject|ctid   | 8|i   |f   
16970|   16960|pg_aggregate  |ctid   | 8|i   |f   
17038|   17033|pg_ipl|ctid   | 8|i   |f   
17051|   17045|pg_inheritproc|ctid   | 8|i   |f   
17067|   17058|pg_rewrite|ctid   | 8|i   |f   
17079|   17074|pg_listener   |ctid   | 8|i   |f   
17090|   17086|pg_description|ctid   | 8|i   |f   
17206|   17201|pg_toast_1215 |ctid   | 8|i   |f   
17221|   17216|pg_toast_17086|ctid   | 8|i   |f   
17236|   17231|pg_toast_1255 |ctid   | 8|i   |f   
17251|   17246|pg_toast_1216 |ctid   | 8|i   |f   
17266|   17261|pg_toast_17058|ctid   | 8|i   |f   
17281|   17276|pg_toast_16600|ctid   | 8|i   |f   
17301|   17291|pg_user   |ctid   | 8|i   |f   
17314|   17309|pg_rules  |ctid   | 8|i   |f   
17327|   17322|pg_views  |ctid   | 8|i   |f   
17342|   17335|pg_tables |ctid   | 8|i   |f   
17355|   17350|pg_indexes|ctid   | 8|i   |f   
18724|   18721|test1 |ctid   | 8|i   |f   
18735|   18731|test2 |ctid   | 8|i   |f   
(39 rows)

  I suspect it might be an alignment problem
 
 Sort of.  I am suspicious that sizeof(ItemPointerData) is returning 8
 rather than 6 as one might expect.

Maybe it's padding the structure to a dword boundary? ARM is 
notorious for such things.. I will rebuild it with 
__attribute__((packed)) on the struct and see if the size changes..


-BEGIN PGP SIGNATURE-
Version: N/A

iQCVAwUBOsFDJP+IdJuhyV9xAQEKxQP/YJXTxZppLd7ECk4BSwDZaStP4+bE6acc
StT//i/drdPC53DDWqiXLGA0bS384EXxyjvvaO1bTXzVFU/3+X/pY6YN/G3HMoah
dbCXRli2Y57yansf1WaVmK1lhiAqLy3iGYFp2nZvO1Sl1u+ba89HtV+G+iaKZSTr
U+HWTU3nnOM=
=vkY+
-END PGP SIGNATURE-

---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])



Re: [HACKERS] Re: Call for platforms

2001-03-27 Thread Mark Knox

The following section of this message contains a file attachment
prepared for transmission using the Internet MIME message format.
If you are using Pegasus Mail, or any another MIME-compliant system,
you should be able to save it or view it from within your mailer.
If you cannot, please ask your system administrator for assistance.

    File information ---
 File:  arm-alignment.patch
 Date:  27 Mar 2001, 21:26
 Size:  533 bytes.
 Type:  Unknown

 arm-alignment.patch


---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])



Re: [HACKERS] Re: Call for platforms

2001-03-27 Thread Mark Knox

-BEGIN PGP SIGNED MESSAGE-

On 27 Mar 2001, at 20:49, Mark Knox wrote:

   I suspect it might be an alignment problem
  
  Sort of.  I am suspicious that sizeof(ItemPointerData) is returning
  8 rather than 6 as one might expect.
 
 Maybe it's padding the structure to a dword boundary? ARM is 
 notorious for such things.. I will rebuild it with 
 __attribute__((packed)) on the struct and see if the size changes..

Aha, progress! The packed directive gives attlen of 6 across the 
board! Type_sanity test passes now too, so the only failing 
regression test is geometry and that is easily dismissed. The 
variation is in the last decimal place and probably due to emulated 
floating point (ARM has no FPU).

The patch is attached.. it's tiny but seems to be effective.



-BEGIN PGP SIGNATURE-
Version: N/A

iQCVAwUBOsFeUv+IdJuhyV9xAQE2XAP9FF93ew+6Ml5iZ1jWjcGrs+3zaXIeWef6
SytNtIfyJqmcnyWnMaxBTlChIvBO5A2HVnBkCydM5BjUXdW1eWsEynrd+U79Yc+e
yVDGo30CK3lAkTLH3Fo6jR3YZe/TsIyr80WlDeqJiWvDmHTfqvo50jRiDq2h1OL/
LmI4YIQM0rQ=
=Vwwp
-END PGP SIGNATURE-

---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly



Re: [HACKERS] Re: Call for platforms

2001-03-27 Thread Tom Lane

Tatsuo Ishii [EMAIL PROTECTED] writes:
  mklinux PPC750 7.0 2000-04-13, Tatsuo Ishii

 If compiled with -O2 or -O2 -g, I got 10 tests FAILED. misc test
 failed due to a backend crash. The SQL caused the crash was:

 select i, length(t), octet_length(t), oldstyle_length(i,t) from
 oldstyle_test;

 #0  ExecReplace (slot=0x1a4a7d0, tupleid=0x0, estate=0x1a4a708)
 at execMain.c:1408
 1408resultRelationDesc = resultRelInfo-ri_RelationDesc;
 (gdb) where
 #0  ExecReplace (slot=0x1a4a7d0, tupleid=0x0, estate=0x1a4a708)
 at execMain.c:1408
 #1  0x188471c in ExecutePlan (estate=0x0, plan=0x1a4a410, 
 operation=CMD_SELECT, numberTuples=0, direction=27567836, 
 destfunc=0x1a4adf8) at execMain.c:1127
 #2  0x188471c in ExecutePlan (estate=0x0, plan=0x1a4a410, 
 operation=CMD_SELECT, numberTuples=0, direction=27567836, 
 destfunc=0x1a4adf8) at execMain.c:1127
 #3  0x18838b8 in ExecutorRun (queryDesc=0x1a4a7d0, estate=0x1a4a708, 
 feature=27567784, count=0) at execMain.c:233

I think you've got a badly broken compiler there.  There's no way that
ExecReplace should be entered for a SELECT.  The backtrace is wrong on
its face anyway --- ExecutePlan does not call itself.

What gcc version does that platform have?

regards, tom lane

---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly



Re: [HACKERS] Re: Call for platforms

2001-03-27 Thread Tatsuo Ishii

 I think you've got a badly broken compiler there.  There's no way that
 ExecReplace should be entered for a SELECT.  The backtrace is wrong on
 its face anyway --- ExecutePlan does not call itself.

Yes, I have suspected that.

 What gcc version does that platform have?

gcc version egcs-2.90.25 980302 (egcs-1.0.2 prerelease)
--
Tatsuo Ishii

---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html



Re: [HACKERS] Re: Call for platforms

2001-03-27 Thread Tom Lane

Tatsuo Ishii [EMAIL PROTECTED] writes:
 What gcc version does that platform have?

 gcc version egcs-2.90.25 980302 (egcs-1.0.2 prerelease)

Can you try a known-stable gcc version?  2.95.2 say?

regards, tom lane

---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])



Re: [HACKERS] Re: Call for platforms

2001-03-27 Thread Tatsuo Ishii

 Tatsuo Ishii [EMAIL PROTECTED] writes:
  What gcc version does that platform have?
 
  gcc version egcs-2.90.25 980302 (egcs-1.0.2 prerelease)
 
 Can you try a known-stable gcc version?  2.95.2 say?

I don't have time right know. Will do maybe for 7.1.1 or 7.2..
--
Tatsuo Ishii

---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]



Re: [HACKERS] Re: Call for platforms

2001-03-26 Thread Thomas Lockhart

  Suddenly I obtain access to
  ULTRIX black 4.3 1 RISC
  Uh ... what kind of processor is that?  Offhand I don't see any
  indication that any of the entries in s_lock.h are supposed to work
  for Ultrix.

As mentioned earlier, Ultrix on RISC means that it is a MIPS processor.
DEC implemented OSF-1 for their Alpha processors.

 I suspect that some one of the implementations in s_lock.h was intended
 to be usable on Ultrix, and we've somehow dropped the declarations
 needed to make it go.  You might want to pull down an old tarball (6.3
 or before) and look at how it compiles the s_lock support on Ultrix.

Any hints for Alexander on how to do it *if* it is a MIPS processor?

  - Thomas

---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]



[HACKERS] Re: Call for platforms

2001-03-26 Thread Thomas Lockhart

The list of unreported or "in progress" platforms has gotten much
shorter. If anyone can help on the remaining problems, we'll be able to
move closer to release status, which is A Good Thing (tm) ;)

btw, if we get most of these qualified, we will be on around 30
platforms

  - Thomas

Unreported or problem platforms:

Linux 2.0.x MIPS   7.0 2000-04-13, Tatsuo Ishii

Tatsuo's machine has died. Anyone else with a Cobalt?

mklinux PPC750 7.0 2000-04-13, Tatsuo Ishii

Any luck with RC1?

NetBSD m68k7.0 2000-04-10, Henry B. Hotz
NetBSD Sparc   7.0 2000-04-13, Tom I. Helbekkmo

We need some NetBSD folks to speak up! Also, there are several flavors
of OpenBSD which are not represented in our list, but which probably are
already running PostgreSQL. Anyone?

QNX 4.25 x86   7.0 2000-04-01, Dr. Andreas Kardos

Does QNX get demoted to the "unsupported list"? It is known to have
problems with 7.1, right?

Solaris x867.0 2000-04-12, Marc Fournier

scrappy, did you work through the tests yet?

Ultrix MIPS7.1 2001-??-??, Alexander Klimov

Any possibilities here?


And here are the up-to-date platforms; thanks for the reports:

AIX 4.3.3 RS6000   7.1 2001-03-21, Gilles Darold
BeOS 5.0.3 x86 7.1 2000-12-18, Cyril Velter
BSDI 4.01  x86 7.1 2001-03-19, Bruce Momjian
Compaq Tru64 4.0g Alpha 7.1 2001-03-19, Brent Verner
FreeBSD 4.3 x867.1 2001-03-19, Vince Vielhaber
HPUX PA-RISC   7.1 2001-03-19, 10.20 Tom Lane, 11.00 Giles Lean
IRIX 6.5.11 MIPS   7.1 2001-03-22, Robert Bruccoleri
Linux 2.2.x Alpha  7.1 2001-01-23, Ryan Kirkpatrick
Linux 2.2.x armv4l 7.1 2001-03-22, Mark Knox
Linux 2.2.18 PPC750 7.1 2001-03-19, Tom Lane
Linux 2.2.x S/390  7.1 2000-11-17, Neale Ferguson
Linux 2.2.15 Sparc 7.1 2001-01-30, Ryan Kirkpatrick
Linux 2.2.16 x86   7.1 2001-03-19, Thomas Lockhart
MacOS X Darwin PPC 7.1 2000-12-11, Peter Bierman
NetBSD 1.5 alpha   7.1 2001-03-22, Giles Lean
NetBSD 1.5E arm32  7.1 2001-03-21, Patrick Welche
NetBSD 1.5S x867.1 2001-03-21, Patrick Welche
OpenBSD 2.8 x867.1 2001-03-22, Brandon Palmer
SCO OpenServer 5 x86   7.1 2001-03-13, Billy Allie
SCO UnixWare 7.1.1 x86 7.1 2001-03-19, Larry Rosenman
Solaris 2.7 Sparc  7.1 2001-03-22, Marc Fournier
SunOS 4.1.4 Sparc  7.1 2001-03-23, Tatsuo Ishii
Windows/Win32 x86  7.1 2001-03-26, Magnus Hagander (clients only)
WinNT/Cygwin x86   7.1 2001-03-16, Jason Tishler

---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly



Re: [HACKERS] Re: Call for platforms

2001-03-26 Thread Peter Eisentraut

Thomas Lockhart writes:

 SCO OpenServer 5 x86   7.1 2001-03-13, Billy Allie

Where did you see this?  I don't find it in the archives or in Vince's
database.

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


---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]



Re: [HACKERS] Re: Call for platforms

2001-03-26 Thread Thomas Lockhart

  SCO OpenServer 5 x86   7.1 2001-03-13, Billy Allie
 Where did you see this?  I don't find it in the archives or in Vince's
 database.

In FAQ_SCO. I was looking to try to figure out what the differences were
between the SCO products :)

   - Thomas

---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]



Re: [HACKERS] Re: Call for platforms

2001-03-26 Thread Larry Rosenman


Since the SCO UDK works on both UnixWare and OpenServer, I think we are 
pretty safe.  Also, there was a post to -HACKERS about the accept bug and 
we changed the workaround to include OSR5. 

I'd leave it until disproved.  I don't have a OSR5 installation to check 
it with, however. 

LER

 Original Message 

On 3/26/01, 12:05:55 PM, Thomas Lockhart [EMAIL PROTECTED] 
wrote regarding Re: [HACKERS] Re: Call for platforms:


   SCO OpenServer 5 x86   7.1 2001-03-13, Billy Allie
  Where did you see this?  I don't find it in the archives or in Vince's
  database.

 In FAQ_SCO. I was looking to try to figure out what the differences were
 between the SCO products :)

- Thomas

 ---(end of broadcast)---
 TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])



Re: [HACKERS] Re: Call for platforms

2001-03-26 Thread Tom Lane

Thomas Lockhart [EMAIL PROTECTED] writes:
 Linux 2.2.18 PPC750 7.1 2001-03-19, Tom Lane

"PPC750"?  What's that?  "PPC G3" might be more likely to mean something
to onlookers ...

regards, tom lane

---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])



Re: [HACKERS] Re: Call for platforms

2001-03-26 Thread Tom Lane

Thomas Lockhart [EMAIL PROTECTED] writes:
 As mentioned earlier, Ultrix on RISC means that it is a MIPS processor.

 I suspect that some one of the implementations in s_lock.h was intended
 to be usable on Ultrix, and we've somehow dropped the declarations
 needed to make it go.  You might want to pull down an old tarball (6.3
 or before) and look at how it compiles the s_lock support on Ultrix.

 Any hints for Alexander on how to do it *if* it is a MIPS processor?

Not sure.  The only info I see in s_lock.h is in the "SGI" section:

 * This stuff may be supplemented in the future with Masato Kataoka's MIPS-II
 * assembly from his NECEWS SVR4 port, but we probably ought to retain this
 * for the R3000 chips out there.

That name doesn't ring a bell with me --- anyone remember what code is
being referred to here, or where we might find Masato Kataoka?

MIPS-II code may or may not be compatible with Alexander's machine
anyway, but it's the only starting point I see.

Anyway, the last CVS update to port/ultrix.h that appears to have come
from someone actually using Ultrix was rev 1.2 on 7-May-97, which
predates the very existence of s_lock.h as a separate file.  So I'd
definitely advise Alexander to find a tarball from that era and look at
how Ultrix was handled then.

I dunno if we even have tarballs from that far back on-line ... I
suppose another possibility is a date-based pull from the CVS server.

regards, tom lane

---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html



Re: [HACKERS] Re: Call for platforms

2001-03-26 Thread Peter Eisentraut

Thomas Lockhart writes:

   SCO OpenServer 5 x86   7.1 2001-03-13, Billy Allie
  Where did you see this?  I don't find it in the archives or in Vince's
  database.

 In FAQ_SCO. I was looking to try to figure out what the differences were
 between the SCO products :)

I wouldn't necessarily count something dated Oct 9, 2000.  That was half a
year ago, and even two months before beta.  And the message doesn't
actually say it worked.

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


---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly



Re: [HACKERS] Re: Call for platforms

2001-03-26 Thread Thomas Lockhart

 "PPC750"?  What's that?  "PPC G3" might be more likely to mean something
 to onlookers ...

Actually "G3" means nothing outside of Apple afaict. The 750 series is a
follow-on to the 60x series, and there is a 7xxx series also. From my
pov, using an accepted label, rather than a marketing (re)label, better
indicates *what* this actually can run on. I'm not sure that I have it
labeled correctly yet, but "G3" is not a step in the right direction.

As we both found, it is difficult to wade through Apple's own docs to
decipher which processor is actually built into the system.

Should I put "Mac G3" in the comment section?

   - Thomas

---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly



Re: [HACKERS] Re: Call for platforms

2001-03-26 Thread Thomas Lockhart

SCO OpenServer 5 x86   7.1 2001-03-13, Billy Allie
   Where did you see this?  I don't find it in the archives or in Vince's
   database.
  In FAQ_SCO. I was looking to try to figure out what the differences were
  between the SCO products :)
 I wouldn't necessarily count something dated Oct 9, 2000.  That was half a
 year ago, and even two months before beta.  And the message doesn't
 actually say it worked.

?? I can see I was thrown off by the "last updated:" line near the top
of the file. It actually comes from a CVS commit, not from an explicit
update of the info in the file.

Very bad :(

- Thomas

---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html



Re: [HACKERS] Re: Call for platforms

2001-03-26 Thread Larry Rosenman

I would. 

LER

-- 
Larry Rosenman
 http://www.lerctr.org/~ler/
Phone: +1 972 414 9812
 E-Mail: [EMAIL PROTECTED]
US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749 US

 Original Message 

On 3/26/01, 2:36:19 PM, Thomas Lockhart [EMAIL PROTECTED] wrote 
regarding Re: [HACKERS] Re: Call for platforms:


  "PPC750"?  What's that?  "PPC G3" might be more likely to mean something
  to onlookers ...

 Actually "G3" means nothing outside of Apple afaict. The 750 series is a
 follow-on to the 60x series, and there is a 7xxx series also. From my
 pov, using an accepted label, rather than a marketing (re)label, better
 indicates *what* this actually can run on. I'm not sure that I have it
 labeled correctly yet, but "G3" is not a step in the right direction.

 As we both found, it is difficult to wade through Apple's own docs to
 decipher which processor is actually built into the system.

 Should I put "Mac G3" in the comment section?

- Thomas

 ---(end of broadcast)---
 TIP 3: if posting/reading through Usenet, please send an appropriate
 subscribe-nomail command to [EMAIL PROTECTED] so that your
 message can get through to the mailing list cleanly

---(end of broadcast)---
TIP 6: Have you searched our list archives?

http://www.postgresql.org/search.mpl



Re: [HACKERS] Re: Call for platforms

2001-03-26 Thread Tom Lane

Karl DeBisschop [EMAIL PROTECTED] writes:
 In my tests on sparc/7 my compile died at line 3088 of
 postgresql-7.1beta6/src/interfaces/python/pgmodule.c:

 ./pgmodule.c:3088: parse error before `init_pg'

 That's line 3137 of today's (22Mar) snapshot, which reads:

 /* Initialization function for the module */
 DL_EXPORT(void)
 init_pg(void)
 {

What version of Python are you using?  In Python 1.5, I find this
in Python.h:

#ifndef DL_EXPORT   /* declarations for DLL import/export */
#define DL_EXPORT(RTYPE) RTYPE
#endif

which should make the above work.

regards, tom lane

---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]



Re: [HACKERS] Re: Call for platforms

2001-03-26 Thread Lamar Owen

Thomas Lockhart wrote:
 Linux 2.2.x Alpha  7.1 2001-01-23, Ryan Kirkpatrick
 Linux 2.2.x armv4l 7.1 2001-03-22, Mark Knox
 Linux 2.2.18 PPC750 7.1 2001-03-19, Tom Lane
 Linux 2.2.x S/390  7.1 2000-11-17, Neale Ferguson
 Linux 2.2.15 Sparc 7.1 2001-01-30, Ryan Kirkpatrick
 Linux 2.2.16 x86   7.1 2001-03-19, Thomas Lockhart

Did you get the message from Trond about Linux 2.4 x86?  I can also
verify all tests passed on a RedHat Public Beta installation with kernel
2.4.
--
Lamar Owen
WGCR Internet Radio
1 Peter 4:11

---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster



Re: [HACKERS] Re: Call for platforms

2001-03-26 Thread Trond Eivind Glomsrød

Lamar Owen [EMAIL PROTECTED] writes:

 Thomas Lockhart wrote:
  Linux 2.2.x Alpha  7.1 2001-01-23, Ryan Kirkpatrick
  Linux 2.2.x armv4l 7.1 2001-03-22, Mark Knox
  Linux 2.2.18 PPC750 7.1 2001-03-19, Tom Lane
  Linux 2.2.x S/390  7.1 2000-11-17, Neale Ferguson
  Linux 2.2.15 Sparc 7.1 2001-01-30, Ryan Kirkpatrick
  Linux 2.2.16 x86   7.1 2001-03-19, Thomas Lockhart
 
 Did you get the message from Trond about Linux 2.4 x86?  I can also
 verify all tests passed on a RedHat Public Beta installation with kernel
 2.4.

I haven't put those in the list yet... I'll wait until we release a
product, and test it on that.

-- 
Trond Eivind Glomsrd
Red Hat, Inc.

---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly



Re: [HACKERS] Re: Call for platforms

2001-03-26 Thread Lamar Owen

Trond Eivind Glomsrd wrote:
 Lamar Owen [EMAIL PROTECTED] writes:
  Did you get the message from Trond about Linux 2.4 x86?  I can also
  verify all tests passed on a RedHat Public Beta installation with kernel
  2.4.
 
 I haven't put those in the list yet... I'll wait until we release a
 product, and test it on that.

Ah.  Ok.
--
Lamar Owen
WGCR Internet Radio
1 Peter 4:11

---(end of broadcast)---
TIP 6: Have you searched our list archives?

http://www.postgresql.org/search.mpl



[HACKERS] Re: Call for platforms

2001-03-26 Thread Thomas Lockhart

 NetBSD m68k7.0 2000-04-10, Henry B. Hotz
 I no longer have a 68k machine that's fast enough to reasonably test
 PG on.  I have a IIcx that sometimes serves as a router, but I'm
 using some second-generation powermac's  mostly now.  (You still have
 that Centris in your closet Tom?)

Oof. With its giant 250MB hard disk. I'm not likely to ever get that
going ;)

 I *did* just get MacOS X this weekend though and if I get it working
 on my work G4 maybe I could give it a try there.

It will require at least the second Darwin beta release to work.

   - Thomas

---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]



Re: [HACKERS] Re: Call for platforms

2001-03-26 Thread Justin Clift

I know that Sourceforge has been adding all sorts of machines to their
compile farm.

Maybe it would be worthwhile taking a look if they have platforms we
don't?

Regards and best wishes,

Justin Clift

Thomas Lockhart wrote:
 
  The non-test-and-set case should work again in current CVS, and I'd
  appreciate it if Alexander would verify that.  But as far as getting
  some test-and-set support for MIPS goes, it looks like the only way
  is for someone to sit down with a MIPS assembly manual.  I haven't
  got one, nor access to a machine to test on...
 
 That is not already available from the Irix support code?
 
   - Thomas
 
 ---(end of broadcast)---
 TIP 2: you can get off all lists at once with the unregister command
 (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly



Re: [HACKERS] Re: Call for platforms

2001-03-26 Thread Mathijs Brands

On Tue, Mar 27, 2001 at 12:01:24PM +1000, Justin Clift allegedly wrote:
 I know that Sourceforge has been adding all sorts of machines to their
 compile farm.
 
 Maybe it would be worthwhile taking a look if they have platforms we
 don't?
 
 Regards and best wishes,
 
 Justin Clift

Compaq also still hands out free test accounts on Digital servers
running Linux, Tru64 and FreeBSD... I think it's called the Testdrive
program.

Cheers,

Mathijs
-- 
It's not that perl programmers are idiots, it's that the language
rewards idiotic behavior in a way that no other language or tool has
ever done.
Erik Naggum

---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html



Regression test on FBSD 3.3 4.2, IRIX 6.5 (was Re: [HACKERS] Re: Call for platforms)

2001-03-26 Thread Mathijs Brands

On Mon, Mar 26, 2001 at 07:09:38PM -0500, Tom Lane allegedly wrote:
 Thomas Lockhart [EMAIL PROTECTED] writes:
  That is not already available from the Irix support code?
 
 What we have for IRIX is
 
 #if defined(__sgi)
 /*
  * SGI IRIX 5
  * slock_t is defined as a unsigned long. We use the standard SGI
  * mutex API.
  *
  * The following comment is left for historical reasons, but is probably
  * not a good idea since the mutex ABI is supported.
  *
  * This stuff may be supplemented in the future with Masato Kataoka's MIPS-II
  * assembly from his NECEWS SVR4 port, but we probably ought to retain this
  * for the R3000 chips out there.
  */
 #include "mutex.h"
 #define TAS(lock) (test_and_set(lock,1))
 #define S_UNLOCK(lock)(test_then_and(lock,0))
 #define S_INIT_LOCK(lock) (test_then_and(lock,0))
 #define S_LOCK_FREE(lock) (test_then_add(lock,0) == 0)
 #endif /* __sgi */
 
 Doesn't look to me like it's likely to work on anything but IRIX ...
 
   regards, tom lane
 
 ---(end of broadcast)---
 TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

I just tried to compile 7.1RC1 on my IRIX 6.5 box using gcc 2.95.2.
Appearently gcc chokes on some assembly in src/backend/storage/buffer/s_lock.c
(tas_dummy on line 235 to be precise).

Here's the offending code:

#if defined(__mips__)
static void
tas_dummy()
{
__asm__ _volatile__(
"\
.global tas \n\
tas:\n\
.frame  $sp, 0, $31 \n\
ll  $14, 0($4)  \n\
or  $15, $14, 1 \n\
sc  $15, 0($4)  \n\
beq $15, 0, fail\n\
bne $14, 0, fail\n\
li  $2, 0   \n\
.livereg 0x2000FF0E,0x0FFF  \n\
j   $31 \n\
fail:   \n\
li  $2, 1   \n\
j   $31 \n\
");
}

Notice the single underscore before volatile. I just checked the CVS
version of s_lock.c and this is still not fixed. Fixing this causes
as (the SGI version, not GNU as) to choke on the '.global tas' statement.

s_lock.c: At top level:
s_lock.c:234: warning: `tas_dummy' defined but not used
as: Error: /var/tmp/ccoUdrOb.s, line 421: undefined assembler operation: .global
  .global tas
gmake[4]: *** [s_lock.o] Error 1

Commenting out the .global statements does produce a binary, but it can't
complete the regression test due to other problems.

IpcSemaphoreCreate: semctl(id=0, 0, SETALL, ...) failed: Bad address

I'll see if I can come up with a solution for the .global and the
semaphore problem. I'll check wether pgsql 7.0 does run on this box too.
One wonders how Robert Bruccoleri did get 7.1RC1 to work properly. I'll
check the archive for clues.

On my FreeBSD 4.2 box 7.1RC1 runs flawlessly. I've also tested the CVS
version a few days ago on a 4.1.1 box without any problems.

FreeBSD 3.3 however does have some problems.

*** ./expected/float8-small-is-zero.out Fri Mar 31 07:30:31 2000
--- ./results/float8.out  Tue Mar 27 02:28:07 2001
***
*** 214,220 
 SET f1 = FLOAT8_TBL.f1 * '-1'
 WHERE FLOAT8_TBL.f1  '0.0';
  SELECT '' AS bad, f.f1 * '1e200' from FLOAT8_TBL f;
! ERROR:  Bad float8 input format -- overflow
  SELECT '' AS bad, f.f1 ^ '1e200' from FLOAT8_TBL f;
  ERROR:  pow() result is out of range
  SELECT '' AS bad, ln(f.f1) from FLOAT8_TBL f where f.f1 = '0.0' ;
--- 214,220 
 SET f1 = FLOAT8_TBL.f1 * '-1'
 WHERE FLOAT8_TBL.f1  '0.0';
  SELECT '' AS bad, f.f1 * '1e200' from FLOAT8_TBL f;
! ERROR:  floating point exception! The last floating point operation either exceeded 
legal ranges or was a divide by zero
  SELECT '' AS bad, f.f1 ^ '1e200' from FLOAT8_TBL f;
  ERROR:  pow() result is out of range
  SELECT '' AS bad, ln(f.f1) from FLOAT8_TBL f where f.f1 = '0.0' ;

Some geometry tests also fail. I'll check those tomorrow, erm, today. The
same goes for 7.1RC1 on Solaris 8 (Intel and Sparc).

Cheers,

Mathijs
-- 
It's not that perl programmers are idiots, it's that the language
rewards idiotic behavior in a way that no other language or tool has
ever done.
Erik Naggum

---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster



Re: [HACKERS] Re: Call for platforms

2001-03-26 Thread Peter Bierman

At 7:53 PM -0500 3/26/01, Tom Lane wrote:
Thomas Lockhart [EMAIL PROTECTED] writes:
 "PPC750"?  What's that?  "PPC G3" might be more likely to mean something
 to onlookers ...

 Actually "G3" means nothing outside of Apple afaict. The 750 series is a
 follow-on to the 60x series, and there is a 7xxx series also. From my
 pov, using an accepted label, rather than a marketing (re)label, better
 indicates *what* this actually can run on. I'm not sure that I have it
 labeled correctly yet, but "G3" is not a step in the right direction.

I found an apparently current "PowerPC CPU Summary" at
http://e-www.motorola.com/webapp/sps/technology/tech_tutorial.jsp?catId=M943030621280

If accurate, the chip in this PowerBook is *not* a 750, since that tops
out at 400 MHz.  Apple offered this model in 400 and 500 MHz speeds,
which makes it either a 7400 or 7410 chip ...

 Should I put "Mac G3" in the comment section?

Yes, if you won't put it where it should be ;-).  I'm still of the
opinion that "G3" will mean something to a vastly larger population
than "750" or "7400" would.  The latter are "marketing relabels" too
you know; Motorola's internal designation would probably be something
else entirely.


A "Me Too" from the peanut gallery.

There are probably 1000x as many users that will recognize that they have a PowerPC G3 
than will know they have a PPC750 or PPC7400.

-pmb



---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly



Re: Regression test on FBSD 3.3 4.2, IRIX 6.5 (was Re: [HACKERS] Re: Call for platforms)

2001-03-26 Thread Tom Lane

Mathijs Brands [EMAIL PROTECTED] writes:
 Notice the single underscore before volatile.

That's definitely wrong --- fixed.

 Fixing this causes
 as (the SGI version, not GNU as) to choke on the '.global tas' statement.

 s_lock.c: At top level:
 s_lock.c:234: warning: `tas_dummy' defined but not used
 as: Error: /var/tmp/ccoUdrOb.s, line 421: undefined assembler operation: .global
   .global tas
 gmake[4]: *** [s_lock.o] Error 1

Perhaps it should be ".globl"?  That's another common spelling.

Do you know whether anyone uses the GNU assembler on this platform,
or is it always SGI's?  I'm wondering if we need two versions of the
assembly code ...


I had missed the fact that s_lock.c contains some MIPS code.  Anyone
have any idea what versions of the MIPS series this code runs on?

regards, tom lane

---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]



[HACKERS] Re: Call for platforms

2001-03-26 Thread Tom Ivar Helbekkmo

Thomas Lockhart [EMAIL PROTECTED] writes:

 NetBSD Sparc   7.0 2000-04-13, Tom I. Helbekkmo

Fetching the latest source kit now -- hope to have regression tests
run and a report back to you within a day or two.

 We need some NetBSD folks to speak up!

I've once again got a VAX that should be able to run PostgreSQL on
NetBSD/vax, so I hope to be able to help revitalize that port soon...

-tih
-- 
The basic difference is this: hackers build things, crackers break them.

---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])



Re: [HACKERS] Re: Call for platforms

2001-03-26 Thread Tom Lane

"Mark Knox" [EMAIL PROTECTED] writes:
 On 25 Mar 2001, at 16:07, Tom Lane wrote:
 Does that database have any user-created relations in it, or is it
 just a virgin database?

 Totally virgin. I created it just for that select you wanted.

Okay.   Would you create a couple of random tables in it and do the
select again?  I want to see what ctid looks like in a user-created
table.

 I suspect it might be an alignment problem

Sort of.  I am suspicious that sizeof(ItemPointerData) is returning 8
rather than 6 as one might expect.

regards, tom lane

---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster



[HACKERS] Re: Call for platforms

2001-03-25 Thread Alexander Klimov

Hi all.

Suddenly I obtain access to 
ULTRIX black 4.3 1 RISC

I don't shure is it supported, but I see /src/include/port/ultrix4.h file
so my guess is `yes, at least was'. I got last version from CVS and try
configure  gmake
it results in

gcc  -Wall -Wmissing-prototypes -Wmissing-declarations
-I../../../../src/include   -c xlog.c -o xlog.o
In file included from xlog.c:36:
../../../../src/include/storage/s_lock.h:88: warning: type defaults to
`int' in declaration of `slock_t'
../../../../src/include/storage/s_lock.h:88: parse error before `*'
../../../../src/include/storage/s_lock.h:91: warning: type defaults to
`int' in declaration of `slock_t'
../../../../src/include/storage/s_lock.h:91: parse error before `*'
gmake[4]: *** [xlog.o] Error 1

grep of .h files shows that slock_t usualy defined in
/src/include/port/*.h, but it is not defined in ultrix4.h
and I can't find it in system includes.

Regards,
ASK


---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html



Re: [HACKERS] Re: Call for platforms

2001-03-25 Thread Doug McNaught

Tom Lane [EMAIL PROTECTED] writes:

 Alexander Klimov [EMAIL PROTECTED] writes:
  Suddenly I obtain access to 
  ULTRIX black 4.3 1 RISC
 
 Uh ... what kind of processor is that?  Offhand I don't see any
 indication that any of the entries in s_lock.h are supposed to work
 for Ultrix.

The RISC/Ultrix machines ran (older) MIPS chips.  Ultrix also ran
(amazingly slowly) on the VAX architecture.

[Fond memories of my first sysadmin job...]

-Doug

---(end of broadcast)---
TIP 6: Have you searched our list archives?

http://www.postgresql.org/search.mpl



Re: [HACKERS] Re: Call for platforms

2001-03-25 Thread Tom Lane

 Alexander Klimov [EMAIL PROTECTED] writes:
 Suddenly I obtain access to 
 ULTRIX black 4.3 1 RISC

 Uh ... what kind of processor is that?  Offhand I don't see any
 indication that any of the entries in s_lock.h are supposed to work
 for Ultrix.

On closer look I notice that the putative support for machines without
a TEST_AND_SET implementation got broken by careless rearrangement of
the declarations in s_lock.h :-(.  I have repaired this, and if you
update from CVS you should find that things compile.

However, you don't really want to run without TEST_AND_SET support;
it'll be dog-slow.  Furthermore, the support for machines without
TEST_AND_SET is fairly new.  I doubt it existed when the Ultrix port
was last reported to work.  So the question above still stands.

I suspect that some one of the implementations in s_lock.h was intended
to be usable on Ultrix, and we've somehow dropped the declarations
needed to make it go.  You might want to pull down an old tarball (6.3
or before) and look at how it compiles the s_lock support on Ultrix.

Please send in a patch if you find that one is necessary for s_lock
support on Ultrix.

regards, tom lane

---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly



Re: [HACKERS] Re: Call for platforms

2001-03-25 Thread Karl DeBisschop

The Hermit Hacker wrote:
 
 On Thu, 22 Mar 2001, Thomas Lockhart wrote:
 
  Solaris x867.0 2000-04-12, Marc Fournier
 
  scrappy, do you still have this machine?
 
 Doing tests on Solaris x86/7 right now, will report as soon as they are
 done ...
 
  Solaris 2.5.1-2.7 Sparc 7.0 2000-04-12, Peter Eisentraut
 
  I'll bet that someone already has Solaris covered. Report?
 
 Will do up Sparc/7 also this morning ...

In my tests on sparc/7 my compile died at line 3088 of
postgresql-7.1beta6/src/interfaces/python/pgmodule.c:

./pgmodule.c:3088: parse error before `init_pg'

That's line 3137 of today's (22Mar) snapshot, which reads:

/* Initialization function for the module */
DL_EXPORT(void)
init_pg(void)
{

I'm not a C expert by any means, but I can't figure how that is valid. 

Given my ignorance, I don't want to call it a bug. Plus we don't use the
python module in production, nor the sparc platform. But it seemed worth
pointing out.

-- 
Karl

---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly



Re: [HACKERS] Re: Call for platforms

2001-03-25 Thread Tom Lane

"Mark Knox" [EMAIL PROTECTED] writes:
 Linux 2.2.x armv4l 7.0 2000-04-17, Mark Knox

 Compiled and tested 7.1beta6 tonight. All the regression tests passed 
 except two - the usual minor differences in geometry (rounding on the 
 final digit) and this rather troubling output from type_sanity.

Most bizarre --- and definitely indicative of trouble.  Would you send
along the output of this query in that database:

select p1.oid,attrelid,relname,attname,attlen,attalign,attbyval
from pg_attribute p1, pg_class p2
where atttypid = 27 and p2.oid = attrelid
order by 1;

regards, tom lane

---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster



Re: [HACKERS] Re: Call for platforms

2001-03-25 Thread Tom Lane

Does that database have any user-created relations in it, or is it
just a virgin database?  It seems that the wrong attlen is being
computed for ctid fields during bootstrap, but the regression test
output (if it was complete) implies that the value inserted for
user-created fields was OK.  This doesn't make a lot of sense since
it's the same code...

regards, tom lane

---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster



Re: [HACKERS] Re: Call for platforms

2001-03-25 Thread Mark Knox

-BEGIN PGP SIGNED MESSAGE-

On 25 Mar 2001, at 15:02, Tom Lane wrote:

  (rounding on the final digit) and this rather troubling output from
  type_sanity.
 
 Most bizarre --- and definitely indicative of trouble.  Would you send
 along the output of this query in that database:
 
 select p1.oid,attrelid,relname,attname,attlen,attalign,attbyval
 from pg_attribute p1, pg_class p2
 where atttypid = 27 and p2.oid = attrelid
 order by 1;

I was afraid of that ;) Here's the output:

[PostgreSQL 7.1beta6 on armv4l-unknown-linux-gnuoldld, compiled by 
GCC 2.95.1]

   type \? for help on slash commands
   type \q to quit
   type \g or terminate with semicolon to execute query
 You are currently connected to the database: postgres

postgres= select 
p1.oid,attrelid,relname,attname,attlen,attalign,attbyval from 
pg_attribute p1, pg_class p2 where atttypid = 27 and p2.oid = 
attrelid order by 1;
  oid|attrelid|relname   |attname|attlen|attalign|attbyval
- -++--+---+--++
16401|1247|pg_type   |ctid   | 6|i   |f   
16415|1262|pg_database   |ctid   | 6|i   |f   
16439|1255|pg_proc   |ctid   | 6|i   |f   
16454|1260|pg_shadow |ctid   | 6|i   |f   
16464|1261|pg_group  |ctid   | 6|i   |f   
16486|1249|pg_attribute  |ctid   | 6|i   |f   
16515|1259|pg_class  |ctid   | 6|i   |f   
16526|1215|pg_attrdef|ctid   | 6|i   |f   
16537|1216|pg_relcheck   |ctid   | 6|i   |f   
16557|1219|pg_trigger|ctid   | 6|i   |f   
16572|   16567|pg_inherits   |ctid   | 8|i   |f   
16593|   16579|pg_index  |ctid   | 8|i   |f   
16610|   16600|pg_statistic  |ctid   | 8|i   |f   
16635|   16617|pg_operator   |ctid   | 8|i   |f   
16646|   16642|pg_opclass|ctid   | 8|i   |f   
16678|   16653|pg_am |ctid   | 8|i   |f   
16691|   16685|pg_amop   |ctid   | 8|i   |f   
16873|   16867|pg_amproc |ctid   | 8|i   |f   
16941|   16934|pg_language   |ctid   | 8|i   |f   
16953|   16948|pg_largeobject|ctid   | 8|i   |f   
16970|   16960|pg_aggregate  |ctid   | 8|i   |f   
17038|   17033|pg_ipl|ctid   | 8|i   |f   
17051|   17045|pg_inheritproc|ctid   | 8|i   |f   
17067|   17058|pg_rewrite|ctid   | 8|i   |f   
17079|   17074|pg_listener   |ctid   | 8|i   |f   
17090|   17086|pg_description|ctid   | 8|i   |f   
17206|   17201|pg_toast_1215 |ctid   | 8|i   |f   
17221|   17216|pg_toast_17086|ctid   | 8|i   |f   
17236|   17231|pg_toast_1255 |ctid   | 8|i   |f   
17251|   17246|pg_toast_1216 |ctid   | 8|i   |f   
17266|   17261|pg_toast_17058|ctid   | 8|i   |f   
17281|   17276|pg_toast_16600|ctid   | 8|i   |f   
17301|   17291|pg_user   |ctid   | 8|i   |f   
17314|   17309|pg_rules  |ctid   | 8|i   |f   
17327|   17322|pg_views  |ctid   | 8|i   |f   
17342|   17335|pg_tables |ctid   | 8|i   |f   
17355|   17350|pg_indexes|ctid   | 8|i   |f   
(37 rows)


-BEGIN PGP SIGNATURE-
Version: N/A

iQCVAwUBOr5XA/+IdJuhyV9xAQGfOgP6ApV6ia44bxCo/KyIE20knn/1FTysECW9
Rq9mLDhpYKHYtTWz1cgGtxzCEiRAMN+ZuO7u5nydy6TB8dp8iCd9eLAro4GAzqYM
aD9V9S3nK3YwV9RaKBWJqHXNPI5enp19YS74GxN0f9VIw/4PXlYVm2tQJLVWNGs+
lFfQnraYEZQ=
=Cj2l
-END PGP SIGNATURE-

---(end of broadcast)---
TIP 6: Have you searched our list archives?

http://www.postgresql.org/search.mpl



Re: [HACKERS] Re: Call for platforms

2001-03-24 Thread Peter Eisentraut

Tom Lane writes:

  and yet another run (and different results):

  =
   1 of 76 tests failed, 1 failed test(s) ignored.
  =

 That's just ye olde random "random" failure ...

Actually, this is one real failed test plus the "random" failure.

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


---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly



Re: [HACKERS] Re: Call for platforms

2001-03-24 Thread Tom Lane

Peter Eisentraut [EMAIL PROTECTED] writes:
 Tom Lane writes:
 =
 1 of 76 tests failed, 1 failed test(s) ignored.
 =
 
 That's just ye olde random "random" failure ...

 Actually, this is one real failed test plus the "random" failure.

(Checks code...)  Hm, you're right.  May I suggest that this is a rather
confusing wording?  Perhaps

 1 of 76 tests failed, plus 1 failed test(s) ignored.

would be less likely to mislead people.

regards, tom lane

---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster



Re: [HACKERS] Re: Call for platforms

2001-03-23 Thread bpalmer

 OpenBSD 2.8 x867.1 2001-03-22, Brandon. Palmer

OBSD checks out for sparc and i386.  We did need to make a change to the
resultmap file to make the regression tests clean for the sparc.  I have
attached the diff.





Also,  on the sparc that i'm using (sparc4/110),  make check takes 1950
seconds.  Most of the time is spent in this test:

parallel group (13 tests):  float4 int2 int4 text name varchar oid boolean
char float8 int8 bit numeric

There is a long pause between 'bit' and 'numeric'.  Same with on i386.  Is
this a problem that is local to obsd?  Is it an expected delay?  It works,
but seems like a real perf problem.








Anyway:



Sparc 4/110, 64M, SCSI disk, OBSD 2.8 virgin

==
 All 76 tests passed.
==

 1941.34s real   130.23s user93.77s system

$ uname -a
OpenBSD azreal 2.8 GENERIC#0 sparc



P2 300, 96M, IDE Disk,  OBSD 2.8 virgin

==
 All 76 tests passed.
==

  262.67s real21.84s user13.56s system

$ uname -a
OpenBSD orion 2.8 GENERIC#0 i386



I can't get tcl/tk working to same my life,  but that's not too important
for a release,  just a config pain in the rear for obsd I guess.

- brandon

b. palmer,  [EMAIL PROTECTED]
pgp:  www.crimelabs.net/bpalmer.pgp5



*** resultmap.orig  Fri Mar 23 12:34:56 2001
--- resultmap.new   Fri Mar 23 12:19:47 2001
***
*** 5,11 
  float4/.*-qnx=float4-exp-three-digits
  float8/.*-bsdi=float8-small-is-zero
  float8/.*-freebsd=float8-small-is-zero
! float8/.*-openbsd=float8-small-is-zero
  float8/i.86-.*-netbsd=float8-small-is-zero
  float8/.*-qnx=float8-exp-three-digits
  float8/alpha.*-dec-osf.*:cc=float8-fp-exception
--- 5,11 
  float4/.*-qnx=float4-exp-three-digits
  float8/.*-bsdi=float8-small-is-zero
  float8/.*-freebsd=float8-small-is-zero
! float8/i.86-.*-openbsd=float8-small-is-zero
  float8/i.86-.*-netbsd=float8-small-is-zero
  float8/.*-qnx=float8-exp-three-digits
  float8/alpha.*-dec-osf.*:cc=float8-fp-exception
***
*** 14,20 
  geometry/.*-darwin=geometry-powerpc-darwin
  geometry/.*-freebsd=geometry-positive-zeros
  geometry/.*-freebsd4=geometry-positive-zeros-bsd
! geometry/.*-openbsd=geometry-positive-zeros-bsd
  geometry/.*-irix6=geometry-irix
  geometry/.*-netbsd=geometry-positive-zeros
  geometry/.*-sysv5uw7.*:cc=geometry-uw7-cc
--- 14,21 
  geometry/.*-darwin=geometry-powerpc-darwin
  geometry/.*-freebsd=geometry-positive-zeros
  geometry/.*-freebsd4=geometry-positive-zeros-bsd
! geometry/i386-.*-openbsd=geometry-positive-zeros-bsd
! geometry/sparc-.*-openbsd=geometry-positive-zeros
  geometry/.*-irix6=geometry-irix
  geometry/.*-netbsd=geometry-positive-zeros
  geometry/.*-sysv5uw7.*:cc=geometry-uw7-cc



---(end of broadcast)---
TIP 6: Have you searched our list archives?

http://www.postgresql.org/search.mpl



Re: [HACKERS] Re: Call for platforms

2001-03-23 Thread Tom Lane

bpalmer [EMAIL PROTECTED] writes:
 seconds.  Most of the time is spent in this test:

 parallel group (13 tests):  float4 int2 int4 text name varchar oid boolean
 char float8 int8 bit numeric

 There is a long pause between 'bit' and 'numeric'.  Same with on i386.  Is
 this a problem that is local to obsd?  Is it an expected delay?

Yes, that's the expected behavior.  The 'numeric' test runs considerably
longer than most of the others.  (It used to be even slower, but I made
Jan trim it down ;-))

regards, tom lane

---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]



[HACKERS] Re: Call for platforms

2001-03-22 Thread Thomas Lockhart

 NetBSD-1.5/i386 one spurious floating point test failure
 (mail sent to postgresql-bugs with details)
 NetBSD_1.5/alphaall tests passed
 NetBSD-1.4.2/i386   four tests fail

Thanks! I'm not too worried about 1.4.2, but be sure to let us know what
the problem was; it may help out someone else...

  - Thomas

---(end of broadcast)---
TIP 6: Have you searched our list archives?

http://www.postgresql.org/search.mpl



[HACKERS] Re: Call for platforms

2001-03-22 Thread Thomas Lockhart

Here is the current scorecard. We have a couple of new platforms
reported (yeaaa!):

NetBSD 2.8 alpha   7.1 2001-03-22, Giles Lean
OpenBSD 2.8 x867.1 2001-03-22, B. Palmer (first name?)

Any more OpenBSD architectures out there running PostgreSQL? Here are
the remaining (unreported, or unnoted) platforms:

IRIX 6.5.6f MIPS   6.5.3 2000-02-18, Kevin Wheatley

Anyone running IRIX? It may be on the unsupported list for 7.1 :(

Linux 2.2.x armv4l 7.0 2000-04-17, Mark Knox
Linux 2.0.x MIPS   7.0 2000-04-13, Tatsuo Ishii
mklinux PPC750 7.0 2000-04-13, Tatsuo Ishii

Tatsuo, do you still have access to the MIPS box?

NetBSD m68k7.0 2000-04-10, Henry B. Hotz
NetBSD Sparc   7.0 2000-04-13, Tom I. Helbekkmo
QNX 4.25 x86   7.0 2000-04-01, Dr. Andreas Kardos

cvs shows that there were patches from Maurizio in February, and he said
that ecpg worked for him. Bruce applied the patches, but I'm not certain
that this was done on the 7.1 code tree? Bruce, do you recall anything?

Solaris x867.0 2000-04-12, Marc Fournier

scrappy, do you still have this machine?

Solaris 2.5.1-2.7 Sparc 7.0 2000-04-12, Peter Eisentraut

I'll bet that someone already has Solaris covered. Report?

SunOS 4.1.4 Sparc  7.0 2000-04-13, Tatsuo Ishii

Tatsuo, I vaguely recall that you reported trouble recently. Is this
worth continuing as a supported platform?

Windows/Win32 x86  7.0 2000-04-02, Magnus Hagander (clients only)

Anyone compiled for Win32 recently?

And here are the up-to-date platforms; thanks for the reports:

AIX 4.3.3 RS6000   7.1 2001-03-21, Gilles Darold
BeOS 5.0.3 x86 7.1 2000-12-18, Cyril Velter
BSDI 4.01  x86 7.1 2001-03-19, Bruce Momjian
Compaq Tru64 5.0 Alpha 7.0 2000-04-11, Andrew McMurry
FreeBSD 4.2 x867.1 2001-03-19, Vince Vielhaber
HPUX 10.20 PA-RISC 7.1 2001-03-19, Tom Lane
IBMS/390   7.1 2000-11-17, Neale Ferguson
Linux 2.2.x Alpha  7.1 2001-01-23, Ryan Kirkpatrick
Linux 2.2.16 x86   7.1 2001-03-19, Thomas Lockhart
Linux 2.2.15 Sparc 7.1 2001-01-30, Ryan Kirkpatrick
LinuxPPC G37.1 2001-03-19, Tom Lane
NetBSD 1.5E arm32  7.1 2001-03-21, Patrick Welche
NetBSD 1.5S x867.1 2001-03-21, Patrick Welche
SCO OpenServer 5 x86   7.1 2001-03-13, Billy Allie
SCO UnixWare 7.1.1 x86 7.1 2001-03-19, Larry Rosenman
MacOS-X Darwin PowerPC 7.1 2000-12-11, Peter Bierman
WinNT/Cygwin x86   7.1 2001-03-16, Jason Tishler

---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster



[HACKERS] Re: Call for platforms

2001-03-22 Thread The Hermit Hacker

On Thu, 22 Mar 2001, Thomas Lockhart wrote:

 Solaris x867.0 2000-04-12, Marc Fournier

 scrappy, do you still have this machine?

Doing tests on Solaris x86/7 right now, will report as soon as they are
done ...

 Solaris 2.5.1-2.7 Sparc 7.0 2000-04-12, Peter Eisentraut

 I'll bet that someone already has Solaris covered. Report?

Will do up Sparc/7 also this morning ...

 AIX 4.3.3 RS6000   7.1 2001-03-21, Gilles Darold
 BeOS 5.0.3 x86 7.1 2000-12-18, Cyril Velter
 BSDI 4.01  x86 7.1 2001-03-19, Bruce Momjian
 Compaq Tru64 5.0 Alpha 7.0 2000-04-11, Andrew McMurry
 FreeBSD 4.2 x867.1 2001-03-19, Vince Vielhaber

FreeBSD 4.3-BETA is good to go also ...



---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly



[HACKERS] Re: Call for platforms

2001-03-22 Thread Thomas Lockhart

  FreeBSD 4.2 x867.1 2001-03-19, Vince Vielhaber
 FreeBSD 4.3-BETA is good to go also ...

Yeah, I'm not sure how to list that, or whether to bother. It is beta,
4.2 works fine (and nothing had to change for 4.3, right?) so maybe we
just list it when 4.3 goes stable? Or is 4.3 sufficiently different that
it would be good to list in the comments for the platform?

  - Thomas

---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster



Re: [HACKERS] Re: Call for platforms

2001-03-22 Thread Thomas Lockhart

 Solaris x86/7 results, for example, in geometry.out, show a difference of:
 3,-3.06204718156754e-11 (expected)
 3,-3.06204718035418e-11 (results)
 acceptable diviation?

That sort of deviation is well within bounds, particularly for geometry
tests which might have some transcendental math involved.

Is Solaris-x86 ready to go then?

 - Thomas

---(end of broadcast)---
TIP 6: Have you searched our list archives?

http://www.postgresql.org/search.mpl



Re: [HACKERS] Re: Call for platforms

2001-03-22 Thread Larry Rosenman


4.3 is in RELEASE CANDIDATE right now.  By the time we release, it should 
be -RELEASE or -STABLE. 

I'd include it as just 4.3. 

It will be the -RELEASE at the time we are.

LER

 Original Message 

On 3/22/01, 8:50:26 AM, Thomas Lockhart [EMAIL PROTECTED] wrote 
regarding [HACKERS] Re: Call for platforms:


   FreeBSD 4.2 x867.1 2001-03-19, Vince Vielhaber
  FreeBSD 4.3-BETA is good to go also ...

 Yeah, I'm not sure how to list that, or whether to bother. It is beta,
 4.2 works fine (and nothing had to change for 4.3, right?) so maybe we
 just list it when 4.3 goes stable? Or is 4.3 sufficiently different that
 it would be good to list in the comments for the platform?

   - Thomas

 ---(end of broadcast)---
 TIP 4: Don't 'kill -9' the postmaster

---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly



Re: [HACKERS] Re: Call for platforms

2001-03-22 Thread The Hermit Hacker

On Thu, 22 Mar 2001, Thomas Lockhart wrote:

  Solaris x86/7 results, for example, in geometry.out, show a difference of:
  3,-3.06204718156754e-11 (expected)
  3,-3.06204718035418e-11 (results)
  acceptable diviation?

 That sort of deviation is well within bounds, particularly for geometry
 tests which might have some transcendental math involved.

 Is Solaris-x86 ready to go then?

Nope, still working through some things ... the select_implicit test
failed completely:

dragon:/home/centre/marc/src/postgresql-7.1RC1/src/test/regress more 
results/select_implicit.out
psql: connectDBStart() -- connect() failed: Connection refused
Is the postmaster running locally
and accepting connections on Unix socket '/tmp/.s.PGSQL.65432'?

I'm going to re-run the test(s) and see if its an isolated thing or not ...


---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]



Re: [HACKERS] Re: Call for platforms

2001-03-22 Thread The Hermit Hacker

On Thu, 22 Mar 2001, Tom Lane wrote:

 The Hermit Hacker [EMAIL PROTECTED] writes:
  Nope, still working through some things ... the select_implicit test
  failed completely:

  dragon:/home/centre/marc/src/postgresql-7.1RC1/src/test/regress more 
results/select_implicit.out
  psql: connectDBStart() -- connect() failed: Connection refused
  Is the postmaster running locally
  and accepting connections on Unix socket '/tmp/.s.PGSQL.65432'?

  I'm going to re-run the test(s) and see if its an isolated thing or not ...

 Transient overflow of the postmaster socket's accept queue, maybe?  How
 big is SOMAXCONN on your box?

Okay, for me, solaris has always been a nemesis as I can never find
anything on this box :(  But, looking through the header files, I find:

/usr/include/sys/socket.h:#define   SOMAXCONN   5

I reran the tests two more times since the above ... first time went
through clean as could be, with the geometry test failing (forgot to
update my expected/resultmaps file(s) in my compile tree), the second time
failed *totally* different tests then the first run:

dragon:/home/centre/marc/src/postgresql-7.1RC1/src/test/regress grep
FAILED regression.out
 opr_sanity   ... FAILED
 join ... FAILED
 aggregates   ... FAILED
 arrays   ... FAILED

I


---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html



Re: [HACKERS] Re: Call for platforms

2001-03-22 Thread Tom Lane

The Hermit Hacker [EMAIL PROTECTED] writes:
 Nope, still working through some things ... the select_implicit test
 failed completely:

 dragon:/home/centre/marc/src/postgresql-7.1RC1/src/test/regress more 
results/select_implicit.out
 psql: connectDBStart() -- connect() failed: Connection refused
 Is the postmaster running locally
 and accepting connections on Unix socket '/tmp/.s.PGSQL.65432'?

 I'm going to re-run the test(s) and see if its an isolated thing or not ...

Transient overflow of the postmaster socket's accept queue, maybe?  How
big is SOMAXCONN on your box?

regards, tom lane

---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])



Re: [HACKERS] Re: Call for platforms

2001-03-22 Thread Thomas Lockhart

  OpenBSD 2.8 x867.1 2001-03-22, B. Palmer (first name?)
 Though it does work,  like FBSD,  there are some changes that need to be
 made to the system.  Need max proc / files changes and a kernel recompile
 with SEMMNI and SEMMNS changes.  Anywhere special to note this?

So more-or-less the *same* configuration as is required for FBSD? If so,
I could note that in the comments part of the platform support table.

I'm not sure if either one (OBSD, FBSD) is actually explicitly
documented for PostgreSQL (I don't see a FAQ, and am not sure if there
is something in the sgml docs). Does anyone know if and where these
things are noted?

   - Thomas

---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])



Re: [HACKERS] Re: Call for platforms

2001-03-22 Thread bpalmer

On Thu, 22 Mar 2001, Thomas Lockhart wrote:

   OpenBSD 2.8 x867.1 2001-03-22, B. Palmer (first name?)
  Though it does work,  like FBSD,  there are some changes that need to be
  made to the system.  Need max proc / files changes and a kernel recompile
  with SEMMNI and SEMMNS changes.  Anywhere special to note this?

 So more-or-less the *same* configuration as is required for FBSD? If so,
 I could note that in the comments part of the platform support table.

The kernel changes are the same,  but OBSD needs the max proc, max open
file settings changes (no reboot required).


 I'm not sure if either one (OBSD, FBSD) is actually explicitly
 documented for PostgreSQL (I don't see a FAQ, and am not sure if there
 is something in the sgml docs). Does anyone know if and where these
 things are noted?

http://www.postgresql.org/devel-corner/docs/postgres/kernel-resources.html

This is the closest thing to docs.  kernel-resources for specific OSs.

- b


b. palmer,  [EMAIL PROTECTED]
pgp:  www.crimelabs.net/bpalmer.pgp5


---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster



Re: [HACKERS] Re: Call for platforms

2001-03-22 Thread Tom Lane

The Hermit Hacker [EMAIL PROTECTED] writes:
 the second time
 failed *totally* different tests then the first run:

 dragon:/home/centre/marc/src/postgresql-7.1RC1/src/test/regress grep
 FAILED regression.out
  opr_sanity   ... FAILED
  join ... FAILED
  aggregates   ... FAILED
  arrays   ... FAILED

These are parallel tests right?  What's the failure diffs?

regards, tom lane

---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])



Re: [HACKERS] Re: Call for platforms

2001-03-22 Thread Peter Eisentraut

The Hermit Hacker writes:

  Is Solaris-x86 ready to go then?

 Nope, still working through some things ... the select_implicit test
 failed completely:

 dragon:/home/centre/marc/src/postgresql-7.1RC1/src/test/regress more 
results/select_implicit.out
 psql: connectDBStart() -- connect() failed: Connection refused
 Is the postmaster running locally
 and accepting connections on Unix socket '/tmp/.s.PGSQL.65432'?

 I'm going to re-run the test(s) and see if its an isolated thing or not ...

Solaris is known to have trouble with Unix domain sockets.

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


---(end of broadcast)---
TIP 6: Have you searched our list archives?

http://www.postgresql.org/search.mpl



Re: [HACKERS] Re: Call for platforms

2001-03-22 Thread bpalmer

On Thu, 22 Mar 2001, Thomas Lockhart wrote:

 OpenBSD 2.8 x867.1 2001-03-22, B. Palmer (first name?)

Though it does work,  like FBSD,  there are some changes that need to be
made to the system.  Need max proc / files changes and a kernel recompile
with SEMMNI and SEMMNS changes.  Anywhere special to note this?


b. palmer,  [EMAIL PROTECTED]
pgp:  www.crimelabs.net/bpalmer.pgp5


---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html



Re: [HACKERS] Re: Call for platforms

2001-03-22 Thread Peter Eisentraut

The Hermit Hacker writes:

 How much 'diviation' are we allowing for?

 Solaris x86/7 results, for example, in geometry.out, show a difference of:

 1.53102359078377e-11,3 (expected)
 1.53102359017709e-11,3 (results)

 or

 3,-3.06204718156754e-11 (expected)
 3,-3.06204718035418e-11 (results)

 acceptable diviation?

Practically yes, technically not.  Check if the geometry results match any
of the other "expected" files so we can update the "resultmap".  See

http://www.postgresql.org/devel-corner/docs/postgres/regress-platform.html

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


---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])



[HACKERS] Re: Call for platforms

2001-03-22 Thread Peter Eisentraut

Thomas Lockhart writes:

 Here is the current scorecard. We have a couple of new platforms
 reported (yeaaa!):

 QNX 4.25 x86   7.0 2000-04-01, Dr. Andreas Kardos

This one is getting a "no good", as of latest reports.  There are some
issues to be worked out in the dreaded spin lock area, which will probably
not happen between now and next week.

 And here are the up-to-date platforms; thanks for the reports:

 IBMS/390   7.1 2000-11-17, Neale Ferguson
  ^^^
 should be "Linux"

 LinuxPPC G37.1 2001-03-19, Tom Lane

The kernel is called "Linux", the processor is called "PowerPC G3".  But
"PowerPC" is probably enough, given that we list "x86".  Compare to...

 MacOS-X Darwin PowerPC 7.1 2000-12-11, Peter Bierman

...this.  There's a space, no dash, before the "X".

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


---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly



Re: [HACKERS] Re: Call for platforms

2001-03-22 Thread Peter Eisentraut

Thomas Lockhart writes:

   OpenBSD 2.8 x867.1 2001-03-22, B. Palmer (first name?)
  Though it does work,  like FBSD,  there are some changes that need to be
  made to the system.  Need max proc / files changes and a kernel recompile
  with SEMMNI and SEMMNS changes.  Anywhere special to note this?

 So more-or-less the *same* configuration as is required for FBSD? If so,
 I could note that in the comments part of the platform support table.

Quite a few platforms will need some tuning in that area before production
use.  This is all documented.

 I'm not sure if either one (OBSD, FBSD) is actually explicitly
 documented for PostgreSQL (I don't see a FAQ, and am not sure if there
 is something in the sgml docs). Does anyone know if and where these
 things are noted?

- Thomas


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


---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly



Re: [HACKERS] Re: Call for platforms

2001-03-22 Thread Thomas Lockhart

  NetBSD 2.8 alpha   7.1 2001-03-22, Giles Lean
 Correction: NetBSD-1.5/alpha.

Right. That was a typo in transcribing my online copy of the sgml docs
to the email. I was hoping no one caught it, and didn't bother sending a
correction ;)

  - Thomas

---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly



Re: [HACKERS] Re: Call for platforms

2001-03-22 Thread Patrick Welche

On Thu, Mar 22, 2001 at 12:49:39PM -0500, Tom Lane wrote:
 The Hermit Hacker [EMAIL PROTECTED] writes:
  These are parallel tests right?  What's the failure diffs?
 
  same as last time:
 
  dragon:/home/centre/marc/src/postgresql-7.1RC1/src/test/regress more
  results/opr_sanity.out
  psql: connectDBStart() -- connect() failed: Connection refused
  Is the postmaster running locally
  and accepting connections on Unix socket '/tmp/.s.PGSQL.65432'?
 
 See Peter's comment elsewhere that he doesn't think Solaris handles
 Unix socket connections very well.  Try patching pg_regress to force
 unix_sockets=no.
 
 
  and yet another run (and different results):
 
  =
   1 of 76 tests failed, 1 failed test(s) ignored.
  =
 
 That's just ye olde random "random" failure ...

Funny, I get the more optimistic:

==
 75 of 76 tests passed, 1 failed test(s) ignored. 
==

Different version? PostgreSQL 7.1RC1

---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html



Re: [HACKERS] Re: Call for platforms

2001-03-22 Thread Giles Lean


 NetBSD 2.8 alpha   7.1 2001-03-22, Giles Lean

Correction: NetBSD-1.5/alpha.

Ciao,

Giles

---(end of broadcast)---
TIP 6: Have you searched our list archives?

http://www.postgresql.org/search.mpl



Re: [HACKERS] Re: Call for platforms

2001-03-22 Thread The Hermit Hacker

On Thu, 22 Mar 2001, Patrick Welche wrote:

 On Thu, Mar 22, 2001 at 12:49:39PM -0500, Tom Lane wrote:
  The Hermit Hacker [EMAIL PROTECTED] writes:
   These are parallel tests right?  What's the failure diffs?
 
   same as last time:
 
   dragon:/home/centre/marc/src/postgresql-7.1RC1/src/test/regress more
   results/opr_sanity.out
   psql: connectDBStart() -- connect() failed: Connection refused
   Is the postmaster running locally
   and accepting connections on Unix socket '/tmp/.s.PGSQL.65432'?
 
  See Peter's comment elsewhere that he doesn't think Solaris handles
  Unix socket connections very well.  Try patching pg_regress to force
  unix_sockets=no.
 
 
   and yet another run (and different results):
 
   =
1 of 76 tests failed, 1 failed test(s) ignored.
   =
 
  That's just ye olde random "random" failure ...

 Funny, I get the more optimistic:

 ==
  75 of 76 tests passed, 1 failed test(s) ignored.
 ==

 Different version? PostgreSQL 7.1RC1

7.1RC1 (the not released yet version) :)



---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html



Re: [HACKERS] Re: Call for platforms

2001-03-21 Thread Peter Eisentraut

Thomas Lockhart writes:

  SCO OpenServer 5 x86...

 OK, I see that Billy Allie recently updated FAQ_SCO to indicate
 demonstrated (?) support for OpenServer. I will reflect that in the
 platform support info.

The last FAQ_SCO update was by me, and it was rather the consequence of
some implementational developments and not a good indicator of any
actually working platform.  (I do have access to a Unixware box, but that
was already reported.)

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


---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster



[HACKERS] Re: Call for platforms

2001-03-20 Thread Thomas Lockhart

 SCO OpenServer 5 x86...

OK, I see that Billy Allie recently updated FAQ_SCO to indicate
demonstrated (?) support for OpenServer. I will reflect that in the
platform support info.

 - Thomas

---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html