[COMMITTERS] pgsql-server/. Tag: REL7_4_STABLE INSTALL
CVSROOT:/cvsroot Module name:pgsql-server Changes by: [EMAIL PROTECTED] 03/12/20 11:32:18 Modified files: . : Tag: REL7_4_STABLE INSTALL Log message: Update INSTALL file for 7.4.1. ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
[COMMITTERS] pgsql-server/ oc/src/sgml/datatype.sgml rc/bac ...
CVSROOT:/cvsroot Module name:pgsql-server Changes by: [EMAIL PROTECTED] 03/12/20 11:32:55 Modified files: doc/src/sgml : datatype.sgml src/backend/commands: variable.c src/backend/utils/adt: datetime.c src/include: miscadmin.h src/interfaces/ecpg/pgtypeslib: dt.h dt_common.c interval.c Log message: In my mind there were two categories of open issues a) ones that are 100% backward (such as the comment about outputting this format) and b) ones that aren't (such as deprecating the current postgresql shorthand of '1Y1M'::interval = 1 year 1 minute in favor of the ISO-8601 'P1Y1M'::interval = 1 year 1 month. Attached is a patch that addressed all the discussed issues that did not break backward compatability, including the ability to output ISO-8601 compliant intervals by setting datestyle to iso8601basic. Interval values can now be written as ISO 8601 time intervals, using the "Format with time-unit designators". This format always starts with the character 'P', followed by a string of values followed by single character time-unit designators. A 'T' separates the date and time parts of the interval. Ron Mayer ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
[COMMITTERS] pgsql-server/doc/src/sgml datatype.sgml
CVSROOT:/cvsroot Module name:pgsql-server Changes by: [EMAIL PROTECTED] 03/12/20 11:59:25 Modified files: doc/src/sgml : datatype.sgml Log message: Fix broken markup. ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
[COMMITTERS] pgsql-server/doc/src/sgml datatype.sgml
CVSROOT:/cvsroot Module name:pgsql-server Changes by: [EMAIL PROTECTED] 03/12/20 12:06:54 Modified files: doc/src/sgml : datatype.sgml Log message: Another markup fix for recent patch. ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
[COMMITTERS] pgsql-server/src backend/access/transam/xlog.c ...
CVSROOT:/cvsroot Module name:pgsql-server Changes by: [EMAIL PROTECTED] 03/12/20 13:31:22 Modified files: src/backend/access/transam: xlog.c src/backend/bootstrap: bootstrap.c src/backend/postmaster: pgstat.c postmaster.c src/backend/storage/buffer: buf_init.c src/backend/storage/file: fd.c src/backend/storage/freespace: freespace.c src/backend/storage/ipc: ipci.c pmsignal.c shmem.c sinvaladt.c src/backend/storage/lmgr: lock.c lwlock.c proc.c src/backend/tcop: postgres.c src/include: c.h src/include/access: xlogdefs.h src/include/libpq: libpq-be.h src/include/storage: fd.h ipc.h lock.h lwlock.h shmem.h Log message: This patch is the next step towards (re)allowing fork/exec. Claudio Natoli ---(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
[COMMITTERS] pgsql-server/src backend/libpq/auth.c interfac ...
CVSROOT:/cvsroot Module name:pgsql-server Changes by: [EMAIL PROTECTED] 03/12/20 14:24:52 Modified files: src/backend/libpq: auth.c src/interfaces/libpq: fe-auth.c Log message: Fix broken IDENT support for FreeBSD (appears to have been broken by ill-considered conditional logic in getpeereid patch of 3-Dec-2002). Per bug #1021. ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
[COMMITTERS] pgsql-server/src backend/libpq/Tag: backend/li ...
CVSROOT:/cvsroot Module name:pgsql-server Changes by: [EMAIL PROTECTED] 03/12/20 14:25:02 Modified files: src/backend/libpq: Tag: REL7_4_STABLE auth.c src/interfaces/libpq: Tag: REL7_4_STABLE fe-auth.c Log message: Fix broken IDENT support for FreeBSD (appears to have been broken by ill-considered conditional logic in getpeereid patch of 3-Dec-2002). Per bug #1021. ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
[COMMITTERS] pgsql-server/src/interfaces/libpq fe-auth.c
CVSROOT:/cvsroot Module name:pgsql-server Changes by: [EMAIL PROTECTED] 03/12/20 14:45:49 Modified files: src/interfaces/libpq: fe-auth.c Log message: Dept. of third thoughts: in fact, libpq should support SCM_CREDS challenge even when HAVE_GETPEEREID is defined, else it will be unable to connect to pre-7.4 backends that are using IDENT authentication. ---(end of broadcast)--- TIP 8: explain analyze is your friend
[COMMITTERS] pgsql-server/src/interfaces/libpq Tag: REL7_4_ ...
CVSROOT:/cvsroot Module name:pgsql-server Changes by: [EMAIL PROTECTED] 03/12/20 14:46:02 Modified files: src/interfaces/libpq: Tag: REL7_4_STABLE fe-auth.c Log message: Dept. of third thoughts: in fact, libpq should support SCM_CREDS challenge even when HAVE_GETPEEREID is defined, else it will be unable to connect to pre-7.4 backends that are using IDENT authentication. ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
Re: [COMMITTERS] pgsql-server/ oc/src/sgml/datatype.sgml rc/bac ...
[EMAIL PROTECTED] (Bruce Momjian) writes: > Attached is a patch that addressed all the discussed issues that > did not break backward compatability, Was this patch actually agreed to? I hadn't gotten around to looking at it because I thought Peter was still objecting to the whole idea. > including the ability to > output ISO-8601 compliant intervals by setting datestyle to > iso8601basic. This is a horrid, horrid idea. Datestyle is already a complete mess because it is being used to control several things; it should have been two or possibly three GUC variables not one. Sticking in yet another behavior is just not acceptable IMHO, especially when it's defined as non-orthogonally as that. Please revert that part of the patch and instead invent a new GUC variable that's specifically for interval formatting. BTW, I can tell without looking that the patch is deficient in documentation; if it has effects on GUC variables, why is there no mod in runtime.sgml? regards, tom lane ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings
[COMMITTERS] pgsql-server/src/backend/storage/buffer bufmgr.c
CVSROOT:/cvsroot Module name:pgsql-server Changes by: [EMAIL PROTECTED] 03/12/20 18:18:02 Modified files: src/backend/storage/buffer: bufmgr.c Log message: bufmgr.c failed to compile on Darwin, because it didn't include where struct timeval is defined. ---(end of broadcast)--- TIP 8: explain analyze is your friend
[COMMITTERS] pgsql-server/src/backend/storage/lmgr proc.c
CVSROOT:/cvsroot Module name:pgsql-server Changes by: [EMAIL PROTECTED] 03/12/20 20:33:33 Modified files: src/backend/storage/lmgr: proc.c Log message: The recent DUMMY_PROCS patch broke accounting for the number of semaphores needed. This caused us to fail all the time on Darwin, and we'd fail for some values of maxBackends on SysV-sema platforms, too. ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
[COMMITTERS] pgsql-server/src backend/access/nbtree/nbtinse ...
CVSROOT:/cvsroot Module name:pgsql-server Changes by: [EMAIL PROTECTED] 03/12/20 21:23:06 Modified files: src/backend/access/nbtree: nbtinsert.c nbtpage.c nbtsearch.c src/include/access: nbtree.h Log message: Improve btree's initial-positioning-strategy code so that we never need to step more than one entry after descending the search tree to arrive at the correct place to start the scan. This can improve the behavior substantially when there are many entries equal to the chosen boundary value. Per suggestion from Dmitry Tkach, 14-Jul-03. ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings
[COMMITTERS] pgsql-server/src/backend/access/nbtree nbtsearch.c
CVSROOT:/cvsroot Module name:pgsql-server Changes by: [EMAIL PROTECTED] 03/12/20 23:00:04 Modified files: src/backend/access/nbtree: nbtsearch.c Log message: Previous change exposed some opportunities for further simplification in _bt_first(). ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
[COMMITTERS] pgsql-server/src/backend/storage/ipc shmem.c
CVSROOT:/cvsroot Module name:pgsql-server Changes by: [EMAIL PROTECTED] 03/12/21 00:30:10 Modified files: src/backend/storage/ipc: shmem.c Log message: [ This description should have been on the earlier fork/exec commit, but I am adding it now so it is in CVS.] The patch basically is a slight rearrangement of the code to allow fork/exec on Unix, with the ultimate goal of doing CreateProcess on Win32. The changes are: o Write out postmaster global variables and per-backend variables to be read by the exec'ed backend o Mark some static variables as global when exec is used so then can be dumped from postmaster.c, marked NON_EXEC_STATIC o Remove value passing with -p now that we have per-backend file o Move some pointer storage out of shared memory for easier dumping. o Modified pgsql_temp directory cleanup to handle per-database directories and the backend exec directory under datadir. Claudio Natoli ---(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
[COMMITTERS] pgsql-server/ oc/src/sgml/datatype.sgml rc/bac ...
CVSROOT:/cvsroot Module name:pgsql-server Changes by: [EMAIL PROTECTED] 03/12/21 00:34:36 Modified files: doc/src/sgml : datatype.sgml src/backend/commands: variable.c src/backend/utils/adt: datetime.c src/include: miscadmin.h src/interfaces/ecpg/pgtypeslib: dt.h dt_common.c interval.c Log message: Back out: > Attached is a patch that addressed all the discussed issues > that did not break backward compatability, including the > ability to output ISO-8601 compliant intervals by setting > datestyle to iso8601basic. ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
[COMMITTERS] pgsql-server/ /HISTORY oc/src/sgml/release.sgml
CVSROOT:/cvsroot Module name:pgsql-server Changes by: [EMAIL PROTECTED] 03/12/21 01:23:36 Modified files: . : HISTORY doc/src/sgml : release.sgml Log message: Update 7.4.1 release notes in preparation for release. ---(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
[COMMITTERS] pgsql-server/ /Tag: /REL7_4_STABLE /HISTORY oc ...
CVSROOT:/cvsroot Module name:pgsql-server Changes by: [EMAIL PROTECTED] 03/12/21 01:24:00 Modified files: . : Tag: REL7_4_STABLE HISTORY doc/src/sgml : Tag: REL7_4_STABLE release.sgml Log message: Update 7.4.1 release notes in preparation for release. ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
