3d642ae | Bruce Momjian | 09 August 2004, 03:12:38 UTC | Fix Win32 pg_dumpall check. | 09 August 2004, 03:12:38 UTC |
bc1ca75 | Bruce Momjian | 09 August 2004, 02:12:51 UTC | Improve comment. | 09 August 2004, 02:12:51 UTC |
b942e87 | Bruce Momjian | 09 August 2004, 01:55:42 UTC | Stamp libpq.rc with 8.0 version. | 09 August 2004, 01:55:42 UTC |
708de81 | PostgreSQL Daemon | 08 August 2004, 23:27:11 UTC | tag her configure 8.0.0beta1 ... | 08 August 2004, 23:27:11 UTC |
82fde1a | Tom Lane | 08 August 2004, 22:40:46 UTC | Add note pointing out the difference in semantics between Oracle and plpgsql EXCEPTION blocks. | 08 August 2004, 22:40:46 UTC |
35a5fb6 | Tom Lane | 08 August 2004, 21:33:11 UTC | Move expanded discussion of inheritance's limitations out of tutorial and into ddl.sgml. Rewrite for more completeness and (hopefully) clarity. | 08 August 2004, 21:33:11 UTC |
33bf242 | Tom Lane | 08 August 2004, 20:17:36 UTC | Make listen_addresses be a comma-separated list instead of a space-separated list. More consistent with our other list-containing GUC variables. | 08 August 2004, 20:17:36 UTC |
dc199ea | Tom Lane | 08 August 2004, 19:42:57 UTC | Document background writer control parameters, do some editorial work on other recent changes in runtime parameter list. | 08 August 2004, 19:42:57 UTC |
faafbae | Tom Lane | 08 August 2004, 16:13:05 UTC | If these are ifdef WIN32 in the .c file, should be so in .h as well. | 08 August 2004, 16:13:05 UTC |
d5fc378 | Bruce Momjian | 08 August 2004, 15:37:06 UTC | Disable vacuum delay, as discussed on hackers. | 08 August 2004, 15:37:06 UTC |
640d0dc | Bruce Momjian | 08 August 2004, 07:00:22 UTC | Fix compiler warning in the proper way. | 08 August 2004, 07:00:22 UTC |
6ec4520 | Bruce Momjian | 08 August 2004, 06:58:00 UTC | Supress warning about zero-length format string. | 08 August 2004, 06:58:00 UTC |
7ee3c35 | Bruce Momjian | 08 August 2004, 06:44:36 UTC | Allow libpgport to call memory allocation routines even though CurrentMemoryContext is DLLIMPORT on Win32. Work around that by creating stubs in the backend for palloc/pstrdup. Also fix pg_dumpall to do proper quoting on Win32. | 08 August 2004, 06:44:36 UTC |
881ea47 | Joe Conway | 08 August 2004, 06:03:36 UTC | Another array syntax change (whitespace) clarification -- this time in the release notes. | 08 August 2004, 06:03:36 UTC |
4187adc | Joe Conway | 08 August 2004, 05:55:55 UTC | Minor clarification of documentation regarding trailing whitespace. | 08 August 2004, 05:55:55 UTC |
da8325f | Joe Conway | 08 August 2004, 05:46:40 UTC | Updated release notes for recent array syntax changes. | 08 August 2004, 05:46:40 UTC |
8120ff6 | Bruce Momjian | 08 August 2004, 05:19:44 UTC | More Win32 zic build cleanups now that we have symlinks, it needs help. | 08 August 2004, 05:19:44 UTC |
e81cbc2 | Bruce Momjian | 08 August 2004, 05:04:41 UTC | Adjust defines to be consistent. | 08 August 2004, 05:04:41 UTC |
cb50ee2 | Joe Conway | 08 August 2004, 05:01:55 UTC | Tighened up syntax checking of array input processing considerably. Junk that was previously allowed in odd places with odd results now causes an ERROR. Also changed behavior with respect to whitespace -- trailing whitespace is now ignored as well as leading whitespace (which has always been ignored). Documentation updated to reflect change in whitespace handling. Also some refactoring to what I believe is a more sensible order of several paragraphs. | 08 August 2004, 05:01:55 UTC |
988d84f | Bruce Momjian | 08 August 2004, 04:53:41 UTC | Another zic cleanup . | 08 August 2004, 04:53:41 UTC |
8e953e6 | Tom Lane | 08 August 2004, 04:34:43 UTC | Update admin guide's discussion of WAL to match present reality. | 08 August 2004, 04:34:43 UTC |
68993b6 | Bruce Momjian | 08 August 2004, 03:57:35 UTC | Link in dirmod specially for zic so it works on Win32. | 08 August 2004, 03:57:35 UTC |
dc94d4a | Bruce Momjian | 08 August 2004, 03:51:20 UTC | Remove xstrdup and friends who were only called once. Replace with #ifdef calls. | 08 August 2004, 03:51:20 UTC |
7dca975 | Tom Lane | 08 August 2004, 03:22:08 UTC | Add a comment about why we always replay backup blocks from WAL. | 08 August 2004, 03:22:08 UTC |
fd62065 | Bruce Momjian | 08 August 2004, 03:21:39 UTC | Fix Win32 pg_dumpall, with help from Claudio. | 08 August 2004, 03:21:39 UTC |
2732932 | Bruce Momjian | 08 August 2004, 02:22:55 UTC | Improve comment. | 08 August 2004, 02:22:55 UTC |
6c3561b | Tom Lane | 08 August 2004, 02:05:32 UTC | Minor editorialization on example --- I think that the use of dollar quoting in this case is just needless obscurantism. | 08 August 2004, 02:05:32 UTC |
ff9d69d | Bruce Momjian | 08 August 2004, 01:52:14 UTC | This patch adds SQL2003 to the set of standards with which PostgreSQL is attempting to comply. David Fetter | 08 August 2004, 01:52:14 UTC |
2539edc | Bruce Momjian | 08 August 2004, 01:51:05 UTC | This adds a caveat to the inheritance part of the tutorial. David Fetter | 08 August 2004, 01:51:05 UTC |
0236b5e | Bruce Momjian | 08 August 2004, 01:49:30 UTC | This patch adds an example to the CREATE DOMAIN docs. David Fetter | 08 August 2004, 01:49:30 UTC |
ff8d68d | Bruce Momjian | 08 August 2004, 01:48:31 UTC | Included is an example of using savepoints in a non-trivial example. Giving examples in the SQL command reference is hard because we don't have conditionals at the SQL level. Gavin Sherry | 08 August 2004, 01:48:31 UTC |
51fa8b0 | Bruce Momjian | 08 August 2004, 01:43:33 UTC | Fix comment. | 08 August 2004, 01:43:33 UTC |
5e01aa7 | Bruce Momjian | 08 August 2004, 01:31:15 UTC | Fixups for Win32 symlinks. | 08 August 2004, 01:31:15 UTC |
9b3caeb | Tom Lane | 08 August 2004, 00:50:58 UTC | Update plpgsql documentation for 8.0 (mostly, make use of named function parameters and dollar quoting in examples; do some polishing of the existing dollar-quoting docs). The 'how to port from Oracle' section is looking pretty respectable these days ... | 08 August 2004, 00:50:58 UTC |
53e8bec | Bruce Momjian | 07 August 2004, 21:48:09 UTC | The attached patch implements a symlink for win32 using junctions, and uses that for win32 tablespaces. Andreas Pflug | 07 August 2004, 21:48:09 UTC |
27fedc8 | Tom Lane | 07 August 2004, 20:44:50 UTC | Improve privileges discussion (mostly, mention grant options). | 07 August 2004, 20:44:50 UTC |
82433e9 | Tom Lane | 07 August 2004, 19:53:48 UTC | Update a couple of example error messages to reflect the fact that we don't generate constraint names like "$1" anymore. | 07 August 2004, 19:53:48 UTC |
c71e3de | Tom Lane | 07 August 2004, 19:14:45 UTC | Improve markup a little. | 07 August 2004, 19:14:45 UTC |
c2f14a7 | Tom Lane | 07 August 2004, 19:02:43 UTC | Improve tablespace discussion, and bring it up to date with code. | 07 August 2004, 19:02:43 UTC |
ff2c895 | Bruce Momjian | 07 August 2004, 18:07:46 UTC | Update pitr docs to mention inclusive/exclusive xid specification | 07 August 2004, 18:07:46 UTC |
d48d866 | Tom Lane | 07 August 2004, 17:55:59 UTC | Remove bogus trailing dot from eventlog output, per Andreas. Clean up README file a bit. | 07 August 2004, 17:55:59 UTC |
b2b5656 | Tom Lane | 07 August 2004, 17:40:49 UTC | Don't try to rewrite NEW references in a utility statement in a rule. There won't be any, and in fact there won't even be an RTE for NEW, which was leading to a core dump in CVS tip. 7.4 and earlier manage not to crash when applying ResolveNew in this scenario, but I think it was just good fortune that they didn't. Per report from Bernd Helmle. | 07 August 2004, 17:40:49 UTC |
752089e | Bruce Momjian | 07 August 2004, 12:21:25 UTC | Fix markup. | 07 August 2004, 12:21:25 UTC |
21d1612 | Bruce Momjian | 07 August 2004, 03:36:07 UTC | Ignore trailing spaces in psql \h. Greg Sabino Mullane | 07 August 2004, 03:36:07 UTC |
a1c2ed7 | Bruce Momjian | 07 August 2004, 03:21:11 UTC | Mention that transactions can complete in a different numeric order, for PITR recovery. | 07 August 2004, 03:21:11 UTC |
ddb2508 | Jan Wieck | 07 August 2004, 03:08:49 UTC | Vacuum delay activated by default. Jan | 07 August 2004, 03:08:49 UTC |
8ac6de3 | Bruce Momjian | 07 August 2004, 01:58:12 UTC | Add: > * Create dump tool for write-ahead logs for use in determining > transaction id for point-in-time recovery | 07 August 2004, 01:58:12 UTC |
deb15b5 | Bruce Momjian | 07 August 2004, 01:04:50 UTC | Document delay as 0, per Matthew T. O'Connor | 07 August 2004, 01:04:50 UTC |
f8450bb | Tom Lane | 06 August 2004, 23:33:48 UTC | Some editorial work on the 8.0 release notes. Update for recent commits, improve existing descriptions. | 06 August 2004, 23:33:48 UTC |
220ec93 | Tom Lane | 06 August 2004, 19:17:31 UTC | Arrange for proper newline termination of syslogger's own messages, per Andreas. | 06 August 2004, 19:17:31 UTC |
18661f2 | Tom Lane | 06 August 2004, 18:18:42 UTC | Revert badly-broken patch to dump comments on composite-type columns. | 06 August 2004, 18:18:42 UTC |
d6e05af | Bruce Momjian | 06 August 2004, 18:09:15 UTC | I have noticed that the latex format in psql has some bugs: o "_" is not escaped, and causes TeX to abort, thinking it's a subscript outside of maths mode. Most of my table and field names use underscores, so this is a really nasty one. o The column count is calculated using the contents of opt_align. But opt_align has one extra element, and so it's always one too many. I changed it to count the column headings, like all the other output formats. There may be a bug in computing opt_align that this patch does not address, but I'm not yet familiar enough with the psql source to fix this as well. o The line drawing rules for each border setting (0-3) and expanded mode didn't always match the documented behaviour and what other formats (e.g. aligned) did. I made it as conformant as possible, and also tidied the alignment of the first line of the footer, which was incorrectly indented. Roger Leigh | 06 August 2004, 18:09:15 UTC |
7f018ac | Tom Lane | 06 August 2004, 18:05:49 UTC | Use one, not zero, as the default lower bound for arrays of AclItems. This avoids changing the displayed appearance of ACL columns now that array_out decorates its output with bounds information when the lower bound isn't one. Per gripe from Gaetano Mendola. Note that I did not force initdb for this, although any database initdb'd in the last couple of days is going to have some problems. | 06 August 2004, 18:05:49 UTC |
57050f9 | Bruce Momjian | 06 August 2004, 17:52:44 UTC | Modify: > * Un-comment all variables in postgresql.conf 84,85c84,85 < By removing comments we prevent the confusion that commenting a line < returns a modified value to its default, which it does not. > By not showing commented-out variables, we discourage people from > thinking that re-commenting a variable returns it to its default. | 06 August 2004, 17:52:44 UTC |
533bd1d | Tom Lane | 06 August 2004, 16:06:59 UTC | Add _O_TEXT option to dup2 call on Windows, to ensure redirected postmaster stderr is in text mode. Per Andreas. | 06 August 2004, 16:06:59 UTC |
8ae7278 | Tom Lane | 06 August 2004, 16:00:51 UTC | Fix several small Windows compatibility issues, per Andreas. | 06 August 2004, 16:00:51 UTC |
7887726 | Bruce Momjian | 06 August 2004, 15:24:20 UTC | Add: > * Track dependencies in function bodies and recompile/invalidate | 06 August 2004, 15:24:20 UTC |
ab7e8cb | Bruce Momjian | 06 August 2004, 15:12:38 UTC | Add description: > > By removing comments we prevent the confusion that commenting a line > returns a modified value to its default, which it does not. > | 06 August 2004, 15:12:38 UTC |
e6c7206 | Bruce Momjian | 06 August 2004, 15:08:52 UTC | Add: > * Remove comments on postgresql.conf variables | 06 August 2004, 15:08:52 UTC |
0307c09 | Bruce Momjian | 06 August 2004, 04:15:09 UTC | Rename vacuum_cost_naptime to vacuum_cost_delay, with agreement from Jan. | 06 August 2004, 04:15:09 UTC |
bdf8ef6 | Tom Lane | 05 August 2004, 23:32:13 UTC | Create a built-in log rotation program, so that we no longer have to recommend that people go get Apache's rotatelogs program. Additional benefits are that configuration is done through GUC, rather than externally, and that the postmaster can monitor the log rotator and restart it after failure (though we certainly hope that won't happen often). Andreas Pflug, some rework by Tom Lane. | 05 August 2004, 23:32:13 UTC |
b4cd416 | Dennis Bjorklund | 05 August 2004, 06:50:27 UTC | Translation updates | 05 August 2004, 06:50:27 UTC |
4042abb | Dennis Bjorklund | 05 August 2004, 06:43:42 UTC | Translation updates | 05 August 2004, 06:43:42 UTC |
0e13d62 | Joe Conway | 05 August 2004, 03:30:44 UTC | Require that array literals produce "rectangular" arrays, i.e. all the subarrays of a given dimension have the same number of elements/subarrays. Also repair a longstanding undocumented (as far as I can see) ability to explicitly set array bounds in the array literal syntax. It now can deal properly with negative array indicies. Modify array_out so that arrays with non-standard lower bounds (i.e. not 1) are output with the expicit dimension syntax. This fixes a longstanding issue whereby arrays with non-default lower bounds had them changed to default after a dump/reload cycle. Modify regression tests and docs to suit, and add some minimal documentation regarding the explicit dimension syntax. | 05 August 2004, 03:30:44 UTC |
39ec59f | Joe Conway | 05 August 2004, 03:11:55 UTC | Restore behavior of --pgxs option to that of the original shell script. | 05 August 2004, 03:11:55 UTC |
ab6ee1f | Joe Conway | 05 August 2004, 03:10:29 UTC | Move include for Python.h above postgres.h to eliminate compiler warning. | 05 August 2004, 03:10:29 UTC |
a128926 | Bruce Momjian | 04 August 2004, 22:59:42 UTC | Update for 8.0 | 04 August 2004, 22:59:42 UTC |
dcbb5b9 | Dennis Bjorklund | 04 August 2004, 21:55:27 UTC | Use gettext_noop() to mark strings. errmsg() perform the real gettext() later on, so it was called twice before. | 04 August 2004, 21:55:27 UTC |
fcbc438 | Tom Lane | 04 August 2004, 21:34:35 UTC | Label CVS tip as 8.0devel instead of 7.5devel. Adjust various comments and documentation to reference 8.0 instead of 7.5. | 04 August 2004, 21:34:35 UTC |
ecb6813 | Tom Lane | 04 August 2004, 20:58:46 UTC | Add LOG_NOWAIT flag to openlog() call, per my note of 2004-06-24. | 04 August 2004, 20:58:46 UTC |
55dc7fa | Tom Lane | 04 August 2004, 20:53:53 UTC | Fix silly thinko in ALTER COLUMN TYPE. Check for finding expected dependency was looking at wrong columns and so would always fail. Was not exposed by regression tests because we are only testing cases involving built-in (pinned) types and so no actual dependency entry exists to be removed. | 04 August 2004, 20:53:53 UTC |
e84c71b | Tom Lane | 04 August 2004, 20:33:49 UTC | Update oidjoins regression test to match current catalog structure. | 04 August 2004, 20:33:49 UTC |
bb892ce | Tom Lane | 04 August 2004, 20:09:47 UTC | Tweak postmaster code to avoid double reporting when bgwriter crashes. | 04 August 2004, 20:09:47 UTC |
5cc3864 | Tom Lane | 04 August 2004, 19:31:15 UTC | record_out and friends need to cope with dropped columns in the row datatype. Per example from Gaetano Mendola, 2004-07-25. | 04 August 2004, 19:31:15 UTC |
8515efa | Tom Lane | 04 August 2004, 17:37:09 UTC | Add some notes about unimplemented aspects of PITR backup/recovery. | 04 August 2004, 17:37:09 UTC |
576856b | Tom Lane | 04 August 2004, 17:13:03 UTC | Dump comments on columns of composite types. Instead of putting all the OWNER TO commands at the end, it dumps then after each object. This is WAY more readable and nice. ACLs are still at the end. Christopher Kings-Lynne | 04 August 2004, 17:13:03 UTC |
6568d64 | Dennis Bjorklund | 04 August 2004, 16:40:11 UTC | Translation updates | 04 August 2004, 16:40:11 UTC |
b387d16 | Tom Lane | 04 August 2004, 16:25:02 UTC | Make use of backup label/history files to control recovery properly. | 04 August 2004, 16:25:02 UTC |
cedd05e | Tom Lane | 04 August 2004, 16:24:26 UTC | Fix typo in comment. | 04 August 2004, 16:24:26 UTC |
c6d3158 | Dennis Bjorklund | 04 August 2004, 16:05:13 UTC | Add some strings for translation and remove some cut'n'paste that makes it impossible to translate to other languages. | 04 August 2004, 16:05:13 UTC |
020ec16 | Bruce Momjian | 04 August 2004, 16:02:08 UTC | Fix syntax error by adding a space. | 04 August 2004, 16:02:08 UTC |
59ff484 | Tom Lane | 03 August 2004, 23:42:59 UTC | Preliminary documentation for PITR. | 03 August 2004, 23:42:59 UTC |
58c4171 | Tom Lane | 03 August 2004, 20:32:36 UTC | Add functions pg_start_backup, pg_stop_backup to create backup label and history files as per recent discussion. While at it, remove pg_terminate_backend, since we have decided we do not have time during this release cycle to address the reliability concerns it creates. Split the 'Miscellaneous Functions' documentation section into 'System Information Functions' and 'System Administration Functions', which hopefully will draw the eyes of those looking for such things. | 03 August 2004, 20:32:36 UTC |
a83c45c | Tom Lane | 03 August 2004, 15:57:26 UTC | Fix misplacement of savepointLevel test, per report from Chris K-L. | 03 August 2004, 15:57:26 UTC |
929da8e | Peter Eisentraut | 03 August 2004, 08:11:37 UTC | Translation update | 03 August 2004, 08:11:37 UTC |
635018b | Bruce Momjian | 03 August 2004, 01:14:57 UTC | Move dbsize/oid2name to open items list. | 03 August 2004, 01:14:57 UTC |
946fdc0 | Tom Lane | 02 August 2004, 21:42:18 UTC | Fix not-quite-right Assertion. Did not work at all in extended-query mode (per complaint from Kris Jurka) and it was only by chance that it didn't fail in simple-query mode. A COMMIT or ROLLBACK has to be executed by a portal, therefore it's wrong to suppose that there aren't any live portals at CleanupTransaction time. | 02 August 2004, 21:42:18 UTC |
9aa30e7 | Tom Lane | 02 August 2004, 17:03:48 UTC | Actually, there's no need to use pg_strcasecmp for checking exception names, because the name we got from the lexer is already downcased. Just store the table in lower case and use strcmp ... | 02 August 2004, 17:03:48 UTC |
d529989 | Tom Lane | 02 August 2004, 16:51:10 UTC | While perusing SQL92 I realized that we are delivering the wrong SQLSTATE error code for string-too-long errors. It should be STRING_DATA_RIGHT_TRUNCATION not STRING_DATA_LENGTH_MISMATCH. The latter probably should only be applied to cases where a string must be exactly so many bits --- there are no cases at all where it applies to character strings, only bit strings. | 02 August 2004, 16:51:10 UTC |
630bfcd | Peter Eisentraut | 02 August 2004, 15:17:21 UTC | Translation updates | 02 August 2004, 15:17:21 UTC |
082ca46 | Peter Eisentraut | 02 August 2004, 15:11:19 UTC | Translation update | 02 August 2004, 15:11:19 UTC |
b99b094 | Bruce Momjian | 02 August 2004, 12:46:49 UTC | Mark savepoints as supported. | 02 August 2004, 12:46:49 UTC |
e3b8530 | Bruce Momjian | 02 August 2004, 12:34:14 UTC | Readd pg_config --pgxs code. | 02 August 2004, 12:34:14 UTC |
f0efe26 | Tom Lane | 02 August 2004, 04:28:29 UTC | Support USING INDEX TABLESPACE clause for PRIMARY KEY and UNIQUE constraints. Christopher Kings-Lynne. | 02 August 2004, 04:28:29 UTC |
f622c54 | Tom Lane | 02 August 2004, 01:30:51 UTC | Allow DECLARE CURSOR to take parameters from the portal in which it is executed. Previously, the DECLARE would succeed but subsequent FETCHes would fail since the parameter values supplied to DECLARE were not propagated to the portal created for the cursor. In support of this, add type Oids to ParamListInfo entries, which seems like a good idea anyway since code that extracts a value can double-check that it got the type of value it was expecting. Oliver Jowett, with minor editorialization by Tom Lane. | 02 August 2004, 01:30:51 UTC |
410b1df | Tom Lane | 01 August 2004, 20:57:59 UTC | Update the in-code documentation about the transaction system. Move it into a README file instead of being in xact.c's header comment. Alvaro Herrera. | 01 August 2004, 20:57:59 UTC |
d6f8a76 | Tom Lane | 01 August 2004, 20:30:49 UTC | Cause ALTER OWNER commands to update the object's ACL, replacing references to the old owner with the new owner. This is not necessarily right, but it's sure a lot more likely to be what the user wants than doing nothing. Christopher Kings-Lynne, some rework by Tom Lane. | 01 August 2004, 20:30:49 UTC |
35ff782 | Tom Lane | 01 August 2004, 18:07:42 UTC | Add libpgport to postgres.def for Windows build. Per Magnus Hagander. | 01 August 2004, 18:07:42 UTC |
ee2bfaa | Peter Eisentraut | 01 August 2004, 17:54:22 UTC | Translation updates (zh_TW converted to UTF-8) | 01 August 2004, 17:54:22 UTC |
5cc380f | Tom Lane | 01 August 2004, 17:45:43 UTC | Error message style adjustments, per Alvaro Herrera. | 01 August 2004, 17:45:43 UTC |