Commit Graph

  • 3da29a8b4b Update TODO list. Bruce Momjian 2001-05-18 16:28:12 +00:00
  • 78b674ba35 Add regression test to catch future breakage of avg(interval). This aggregate seems uniquely fragile, because it's the only one with an agginitval that's at all likely to change in format. Tom Lane 2001-05-18 16:02:01 +00:00
  • 1bf1481963 Correct recently-broken avg(interval) definition. We can't force an initdb to fix this in 7.1 installations, but it seems better to be shipping a correct entry than a wrong one. Tom Lane 2001-05-18 16:00:11 +00:00
  • 1945096324 Correct recently-broken avg(interval) definition. Tom Lane 2001-05-18 15:59:04 +00:00
  • d220d3482d Update TODO list. Bruce Momjian 2001-05-18 15:18:55 +00:00
  • 1bb13716ec Update TODO list. Bruce Momjian 2001-05-18 14:39:54 +00:00
  • edf829aa1c Update TODO list. Bruce Momjian 2001-05-17 22:07:21 +00:00
  • a6677f0f9e Change "indices" to "indexes", per OED. Peter Eisentraut 2001-05-17 21:50:18 +00:00
  • f000ffd28e Add -U and -W options to pg_dump and friends to support non-interactive specification of username (like in psql). pg_dumpall now works with password authentication. Peter Eisentraut 2001-05-17 21:12:49 +00:00
  • 761a0bb69b Add dynamic_library_path parameter and automatic appending of shared library extension. Peter Eisentraut 2001-05-17 17:44:18 +00:00
  • 8266e8a84b OK, now pgindent has blank lines before comment blocks, except when there is a brace on the line above it. Bruce Momjian 2001-05-17 16:11:08 +00:00
  • 2d7795ebb4 Prevent forced blank line before comment block in pgindent. Bruce Momjian 2001-05-17 15:55:24 +00:00
  • e044fc0599 Spacing cleanup. Bruce Momjian 2001-05-17 15:22:12 +00:00
  • 806aba49fd Small cleanup of spacing. Bruce Momjian 2001-05-17 14:59:31 +00:00
  • d524c5a2be Add HISTORY items for 7.1.2. Bruce Momjian 2001-05-17 13:29:36 +00:00
  • e4f2bea7fb Add HISTORY items for 7.1.2. Bruce Momjian 2001-05-17 13:28:30 +00:00
  • 8783d2a5bf Add missing space to sample cvs call. Bruce Momjian 2001-05-17 13:20:35 +00:00
  • a8a487df9f Fix pg_index statistics query to join proper relation. Bruce Momjian 2001-05-17 11:54:04 +00:00
  • f107174e8c Included is a patch that fixes a bug introduced in the lastest version (1.22) of interfaces/jdbc/org/postgresql/jdbc2/ResultSet.java. That change removed a line that set the variable s to the value of the stringbuffer. This fix changes the following if checks to check the length of the stringbuffer instead of s, since s no longer contains the string the if conditions are expecting. Bruce Momjian 2001-05-17 04:10:02 +00:00
  • 2e3c56a0ea Cleanup of backpatch of jdbc2 improvements to jdbc1: Bruce Momjian 2001-05-17 03:55:04 +00:00
  • 1ef5c99c85 Fix 'make clean' with jdbc and ant by using filesets. Bruce Momjian 2001-05-17 03:22:53 +00:00
  • e7ffdd4475 1) Decrease the size of some buffers. 2) Repair broken SQLStatistics(). Hiroshi Inoue 2001-05-17 02:56:37 +00:00
  • 77f277575a Replace poorly-coded vac_find_eq routine with call to standard bsearch library code. Tweak progress messages to include elapsed real time, not only CPU time. Tom Lane 2001-05-17 01:28:50 +00:00
  • a246bf935f Back-patch fix for race condition in heap_update (make sure we hold the buffer lock while checking page free space). Tom Lane 2001-05-17 00:48:45 +00:00
  • 6c183005d3 Mark column as not used. Bruce Momjian 2001-05-17 00:29:52 +00:00
  • b350b52139 Update TODO list. Bruce Momjian 2001-05-17 00:10:08 +00:00
  • 2cc332002f Update TODO list. Bruce Momjian 2001-05-17 00:08:38 +00:00
  • 8128ae686f Add missing paren. Bruce Momjian 2001-05-16 22:36:03 +00:00
  • 27336e4f7a Repair race condition introduced into heap_update() in 7.1 --- PageGetFreeSpace() was being called while not holding the buffer lock, which not only could yield a garbage answer, but even if it's the right answer there might be less space available after we reacquire the buffer lock. Tom Lane 2001-05-16 22:35:12 +00:00
  • ae38a1f556 Update TODO list. Bruce Momjian 2001-05-16 20:18:25 +00:00
  • 5abaa779c4 Fix for HASH for index lookups in ODBC. Bruce Momjian 2001-05-16 17:47:27 +00:00
  • 014f98dd36 autoconf Bruce Momjian 2001-05-16 17:28:46 +00:00
  • 94e2d98dd6 The configure.in file erraneous assumes that FreeBSD 1.x and 2.x have ELF capability. Bruce Momjian 2001-05-16 17:24:10 +00:00
  • 7934c93cbe This patch fixes a bug which occurs when setObject(1,obj) is called and obj is of type Object, and is null Bruce Momjian 2001-05-16 17:22:25 +00:00
  • 37b006e074 Add NUMERIC tests to jdbc code. Bruce Momjian 2001-05-16 17:09:26 +00:00
  • 863c9d11f1 I was trying to get a very nice FREE graphical db tool called DbVisualizer (http://www.ideit.com/products/dbvis/) to work with Postgresql and I found out the following bug: if database has views then getTables() gets the null pointer exception ('order by relname' makes the listing tree in DbVisualizer a lot useful !!) Bruce Momjian 2001-05-16 16:42:31 +00:00
  • 01cc344011 Change the line: return ((c == 't') || (c == 'T')); int the getBoolean function on line 184:ish to: return ((c == 't') || (c == 'T') (c == '1')); Bruce Momjian 2001-05-16 16:30:38 +00:00
  • 9cdf723142 Backpatch jdbc2 fixes to jdbc1, ANT fixes, from Peter Eisentraut Bruce Momjian 2001-05-16 16:20:53 +00:00
  • 1292467db1 Backpatch getImportedKeys to jdbc1. Bruce Momjian 2001-05-16 04:08:50 +00:00
  • aad93fb433 Backpatch ORDER BY fix to jdbc1. Bruce Momjian 2001-05-16 04:01:04 +00:00
  • c5039e059e Here's an easy patch for todays snapshot to sort the result of the Bruce Momjian 2001-05-16 03:50:08 +00:00
  • 41a20bbbdf jdbc2 implementation of getImportedKeys. Bruce Momjian 2001-05-16 03:40:25 +00:00
  • e046e1dfab The current implementation of BlobInputStream does not properly handle 8-bit unsigned data as it blindly casts the byte to an int, which java most helpfully promotes to a signed type. This causes problems when you can only return -1 to indicated EOF. Bruce Momjian 2001-05-16 03:29:01 +00:00
  • 6d85003098 Update crypto with patch for computation. Bruce Momjian 2001-05-15 17:05:28 +00:00
  • dbb219b896 Add missing dlfcn.h includes. Fix "" vs <>. Peter Eisentraut 2001-05-15 16:55:27 +00:00
  • 6f3da9ae17 Remove unnecessary EvalPlanQual support code --- since this plan node type never scans a relation directly, it can't be an EPQ target. Explicitly drop subplan's tuple table to ensure we have no buffer pin leaks. Tom Lane 2001-05-15 16:11:58 +00:00
  • d0e1091cfd we found a problem in GiST with massive insert/update operations with many NULLs ( inserting of NULL into indexed field cause ERROR: MemoryContextAlloc: invalid request size) As a workaround 'vacuum analyze' could be used. Bruce Momjian 2001-05-15 14:14:49 +00:00
  • 3848a14ed7 redo record -> undo record, Tom Lane. Bruce Momjian 2001-05-15 13:57:37 +00:00
  • 9478206d32 Fix small thinko. D'Arcy J.M. Cain 2001-05-15 13:28:56 +00:00
  • 6099009eae Well, the correct code - that corresponds to current encode - is below. I even got the linefeed stuff wrong. Bruce Momjian 2001-05-15 04:45:35 +00:00
  • fdbfe1c68e Well, the correct code - that corresponds to current encode - is below. I even got the linefeed stuff wrong. Bruce Momjian 2001-05-15 04:45:15 +00:00
  • 0eacc60e23 Fix regression for new oids. Bruce Momjian 2001-05-15 04:12:56 +00:00
  • ed6998d0b3 Re-add pg_index.indhaskeytype. Bruce Momjian 2001-05-15 03:49:35 +00:00
  • f756acf8a8 Re-add pg_index.indisclustered in a minimalist way. Also fix BSDi dynamic linker change. #include must be before #ifdef test. Bruce Momjian 2001-05-15 01:12:59 +00:00
  • 7809cbf7e6 Some badly needed documentation about EvalPlanQual. Tom Lane 2001-05-15 00:35:50 +00:00
  • a8bc265bad EvalPlanQual was thoroughly broken for concurrent update/delete on inheritance trees (mostly my fault). Repair. Also fix long-standing bug in ExecReplace: after recomputing a concurrently updated tuple, we must recheck constraints. Make EvalPlanQual leak memory with somewhat less enthusiasm than before, although plugging leaks fully will require more changes than I care to risk in a dot-release. Tom Lane 2001-05-15 00:34:02 +00:00
  • a4155d3bbd EvalPlanQual was thoroughly broken for concurrent update/delete on inheritance trees (mostly my fault). Repair. Also fix long-standing bug in ExecReplace: after recomputing a concurrently updated tuple, we must recheck constraints. Make EvalPlanQual leak memory with somewhat less enthusiasm than before, although plugging leaks fully will require more changes than I care to risk in a dot-release. Tom Lane 2001-05-15 00:33:36 +00:00
  • e611348894 Let's stick to the documented number of digits in CATVERSION, shall we? Tom Lane 2001-05-15 00:00:15 +00:00
  • 9d17a1dd29 Update regression for new oids, some now two smaller. Bruce Momjian 2001-05-14 22:16:15 +00:00
  • 70aa2ae6a5 Remove linking hacks now that dynloader is fixed. Peter Eisentraut 2001-05-14 22:06:50 +00:00
  • 80d4ae931a Small include file fix for pg_variabie.h Bruce Momjian 2001-05-14 22:06:41 +00:00
  • 61ba9e685b Update catalog version for fix. Bruce Momjian 2001-05-14 21:59:19 +00:00
  • 7d9504d4e2 Pg_varaiable removal cleanup found from regression. Bruce Momjian 2001-05-14 21:58:10 +00:00
  • 783fbdab70 Remove columns pg_index.haskeytype and pg_index.indisclustered. Not used. Bruce Momjian 2001-05-14 21:53:16 +00:00
  • c87bc779d4 Use RTLD_GLOBAL flag for dlopen-style dynamic loaders. Peter Eisentraut 2001-05-14 21:45:53 +00:00
  • 83966889ed Update TODO list. Bruce Momjian 2001-05-14 20:30:38 +00:00
  • 1e7b79cebc Remove unused tables pg_variable, pg_inheritproc, pg_ipl tables. Initdb forced. Bruce Momjian 2001-05-14 20:30:21 +00:00
  • 096e865438 Current implementation of FOR UPDATE has no hope of working correctly for relations on the nullable side of an OUTER JOIN. For now I think we'd better refuse such queries. Tom Lane 2001-05-14 20:25:36 +00:00
  • 248182560c Current implementation of FOR UPDATE has no hope of working correctly for relations on the nullable side of an OUTER JOIN. For now I think we'd better refuse such queries. Tom Lane 2001-05-14 20:25:00 +00:00
  • 7d802e07a7 Fix 'set path' for csh. Bruce Momjian 2001-05-14 16:16:52 +00:00
  • 2c632e6259 Fix 'set path' for csh, path -> $path. Bruce Momjian 2001-05-14 15:11:31 +00:00
  • fb029f0b36 Cope with configure arguments that contain spaces. Peter Eisentraut 2001-05-13 11:36:58 +00:00
  • 02a062c121 update. Bruce Momjian 2001-05-13 03:27:49 +00:00
  • 21e3848d20 Update TODO list. Bruce Momjian 2001-05-13 02:19:58 +00:00
  • 5ee76ac8c0 > I've been experimenting with pgcrypto 0.3 (distributed with > Postgres 7.1.0), and I think I've found a bug. > > I compiled Pgcrypto with OpenSSL, using gcc 2.95.4 and > OpenSSL 0.9.6a (the latest Debian 'unstable' packages). Bruce Momjian 2001-05-13 02:17:09 +00:00
  • 904ba3ff69 Update to ora2pg 1.2. Bruce Momjian 2001-05-13 02:10:00 +00:00
  • 911a498176 Update TODO list. Bruce Momjian 2001-05-13 01:05:34 +00:00
  • 1f5191ef34 Cope with configure arguments that contain spaces. Peter Eisentraut 2001-05-13 00:12:05 +00:00
  • e6903c49a5 proisstrict must be assumed FALSE when dumping from a 7.0 database, not TRUE. Otherwise we break pl call handler functions. fmgr_oldstyle will take care of making sure the semantics are the same for C functions. Clean up some slightly grotty coding in 7.0 pg_class reading, also. Tom Lane 2001-05-12 23:36:44 +00:00
  • e7c5639226 proisstrict must be assumed FALSE when dumping from a 7.0 database, not TRUE. Otherwise we break pl call handler functions. fmgr_oldstyle will take care of making sure the semantics are the same for C functions. Clean up some slightly grotty coding in 7.0 pg_class reading, also. Tom Lane 2001-05-12 23:36:03 +00:00
  • 01839df6dd Add index. Only some parts of the manual set have index entries so far... Peter Eisentraut 2001-05-12 22:51:36 +00:00
  • 631b3e4691 Backpatch jdbc1 compile failure fix. Bruce Momjian 2001-05-12 20:45:45 +00:00
  • eedb7d18fa Modify RelationGetBufferForTuple() so that we only do lseek and lock when we need to move to a new page; as long as we can insert the new tuple on the same page as before, we only need LockBuffer and not the expensive stuff. Also, twiddle bufmgr interfaces to avoid redundant lseeks in RelationGetBufferForTuple and BufferAlloc. Successive inserts now require one lseek per page added, rather than one per tuple with several additional ones at each page boundary as happened before. Lock contention when multiple backends are inserting in same table is also greatly reduced. Tom Lane 2001-05-12 19:58:28 +00:00
  • d9f55edc2c Add provisions for using strdup replacement in the places that still needed it. Peter Eisentraut 2001-05-12 19:49:48 +00:00
  • b3f66d1980 Add command '\pset footer' to psql to turn off default "(x rows)" footer. Peter Eisentraut 2001-05-12 19:44:46 +00:00
  • bbc3920fe9 PL/Python should build portably now, if you can get over the fact that there's no shared libpython. Test suite works as well. Also, add some documentation. Peter Eisentraut 2001-05-12 17:49:32 +00:00
  • 02549a2d2c Add comment to explain need for bizarre-looking coding in HandleSlashCmds. Tom Lane 2001-05-12 17:37:15 +00:00
  • 2e1579a99f Make bootstrap debug messages more readable. Clean up some clutter. Peter Eisentraut 2001-05-12 01:48:49 +00:00
  • c51b00a213 PL/Python integration: support in create/droplang, add CVS keywords, remove useless files, beat some sense into Makefile. For me it builds and sort of runs, so it's a start. Peter Eisentraut 2001-05-12 01:30:30 +00:00
  • e94a214de9 - Don't dump COMMENTs in data-only dumps - Fix view dumping SQL for V7.0 - Fix bug when getting view oid with long view names - Treat SEQUENCE SET TOC entries as data entries rather than schema entries. - Make allowance for data entries that did not have a data dumper routine (eg. SEQUENCE SET) Philip Warner 2001-05-12 01:09:47 +00:00
  • bb30d49a2a - Don't dump COMMENTs in data-only dumps - Fix view dumping SQL for V7.0 - Fix bug when getting view oid with long view names - Treat SEQUENCE SET TOC entries as data entries rather than schema entries. - Make allowance for data entries that did not have a data dumper routine (eg. SEQUENCE SET) Philip Warner 2001-05-12 01:03:59 +00:00
  • 5e19e14ecd Cleanups of pltcl unknown thingy. Peter Eisentraut 2001-05-11 23:38:06 +00:00
  • 7a76e29b0e no more Andy Piper tools Peter Eisentraut 2001-05-11 22:27:12 +00:00
  • bebd0938b6 no more Andy Piper tools Peter Eisentraut 2001-05-11 22:26:30 +00:00
  • 0ad9abe72e Improve discussion of %TYPE and %ROWTYPE. Tom Lane 2001-05-11 06:10:44 +00:00
  • 1c1eb0fa0e Suppress failures in parallel regress tests due to use of same table name in two different tests. This solution does not meet with universal approval, so it may get changed later ... Tom Lane 2001-05-11 05:09:03 +00:00
  • 54d9099596 Stamp CVS as 7.2. Update all interface version numbers. This is the time to do it, not during beta because people are using this stuff in production sometimes. Bruce Momjian 2001-05-11 01:46:33 +00:00
  • 1d211a6be3 Can't run autoconf on rel, so just manually update. Bruce Momjian 2001-05-11 01:35:47 +00:00
  • 4dc661984b Stamp for 7.1.2. Ready when you are... Bruce Momjian 2001-05-11 01:34:42 +00:00
  • d4dfef1cdb Stamp for 7.1.2. Ready when you are... Bruce Momjian 2001-05-11 01:34:14 +00:00