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

Commit Graph

  • 5541abee0d 1. Additional fix against ERROR: Child itemid marked as unused in CommitTransaction(). 2. Changes in GetSnapshotData(). Vadim B. Mikheev 1999-06-03 13:33:13 +00:00
  • f103501286 Unuseful tuple.t_data->t_infomask & HEAP_XMIN_COMMITTED in vc_scanheap(). Vadim B. Mikheev 1999-06-03 13:25:54 +00:00
  • fb4f5f7cac Notes in Migration to v6.5 section. Vadim B. Mikheev 1999-06-03 07:11:50 +00:00
  • 9680a71205 1. MyProc->xid assignment is moved to GetNewTransactionId so newer transactions will not assume that MyProc transaction was committed before snapshot calculations. With old MyProc->xid assignment (in xact.c:StartTransaction()) there was ability to see the same row twice (I used gdb for this)!... 2. Assignments of InvalidTransactionId to MyProc->xid and MyProc->xmin are moved from xact.c:CommitTransaction() to xact.c:RecordTransactionCommit() - this invalidation must be done before releasing transaction locks or bad (too high) XmaxRecent value might be used by vacuum ("ERROR: Child itemid marked as unused" reported by "Hiroshi Inoue" <Inoue@tpf.co.jp>; once again, gdb allowed me reproduce this error). Vadim B. Mikheev 1999-06-03 04:41:41 +00:00
  • f3d2b2e0c7 Markup changes for v6.5 release. Clean out duplicate stuff in odbc.sgml resulting from a faulty patch. Thomas G. Lockhart 1999-06-03 04:21:51 +00:00
  • 214e8f3292 CGM format from Hannu. Seem to have lost the .ag original :( Thomas G. Lockhart 1999-06-03 04:20:32 +00:00
  • 3d34943b92 New versions of hardcopy for 6.5 release. Thomas G. Lockhart 1999-06-03 04:18:58 +00:00
  • 58d8584eea pg_dump failed on any database containing large objects, because it ignored the LOs themselves but failed to ignore the indexes on the LOs. How long has this been broken?? Tom Lane 1999-06-03 04:01:16 +00:00
  • f463c44fc0 Ensure consistent results when FormSortKeys fails to find all the expected keys (it was returning uninitialized memory). Tom Lane 1999-06-03 03:17:37 +00:00
  • 9b3e2dda16 Ooops ... dllist.c can't use Assert() when it is compiled into libpq ... Tom Lane 1999-06-03 01:28:24 +00:00
  • 98981a9f1c Changed "current." into "old." in rule string backparsing Jan Wieck 1999-06-02 11:52:29 +00:00
  • e47b93d333 The INET and CIDR types mistakenly compared 198.68.123.0/24 and 198.68.123.0/27 the same when indexing them. Bruce Momjian 1999-06-02 03:37:15 +00:00
  • 8593e1ff09 Make sure that only one intro is included in the integrated doc. Multiple intros cause trouble since they have some section elements (e.g. "y2k.sgml") in common leading to duplicate labels. Include emacs formatting hints in the intro*.sgml sources. Thomas G. Lockhart 1999-06-01 17:26:18 +00:00
  • bbf37e9477 typedef struct LTAG { Oid relId; Oid dbId; union { BlockNumber blkno; TransactionId xid; } objId; > > Added: > /* > * offnum should be part of objId.tupleId above, but would increase > * sizeof(LOCKTAG) and so moved here; currently used by userlocks only. > */ > OffsetNumber offnum; uint16 lockmethod; /* needed by userlocks */ } LOCKTAG; Vadim B. Mikheev 1999-06-01 09:35:39 +00:00
  • 42a02c441a forgot to attach the patch. :( Bruce Momjian 1999-06-01 02:43:37 +00:00
  • d2ab04ca73 commented out PgConnection& references for now. May be using them later. Bruce Momjian 1999-06-01 02:37:33 +00:00
  • 185b427284 Fix some latent bugs in dllist.c (carelessness about setting all fields that should be set). Add a MoveToFront primitive to speed up one of the hotspots in SearchSysCache. Tom Lane 1999-05-31 23:48:04 +00:00
  • 2a44383a2d Clean up memory leaks in LO operations by freeing LO's private memory context at transaction commit or abort. Tom Lane 1999-05-31 22:53:59 +00:00
  • 81ced1e037 Generate a more specific error message when an operator used in an index doesn't have a restriction selectivity estimator. Tom Lane 1999-05-31 19:32:47 +00:00
  • cc384fa240 Round up shmem size estimate to 1Kb boundary. Tom Lane 1999-05-31 18:28:52 +00:00
  • 86482e17bd Correct serious bug in hashtable expansion routine: under the right circumstances it would leave old and new bucket headers pointing to the same list of records. Tom Lane 1999-05-31 17:01:52 +00:00
  • 7f79496aa5 NT similar file update. Bruce Momjian 1999-05-31 16:18:53 +00:00
  • 219bb76d61 Release XactLockTable share lock immediately after this lock is acquired (no sense to hold it) or we'll be out of lock entries. Great thanks to Hiroshi Inoue. Vadim B. Mikheev 1999-05-31 01:48:13 +00:00
  • ca08ce28e8 Clean up uninitialized-variable warning from egcs. (Curious that gcc doesn't complain about this code...). Tom Lane 1999-05-30 15:32:45 +00:00
  • 3257b0e592 egcs thinks omitting the return type in a function declaration is poor coding style. I agree. Tom Lane 1999-05-30 15:22:34 +00:00
  • d4d297af3c Replace static rcsid[] strings by IDENTIFICATION comments in file headers, to conform to established Postgres coding style and avoid warnings from gcc. Tom Lane 1999-05-30 15:17:58 +00:00
  • 6687bcb558 configure.in forgot to do AC_LANG_C to reselect C-based tests after checking for presence of C++ compiler. Odd we hadn't seen any reports of problems before... Tom Lane 1999-05-30 00:06:44 +00:00
  • 6f979c1541 Turns out that configure's test for HPUXMATHLIB didn't work when used with egcs --- now it does. Tom Lane 1999-05-29 16:26:42 +00:00
  • df9e539ea2 1. Run all pg_dump queries in single serializable transaction. 2. Get rid of locking when updating statistics in vacuum. 3. Use QuerySnapshot in COPY TO and call SetQuerySnashot in main tcop loop before FETCH and COPY TO. Vadim B. Mikheev 1999-05-29 10:25:33 +00:00
  • bbbc211ed1 Fix xid table sizing. Vadim B. Mikheev 1999-05-29 06:14:43 +00:00
  • dfefad7db0 Missing semicolons in non-HAS_TEST_AND_SET code paths :-( Tom Lane 1999-05-29 03:58:43 +00:00
  • 1bdd7c68c0 Avoid redundant SysCache searches in coerce_type, for another few percent speedup in INSERT... Tom Lane 1999-05-29 03:17:20 +00:00
  • b325dab67a new_relation_targetlist used to cause about 8 separate (and redundant) SearchSysCache searches per table column in an INSERT, which accounted for a good percentage of the CPU time for INSERT ... VALUES(). Now it only does two searches in the typical case. Tom Lane 1999-05-29 01:48:06 +00:00
  • ce2586dbc9 Clean up inefficient and just plain bad code in some hot-spot cache access routines. Tom Lane 1999-05-29 01:45:21 +00:00
  • dc6d404959 Repair performance problem in SI segment manipulations: iterating through MAXBACKENDS array entries used to be fine when MAXBACKENDS = 64. It's not so cool with MAXBACKENDS = 1024 (or more!), especially not in a frequently-used routine like SIDelExpiredDataEntries. Repair by making procState array size be the soft MaxBackends limit rather than the hard limit, and by converting SIGetProcStateLimit() to a macro. Tom Lane 1999-05-28 17:03:31 +00:00
  • 33c6d6099d Clean up mention of gmake vs. make. Bruce Momjian 1999-05-28 14:24:24 +00:00
  • b344b513c7 Update pygresql version stamp. Bruce Momjian 1999-05-28 04:54:34 +00:00
  • f0ae1e8d10 When closure of the backend connection is detected during pqFlush, do the right thing: look for a NOTICE message from the backend before we close our side of the socket. 6.4 libpq did not reliably print the backend's hara-kiri message, 'The Postmaster has informed me ...', because it only did the right thing if connection closure was detected during a read attempt instead of a write attempt. Tom Lane 1999-05-28 01:54:53 +00:00
  • 615e77ede2 Make pg_dump dump ACL's by default, print warning on use of -z, and add new -x option to skip acl dump. Bruce Momjian 1999-05-27 16:29:05 +00:00
  • e53c51280b More info is in sgml and html docs so this is now obsolete. Thomas G. Lockhart 1999-05-27 16:06:33 +00:00
  • 39c02dfefa FAQs contributed for this release. Thomas G. Lockhart 1999-05-27 16:05:38 +00:00
  • 5b1b477cca Markup fixes. Thomas G. Lockhart 1999-05-27 15:49:15 +00:00
  • b805230906 Markup fixes. Update for v6.5 release. Thomas G. Lockhart 1999-05-27 15:49:08 +00:00
  • 7d831b5379 Significant updates from Vince Vielhaber. Thomas G. Lockhart 1999-05-27 15:48:14 +00:00
  • b04b01638b Remove disclaimer about exact numeric types. They work now! Thomas G. Lockhart 1999-05-27 15:47:28 +00:00
  • 8a3c7535c5 Refresh FreeBSD info. Thomas G. Lockhart 1999-05-27 15:46:22 +00:00
  • d6efbf1956 Significant update from Vince Vielhaber. Thomas G. Lockhart 1999-05-27 15:44:54 +00:00
  • 874957a32a Update release notes for 6.5. Bruce Momjian 1999-05-27 15:13:43 +00:00
  • 5fec534f4b Clean up release sgml file. Bruce Momjian 1999-05-27 15:05:57 +00:00
  • 781a1eb99a I am not sure if libpq++ will compile with non g++ compilers, but the Makefile does break non g++. Bruce Momjian 1999-05-27 14:28:40 +00:00
  • 0d5f7ce11c Fix for crypt memory leak, from James Thompson Bruce Momjian 1999-05-27 04:09:45 +00:00
  • 7c8beefd5e Patch from Andreas: when CREATE TABLE is followed by CREATE INDEX before any tuples are loaded, preserve the default '1000 tuples' table size estimate. Tom Lane 1999-05-26 22:57:39 +00:00
  • 8eb18d874e Fix pg_dump to use the same maximum-query-size constant as the backend does. Remove unnecessary limitation on field size in dumpClasses_dumpData (ie, -d or -D case). Tom Lane 1999-05-26 21:51:13 +00:00
  • 26fb87d37e Fix compile of plpgsql by adding 'extern int yylineno.' Bruce Momjian 1999-05-26 20:55:06 +00:00
  • bf09f8aa43 Display numeric precision on \d. Bruce Momjian 1999-05-26 20:08:06 +00:00
  • e7528612d8 Allow GROUPs to be dumped properly. Bruce Momjian 1999-05-26 19:45:53 +00:00
  • 9474dd7ed6 Add chapters on CVS access, MVCC, SQL theory to the docs. Add an appendix with more details on date/time attributes and handling. Update most references to Postgres version numbers to 6.5, *except* for the porting list which will require a report from a successful installation to be updated. Thomas G. Lockhart 1999-05-26 17:30:30 +00:00
  • 0807dbb294 Chapter on multi-version concurrency control from Vadim. Some wording changes from Vadim's original text doc. Processes cleanly, but may need fixup. Thomas G. Lockhart 1999-05-26 17:27:39 +00:00
  • bb0fc46a90 Add new reference pages for postmaster and postgres. Normalize markup for vacuumdb; content is the same. Thomas G. Lockhart 1999-05-26 17:26:32 +00:00
  • ff8bf5a0ef First copy from the man pages. postgres-ref.sgml is not yet marked up. Thomas G. Lockhart 1999-05-26 17:25:38 +00:00
  • fe2bcf854c Fix for NT from Horak Daniel Bruce Momjian 1999-05-26 16:19:48 +00:00
  • 9b35ec2615 Disable use of -o and -d pg_dump options together. Can't set oids in inserts. Change some variables to bool to be clearer. Bruce Momjian 1999-05-26 16:06:45 +00:00
  • 9c56b408c4 Add fix for 0x7fU constants to pgindent Bruce Momjian 1999-05-26 15:20:04 +00:00
  • eeadc5e87f Allow pg_dump -v display proper table/sequence count display. Bruce Momjian 1999-05-26 14:50:38 +00:00
  • 278bbf4572 Make functions static or NOT_USED as appropriate. Bruce Momjian 1999-05-26 12:57:23 +00:00
  • 180186272a Give BEOS a chance ... Marc G. Fournier 1999-05-26 01:22:24 +00:00
  • fcff1cdf4e Another pgindent run. Sorry folks. Bruce Momjian 1999-05-25 22:43:53 +00:00
  • 4eadfe8754 Make 0x007f -> (unsigned)0x7f to make pgindent happy. Bruce Momjian 1999-05-25 22:04:56 +00:00
  • 519cd36d06 Get rid of page-level locking in btree-s. BT_READ/BT_WRITE are BUFFER_LOCK_SHARE/BUFFER_LOCK_EXCLUSIVE now. Also get rid of #define BT_VERSION_1 - we use version 1 as default for near two years now. Vadim B. Mikheev 1999-05-25 18:31:28 +00:00
  • 7d443a85af Get rid of page-level locking in btree-s. LockBuffer is used to acquire read/write access to index pages. Pages are released before leaving index internals. Vadim B. Mikheev 1999-05-25 18:20:31 +00:00
  • 07842084fe pgindent run over code. Bruce Momjian 1999-05-25 16:15:34 +00:00
  • 4b04b01aaa *** empty log message *** Michael Meskes 1999-05-25 13:36:15 +00:00
  • b122e16a1c Bugfix - Range table entries that are unused after rewriting should not be marked inFromCl any longer. Otherwise the planner gets confused and joins over them where in fact it does not have to. Jan Wieck 1999-05-25 13:16:10 +00:00
  • f4fadbe4db Fixed bug in rules event qualification output. Jan Wieck 1999-05-25 08:49:33 +00:00
  • 6bf0db7e07 FIx for 0.0.0.0/0 output as 00/0. Bruce Momjian 1999-05-25 05:29:38 +00:00
  • 9432b6dd64 Do not assign output columns to junk attributes created from GROUP BY or ORDER BY expressions in INSERT ... SELECT. Tom Lane 1999-05-23 21:42:09 +00:00
  • 505b5185fc Detect case of invalid use of GROUP BY when there are no aggregate functions, as in select a, b from foo group by a; The ungrouped reference to b is not kosher, but formerly we neglected to check this unless there was an aggregate function somewhere in the query. Tom Lane 1999-05-23 21:41:14 +00:00
  • 57455fc565 Remove more -B parameters not needed. Bruce Momjian 1999-05-23 19:01:18 +00:00
  • bd5cf46e0c Remove -B from wisconsin test. Bruce Momjian 1999-05-23 18:53:30 +00:00
  • 7e14593d2e Fix tuple chain moving bug found by "Hiroshi Inoue" <Inoue@tpf.co.jp>. Vadim B. Mikheev 1999-05-23 09:10:24 +00:00
  • b14c99d8d6 Here it is. Remove or rename the current interfaces/libpq++ and untar this file in interfaces/ Bruce Momjian 1999-05-23 01:04:07 +00:00
  • 795f6ca66a Update commentary in sample GEQO config file. Tom Lane 1999-05-22 23:59:59 +00:00
  • b2f14e11ec Reduce default GEQO 'effort' setting to MEDIUM always. This agrees with the documentation and seems like a more useful default anyhow ... Tom Lane 1999-05-22 23:27:19 +00:00
  • d52a91a5d8 Modify aset.c logic so that blocks requested from malloc get bigger the more space is used in an allocset. This reduces the malloc overhead very substantially on queries that need lots of memory. Tom Lane 1999-05-22 23:19:37 +00:00
  • f9f90b21b2 Improve error message from failed LOAD command (include kernel's error description when file is not accessible). Tom Lane 1999-05-22 19:49:42 +00:00
  • b21005fa7c Allow GEQO effort to be specified numerically, as well as symbolic LOW/MEDIUM/HIGH values --- needed for experiments with other effort levels ... Tom Lane 1999-05-22 19:29:01 +00:00
  • cf1478982c Modify backend switch parsing to prevent 'insecure' switches from being accepted when they are passed from client connection request. Get rid of a couple that no longer do anything (like -P). Tom Lane 1999-05-22 17:47:54 +00:00
  • e9edb3ef92 Fix for select 1;select 2 without trailing semi. Bruce Momjian 1999-05-22 05:06:43 +00:00
  • a8d2820e6d Fix for DEFAULT ''. Bruce Momjian 1999-05-22 04:12:29 +00:00
  • 9710995fc9 Make postgres prompt backend>, and remove PARSEDEBUG. Bruce Momjian 1999-05-22 02:55:58 +00:00
  • 654f8f0b51 Finish initial markup of cvs.sgml, and include it in the programmer's guide and the integrated doc. Clean up other markup. Thomas G. Lockhart 1999-05-22 02:27:25 +00:00
  • 85170aa9b6 Change perl Makefile test. Bruce Momjian 1999-05-21 19:03:48 +00:00
  • 167529f221 Disable fix. Didn't work. Bruce Momjian 1999-05-21 18:33:12 +00:00
  • c0d979614e Fix typo and attempt default fix. Bruce Momjian 1999-05-21 18:31:06 +00:00
  • a7b06f20c5 *** empty log message *** Michael Meskes 1999-05-21 16:36:27 +00:00
  • 96492290b5 Treat {} as special regex too. Bruce Momjian 1999-05-21 15:47:13 +00:00
  • 08bcc77a5c add retest, a regex testing program Tatsuo Ishii 1999-05-21 06:27:54 +00:00
  • 56b9a549c7 Fix problem with | in ~ comparison using index. Bruce Momjian 1999-05-21 04:40:04 +00:00
  • a1d9186067 Add material about postmaster startup failure messages; update material about client connection failure messages. Tom Lane 1999-05-21 02:42:59 +00:00
  • b3ad49850e Report strerror() rather than errno in low-level backend libpq failure messages. Tom Lane 1999-05-21 01:25:06 +00:00