hcq/postgresql
1
0
Fork 0
mirror of https://git.postgresql.org/git/postgresql.git synced 2026-02-26 08:17:01 +08:00
Code Issues Packages Projects Releases Wiki Activity

Commit Graph

  • 2732932de4 Improve comment. Bruce Momjian 2004-08-08 02:22:55 +00:00
  • 6c3561b9e4 Minor editorialization on example --- I think that the use of dollar quoting in this case is just needless obscurantism. Tom Lane 2004-08-08 02:05:32 +00:00
  • ff9d69d931 This patch adds SQL2003 to the set of standards with which PostgreSQL is attempting to comply. Bruce Momjian 2004-08-08 01:52:14 +00:00
  • 2539edc53f This adds a caveat to the inheritance part of the tutorial. Bruce Momjian 2004-08-08 01:51:05 +00:00
  • 0236b5e07e This patch adds an example to the CREATE DOMAIN docs. Bruce Momjian 2004-08-08 01:49:30 +00:00
  • ff8d68df5c Included is an example of using savepoints in a non-trivial example. Bruce Momjian 2004-08-08 01:48:31 +00:00
  • 51fa8b0120 Fix comment. Bruce Momjian 2004-08-08 01:43:33 +00:00
  • 5e01aa7ad1 Fixups for Win32 symlinks. Bruce Momjian 2004-08-08 01:31:15 +00:00
  • 9b3caebb0a 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 ... Tom Lane 2004-08-08 00:50:58 +00:00
  • 53e8bec717 The attached patch implements a symlink for win32 using junctions, and uses that for win32 tablespaces. Bruce Momjian 2004-08-07 21:48:09 +00:00
  • 27fedc8a5e Improve privileges discussion (mostly, mention grant options). Tom Lane 2004-08-07 20:44:50 +00:00
  • 82433e913c Update a couple of example error messages to reflect the fact that we don't generate constraint names like "$1" anymore. Tom Lane 2004-08-07 19:53:48 +00:00
  • c71e3de264 Improve markup a little. Tom Lane 2004-08-07 19:14:45 +00:00
  • c2f14a7cdf Improve tablespace discussion, and bring it up to date with code. Tom Lane 2004-08-07 19:02:43 +00:00
  • ff2c8950fe Update pitr docs to mention inclusive/exclusive xid specification Bruce Momjian 2004-08-07 18:07:46 +00:00
  • d48d86651c Remove bogus trailing dot from eventlog output, per Andreas. Clean up README file a bit. Tom Lane 2004-08-07 17:55:59 +00:00
  • b2b5656362 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. Tom Lane 2004-08-07 17:40:49 +00:00
  • 752089ea41 Fix markup. Bruce Momjian 2004-08-07 12:21:25 +00:00
  • 21d16121bf Ignore trailing spaces in psql \h. Bruce Momjian 2004-08-07 03:36:07 +00:00
  • a1c2ed7b02 Mention that transactions can complete in a different numeric order, for PITR recovery. Bruce Momjian 2004-08-07 03:21:11 +00:00
  • ddb25082f3 Vacuum delay activated by default. Jan Wieck 2004-08-07 03:08:49 +00:00
  • 8ac6de38f1 Add: Bruce Momjian 2004-08-07 01:58:12 +00:00
  • deb15b55b1 Document delay as 0, per Matthew T. O'Connor Bruce Momjian 2004-08-07 01:04:50 +00:00
  • f8450bb32a Some editorial work on the 8.0 release notes. Update for recent commits, improve existing descriptions. Tom Lane 2004-08-06 23:33:48 +00:00
  • 220ec930fc Arrange for proper newline termination of syslogger's own messages, per Andreas. Tom Lane 2004-08-06 19:17:31 +00:00
  • 18661f282b Revert badly-broken patch to dump comments on composite-type columns. Tom Lane 2004-08-06 18:18:42 +00:00
  • d6e05afc3d I have noticed that the latex format in psql has some bugs: Bruce Momjian 2004-08-06 18:09:15 +00:00
  • 7f018ac1c2 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. Tom Lane 2004-08-06 18:05:49 +00:00
  • 57050f9bdf Modify: Bruce Momjian 2004-08-06 17:52:44 +00:00
  • 533bd1d5a7 Add _O_TEXT option to dup2 call on Windows, to ensure redirected postmaster stderr is in text mode. Per Andreas. Tom Lane 2004-08-06 16:06:59 +00:00
  • 8ae7278ced Fix several small Windows compatibility issues, per Andreas. Tom Lane 2004-08-06 16:00:51 +00:00
  • 78877260e6 Add: Bruce Momjian 2004-08-06 15:24:20 +00:00
  • ab7e8cba58 Add description: Bruce Momjian 2004-08-06 15:12:38 +00:00
  • e6c7206356 Add: Bruce Momjian 2004-08-06 15:08:52 +00:00
  • 0307c09cf5 Rename vacuum_cost_naptime to vacuum_cost_delay, with agreement from Jan. Bruce Momjian 2004-08-06 04:15:09 +00:00
  • bdf8ef6925 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. Tom Lane 2004-08-05 23:32:13 +00:00
  • b4cd416ab0 Translation updates Dennis Bjorklund 2004-08-05 06:50:27 +00:00
  • 4042abba10 Translation updates Dennis Bjorklund 2004-08-05 06:43:42 +00:00
  • 0e13d627be Require that array literals produce "rectangular" arrays, i.e. all the subarrays of a given dimension have the same number of elements/subarrays. Joe Conway 2004-08-05 03:30:44 +00:00
  • 39ec59f30f Restore behavior of --pgxs option to that of the original shell script. Joe Conway 2004-08-05 03:11:55 +00:00
  • ab6ee1f9fc Move include for Python.h above postgres.h to eliminate compiler warning. Joe Conway 2004-08-05 03:10:29 +00:00
  • a128926e89 Update for 8.0 Bruce Momjian 2004-08-04 22:59:42 +00:00
  • dcbb5b9d2d Use gettext_noop() to mark strings. errmsg() perform the real gettext() later on, so it was called twice before. Dennis Bjorklund 2004-08-04 21:55:27 +00:00
  • fcbc438727 Label CVS tip as 8.0devel instead of 7.5devel. Adjust various comments and documentation to reference 8.0 instead of 7.5. Tom Lane 2004-08-04 21:34:35 +00:00
  • ecb68138e9 Add LOG_NOWAIT flag to openlog() call, per my note of 2004-06-24. Tom Lane 2004-08-04 20:58:46 +00:00
  • 55dc7faea2 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. Tom Lane 2004-08-04 20:53:53 +00:00
  • e84c71b4e6 Update oidjoins regression test to match current catalog structure. Tom Lane 2004-08-04 20:33:49 +00:00
  • bb892cecf9 Tweak postmaster code to avoid double reporting when bgwriter crashes. Tom Lane 2004-08-04 20:09:47 +00:00
  • 5cc38649d4 record_out and friends need to cope with dropped columns in the row datatype. Per example from Gaetano Mendola, 2004-07-25. Tom Lane 2004-08-04 19:31:15 +00:00
  • 8515efa128 Add some notes about unimplemented aspects of PITR backup/recovery. Tom Lane 2004-08-04 17:37:09 +00:00
  • 576856b698 Dump comments on columns of composite types. Tom Lane 2004-08-04 17:13:03 +00:00
  • 6568d64350 Translation updates Dennis Bjorklund 2004-08-04 16:40:11 +00:00
  • b387d16f96 Make use of backup label/history files to control recovery properly. Tom Lane 2004-08-04 16:25:02 +00:00
  • cedd05ed8c Fix typo in comment. Tom Lane 2004-08-04 16:24:26 +00:00
  • c6d3158f4f Add some strings for translation and remove some cut'n'paste that makes it impossible to translate to other languages. Dennis Bjorklund 2004-08-04 16:05:13 +00:00
  • 020ec1629b Fix syntax error by adding a space. Bruce Momjian 2004-08-04 16:02:08 +00:00
  • 59ff484894 Preliminary documentation for PITR. Tom Lane 2004-08-03 23:42:59 +00:00
  • 58c41712d5 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. Tom Lane 2004-08-03 20:32:36 +00:00
  • a83c45c4c6 Fix misplacement of savepointLevel test, per report from Chris K-L. Tom Lane 2004-08-03 15:57:26 +00:00
  • 929da8e7f2 Translation update Peter Eisentraut 2004-08-03 08:11:37 +00:00
  • 635018b77e Move dbsize/oid2name to open items list. Bruce Momjian 2004-08-03 01:14:57 +00:00
  • 946fdc000e 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. Tom Lane 2004-08-02 21:42:18 +00:00
  • 9aa30e7109 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 ... Tom Lane 2004-08-02 17:03:48 +00:00
  • d529989149 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. Tom Lane 2004-08-02 16:51:10 +00:00
  • 630bfcd10c Translation updates Peter Eisentraut 2004-08-02 15:17:21 +00:00
  • 082ca46df9 Translation update Peter Eisentraut 2004-08-02 15:11:19 +00:00
  • b99b094487 Mark savepoints as supported. Bruce Momjian 2004-08-02 12:46:49 +00:00
  • e3b8530cc3 Readd pg_config --pgxs code. Bruce Momjian 2004-08-02 12:34:14 +00:00
  • f0efe26402 Support USING INDEX TABLESPACE clause for PRIMARY KEY and UNIQUE constraints. Christopher Kings-Lynne. Tom Lane 2004-08-02 04:28:29 +00:00
  • f622c54049 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. Tom Lane 2004-08-02 01:30:51 +00:00
  • 410b1dfb88 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. Tom Lane 2004-08-01 20:57:59 +00:00
  • d6f8a76cf2 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. Tom Lane 2004-08-01 20:30:49 +00:00
  • 35ff782d71 Add libpgport to postgres.def for Windows build. Per Magnus Hagander. Tom Lane 2004-08-01 18:07:42 +00:00
  • ee2bfaa3aa Translation updates (zh_TW converted to UTF-8) Peter Eisentraut 2004-08-01 17:54:22 +00:00
  • 5cc380f9a3 Error message style adjustments, per Alvaro Herrera. Tom Lane 2004-08-01 17:45:43 +00:00
  • efcaf1e868 Some mop-up work for savepoints (nested transactions). Store a small number of active subtransaction XIDs in each backend's PGPROC entry, and use this to avoid expensive probes into pg_subtrans during TransactionIdIsInProgress. Extend EOXactCallback API to allow add-on modules to get control at subxact start/end. (This is deliberately not compatible with the former API, since any uses of that API probably need manual review anyway.) Add basic reference documentation for SAVEPOINT and related commands. Minor other cleanups to check off some of the open issues for subtransactions. Alvaro Herrera and Tom Lane. Tom Lane 2004-08-01 17:32:22 +00:00
  • 9d9cdf82a4 Some name cleanup. Bruce Momjian 2004-08-01 14:08:08 +00:00
  • b6a40d895e Small pg_config.c cleanup. Bruce Momjian 2004-08-01 14:01:36 +00:00
  • 48187a1dea Fix : Bruce Momjian 2004-08-01 13:55:12 +00:00
  • 72e7f0d48a Add missing file. Bruce Momjian 2004-08-01 13:54:05 +00:00
  • cc07f8cfe7 Create a C version of pg_config. Bruce Momjian 2004-08-01 06:56:39 +00:00
  • 7510ac6203 Minor adjustments for dirmod.c. Bruce Momjian 2004-08-01 06:22:38 +00:00
  • ca9540d34f Add docs for initdb --auth. Bruce Momjian 2004-08-01 06:19:26 +00:00
  • e7029b2127 >I got a new idea on this. I think we should add an initdb option that >takes a string to specify the local authentication method: > > initdb --auth 'ident' > >or whatever the user wants. I think this is more flexible and more >compact. It would default to 'trust', and the packagers could >set it to >whatever they want. If their OS supports local ident, they can use >that. > >Also keep in mind you might want some ident map file: > > initdb --auth 'ident mymap' > >so you would need to allow multiple words in the string. Bruce Momjian 2004-08-01 05:59:13 +00:00
  • 9d623ed252 Minor release wording improvments. Bruce Momjian 2004-08-01 05:22:26 +00:00
  • 5b0d5ea92d Add descriptions to TODO items and make adjustments based on 7.5. Bruce Momjian 2004-08-01 05:15:58 +00:00
  • 6e5e78241b Remove pool discussion. All old stuff. Bruce Momjian 2004-08-01 04:53:38 +00:00
  • 9c8d0850c3 Support "OR condition ..." in plpgsql EXCEPTION clauses to make the syntax more nearly Oracle-equivalent. Allow matching by category as well as specific error code. Document the set of available condition names (or more accurately, synchronize it with the existing documentation). In passing, update errcodes.sgml to include codes added during 7.5 development. Tom Lane 2004-07-31 23:04:58 +00:00
  • ad4d2e9711 Be more consistent about reporting SPI errors in the various PLs. Create a shared function to convert a SPI error code into a string (replacing near-duplicate code in several PLs), and use it anywhere that a SPI function call error is reported. Tom Lane 2004-07-31 20:55:45 +00:00
  • da4a0dab59 Escape backslashes from translation message rather than removing them. Bruce Momjian 2004-07-31 20:00:26 +00:00
  • 2def4552ed Still another try at matching system timezone nicely. On non-Windows machines, break tie scores by preferring shorter zone names over longer; for names of equal length, prefer the alphabetically first name. This yields for example 'EST5EDT' not 'America/New_York' for US eastern time. On Windows, abandon the whole concept of inspecting the detailed behavior of the system TZ library, because it doesn't bear inspection :-(. Instead use a hardwired mapping table to select our zone name based on the result of strftime %Z output. Windows code from Magnus Hagander. Tom Lane 2004-07-31 19:12:15 +00:00
  • a052cd4cc4 For EXEC_BACKEND case, BootstrapMain needs to recompute paths, same as PostgresMain. Per Magnus Hagander. Tom Lane 2004-07-31 17:57:11 +00:00
  • ea7a8b9ed7 Remove obsolete files Peter Eisentraut 2004-07-31 16:35:17 +00:00
  • c92a756a43 Translation update Peter Eisentraut 2004-07-31 07:57:41 +00:00
  • beda4814c1 plpgsql does exceptions. There are still some things that need refinement; in particular I fear that the recognized set of error condition names probably has little in common with what Oracle recognizes. But it's a start. Tom Lane 2004-07-31 07:39:21 +00:00
  • b5d2821929 Fix broken markup, release date. Tom Lane 2004-07-31 07:11:07 +00:00
  • d2b7f511da >OK, if you look at the last few commits to interfaces/libpq/win32.mak, >you will see changes for pg_config_paths.h and for thread safety. Can >you look at those changes, merge them into bcc.mak. There might be >other changes in there you want to add to bcc.mak too. > > > OK, having no M$ diff, I attach files src\interfaces\libpq\bcc32.mak and src\interfaces\libpq\win32.h Bruce Momjian 2004-07-31 06:19:23 +00:00
  • f951a46771 Add: Bruce Momjian 2004-07-31 06:13:52 +00:00
  • bdaf97bd86 Fix zh_TW.po initdb translation. Bruce Momjian 2004-07-31 04:41:54 +00:00
  • 6b771dfa38 Remove mention that we can't trap function errors. Bruce Momjian 2004-07-31 04:22:46 +00:00