hcq/postgresql
1
0
Fork 0
mirror of https://git.postgresql.org/git/postgresql.git synced 2026-02-14 10:27:04 +08:00
Code Issues Packages Projects Releases Wiki Activity

Commit Graph

  • b6f75fe786 Update TODO list. Bruce Momjian 2001-06-29 21:28:16 +00:00
  • af5ced9cfd Further work on connecting the free space map (which is still just a stub) into the rest of the system. Adopt a cleaner approach to preventing deadlock in concurrent heap_updates: allow RelationGetBufferForTuple to select any page of the rel, and put the onus on it to lock both buffers in a consistent order. Remove no-longer-needed isExtend hack from API of ReleaseAndReadBuffer. Tom Lane 2001-06-29 21:08:25 +00:00
  • 0eab92c0e6 Fix VACUUM so that it can use pages as move targets even if they do not have any newly-dead tuples on them. This is a longstanding deficiency that prevents VACUUM from compacting a file as much as one would expect. Change requires fixing repair_frag to not assume that fraged_pages is a subset of vacuum_pages. Also make some further cleanups of places that assumed page numbers fit in int and tuple counts fit in uint32. Tom Lane 2001-06-29 20:14:27 +00:00
  • 4fe8490b5d Add replication email. Bruce Momjian 2001-06-29 20:10:12 +00:00
  • 56720e52b8 Add info on MATCH PARTIAL. Bruce Momjian 2001-06-29 20:07:23 +00:00
  • db491a6d78 SimpleDateFormat performance improvement, thread-safe. Bruce Momjian 2001-06-29 17:23:33 +00:00
  • 1d15afda13 Fix longstanding error in VACUUM: sometimes would examine a buffer page after writing/unpinning it. An actual failure is unlikely, unless the system is tremendously short of buffers ... but a bug is a bug. Tom Lane 2001-06-29 16:34:49 +00:00
  • 39381507b7 Fix longstanding error in VACUUM: sometimes would examine a buffer page after writing/unpinning it. An actual failure is unlikely, unless the system is tremendously short of buffers ... but a bug is a bug. Tom Lane 2001-06-29 16:34:30 +00:00
  • 1d4ee0cc1e Turned high-frequently called pgstat functions into macros for speed. Jan Wieck 2001-06-29 16:29:37 +00:00
  • f889b12be9 Fix erroneous GUC variable references from commandline-GUC patch. Tom Lane 2001-06-29 16:05:57 +00:00
  • fb2c3289ff Repair logic error for multi-key indexes. From Oleg Bartunov. Tom Lane 2001-06-28 16:00:07 +00:00
  • 9a162a39d9 Add to thread item. Bruce Momjian 2001-06-28 15:19:11 +00:00
  • e0c9301c87 Install infrastructure for shared-memory free space map. Doesn't actually do anything yet, but it has the necessary connections to initialization and so forth. Make some gestures towards allowing number of blocks in a relation to be BlockNumber, ie, unsigned int, rather than signed int. (I doubt I got all the places that are sloppy about it, yet.) On the way, replace the hardwired NLOCKS_PER_XACT fudge factor with a GUC variable. Tom Lane 2001-06-27 23:31:40 +00:00
  • b559382134 National language support for pg_dump and pg_restore. Combined with big message clean up. Peter Eisentraut 2001-06-27 21:21:37 +00:00
  • 14807a3c98 Remove another unused include file with obsolete, useless, confusing definitions in it. Tom Lane 2001-06-27 19:02:48 +00:00
  • 0787b904dc Add jdbc item. Bruce Momjian 2001-06-27 18:07:11 +00:00
  • c418512e7a Update TODO list. Bruce Momjian 2001-06-27 18:06:49 +00:00
  • 069ea33073 Update TODO list. Bruce Momjian 2001-06-27 18:05:37 +00:00
  • 69ac9e9cd3 Update TODO list. Bruce Momjian 2001-06-27 17:27:40 +00:00
  • f62c5f861a Update TODO list. Bruce Momjian 2001-06-27 16:24:17 +00:00
  • bbca11bf3b Handle Procedure calls. Now the version is 7.01.0006. Hiroshi Inoue 2001-06-27 07:38:07 +00:00
  • ef20f0ce25 Update TODO list. Bruce Momjian 2001-06-26 19:43:11 +00:00
  • 5d9ffb0cdf Update TODO list. Bruce Momjian 2001-06-26 15:07:59 +00:00
  • 0225f2f1c7 Update TODO list. Bruce Momjian 2001-06-26 04:04:49 +00:00
  • b9d258e872 Update TODO list. Bruce Momjian 2001-06-26 04:03:25 +00:00
  • 5ba723e950 Fix a couple remaining places where GUC variables were assigned to directly, rather than through SetConfigOption(). Tom Lane 2001-06-25 23:03:03 +00:00
  • 2e67a67715 Fix a couple remaining places where GUC variables were assigned to directly, rather than through SetConfigOption(). Tom Lane 2001-06-25 22:56:05 +00:00
  • 4d58a7ca87 Optimizer can now estimate selectivity of IS NULL, IS NOT NULL, IS TRUE, etc, with some degree of verisimilitude. Split out selectivity support functions from builtins.h into a new header file selfuncs.h, so as to reduce the number of header files builtins.h must depend on. Fix a few missing inclusions exposed thereby. From Joe Conway, with some kibitzing from Tom Lane. Tom Lane 2001-06-25 21:11:45 +00:00
  • c31545af27 Suppress gcc warning. Tom Lane 2001-06-25 20:20:02 +00:00
  • 54361b4233 High memory usage Bruce Momjian 2001-06-25 01:53:59 +00:00
  • 06f6404c42 Back out BYTEA binary compatibility changes. Bruce Momjian 2001-06-24 02:41:21 +00:00
  • aea3283cb4 Don't use a temp file. It was created insecurely and was easy to do without. Peter Eisentraut 2001-06-23 23:29:48 +00:00
  • f1423cd9fc Since a missing pg_pwd file is a valid situation, don't print an error message in that case. Peter Eisentraut 2001-06-23 23:26:17 +00:00
  • 6a7f23c213 > Marko Kreen <marko@l-t.ee> writes: > > secure_ctx changes too. it will be PGC_BACKEND after '-p'. > > Oh, okay, I missed that part. Could we see the total state of the > patch --- ie, a diff against current CVS, not a bunch of deltas? > I've gotten confused about what's in and what's out. Bruce Momjian 2001-06-23 22:23:49 +00:00
  • 2e2d17ed51 Here the latest version and first working release of Ora2Pg a tool to export Oracle database to PostgreSQL. Bruce Momjian 2001-06-23 02:56:23 +00:00
  • a0c12d5e90 Add TEMPORARY sequences and have SERIAL on a temp table have a temporary sequence. Bruce Momjian 2001-06-23 00:07:34 +00:00
  • 280b5f4be6 fix markup Peter Eisentraut 2001-06-23 00:03:10 +00:00
  • adf1c52ce6 updates for new startup sequence, some reformatting Peter Eisentraut 2001-06-22 23:27:48 +00:00
  • 9e39ffe4cd Attached is documentation describing plperlu differences from plperl. Bruce Momjian 2001-06-22 21:37:14 +00:00
  • 140ddb78fe The new files for statistical system views. Jan Wieck 2001-06-22 19:18:36 +00:00
  • 8d80b0d980 Statistical system views (yet without the config stuff, but it's hard to keep such massive changes in sync with the tree so I need to get it in and work from there now). Jan Wieck 2001-06-22 19:16:24 +00:00
  • 7d6e28149e Mention that EXPLAIN results on small tables shouldn't be extrapolated to large tables. Recommend ANALYZE or VACUUM ANALYZE after populating a table. Tom Lane 2001-06-22 18:53:36 +00:00
  • 31fe394cd8 Include catalog/pg_type.h instead of manually extracting the interesting oid values. Peter Eisentraut 2001-06-22 17:48:39 +00:00
  • a8dbe428de Change SQLPrimaryKeys() so that it detects the primary key other than tablename_pkey. Hiroshi Inoue 2001-06-22 05:59:43 +00:00
  • d8d9ed931e Add support to lock manager for conditionally locking a lock (ie, return without waiting if we can't get the lock immediately). Not used yet, but will be needed for concurrent VACUUM. Tom Lane 2001-06-22 00:04:59 +00:00
  • 986915c181 Remove unused include file for long-dead flavors of locking. Tom Lane 2001-06-21 21:01:36 +00:00
  • 695e575470 Tweak error message. Tom Lane 2001-06-21 19:45:45 +00:00
  • bcde8ea7cf Fix strangely formatted comment. Bruce Momjian 2001-06-21 18:25:54 +00:00
  • f3868f8af9 A bit of code beautification/cleanup of obsolete comments. Rethink ordering of startup operations in one or two places. Tom Lane 2001-06-21 16:43:24 +00:00
  • 90e2663313 Shared libraries should not be linked explicitly against -lc on FreeBSD (see http://mail.gnu.org/pipermail/libtool/2000-July/001824.html). But apparently it should still be present with -Bsymbolic. Peter Eisentraut 2001-06-20 20:25:11 +00:00
  • 7fdd76cd08 -Bsymbolic requires -lc on NetBSD. Also add rpath for non-ELF. Peter Eisentraut 2001-06-20 20:15:45 +00:00
  • e3cade2e29 Re-add explicit declaration of filename_completion_function(), which seems to be missing in some header files (on OpenBSD 2.8?). Peter Eisentraut 2001-06-20 18:39:14 +00:00
  • c5f7a94f3c There is no RTLD_GLOBAL on OpenBSD, says Alex Pilosov <alex@pilosoft.com>. Peter Eisentraut 2001-06-20 18:33:31 +00:00
  • f445289781 Swedish translation for psql (my interpretation of Swedish, surely) Peter Eisentraut 2001-06-20 18:25:26 +00:00
  • 9b4bfbdc2c Handle reading of startup packet and authentication exchange after forking a new postmaster child process. This should eliminate problems with authentication blocking (e.g., ident, SSL init) and also reduce problems with the accept queue filling up under heavy load. Peter Eisentraut 2001-06-20 18:07:56 +00:00
  • 588463a449 Make sure that everything says version 3.2. D'Arcy J.M. Cain 2001-06-20 11:20:34 +00:00
  • 54e374c9e6 Add NUMERICOID to this script. This script can be run occasionally to make sure that we are using the right #defines in pgmodule.c but the OIDs are never actually expected to change. D'Arcy J.M. Cain 2001-06-20 11:19:56 +00:00
  • 9c50a0047f Change the driver so that large error messages are returned by multiple SQLError calls. Hiroshi Inoue 2001-06-20 07:06:40 +00:00
  • f5d0c6cad5 Apparently, on some systems, ExtUtils::Embed and MakeMaker are slightly broken, and its impossible to make a shared library when compiling with both CCDLFLAGS and LDDLFAGS, you have to pick one or the other. Bruce Momjian 2001-06-20 00:26:06 +00:00
  • 7aac048b59 Attached is a patch to deal with the ones that I missed the first time around. I tested this patch under Cygwin and Linux. Bruce Momjian 2001-06-20 00:04:44 +00:00
  • 2e81f3d204 Back out SET ALL patch because it is breaking things. Bruce Momjian 2001-06-19 23:40:10 +00:00
  • 116d2bba7e Add IS UNKNOWN, IS NOT UNKNOWN boolean tests, fix the existing boolean tests to return the correct results per SQL9x when given NULL inputs. Reimplement these tests as well as IS [NOT] NULL to have their own expression node types, instead of depending on special functions. From Joe Conway, with a little help from Tom Lane. Tom Lane 2001-06-19 22:39:12 +00:00
  • 8c30aca2ba Fix badly broken RelationGetRelationName(). Tom Lane 2001-06-19 21:28:41 +00:00
  • bbbc00af88 Clean up some longstanding problems in shared-cache invalidation. SI messages now include the relevant database OID, so that operations in one database do not cause useless cache flushes in backends attached to other databases. Declare SI messages properly using a union, to eliminate the former assumption that Oid is the same size as int or Index. Rewrite the nearly-unreadable code in inval.c, and document it better. Arrange for catcache flushes at end of command/transaction to happen before relcache flushes do --- this avoids loading a new tuple into the catcache while setting up new relcache entry, only to have it be flushed again immediately. Tom Lane 2001-06-19 19:42:16 +00:00
  • d9a069e224 Move temprel name define from temprel.h to rel.h. Bruce Momjian 2001-06-19 12:03:41 +00:00
  • d47e10bfde Bring RelationGetRelationName into sync with new temp rel names. Quick hack -- need to decide which header should include the other. Tom Lane 2001-06-19 05:11:50 +00:00
  • 8804bdcd0e Corrected the check for *message truncated* for the future use. Hiroshi Inoue 2001-06-19 03:17:12 +00:00
  • 76d38cb0c6 Changed the error handling as follows. 1) ERRORs cause an SQL_ERROR and the SQLSTATE='S1000'. 2) NOTICEs cause an SQL_SUCCESS_WITH_INFO and the succeeding SQLError() returns the NOTICE message. Hiroshi Inoue 2001-06-19 02:17:06 +00:00
  • 3709a5ada7 RESET ALL secondary patch: Bruce Momjian 2001-06-18 23:42:32 +00:00
  • 0ed7864d68 Well, after persuading cvsup and cvs that it _is_ possible to have local modifiable repositories, I have a clean untrusted plperl patch to offer you :) Bruce Momjian 2001-06-18 21:40:06 +00:00
  • 558fae16e3 The attached patch enables the contrib subtree to build cleanly under Cygwin with the possible exception of mSQL-interface. Since I don't have mSQL installed, I skipped this tool. Bruce Momjian 2001-06-18 21:38:02 +00:00
  • 22dc12b8c3 Untar copyright.html file and make good version. Bruce Momjian 2001-06-18 21:34:34 +00:00
  • 10b5f0bea8 Here's a small patch for dblink: Bruce Momjian 2001-06-18 19:09:50 +00:00
  • ec96f1dacd Fix some references to USE_AUSTRALIAN_RULES that Bruce missed; plus a few trivial improvements in wording. Tom Lane 2001-06-18 19:05:11 +00:00
  • bf2a92365c Update FAQ. Bruce Momjian 2001-06-18 18:56:03 +00:00
  • 3dba1ff6e8 Add new dblink to /contrib Makefile.' Bruce Momjian 2001-06-18 17:20:56 +00:00
  • 7dac778561 Add GUC setting for Australian timezones. Uses new GUC boolean callback functions to clear date cache. Allow regression tests to pass when timezone set. Bruce Momjian 2001-06-18 16:14:44 +00:00
  • 49ce6fff1d Allow removal of system-named pg_* temp tables. Rename temp file/dir as pgsql_tmp. Bruce Momjian 2001-06-18 16:13:21 +00:00
  • 0bba6bdb8a Improve wording of authentication files. Bruce Momjian 2001-06-18 16:11:30 +00:00
  • 2c5aa2acb4 Do some restructuring to improve performance of the catcaches. Teach CatalogCacheFlushRelation (formerly called SystemCacheRelationFlushed) how to distinguish tuples it should flush from those it needn't; this means a relcache flush event now only removes the catcache entries it ought to, rather than zapping the caches completely as it used to. Testing with the regression tests indicates that this considerably improves the lifespan of catcache entries. Also, rearrange catcache data structures so that the limit on number of cached tuples applies globally across all the catcaches, rather than being per-catcache. It was a little silly to have the same size limit on both, say, pg_attribute caches and pg_am caches (there being only four possible rows in the latter...). Doing LRU removal across all the caches instead of locally in each one should reduce cache reload traffic in the more heavily used caches and improve the efficiency of cache memory use. Tom Lane 2001-06-18 03:35:07 +00:00
  • 41c377f5c6 Fix *escape* handling in copy_statement_with_parameters(was my fault). Hiroshi Inoue 2001-06-18 02:16:09 +00:00
  • 6054b33290 Keep the list of to-be-NOTIFYed names in a plain List palloc'd in TopTransactionContext, rather than using Dllist. This simplifies and speeds up the code, and eliminates a former risk of coredump when out of memory (since the old code didn't bother to check for malloc failure). It also moves us one step closer to retiring Dllist... Tom Lane 2001-06-17 22:27:15 +00:00
  • 1f1ca182be Make inet/cidr << and <<= operators indexable. From Alex Pilosov <alex@pilosoft.com>. Tom Lane 2001-06-17 02:05:20 +00:00
  • 2917f0a5dd Tweak startup sequence so that running out of PROC array slots is detected sooner in backend startup, and is treated as an expected error (it gives 'Sorry, too many clients already' now). This allows us not to have to enforce the MaxBackends limit exactly in the postmaster. Also, remove ProcRemove() and fold its functionality into ProcKill(). There's no good reason for a backend not to be responsible for removing its PROC entry, and there are lots of good reasons for the postmaster not to be touching shared-memory data structures. Tom Lane 2001-06-16 22:58:17 +00:00
  • 668db147d5 It turns out that the relcache thinks it can distinguish different rules and triggers by OID. So, even though we have no cross-references in the system catalogs to pg_rewrite.oid or pg_trigger.oid, we'd better have unique indexes on them. Put back pg_rewrite_oid_index, which I mistakenly removed a few days ago, and add pg_trigger_oid_index. Tom Lane 2001-06-16 18:59:31 +00:00
  • 2adf1ce63c Oops, forgot to commit doco updates for has_table_privilege. Tom Lane 2001-06-15 21:03:07 +00:00
  • a8261182d2 fixed bug in connect.c Michael Meskes 2001-06-15 09:55:51 +00:00
  • f09546fabf Add bpchar to list of string types. Thanks to Steve McClure <smcclure@racemi.com> for the patch. D'Arcy J.M. Cain 2001-06-15 02:23:18 +00:00
  • 823ab92295 Add missing PG_SETMASK(&BlockSig) to SIGHUP_handler(). Tom Lane 2001-06-14 19:59:24 +00:00
  • 16ea152b7e Revoke public read access from pg_statistic, create new system view pg_stats to provide controlled (and, hopefully, more readable) access to statistics. Comments on definition of pg_stats welcome. I didn't force initdb, but the rules regress test will fail until you do one. Tom Lane 2001-06-14 19:47:25 +00:00
  • 5af4855383 Allow remote query execution (dblink) Bruce Momjian 2001-06-14 16:49:03 +00:00
  • b33c66234e Remove more NULL lines. Bruce Momjian 2001-06-14 04:59:59 +00:00
  • c4f532db78 Fix nulls in HTML file. Bruce Momjian 2001-06-14 04:24:01 +00:00
  • c9499e68da has_table_privilege functions from Joe Conway (with some kibitzing from Tom Lane). For the moment, only the OID/name variants are provided. I didn't force initdb, but the additions to the 'privileges' regress test won't pass until you do one. Tom Lane 2001-06-14 01:09:22 +00:00
  • d7763c1f9c Docs for: Bruce Momjian 2001-06-13 22:51:02 +00:00
  • 1a6bb6d877 Allow a non-superuser database owner to vacuum all tables in his database, including system catalogs (but not the shared catalogs, since they don't really belong to his database). This is per recent mailing list discussion. Clean up some other code that also checks for database ownerness by introducing a test function is_dbadmin(). Tom Lane 2001-06-13 21:44:41 +00:00
  • f21e3407e6 Fix for duplicate oids just introduced in patch. Don't think it needs initdb unless you are using inet types. Bruce Momjian 2001-06-13 21:12:43 +00:00
  • d4a4d4c326 Attached is a patch adding following functions: Bruce Momjian 2001-06-13 21:09:00 +00:00
  • 82dc79702f Fix compile failure when --enable-multibyte. Bruce Momjian 2001-06-13 21:07:12 +00:00
  • dbe49b8c66 Update TODO list. Bruce Momjian 2001-06-13 20:17:05 +00:00