aboutsummaryrefslogtreecommitdiff
Commit message (Collapse)AuthorAge
...
* Add NOWAIT option to LOCK commandTatsuo Ishii2004-03-11
|
* Move non-blocking code into its own /port file, for code clarity.Bruce Momjian2004-03-10
|
* Fix a typo.Neil Conway2004-03-10
|
* Improvements to README.CVSNeil Conway2004-03-10
|
* Remove HISTORY and INSTALL. Have them generated by the tarball scripts.Bruce Momjian2004-03-10
| | | | Add README.CVS to help CVS folks find this information.
* Tweak some text to avoid using <command>SET</command> as a verb, perNeil Conway2004-03-09
| | | | suggestion from Peter E.
* Add comment for Win32.Bruce Momjian2004-03-09
|
* Remove blank line in Makefile.Bruce Momjian2004-03-09
|
* Add HISTORY/INSTALL clean target to 7.4.X.Bruce Momjian2004-03-09
|
* Build scanner output when making a distribution.Peter Eisentraut2004-03-09
|
* Add documentation for the recent 'ALSO' patch for CREATE RULE. AlongNeil Conway2004-03-09
| | | | the way, fix a typo and make a few SGML cleanups.
* Rebuild HISTORY file to match our official style sheets.Bruce Momjian2004-03-09
|
* Refer to GUC variables using <xref> tags rather than <varname> tags,Neil Conway2004-03-09
| | | | | | where appropriate. Add "id" and "xreflabel" tags to the descriptions of the GUC variables to facilitate this. Also make a few minor docs cleanups.
* Corrects a typo, introduces missing variables, and rearranges theBruce Momjian2004-03-09
| | | | | | | | | | | initialization of stats process under EXEC_BACKEND. [A cleaner, rationalized approach to stat/backend/SSDataBase child processes under EXEC_BACKEND is on my TODO list. However this patch takes care of immediate concerns (ie. stats test now passes under win32)] Claudio Natoli
* Determines the PKGLIBDIR equivalent under win32. Requires pgsql lib andBruce Momjian2004-03-09
| | | | | | | | bin directories to be packaged under the same root directory (eg. <some path>/pgsql/bin and <some path>/pgsql/lib) for the win32 port, which does not appear to be an onerous restriction. Claudio Natoli
* Add ALSO keyword to CREATE RULE.Bruce Momjian2004-03-09
| | | | Fabien COELHO
* Make a separate win32 debug DLL along with the non-debug version:Bruce Momjian2004-03-09
| | | | | | | | | | | | | | | | | | | Currently, src/interfaces/libpq/win32.mak builds a statically-linked library "libpq.lib", a debug dll "libpq.dll", import library for the debug dll "libpqdll.lib", a release dll "libpq.dll", import library for the release dll "libpqdll.lib". To avoid naming clashes, I would make the debug dll and import libraries "libpqd.dll" and "libpqddll.lib". Basically, the debug build uses the cl flags: "/MDd /D _DEBUG", and the release build uses the cl flags "/MD /D NDEBUG". Usually the debug build has a "D" suffix on the file name, so for example: libpqd.dll libpq, debug build libpqd.lib libpq, debug build, import library libpq.dll libpq, release build libpq.lib libpq, release build, import library David Turner
* The win32 port backend will require the functionality provided byBruce Momjian2004-03-09
| | | | | | canonicalize_path. Patch moves it from initdb.c to port/path.c. Claudio Natoli
* Done:Bruce Momjian2004-03-09
| | | | > * -Allow log lines to include session-level information, like database and user
* Add:Bruce Momjian2004-03-09
| | | | | | | | | | | | | #log_line_prefix = '' # e.g. '<%u%%%d> ' # %u=user name %d=database name # %r=remote host and port # %p=PID %t=timestamp %i=command tag # %c=session id %l=session line number # %s=session start timestamp # %x=stop here in non-session processes # %%='%' Andrew Dunstan
* I wanted to submit some changes to the bundled postgres startupBruce Momjian2004-03-09
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | script for Mac OS X. I added calls to utilize the bundled apache rotatelogs script in the DB startup for log rotation. Also modified startup parameters file to allow using the "SystemStarter" utility to start/stop/restart postgres with a rotating log file. The script credits David Wheeler, 2002. I wrote him a message about the changes an he suggested I post them here. I explain some of the changes below. Not sure how to submit the changes. I have 3 files, "PostgreSQL" script, "StartupParameters.plist" file, "pg_startupscript.diff" file. The diff file was run against the original "PostgreSQL" script file. I'll try attaching them to this message. If they get filtered I can resend if needed. Thanks. Ray A. ------------------------------------ 1) Changed the "Provides" parameter in StartupParameters.plist to "PostgreSQL" from "postgres database" simply for ease of typing. It seems that the SystemStarter utility uses the "Provides" value if you want to control the script. This way I did not have to enclose it in quotes on commandline. The modified StartupParameters.plist is now an XML document also. 2) For the startup script I added 2 user modifiable variables: # do you want to rotate the log files, 1=true 0=false ROTATELOGS=1 # logfile rotate in seconds ROTATESEC="604800" I also added a non modifiable variable: # The apache log rotation utility LOGUTIL="/usr/sbin/rotatelogs" I modified the StartService and RestartService functions to execute the new commands if the user wants log rotation. Ray Aspeitia
* Have SGML make clean remove text files output as wellBruce Momjian2004-03-08
|
* Add comment about why ON COMMENT in non-current database throws just anBruce Momjian2004-03-08
| | | | warning.
* Update German FAQ.Bruce Momjian2004-03-08
| | | | Ian Barwick
* Test for whether a previous IN join restricts the current join was tooTom Lane2004-03-08
| | | | | strict, per discussion with Dennis Haney. Also, rearrange the preceding tests to avoid redundancy.
* Some editorial work on 7.4.2 release notes.Tom Lane2004-03-07
|
* contrib/xml2 updates from John Gray:Neil Conway2004-03-07
| | | | | | I have changed the name of the new parse function to xml_valid and fixed a reference to SortMem which meant that the code as supplied would work against 7.3 and 7.4 but wouldn't work in CVS.
* Added multidimensional arrays as todo for ecpg.Michael Meskes2004-03-07
|
* When testing usability of a partial index, recognize that an indexTom Lane2004-03-07
| | | | | | | predicate of the form 'foo IS NOT NULL' is implied by a WHERE clause that uses 'foo' in any strict operator or function. Per suggestion and preliminary implementation by John Siracusa; some further hacking by moi.
* Improve discussion of using OIDs for identifying rows, fix an instance ofNeil Conway2004-03-07
| | | | incorrect SGML markup.
* Added new versions of dblink, dblink_exec, dblink_open, dblink_close,Joe Conway2004-03-07
| | | | | | and, dblink_fetch -- allows ERROR on remote side of connection to throw NOTICE locally instead of ERROR. Also removed documentation for previously deprecated, now removed, functions.
* Explicitely mention that some GUC variables cannot be changed atNeil Conway2004-03-07
| | | | runtime.
* Editorialization of some text discussing 'IS NULL' vs. '= NULL'.Neil Conway2004-03-07
|
* Use lynx -stdin and regenerate HISTORYBruce Momjian2004-03-06
|
* Improve documentation of virtual_host parameter: old text failed toTom Lane2004-03-05
| | | | indicate that you could specify multiple listen addresses.
* Have makefile reference /xml2.Bruce Momjian2004-03-05
|
* First update of release notes for 7.4.2. Still needs work.Bruce Momjian2004-03-05
|
* Oops, '-' doesn't work for my lynx either.Bruce Momjian2004-03-05
| | | | | Change back to /dev/stdin, even though it isn't portable. Let's wait for someone to complain they don't have /dev/stdin.
* Use '-' for stdin on lynx, my lynx version doesn't support -stdin.Bruce Momjian2004-03-05
|
* Update Polish FAQ, from Marcin Mazurek.Bruce Momjian2004-03-05
|
* Add xml2 as skipped /contrib Makefile entry.Bruce Momjian2004-03-05
|
* Add mention xml2 is a newer version.Bruce Momjian2004-03-05
|
* Add missing xml files.Bruce Momjian2004-03-05
|
* Move new version of contrib/ xml into xml2, keep old version in /xml.Bruce Momjian2004-03-05
|
* Thanks to the generous support of Torchbox (http://www.torchbox.com), IBruce Momjian2004-03-05
| | | | | | | | | | | | | | | | | | | | | | | | | | | | have been able to significantly improve the contrib/xml XPath integration code. New features: * XPath set-returning function allows multiple results from an several XPath queries to be used as a virtual table. * Using libxslt, XSLT transformations (with and without parameters) are supported. (Caution: This support allows generic URL fetching from within the backend as well). I've removed the old code so that it is all libxml based. Rather than attach as a patch, I've put the tar.gz (10k!) at http://www.azuli.co.uk/pgxml-1.0.tar.gz (all files in archive are xml/....). I think this is worth replacing the contrib version with, even though the function names have changed (though the same functionality is there), because it includes a SRF and some SPI usage, in addition to linking to an external library. And it isn't a big module! Obviously, I understand that people might prefer to move it elsewhere, or might have reservations about replacing an existing contrib module with an incompatible one. I'm open to suggestions. John Gray
* Per a brief conversation with Tom, I've created a patch for addingBruce Momjian2004-03-05
| | | | | | | | | support for 'week' within the date_trunc function. Within the patch I added a couple of test cases and associated target output, and changed the documentation to add 'week' appropriately. Robert Creager
* libpq's query to get the OIDs of large-object support functions was notTom Lane2004-03-05
| | | | | schema-safe. Make it so, and improve the internal support for knowledge of server version.
* Win32:Bruce Momjian2004-03-05
| | | | | | | | | | | | | * Mostly, casting etc to remove compilation warnings in win32 only code. * main.c: set _IONBF to stdout/stderr under win32 (under win32, _IOLBF defaults to full buffering) * pg_resetxlog/Makefile: ensures dirmod.o gets cleaned (got bitten by this when, after "make clean"ing, switching compilation between Ming + Cygwin) Claudio Natoli
* Fix for underscore in ID sgml markup.Bruce Momjian2004-03-05
|
* Add new SPI functions for use by PL/Java:Bruce Momjian2004-03-05
| | | | | | | | +extern Oid SPI_getargtypeid(void *plan, int argIndex); +extern int SPI_getargcount(void *plan); +extern bool SPI_is_cursor_plan(void *plan); Thomas Hallgren