[PATCHES] spanish updates, take 2
I attach the whole spanish PO catalogs again, correcting some typos. They are at 100% again. I already posted them three days ago, but they got lost probably because the size of the mail. I will post the backend and libpq catalog separately. -- Alvaro Herrera (alvherre[a]dcc.uchile.cl) Si no sabes adonde vas, es muy probable que acabes en otra parte. libpq-es.po.gz Description: Binary data pg_controldata-es.po.gz Description: Binary data pg_dump-es.po.gz Description: Binary data pg_resetxlog-es.po.gz Description: Binary data scripts-es.po.gz Description: Binary data ---(end of broadcast)--- TIP 8: explain analyze is your friend
Re: [PATCHES] spanish psql update
Alvaro Herrera writes: The spanish psql message catalog is attached. Installed as well. -- Peter Eisentraut [EMAIL PROTECTED] ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings
Re: [PATCHES] [BUGS] PostgreSQL Patch: Test-and-set routine for HP-UX
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 `/home/postgres/src/postgresql-7.3.4/src/backend/ac cess/transam' gcc -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -I../../../../src/incl ude -c -o xlog.o xlog.c xlog.c: In function `XLogInsert': xlog.c:641: incompatible types in assignment xlog.c:870: incompatible types in assignment xlog.c: In function `AdvanceXLInsertBuffer': xlog.c:929: incompatible types in assignment xlog.c: In function `XLogWrite': xlog.c:1189: incompatible types in assignment xlog.c: In function `XLogFlush': xlog.c:1248: incompatible types in assignment xlog.c: In function `XLOGShmemInit': xlog.c:2361: incompatible types in assignment xlog.c: In function `GetRedoRecPtr': xlog.c:2918: incompatible types in assignment xlog.c: In function `CreateCheckPoint': xlog.c:3068: incompatible types in assignment gmake[4]: *** [xlog.o] Error 1 gmake[4]: Leaving directory `/home/postgres/src/postgresql-7.3.4/src/backend/acc ess/transam' gmake[3]: *** [transam-recursive] Error 2 This seems to be a problem with SpinLockRelease_NoHoldoff. On Fri, 2003-10-24 at 11:51, 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 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 (test-and-set) routine for HP-UX IA-64 in the s_lock.h header file. 2. In HP-UX IA-64, the suffix of shared libraries is .so, but PostgreSQL generates a .sl suffix. The attached patch fixes both issues. The bug template (also attached) contains the details. We (ViSolve) are a group that works closely with HP on their OpenSource initiative. We would really appreciate a timely inclusion of this patch into mainstream PostgreSQL. thanks ViSolve OpenSource Team (for HP) __ ---(end of broadcast)--- TIP 8: explain analyze is your friend ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])
Re: [PATCHES] minor psql cleanup
This has been saved for the 7.5 release: http:/momjian.postgresql.org/cgi-bin/pgpatches2 --- Neil Conway wrote: This patch reduces some unsightly #ifdefs, and fixes two typos in comments in the psql code. This doesn't make any functional change, so feel free to save it for 7.5 -Neil [ Attachment, skipping... ] ---(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 -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup.| Newtown Square, Pennsylvania 19073 ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings
Re: [PATCHES] more improvements to release notes
Neil Conway wrote: On Wed, 2003-10-22 at 13:26, Bruce Momjian wrote: * Cause FETCH 1 to return the next cursor row, or zero if at beginning/end of cursor, per SQL spec (Bruce) That's better, but still wrong: what does it mean for FETCH 1 to return zero if at the beginning/end of cursor? If we're at the end of the cursor, we return an empty result set, not zero. OK, updated: listitemparaMake MOVE/FETCH 0 now does nothing (Bruce)/para/listitem listitemparaCause MOVE/FETCH now returns the number of rows moved/fetched, or zero if at the beginning/end of cursor, per SQL spec (Bruce)/para/listitem -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup.| Newtown Square, Pennsylvania 19073 ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
Re: [PATCHES] [BUGS] ISM shared memory on solaris
OK, attached patch applied. I tested for 'sun' rather than 'solaris'. --- Josh Wilmes wrote: 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 your defines? I would like to have something that identifies Solaris rather than something that checks for ISM so that if the ISM define isn't found, we throw an error and we hear about it. That would be preferable- i didn't know what was safe to assume would always be defined. ccsym is pretty neat. Here's what it shows (gcc) __GNUC__=2 __GNUC_MINOR__=95 sparc sun unix __svr4__ __SVR4 __sparc__ __sun__ __unix__ __svr4__ __SVR4 __sparc __sun __unix system=unix system=svr4 __GCC_NEW_VARARGS__ cpu=sparc machine=sparc ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup.| Newtown Square, Pennsylvania 19073 Index: src/backend/port/sysv_shmem.c === RCS file: /cvsroot/pgsql-server/src/backend/port/sysv_shmem.c,v retrieving revision 1.21 diff -c -c -r1.21 sysv_shmem.c *** src/backend/port/sysv_shmem.c 13 Oct 2003 22:47:15 - 1.21 --- src/backend/port/sysv_shmem.c 26 Oct 2003 04:52:33 - *** *** 133,139 on_shmem_exit(IpcMemoryDelete, Int32GetDatum(shmid)); /* OK, should be able to attach to the segment */ ! #if defined(solaris) defined(__sparc__) /* use intimate shared memory on SPARC Solaris */ memAddress = shmat(shmid, 0, SHM_SHARE_MMU); #else --- 133,139 on_shmem_exit(IpcMemoryDelete, Int32GetDatum(shmid)); /* OK, should be able to attach to the segment */ ! #if defined(sun) defined(__sparc__) /* use intimate shared memory on SPARC Solaris */ memAddress = shmat(shmid, 0, SHM_SHARE_MMU); #else *** *** 352,358 hdr = (PGShmemHeader *) shmat(*shmid, UsedShmemSegAddr, ! #if defined(solaris) defined(__sparc__) /* use intimate shared memory on Solaris */ SHM_SHARE_MMU #else --- 352,358 hdr = (PGShmemHeader *) shmat(*shmid, UsedShmemSegAddr, ! #if defined(sun) defined(__sparc__) /* use intimate shared memory on Solaris */ SHM_SHARE_MMU #else ---(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: [PATCHES] [BUGS] ISM shared memory on solaris
Please use new patch. This uses __sun__ rather than sun. --- Josh Wilmes wrote: 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 your defines? I would like to have something that identifies Solaris rather than something that checks for ISM so that if the ISM define isn't found, we throw an error and we hear about it. That would be preferable- i didn't know what was safe to assume would always be defined. ccsym is pretty neat. Here's what it shows (gcc) __GNUC__=2 __GNUC_MINOR__=95 sparc sun unix __svr4__ __SVR4 __sparc__ __sun__ __unix__ __svr4__ __SVR4 __sparc __sun __unix system=unix system=svr4 __GCC_NEW_VARARGS__ cpu=sparc machine=sparc ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup.| Newtown Square, Pennsylvania 19073 Index: src/backend/port/sysv_shmem.c === RCS file: /cvsroot/pgsql-server/src/backend/port/sysv_shmem.c,v retrieving revision 1.21 diff -c -c -r1.21 sysv_shmem.c *** src/backend/port/sysv_shmem.c 13 Oct 2003 22:47:15 - 1.21 --- src/backend/port/sysv_shmem.c 26 Oct 2003 04:52:33 - *** *** 133,139 on_shmem_exit(IpcMemoryDelete, Int32GetDatum(shmid)); /* OK, should be able to attach to the segment */ ! #if defined(solaris) defined(__sparc__) /* use intimate shared memory on SPARC Solaris */ memAddress = shmat(shmid, 0, SHM_SHARE_MMU); #else --- 133,139 on_shmem_exit(IpcMemoryDelete, Int32GetDatum(shmid)); /* OK, should be able to attach to the segment */ ! #if defined(__sun__) defined(__sparc__) /* use intimate shared memory on SPARC Solaris */ memAddress = shmat(shmid, 0, SHM_SHARE_MMU); #else *** *** 352,358 hdr = (PGShmemHeader *) shmat(*shmid, UsedShmemSegAddr, ! #if defined(solaris) defined(__sparc__) /* use intimate shared memory on Solaris */ SHM_SHARE_MMU #else --- 352,358 hdr = (PGShmemHeader *) shmat(*shmid, UsedShmemSegAddr, ! #if defined(__sun__) defined(__sparc__) /* use intimate shared memory on Solaris */ SHM_SHARE_MMU #else ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match