summaryrefslogtreecommitdiff
AgeCommit message (Collapse)Author
2004-03-09Build scanner output when making a distribution.Peter Eisentraut
2004-03-09Add documentation for the recent 'ALSO' patch for CREATE RULE. AlongNeil Conway
the way, fix a typo and make a few SGML cleanups.
2004-03-09Rebuild HISTORY file to match our official style sheets.Bruce Momjian
2004-03-09Refer to GUC variables using <xref> tags rather than <varname> tags,Neil Conway
where appropriate. Add "id" and "xreflabel" tags to the descriptions of the GUC variables to facilitate this. Also make a few minor docs cleanups.
2004-03-09Corrects a typo, introduces missing variables, and rearranges theBruce Momjian
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
2004-03-09Determines the PKGLIBDIR equivalent under win32. Requires pgsql lib andBruce Momjian
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
2004-03-09Add ALSO keyword to CREATE RULE.Bruce Momjian
Fabien COELHO
2004-03-09Make a separate win32 debug DLL along with the non-debug version:Bruce Momjian
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
2004-03-09The win32 port backend will require the functionality provided byBruce Momjian
canonicalize_path. Patch moves it from initdb.c to port/path.c. Claudio Natoli
2004-03-09Done:Bruce Momjian
> * -Allow log lines to include session-level information, like database and user
2004-03-09Add:Bruce Momjian
#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
2004-03-09I wanted to submit some changes to the bundled postgres startupBruce Momjian
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
2004-03-08Have SGML make clean remove text files output as wellBruce Momjian
2004-03-08Add comment about why ON COMMENT in non-current database throws just anBruce Momjian
warning.
2004-03-08Update German FAQ.Bruce Momjian
Ian Barwick
2004-03-08Test for whether a previous IN join restricts the current join was tooTom Lane
strict, per discussion with Dennis Haney. Also, rearrange the preceding tests to avoid redundancy.
2004-03-07Some editorial work on 7.4.2 release notes.Tom Lane
2004-03-07contrib/xml2 updates from John Gray:Neil Conway
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.
2004-03-07Added multidimensional arrays as todo for ecpg.Michael Meskes
2004-03-07When testing usability of a partial index, recognize that an indexTom Lane
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.
2004-03-07Improve discussion of using OIDs for identifying rows, fix an instance ofNeil Conway
incorrect SGML markup.
2004-03-07Added new versions of dblink, dblink_exec, dblink_open, dblink_close,Joe Conway
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.
2004-03-07Explicitely mention that some GUC variables cannot be changed atNeil Conway
runtime.
2004-03-07Editorialization of some text discussing 'IS NULL' vs. '= NULL'.Neil Conway
2004-03-06Use lynx -stdin and regenerate HISTORYBruce Momjian
2004-03-05Improve documentation of virtual_host parameter: old text failed toTom Lane
indicate that you could specify multiple listen addresses.
2004-03-05Have makefile reference /xml2.Bruce Momjian
2004-03-05First update of release notes for 7.4.2. Still needs work.Bruce Momjian
2004-03-05Oops, '-' doesn't work for my lynx either.Bruce Momjian
Change back to /dev/stdin, even though it isn't portable. Let's wait for someone to complain they don't have /dev/stdin.
2004-03-05Use '-' for stdin on lynx, my lynx version doesn't support -stdin.Bruce Momjian
2004-03-05Update Polish FAQ, from Marcin Mazurek.Bruce Momjian
2004-03-05Add xml2 as skipped /contrib Makefile entry.Bruce Momjian
2004-03-05Add mention xml2 is a newer version.Bruce Momjian
2004-03-05Add missing xml files.Bruce Momjian
2004-03-05Move new version of contrib/ xml into xml2, keep old version in /xml.Bruce Momjian
2004-03-05Thanks to the generous support of Torchbox (http://www.torchbox.com), IBruce Momjian
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
2004-03-05Per a brief conversation with Tom, I've created a patch for addingBruce Momjian
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
2004-03-05libpq's query to get the OIDs of large-object support functions was notTom Lane
schema-safe. Make it so, and improve the internal support for knowledge of server version.
2004-03-05Win32:Bruce Momjian
* 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
2004-03-05Fix for underscore in ID sgml markup.Bruce Momjian
2004-03-05Add new SPI functions for use by PL/Java:Bruce Momjian
+extern Oid SPI_getargtypeid(void *plan, int argIndex); +extern int SPI_getargcount(void *plan); +extern bool SPI_is_cursor_plan(void *plan); Thomas Hallgren
2004-03-05Fix log_executor_stats for non-multi queries. Backpatch to 7.4.X.Bruce Momjian
2004-03-04Emit a warning when an empty string is input to the oid, float4, andNeil Conway
float8 types. This begins the deprecation of this feature: in 7.6, this input will be rejected. Also added a new error code for warnings about deprecated features, and updated the regression tests.
2004-03-04The trim function doc did not say that the second argument could beDennis Bjorklund
be omitted. This patch fixes that. It also fixes a bug where the type text was not wrapped as <type>text</type>.
2004-03-04Better document INSTEAD behavior for rules.Bruce Momjian
2004-03-04- Fixed segfault due to missing check for variable declaration.Michael Meskes
- Added check for multidimensional array usage.
2004-03-03Add a few more cross-references where appropriate, add more text aboutNeil Conway
the FROM clause and an example to the UPDATE reference page, and make a few other SGML tweaks.
2004-03-03Modify pg_dump so that the preferred dump order is by name withinTom Lane
object types, rather than by OID. This should help ensure consistent dump output from databases that are logically the same but have different histories, per recent discussion about 'diffing' databases. The patch is bulky because of renaming of fields, but not very complicated. Also, do some tweaking to cause BLOB restoration to be done in a better order, and clean up pg_restore's textual output to exactly match pg_dump.
2004-03-03Fix wording of new bison warning, per Peter.Bruce Momjian
2004-03-03Remove Jan:Bruce Momjian
< o Add PL/PHP (Joe, Jan) > o Add PL/PHP (Joe)
generated by cgit v1.2.3 (git 2.46.0) at 2025-10-31 22:07:33 +0000