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

Commit Graph

  • 47ed658c59 heap_open => relation_open to avoid unwanted restriction on relkind. Per gripe from Gaetano Mendola. Tom Lane 2003-09-30 00:59:51 +00:00
  • e33f205a94 Adjust btree index build procedure so that the btree metapage looks invalid (has the wrong magic number) until the build is entirely complete. This turns out to cost no additional writes in the normal case, since we were rewriting the metapage at the end of the process anyway. In normal scenarios there's no real gain in security, because a failed index build would roll back the transaction leaving an unused index file, but for rebuilding shared system indexes this seems to add some useful protection. Tom Lane 2003-09-29 23:40:26 +00:00
  • 6b4caf53e6 Release updates by Tom. Bruce Momjian 2003-09-29 23:16:44 +00:00
  • 0e319c7ad7 Improve context display for failures during COPY IN, as recently discussed on pghackers. Tom Lane 2003-09-29 22:06:40 +00:00
  • 34c64955cd Update Jan's completed item. Bruce Momjian 2003-09-29 21:42:04 +00:00
  • 7bc0678e0b Remove, already done: Bruce Momjian 2003-09-29 21:41:29 +00:00
  • 8dd0573772 Update HISTORY for 7.4. Bruce Momjian 2003-09-29 21:25:43 +00:00
  • fb72fc8b80 Add: Bruce Momjian 2003-09-29 21:15:19 +00:00
  • 36f15ddecd Fixed type lookup in spi_prepare for possible qualified type name specification. Jan Wieck 2003-09-29 19:24:06 +00:00
  • 2f98ece4de The brackets aren't put on the CHECK constraints properly. Bruce Momjian 2003-09-29 18:55:56 +00:00
  • 6000e32805 I've not changed any malloc/calloc to palloc. It looks to me that these memory areas are for the lifetime of the backend and in the interests of not breaking something that's not broken I left alone. Bruce Momjian 2003-09-29 18:54:38 +00:00
  • 243f11ccf1 [ Patch applied only to 7.3.X.] Bruce Momjian 2003-09-29 18:53:08 +00:00
  • 4b4c43b146 This patch fixes an obvious bug in the "should I print the duration of this query?" logic in postgres.c Bruce Momjian 2003-09-29 18:50:58 +00:00
  • fc7a2affab I discovered that TupleDescGetAttInMetadata and BuildTupleFromCStrings don't deal well with tuples having dropped columns. The attached fixes the issue. Please apply. Bruce Momjian 2003-09-29 18:22:48 +00:00
  • f3db606592 > > > > a) Write documentation how the win32 console needs to be set up so that > > psql can handle 8-bit characters. > > Where should it be added? The Section "Installation on Windows" in the > > Administrator's Guide seems natural to me. > > > > b) Add code to psql that prints a warning on startup of psql when the > > console codepage differs from the windows codepage, something like > > > > Warning: Console codepage (850) differs from windows codepage (1252) > > 8-bit characters will not work correctly. See PostgreSQL > > documentation "Installation on Windows" for details. > Attached are two patches: Bruce Momjian 2003-09-29 18:21:33 +00:00
  • a17b53753e This patch makes a few incremental improvements to geqo.sgml and arch-dev.sgml Bruce Momjian 2003-09-29 18:18:35 +00:00
  • 04e401f97f A) Fixes a bug that prevented mirroring of data on a table that has had a column dropped. Bruce Momjian 2003-09-29 18:16:48 +00:00
  • b8d7e1e798 Change 7.3.4 release note format to match the rest of the 7.3.x releases. Bruce Momjian 2003-09-29 18:15:12 +00:00
  • e22c891361 Update release notes. Bruce Momjian 2003-09-29 18:06:48 +00:00
  • e7a9ba4872 Add: Bruce Momjian 2003-09-29 16:52:14 +00:00
  • 55fbc98b3f Adjust the new Norwegian translation for some of the easier message changes between 7.3 and 7.4, for example quoting and function names. Peter Eisentraut 2003-09-29 16:41:33 +00:00
  • 275c909a8c Apparently, gettext doesn't like double parentheses around argument. What were they doing here anyway? Peter Eisentraut 2003-09-29 16:39:18 +00:00
  • f4d5d620f2 Make message fit guidelines. Peter Eisentraut 2003-09-29 16:38:04 +00:00
  • 2d480b92cf Eliminate another gratuitous message wording difference. Peter Eisentraut 2003-09-29 16:37:29 +00:00
  • a776bd9b69 New Norwegian translation by Trond Endrestøl, actually made for 7.3, but this should help people get started in 7.4 as well. Peter Eisentraut 2003-09-29 10:57:06 +00:00
  • b994b143a6 New translations Peter Eisentraut 2003-09-29 09:51:29 +00:00
  • 77eb4aac75 Update HISTORY to current. Bruce Momjian 2003-09-29 04:50:36 +00:00
  • f7fca96366 Fix #error message to mention renamed option --disable-spinlocks. Bruce Momjian 2003-09-29 04:20:22 +00:00
  • 3e4b208285 Update docs that point to thread test program. Bruce Momjian 2003-09-29 03:32:05 +00:00
  • 5594aa6a6e Fix broken definition of :print: character class, per Bruno Wolff. Also, make :alnum: character class directly dependent on isalnum() rather than guessing. Tom Lane 2003-09-29 00:21:58 +00:00
  • 3b97d9f525 Translation update Peter Eisentraut 2003-09-29 00:17:42 +00:00
  • 7438af96fa More message editing, some suggested by Alvaro Herrera Peter Eisentraut 2003-09-29 00:05:25 +00:00
  • 8b510838f6 Restructure plpgsql's caching of 'simple' expression evaluation trees to be less dangerous, and often faster as well. ExprState trees are not kept across transaction boundaries; this eliminates problems with resource leakage in failed transactions. But by keeping them in a per-transaction EState, we can safely arrange for a single ExprState to be shared by all the expression evaluations done in a given plpgsql function call. (Formerly it seemed necessary to create and destroy an ExprState for each exec_eval_simple_expr() call.) This saves time in any scenario where a plpgsql function executes more than one expression. Seems to be about as fast as 7.3 for simple cases, and significantly faster for functions that do a lot of calculations. Tom Lane 2003-09-28 23:37:45 +00:00
  • 8934790052 Add a mechanism to let dynamically loaded modules register post-commit/ post-abort cleanup hooks. I'm surprised that we have not needed this already, but I need it now to fix a plpgsql problem, and the usefulness for other dynamically loaded modules seems obvious. Tom Lane 2003-09-28 23:26:20 +00:00
  • 6518b4cdf7 Backpatched changes for rules when casts are dumped according to discussion on hackers. Jan Wieck 2003-09-28 17:46:19 +00:00
  • a15207f8d6 Now that we have UPDATE tab SET col = DEFAULT, get rid of horrid hack in the RI triggers for ON DELETE/UPDATE SET DEFAULT. The code depended way too much on knowledge of plan structure, and yet still would fail if the generated query got rewritten by rules. Tom Lane 2003-09-28 02:11:23 +00:00
  • 3900f8368d Update docs on function call permissions in view, from Tom. Bruce Momjian 2003-09-28 01:19:33 +00:00
  • a994d5984f Adjust pgindent for newer awks. Bruce Momjian 2003-09-28 00:25:22 +00:00
  • b4ca39b956 Allow pgindent to work with newer BSD indents. Bruce Momjian 2003-09-28 00:22:58 +00:00
  • 44f8c5c10a Make dbf2pg safe for non-ASCII character sets. Bruce Momjian 2003-09-27 22:24:49 +00:00
  • 74c8703031 Mark Linux for threads. Bruce Momjian 2003-09-27 22:23:35 +00:00
  • 0ac697b269 Remove erroneous restriction that -t cannot be used to select a sequence for dumping. Tom Lane 2003-09-27 22:10:01 +00:00
  • 16e4adc38f Update bsd indent patch. Bruce Momjian 2003-09-27 21:26:09 +00:00
  • ee84100cc1 Cleanup pgindent patch. Bruce Momjian 2003-09-27 21:19:47 +00:00
  • e0736689a3 Got the link order wrong :-( Tom Lane 2003-09-27 20:38:19 +00:00
  • cd75f94daf Adjust Darwin build to use the default 'two level namespace' linking method. Fix a number of places where shared libraries were linked without mentioning all the libraries they depend on; the Darwin and AIX ports are known to require this, and it doesn't seem to hurt any other supported platforms. (Hence, remove code in pl/tcl makefile that tried to avoid mentioning other libs if not needed.) Tom Lane 2003-09-27 19:35:32 +00:00
  • e9ff025345 Fixed calculation of bid when generating accounts. Used to create accounts.bid values of zero. Jan Wieck 2003-09-27 19:15:34 +00:00
  • 4f7a2fa0c3 Fix typo in message. Tom Lane 2003-09-27 18:16:35 +00:00
  • bb9ec59419 Add compile step to instructions. Bruce Momjian 2003-09-27 17:29:30 +00:00
  • e349584d5d Make dump files created by initdb have consistent EOL termination, to pass COPY's EOL tests. Bruce Momjian 2003-09-27 16:27:57 +00:00
  • 391dceb462 Finalize configuration of thread_test program. Bruce Momjian 2003-09-27 16:24:45 +00:00
  • a6790ce857 Changed the logic when a CAST is dumped according to discussion on pgsql-hackers. Jan Wieck 2003-09-27 15:34:06 +00:00
  • 227dd9b427 Rename thread compile flag. Move thread test program to tools/thread, and improve tests. Bruce Momjian 2003-09-27 15:32:48 +00:00
  • fae2adecf5 Small SGML cleanup from Jeroen Ruigrok/asmodai Bruce Momjian 2003-09-27 14:06:21 +00:00
  • e05147e51a You can't NLS-enable a program component by just putting gettext() around every string, especially if some of the output should be fixed-format machine-readable. This needs to be more carefully sorted out. Also, make the help message generated by --help-config -h be more similar in style to the others. Peter Eisentraut 2003-09-27 09:29:31 +00:00
  • 4af19a579d The formatting of the display of the locale names assumed that locale names are not longer than 8 characters. But sometimes they are, and that made the display quite ugly. So just format them vertically so that everyone can read them. Peter Eisentraut 2003-09-27 09:21:26 +00:00
  • 87cbcff9e6 Document that functions are checked independently of the view permissions. Bruce Momjian 2003-09-27 00:10:31 +00:00
  • 90322456fe Add "tuning" section to install instructions. Bruce Momjian 2003-09-26 17:47:44 +00:00
  • 026f9c05d5 Move -D_GNU_SOURCE hack from port header to template, so that configure's tests see the same compilation environment as the code. Per discussion with Stephan Szabo. Tom Lane 2003-09-26 17:39:13 +00:00
  • d84b6ef56b Various message fixes, among those fixes for the previous round of fixes Peter Eisentraut 2003-09-26 15:27:37 +00:00
  • 98150f108f Translation update Peter Eisentraut 2003-09-26 15:25:39 +00:00
  • e11136e4a5 Fixed segfault after error in parsing precision argument. Michael Meskes 2003-09-26 15:16:29 +00:00
  • 8d108fb166 Fix tid scan evaluation of non-constant TID values; can't try to do it during ExecInitTidScan, because the rest of the executor isn't ready. Tom Lane 2003-09-26 01:17:01 +00:00
  • 2848dc5fea Make the world safe (more or less) for dropped columns in plpgsql rowtypes. Tom Lane 2003-09-25 23:02:12 +00:00
  • a039148cad tlist_matches_tupdesc() needs to defend itself against dropped columns. Tom Lane 2003-09-25 19:41:49 +00:00
  • c63a5452d8 Get rid of ReferentialIntegritySnapshotOverride by extending Executor API to allow es_snapshot to be set to SnapshotNow rather than a query snapshot. This solves a bug reported by Wade Klaver, wherein triggers fired as a result of RI cascade updates could misbehave. Tom Lane 2003-09-25 18:58:36 +00:00
  • 7ab5c5b83e Fix regression error messages for platforms Peter doesn't use. Tom Lane 2003-09-25 16:16:35 +00:00
  • d332f7f610 Fix grammatical error introduced into error message. Tom Lane 2003-09-25 15:58:06 +00:00
  • be1d437e01 Forget to update the real source of the regression test results after message editing. Peter Eisentraut 2003-09-25 15:48:17 +00:00
  • feb4f44d29 Message editing: remove gratuitous variations in message wording, standardize terms, add some clarifications, fix some untranslatable attempts at dynamic message building. Peter Eisentraut 2003-09-25 06:58:07 +00:00
  • 42013caf64 Update Japanese FAQ, from Jun Kuwamura Bruce Momjian 2003-09-25 02:27:54 +00:00
  • 266664fcd2 Fix creation of temporary sequences in ecpg, per report from Edmund Bacon. Bruce Momjian 2003-09-24 19:05:32 +00:00
  • a56a016ceb Repair some REINDEX problems per recent discussions. The relcache is now able to cope with assigning new relfilenode values to nailed-in-cache indexes, so they can be reindexed using the fully crash-safe method. This leaves only shared system indexes as special cases. Remove the 'index deactivation' code, since it provides no useful protection in the shared- index case. Require reindexing of shared indexes to be done in standalone mode, but remove other restrictions on REINDEX. -P (IgnoreSystemIndexes) now prevents using indexes for lookups, but does not disable index updates. It is therefore safe to allow from PGOPTIONS. Upshot: reindexing system catalogs can be done without a standalone backend for all cases except shared catalogs. Tom Lane 2003-09-24 18:54:02 +00:00
  • 5f78c6a886 another totally benign, test commit Marc G. Fournier 2003-09-24 18:09:15 +00:00
  • fc058c72e9 test 2, benign, no change Marc G. Fournier 2003-09-24 18:08:20 +00:00
  • c237868b2f not change, just added a space to test something Marc G. Fournier 2003-09-24 18:05:36 +00:00
  • 03858c078b Add positive defense against dropped columns, per suggestion from Christopher Kings-Lynne. Also fix a couple more schema-awareness issues. Tom Lane 2003-09-24 05:38:38 +00:00
  • a9e9abebd9 Issue CREATE SCHEMA as the originally connecting user, with an AUTHORIZATION clause to specify the desired owner. This allows a superuser to restore schemas owned by users without CREATE-SCHEMA permissions (ie, schemas originally created by a superuser using AUTHORIZATION). --no-owner can be specified to suppress the AUTHORIZATION clause if need be. Tom Lane 2003-09-23 23:31:52 +00:00
  • 6767cebc6f pg_dump/pg_restore now always use SET SESSION AUTHORIZATION, not \connect, to control object ownership. The use-set-session-authorization and no-reconnect switches are obsolete (still accepted on the command line, but they don't do anything). This is a precursor to fixing handling of CREATE SCHEMA, which will be a separate commit. Tom Lane 2003-09-23 22:48:53 +00:00
  • 45de72b683 Add: Bruce Momjian 2003-09-23 21:00:18 +00:00
  • eed6ff45d4 Add: Bruce Momjian 2003-09-23 20:45:58 +00:00
  • aefc08e4eb Minor copy-editing for plpgsql chapter. Tom Lane 2003-09-23 19:58:50 +00:00
  • dbf8259adf Tweak generic_type_consistency routines to avoid loss of functionality since 7.3: 'select array_dims(histogram_bounds) from pg_stats' used to work and still should. Problem was that code wouldn't take input of declared type anyarray as matching an anyarray argument. Allow this case as long as we don't need to determine an element type (which in practice means as long as anyelement isn't used in the function signature). Tom Lane 2003-09-23 17:12:53 +00:00
  • 57040f5069 _SPI_cursor_operation forgot to check for failure return from _SPI_begin_call. Per gripe from Tomasz Myrta. Tom Lane 2003-09-23 15:11:41 +00:00
  • 267924ead8 _SPI_cursor_operation forgot to check for failure return from _SPI_begin_call. Per gripe from Tomasz Myrta. Tom Lane 2003-09-23 15:11:33 +00:00
  • 5a5f0a6168 - Changed struct definition handling so "struct foo {}" always gets defined. Michael Meskes 2003-09-23 12:56:35 +00:00
  • 2ec8ee0c0c Fix to properly handle timezone offsets that are partial hours. If the offset was a partial hour and less than gmt (i.e. -02:30) the code would corrupt the minutes part. Barry Lind 2003-09-23 06:13:52 +00:00
  • 618d56d09a A fix for jdbc regression test submitted yesterday by Kim Ho at Redhat Barry Lind 2003-09-23 06:11:06 +00:00
  • f5c5c3c6f7 Putting back the previous change must be the first thing. ALso put back a #ifndef ENABLE_REINDEX_NAILED_RELATIONS which was removed about a year ago. Hiroshi Inoue 2003-09-23 01:51:09 +00:00
  • 0b1ee9b5a3 fix hlfinditem function. Thanks to "Stphane Bidoul" <stephane.bidoul@softwareag.com>. Teodor Sigaev 2003-09-22 13:32:33 +00:00
  • 22c0b1f0f4 - Fixed order mismatch in processing "using" arguments. - Fixed some minor things in test cases. - Use defines for Informix error codes. Michael Meskes 2003-09-22 13:19:39 +00:00
  • 8839b85ed8 Additional jdbc regression tests submitted by Oliver Jowett. Some tests are currently commented out, pending fixes for the bugs these tests uncovered. Barry Lind 2003-09-22 05:38:01 +00:00
  • 66d00417c9 Applied jdbc patch from Kim Ho at RedHat to improve boolean support, as well as some additional regression tests for this an other recent changes. Barry Lind 2003-09-22 04:55:00 +00:00
  • f03d2284c0 HeapTupleSatisfiesVacuum() needs to be more careful about the difference between INSERT_IN_PROGRESS and DELETE_IN_PROGRESS for tuples inserted and then deleted by a concurrent transaction. Example of bug: regression=# create table foo (f1 int); CREATE TABLE regression=# begin; BEGIN regression=# insert into foo values(1); INSERT 195531 1 regression=# delete from foo; DELETE 1 regression=# insert into foo values(1); INSERT 195532 1 regression=# create unique index fooi on foo(f1); ERROR: could not create unique index DETAIL: Table contains duplicated values. Tom Lane 2003-09-22 00:47:23 +00:00
  • 278a13fe47 Translation updates Peter Eisentraut 2003-09-22 00:27:01 +00:00
  • 6f57d63cb4 Message wording improvements Peter Eisentraut 2003-09-22 00:23:35 +00:00
  • 5d00f984d8 Make the SQL command synopses appear less random. Peter Eisentraut 2003-09-22 00:16:58 +00:00
  • 5aa29e88e9 Arrange to align shared disk buffers on at least 32-byte boundaries, not just MAXALIGN boundaries. This makes a noticeable difference in the speed of transfers to and from kernel space, at least on recent Pentiums, and might help other CPUs too. We should look at making this happen for local buffers and buffile.c too. Patch from Manfred Spraul. Tom Lane 2003-09-21 17:57:21 +00:00
  • 11b274f00f Fix some ill-considered ifdefs, per report from Hans-JÏrgen SchÎnig. Tom Lane 2003-09-21 17:42:22 +00:00
  • 58ad65ec2d Apply ranlib(1) after installing a static (.a) library on Darwin. Per past complaints --- verified to still be a problem on OS X 10.2.6. Tom Lane 2003-09-20 21:26:20 +00:00