hcq/postgresql
1
0
Fork 0
mirror of https://git.postgresql.org/git/postgresql.git synced 2026-02-11 03:47:32 +08:00
Code Issues Packages Projects Releases Wiki Activity

Commit Graph

  • 752314eb26 Update TODO list. Bruce Momjian 2000-01-10 13:20:57 +00:00
  • 0f2e7948e2 Improve cache invalidation handling. Eespecially this would fix TODO * elog() flushes cache, try invalidating just entries from current xact, perhaps using invalidation cache Hiroshi Inoue 2000-01-10 06:30:56 +00:00
  • 5770935965 Fix oid8in and int28in for spaces Bruce Momjian 2000-01-10 05:23:47 +00:00
  • a040281787 Move fixes for >8 indexed fields. Bruce Momjian 2000-01-10 05:20:26 +00:00
  • b99f300675 Move INDEX_MAX_KEYS to postgres.h, and make it configurable for users. Bruce Momjian 2000-01-10 04:36:37 +00:00
  • 8cc9d8454b Update TODO list. Bruce Momjian 2000-01-10 04:23:58 +00:00
  • 2513765e7b Back-patch a low-risk fix for the 'HEAP_MOVED_IN was not expected' bug: just dike out the code that tries to remove pages from fraged_pages. Tom Lane 2000-01-10 04:16:10 +00:00
  • fcb7c14d02 Repair subtle VACUUM bug that led to 'HEAP_MOVED_IN was not expected' errors. VACUUM normally compacts the table back-to-front, and stops as soon as it gets to a page that it has moved some tuples onto. (This logic doesn't make for a complete packing of the table, but it should be pretty close.) But the way it was checking whether it had got to a page with some moved-in tuples was to look at whether the current page was the same as the last page of the list of pages that have enough free space to be move-in targets. And there was other code that would remove pages from that list once they got full. There was a kluge that prevented the last list entry from being removed, but it didn't get the job done. Fixed by keeping a separate variable that contains the largest block number into which a tuple has been moved. There's no longer any need to protect the last element of the fraged_pages list. Also, fix NOTICE messages to describe elapsed user/system CPU time correctly. Tom Lane 2000-01-10 04:09:50 +00:00
  • b86ca72f39 Update platform-specific-expected-file support so that platforms can be specified by regular-expression patterns. Add some more files. Tom Lane 2000-01-09 20:54:36 +00:00
  • 4f9d74f98b install_plpgsql is no longer a regress test (it's done via createlang); remove the no-longer-used files. Tom Lane 2000-01-09 19:34:43 +00:00
  • aa48a22a82 The psql online help for ALTER TABLE (\h alter table) is corrupt. I traced this back to what I believe is an error in the sgml file used to generate this comment, found in pgsql/doc/src/sgml/ref/alter_table.sgml. Bruce Momjian 2000-01-09 17:35:27 +00:00
  • 85b309ee8f Add SetPidFile() and friends. Tatsuo Ishii 2000-01-09 12:19:27 +00:00
  • ac0d141ead Do not start if postmaster is running. Tatsuo Ishii 2000-01-09 12:17:33 +00:00
  • 10283ee6a4 Move SetPidFile() and firends to utils/init/miscinit.c from postmaster/postmaster.c so that tcop/postgres.c can use them. Now we have an interlock between postmaster and postgres. Tatsuo Ishii 2000-01-09 12:15:57 +00:00
  • 3f3421f905 Move SetPidFile() and firends to utils/init/miscinit.c so that tcop/postgres.c can use them. Now we have an interlock between postmaster and postgres. Tatsuo Ishii 2000-01-09 12:13:24 +00:00
  • 359652898b Add more portability to echo -n (code stolen from createlang) Do not start postmaster if postgres is running Tatsuo Ishii 2000-01-09 12:06:52 +00:00
  • bd62e062aa New scheme for managing platform-specific regress test result files. Instead of hard-wiring one result file per platform, there is a map file 'resultmap' that says which one to use --- a lot like template/.similar. I have only created entries in resultmap for my own platform (HPUX) so far; feel free to add lines for other platforms. Tom Lane 2000-01-09 07:54:00 +00:00
  • 2a19ac97a7 Remove obsolete platform-specific comparison files. Tom Lane 2000-01-09 06:34:46 +00:00
  • 8ba050698b First examples of multiplatform result comparison files. Tom Lane 2000-01-09 06:32:33 +00:00
  • 62cbd53bcd Remove obsolete platform-specific regress test comparison files. Note: don't put any of these back till you've grokked the new code for platform-specific comparisons that I'm about to commit... Tom Lane 2000-01-09 06:30:55 +00:00
  • fc0a46dc16 Remove CVS $Header lines from a couple of regress test files that had them --- it is just *way* too painful to keep expected results in sync when these are present. Tom Lane 2000-01-09 04:01:49 +00:00
  • f5b754a492 Update remaining tests for new psql, with the exception of 'arrays'. Tom Lane 2000-01-09 03:50:27 +00:00
  • 260b6afc79 Update remaining tests for new psql, with the exception of 'arrays', which is broken in some weird way that I don't understand. I think it may be exposing a bug in the new psql --- for one thing, I get different results when I run psql by hand than the regress script gets. What the heck??? Tom Lane 2000-01-09 03:48:39 +00:00
  • 0e821fb771 Fix some missing substitutions of _OBJWD_ and _DLSUFFIX_. Tom Lane 2000-01-09 02:48:01 +00:00
  • 166b5c1def Another round of planner/optimizer work. This is just restructuring and code cleanup; no major improvements yet. However, EXPLAIN does produce more intuitive outputs for nested loops with indexscans now... Tom Lane 2000-01-09 00:26:47 +00:00
  • 69d4299e3e This patch removes the initialization of ri in loop in quote_postgres(...) in ecpglib.c. Bruce Momjian 2000-01-08 22:58:03 +00:00
  • 2515882a0f Modify PageIsEmpty and PageGetMaxOffsetNumber macros to behave sanely if presented an uninitialized (all zeroes) page. The system no longer crashes hard if an all-zeroes page is present in a relation. There seem to be some boundary conditions where a page will be appended to a relation and zeroed, but its page header is never initialized; until we can track down and fix all of those, robustness seems like a good idea. Also, clean up some obsolete and downright wrong comments. Tom Lane 2000-01-08 21:59:55 +00:00
  • 9dde24e272 Back-patch fix for oversize index tuples during index creation. Tom Lane 2000-01-08 21:47:31 +00:00
  • b79e75d66f Need defense against oversize index entries in btree CREATE INDEX, as well as when inserting entries into an existing index. Tom Lane 2000-01-08 21:24:49 +00:00
  • 8da88a6f2b Sorry, that I send this letter/patch again, but previous sending is still without answer. I want continue with to_char(), but I need any answer for this patch. Please. Bruce Momjian 2000-01-07 17:22:47 +00:00
  • 27fdbca749 Correct grammatical error Tatsuo Ishii 2000-01-07 09:28:03 +00:00
  • 33d71e3037 *** empty log message *** Michael Meskes 2000-01-07 08:01:18 +00:00
  • 5633e22e2c Update pg_dumpall for new psql format. Bruce Momjian 2000-01-06 21:16:18 +00:00
  • b7b6d4bf53 Changed "triggered data change violation" detection code in trigger manager. Jan Wieck 2000-01-06 20:47:01 +00:00
  • 88016a564a Fixed bug in targetlist expression replacement of SET DEFAULT referential action triggers. Jan Wieck 2000-01-06 16:30:43 +00:00
  • d1e6368816 Clean up header for uniform appearance throughout tests. Thomas G. Lockhart 2000-01-06 06:41:55 +00:00
  • 67ac38085c Update for new psql formatting. Thomas G. Lockhart 2000-01-06 06:40:54 +00:00
  • 6e0cc2ac45 Freshen up the banner displayed when running the regression test. Thomas G. Lockhart 2000-01-06 06:40:18 +00:00
  • b78769fda2 Fix it's and its to be correct. Bruce Momjian 2000-01-05 18:23:54 +00:00
  • c0cab6f4fa Update format to add uniform headers on files. Thomas G. Lockhart 2000-01-05 17:32:29 +00:00
  • 69789bf33d Update format to add uniform headers on files. Update output to new psql conventions. Thomas G. Lockhart 2000-01-05 17:32:18 +00:00
  • 9c1b29816e Update output to new psql conventions. Thomas G. Lockhart 2000-01-05 17:31:08 +00:00
  • 6033cfd429 Fix spaces in text message. Thomas G. Lockhart 2000-01-05 17:30:05 +00:00
  • 4c4e68dccc Clean up format of tests. Remove older "::" type coersion syntax in favor of extended SQL92 style. Include a few new tests for datetime/timespan arithmetic. Thomas G. Lockhart 2000-01-05 06:07:58 +00:00
  • d83105539a Verified output from new psql. Include a few new tests for datetime/timespan arithmetic. Thomas G. Lockhart 2000-01-05 06:06:23 +00:00
  • 24e8ca6ef9 Move numeric test to be near other numeric data types like int4 and float8. Thomas G. Lockhart 2000-01-05 06:04:56 +00:00
  • 6580668392 Back-patch fix for problems with oversize pg_statistic tuples when both the min and max values of a column are long. Tom Lane 2000-01-04 17:27:26 +00:00
  • 61ef6a1a3f Clean up syntax to use SQL92-ish type coersion rather than the Postgres "::" notation. All of these tests have been completely inspected and give correct results. Thomas G. Lockhart 2000-01-04 16:21:02 +00:00
  • f54668d617 Match results with format from new psql. All of these tests have been completely inspected and give correct results. Thomas G. Lockhart 2000-01-04 16:19:34 +00:00
  • 621e372189 Repair two recently reported problems: 1) datetime_pl_span() added the seconds field before adding the months field. This lead to erroneous results for e.g. select datetime '1999-11-30' + timespan '1 mon - 1 sec'; Reverse the order of operations to add months first. 2) tm2timespan() did all intermediate math as integer, converting to double at the very end. This resulted in hidden overflows when given very large integer days, hours, etc. For example, select '74565 days'::timespan; produced the wrong result. Change code to ensure that doubles are used for intermediate calculations. Thanks to Olivier PRENANT <ohp@pyrenet.fr> and Tulassay Zsolt <zsolt@tek.bke.hu> for problem reports and to Tom Lane for accurate analyses. Thomas G. Lockhart 2000-01-04 07:56:23 +00:00
  • 3ec826f99a Repair two recently reported problems: 1) datetime_pl_span() added the seconds field before adding the months field. This lead to erroneous results for e.g. select datetime '1999-11-30' + timespan '1 mon - 1 sec'; Reverse the order of operations to add months first. 2) tm2timespan() did all intermediate math as integer, converting to double at the very end. This resulted in hidden overflows when given very large integer days, hours, etc. For example, select '74565 days'::timespan; produced the wrong result. Change code to ensure that doubles are used for intermediate calculations. Thanks to Olivier PRENANT <ohp@pyrenet.fr> and Tulassay Zsolt <zsolt@tek.bke.hu> for problem reports and to Tom Lane for accurate analyses. Thomas G. Lockhart 2000-01-04 07:53:27 +00:00
  • aae7b19077 Update DATEDEBUG removal. Bruce Momjian 2000-01-02 02:32:37 +00:00
  • 424ff563ba Update length of timestamp to 30. Bruce Momjian 2000-01-02 02:11:13 +00:00
  • a8587d02eb Update length of timestamp to 30. Bruce Momjian 2000-01-02 02:11:08 +00:00
  • a17c0e0b0c Backpatch Y2K timestamp patch. Bruce Momjian 2000-01-02 01:38:48 +00:00
  • 7a877dfd2d Remove DATEDEBUG because it didn't look Y2K safe, and fix timestamp elog to be Y2K safe. Bruce Momjian 2000-01-02 01:37:28 +00:00
  • eb9bb3de33 Make psql \dT always show descriptions. There is room. Bruce Momjian 1999-12-31 21:06:19 +00:00
  • d8f3752133 Generate double-sided LIKE indexquals that work even in weird locales, by continuing to increment the rightmost character until we get a string that is demonstrably greater than the pattern prefix. Tom Lane 1999-12-31 05:38:25 +00:00
  • 5f68d5c38f Clean up loose end in LIKE optimization fix: parser's code would generate <= and >= indexquals from a LIKE even if the index in question didn't support those operators. (As, for example, a hash index does not.) Tom Lane 1999-12-31 03:41:03 +00:00
  • 2784a5aedf Clean up datatypes and comments for op_class() routine. Tom Lane 1999-12-31 03:18:43 +00:00
  • f35e1c8c1f Revise init_sequence so that it doesn't leak memory if the requested sequence doesn't exist. Tom Lane 1999-12-31 00:54:27 +00:00
  • 8a40400d40 elog() was set up to call abort() if it saw an ERROR or FATAL exit during InitProcessingMode and the CurrentTransactionState was neither TRANS_DEFAULT nor TRANS_DISABLED. Unfortunately, after someone's recent change to start the transaction manager earlier in startup than it used to be started, that caused an abort() and consequent database system reset on quite harmless errors (such as rejecting an invalid user name!). As far as I can see, the test on CurrentTransactionState was completely useless anyway, so I've removed it. Tom Lane 1999-12-30 23:03:40 +00:00
  • b16bd18546 Clearify DECLARE syntax by saying cursorname, not just cursor. Bruce Momjian 1999-12-30 22:58:10 +00:00
  • 0022f21dcb Allow --with-mb=SQL_ASCII Tatsuo Ishii 1999-12-30 08:33:49 +00:00
  • 9c95f8c9b2 Repair bugs discussed in pghackers thread of 15 May 1999: creation of a relcache entry no longer leaks a small amount of memory. index_endscan now releases all the memory acquired by index_beginscan, so callers of it should NOT pfree the scan descriptor anymore. Tom Lane 1999-12-30 05:05:13 +00:00
  • 649ffe1616 Improve subquery error message, now says "More than one tuple returned by subselect used as expression." Bruce Momjian 1999-12-29 22:57:17 +00:00
  • e1b212ff3b Move ipc patch into README.NT. Bruce Momjian 1999-12-29 10:28:00 +00:00
  • 25f187d339 Add NT patch. Bruce Momjian 1999-12-29 10:24:16 +00:00
  • 331dc2378f Move NT patch into readme. Bruce Momjian 1999-12-29 10:18:10 +00:00
  • f63ff18153 Move NT patch into readme. Bruce Momjian 1999-12-29 10:18:04 +00:00
  • e966b4f1c8 Add NT patch. Bruce Momjian 1999-12-29 10:14:46 +00:00
  • 2e2fb0a2a6 Update comment. Bruce Momjian 1999-12-29 10:13:20 +00:00
  • b21ee21455 Update comments. Bruce Momjian 1999-12-29 10:12:23 +00:00
  • e3cec20ccd Removed LZTEXT datatype as discussed. Jan Wieck 1999-12-28 13:40:53 +00:00
  • e9bfedc9bc Fix length limit, MikeA Bruce Momjian 1999-12-27 18:21:07 +00:00
  • 635498623d Hi, all, Bruce Momjian 1999-12-27 15:45:04 +00:00
  • 24a0f021ef Hi, all Bruce Momjian 1999-12-27 15:42:44 +00:00
  • bc036a063d Put back erroneously-removed definition of 'defines' variable. Tom Lane 1999-12-26 21:31:35 +00:00
  • 950539131e Back-patch defense against oversize index tuples and fix for trying to split a page that only has one entry. Tom Lane 1999-12-26 20:44:15 +00:00
  • a6a70315af It turns out that the item size limit for btree indexes is about BLCKSZ/3, not BLCKSZ/2 as some of us thought. Add check for oversize item so that failure is detected before corrupting the index, not after. Tom Lane 1999-12-26 03:48:22 +00:00
  • ad322de0ae Update developers faq. Bruce Momjian 1999-12-24 16:46:11 +00:00
  • 350cb386af Clean up handling of explicit NULL constants. Cases like SELECT null::text; SELECT int4fac(null); work as expected now. In some cases a NULL must be surrounded by parentheses: SELECT 2 + null; fails SELECT 2 + (null); OK This is a grammatical ambiguity that seems difficult to avoid. Other than that, NULLs seem to behave about like you'd expect. The internal implementation is that NULL constants are typed as UNKNOWN (like untyped string constants) until the parser can deduce the right type. Tom Lane 1999-12-24 06:43:34 +00:00
  • bd5ea42a8d *** empty log message *** Michael Meskes 1999-12-23 12:33:19 +00:00
  • e80ade5e22 Fix minor bug. Tatsuo Ishii 1999-12-22 04:41:17 +00:00
  • e3736d2c3a Add installtion of postmaster.opts.default. Tatsuo Ishii 1999-12-22 04:23:31 +00:00
  • b680d5bec7 Add installation of pg_ctl Locate path of postmaster in a portable way (stolen from initdb) Add postmaster.opts.default.sample which should be copied into $PGLIB in the installtion process. Also, it will be installed into $PGDATA while initdb is running. Tatsuo Ishii 1999-12-22 04:12:55 +00:00
  • a3e2bc732d to live in a transaction before access to db during backend startup. Hiroshi Inoue 1999-12-22 00:07:16 +00:00
  • 3e99158548 update_pg_pwd() is an AR trigger. Corrected return type. Jan Wieck 1999-12-21 22:39:02 +00:00
  • b57b0e0445 The first fix is to allow an input file with a relative path and without a ".pgc " extension. The second patch fixes a coredump when there is more than one input file (in that case, cur and types were not set to NULL before processing the second f ile) Bruce Momjian 1999-12-21 17:42:16 +00:00
  • a0fa26bef6 Update developers faq in main tree. Bruce Momjian 1999-12-21 17:34:05 +00:00
  • bb50fb517f This patch will avoid SIGFPE on some geo functions , if PostgreSQL is compiled with DEC C. Bruce Momjian 1999-12-21 17:01:44 +00:00
  • 04c78e2eb4 autoconf Bruce Momjian 1999-12-21 16:56:42 +00:00
  • 6a554a07b4 Clean up qnx template finding. Bruce Momjian 1999-12-21 16:55:38 +00:00
  • e2aef49694 Added empty TOASTER files and corrected some minor glitches in regression tests. Jan Wieck 1999-12-21 00:06:44 +00:00
  • 2c29c96ed6 tr cleanup Bruce Momjian 1999-12-20 14:41:55 +00:00
  • 7c385f73e5 Required catalog changes for extended LONG attribute storage. Jan Wieck 1999-12-20 10:40:43 +00:00
  • 665db209e5 Cleanup of effective username test. Bruce Momjian 1999-12-20 05:39:40 +00:00
  • f74b94db09 Finally found a platform which has finite() but nonetheless sets errno rather than returning a NaN for bogus input to pow(). Namely, HPUX 10.20. I think this is sufficient evidence for what I thought all along, which is that the float.c code *must* look at errno whether finite() exists or not. Tom Lane 1999-12-20 02:15:35 +00:00
  • 76b110c82a Clean up some minor gcc warnings. Tom Lane 1999-12-20 01:41:32 +00:00
  • ec806d72c0 Clean up some minor gcc warnings. Tom Lane 1999-12-20 01:34:19 +00:00