Re: [BUGS] PostgreSQL Patch: Test-and-set routine for HP-UX (IA-64)

2003-10-24 Thread Bruce Momjian
Download current CVS and try that, or 7.4beta5. --- ViSolve Open Source Team wrote: > Subject: PostgreSQL Patch: Test-and-set routine for HP-UX (IA-64) > > > Hello, > > The attached patch provides a test-and-set routine f

Re: [BUGS] PostgreSQL Patch: Test-and-set routine for HP-UX

2003-10-24 Thread Edmund Bacon
I am unable to get this patch to compile: gcc version : gcc (GCC) 3.2 20020329 (experimental) uname -srm : HP-UX B.11.22 ia64 tar xvf postgresql-7.3.4.tar cd postgresql-7.3.4 patch -p0 ../PostgreSQL-7.3.4_hpux3_11iv2_IA-64.patch ./configure [snip] make [snip] gmake[4]: Entering directory

[BUGS] PostgreSQL Patch: Test-and-set routine for HP-UX (IA-64)

2003-10-24 Thread ViSolve Open Source Team
Subject: PostgreSQL Patch: Test-and-set routine for HP-UX (IA-64) Hello, The attached patch provides a test-and-set routine for PostgreSQL for HP-UX 11iV2 for the Intel Itanium architecture (known to the PostgreSQL code as IA-64). There are actually two issues: 1. There is currently no tas (

Re: [BUGS] ISM shared memory on solaris

2003-10-24 Thread Josh Wilmes
Bruce Momjian wrote: Josh Wilmes wrote: Nope, __solaris__ is not defined on our system either. I thought our configure defined __portname__ for every platform, but I don't see that anywhere, so it seems we rely on the compiler to supply defines for the cpu and OS. Does src/tools/ccsym show you

Re: [BUGS] ISM shared memory on solaris

2003-10-24 Thread Josh Wilmes
Nope, __solaris__ is not defined on our system either. --Josh Bruce Momjian wrote: Yikes! We thought we were already using ISM on Solaris. Would you test the attached patch? It uses _solaris_ rather than SHM_SHARE_MMU in the define test. Does that work too? --

Re: [BUGS] ISM shared memory on solaris

2003-10-24 Thread Bruce Momjian
Josh Wilmes wrote: > Nope, __solaris__ is not defined on our system either. I thought our configure defined __portname__ for every platform, but I don't see that anywhere, so it seems we rely on the compiler to supply defines for the cpu and OS. Does src/tools/ccsym show you your defines? I woul

Re: [BUGS] ISM shared memory on solaris

2003-10-24 Thread Bruce Momjian
Yikes! We thought we were already using ISM on Solaris. Would you test the attached patch? It uses _solaris_ rather than SHM_SHARE_MMU in the define test. Does that work too? --- Josh Wilmes wrote: > I hope this is the r

[BUGS] ISM shared memory on solaris

2003-10-24 Thread Josh Wilmes
I hope this is the right place to send this.. the FAQ in the distribution mentions http://www.PostgreSQL.org/bugs/bugs.php, which doesn't work. We've found that postgresql wasn't using ISM shared memory on solaris, which theoretically would cost performance. The root cause in our case was th

Re: [BUGS] currval and nextval in 7.3.4

2003-10-24 Thread j6m
Hello, Quoting Keith Marr <[EMAIL PROTECTED]>: > Hi, > > I recently installed 7.3.4 (complete install from scratch) and both 'select > > nextval('my_seq') from my_table' and 'select currval('my_seq') from my_table' > > return a number of rows equal to the number of rows in the table. > > The