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

Commit Graph

  • 237e5dfa58 Update TODO list. Bruce Momjian 2001-07-16 05:01:46 +00:00
  • a9bf773017 Update TODO list. Bruce Momjian 2001-07-16 05:00:29 +00:00
  • c8076f09d2 Restructure index AM interface for index building and index tuple deletion, per previous discussion on pghackers. Most of the duplicate code in different AMs' ambuild routines has been moved out to a common routine in index.c; this means that all index types now do the right things about inserting recently-dead tuples, etc. (I also removed support for EXTEND INDEX in the ambuild routines, since that's about to go away anyway, and it cluttered the code a lot.) The retail indextuple deletion routines have been replaced by a "bulk delete" routine in which the indexscan is inside the access method. I haven't pushed this change as far as it should go yet, but it should allow considerable simplification of the internal bookkeeping for deletions. Also, add flag columns to pg_am to eliminate various hardcoded tests on AM OIDs, and remove unused pg_am columns. Tom Lane 2001-07-15 22:48:19 +00:00
  • 997439f59e Add ORDER BY to a couple of test queries whose output ordering is not as predictable as it used to be, due to recycling of free space with new VACUUM. Tom Lane 2001-07-15 20:16:17 +00:00
  • 1e3eacc6f1 Update TODO list. Bruce Momjian 2001-07-15 14:34:02 +00:00
  • 1a17447be1 NLS for libpq. Clean up the message formats and change the documentation accordingly. Peter Eisentraut 2001-07-15 13:45:04 +00:00
  • 9e5ec3b0b9 Change xgettext rule to run in the source tree, so we don't have the absolute paths of the source tree in the po files. Also, run msgfmt with -c option in maintainer-check. Peter Eisentraut 2001-07-15 11:43:55 +00:00
  • 6102553e2d Make sure the build tree is before the source tree in the include path. Peter Eisentraut 2001-07-15 11:20:01 +00:00
  • 1032445e5d TODO item: * Make n of CHAR(n)/VARCHAR(n) the number of letters, not bytes Tatsuo Ishii 2001-07-15 11:07:37 +00:00
  • b08e86d557 The attached patch fixes problems with the JDBC driver handling long null terminated strings. The FE/BE protocol sends in some cases null terminated strings to the client. The docs for the FE/BE protocol state that there is no limit on the size of a null terminated string sent to the client and a client should be coded using an expanding buffer to deal with large strings. The old code did not do this and gave an error if a null terminated string was greater than either 4 or 8K. It appears that with the advent of TOAST very long SQL statements are becoming more common, and apparently some error messages from the backend include the SQL statement thus easily exceeding the 8K limit in the old code. Bruce Momjian 2001-07-15 04:21:26 +00:00
  • 4046e58c24 Initial implementation of concurrent VACUUM. Ifdef'd out for the moment, because index locking issues are not handled correctly yet. Need to go work on the index AMs next. Tom Lane 2001-07-13 22:55:59 +00:00
  • 20ca834ce9 Minor code cleanup/beautification in RelationPutHeapTuple. Tom Lane 2001-07-13 22:52:58 +00:00
  • 379ac0d03a Update TODO list. Bruce Momjian 2001-07-13 18:22:03 +00:00
  • fb02b000a7 Update TODO list. Bruce Momjian 2001-07-13 17:58:31 +00:00
  • 3647a72262 Update TODO list. Bruce Momjian 2001-07-13 00:57:37 +00:00
  • 5ab456b7ba Update TODO list. Bruce Momjian 2001-07-12 21:47:13 +00:00
  • 249ecff611 indicies to indexes from Neil Conway Bruce Momjian 2001-07-12 20:35:54 +00:00
  • bc26c83ca9 Add jdbc items. Bruce Momjian 2001-07-12 19:59:55 +00:00
  • 3284758a17 Remove grammar restrictions on order of optional clauses in CREATE GROUP. From Vince Vielhaber. Tom Lane 2001-07-12 18:03:00 +00:00
  • 5c4d1398a6 Back out SET AUTHORIZATION patch until security is resolved. Bruce Momjian 2001-07-12 17:42:08 +00:00
  • fb45d4ae07 Add win32 c++ files. Bruce Momjian 2001-07-12 14:07:48 +00:00
  • 79d78bb26a Add missing encode file. Bruce Momjian 2001-07-12 14:05:31 +00:00
  • b9f3a929ee Create a new HeapTupleSatisfiesVacuum() routine in tqual.c that embodies the validity checking rules for VACUUM. Make some other rearrangements of the VACUUM code to allow more code to be shared between full and lazy VACUUM. Minor code cleanups and added comments for TransactionId manipulations. Tom Lane 2001-07-12 04:11:13 +00:00
  • eaafc9d66c Update TODO list. Bruce Momjian 2001-07-12 03:53:11 +00:00
  • 09523c90fa Make code malloc memory of proper length. Bruce Momjian 2001-07-12 01:19:40 +00:00
  • 7771436e18 > > Put encode() into base system. Used part of Alex' patch > > for docs, hope he does not mind ;) Bruce Momjian 2001-07-11 22:14:03 +00:00
  • 4051bce27d Libpq++ fixes for Win32 compile. Bruce Momjian 2001-07-11 22:12:43 +00:00
  • d674b48307 Add prototypes to supress warnings. Bruce Momjian 2001-07-11 22:00:57 +00:00
  • b6564c445e Disable COPY TO/FROM on views. Bruce Momjian 2001-07-11 21:53:59 +00:00
  • 75d872aa69 More comment out of block quote. Bruce Momjian 2001-07-11 21:27:07 +00:00
  • 4cf7b823ce Update TODO list. Bruce Momjian 2001-07-11 20:40:06 +00:00
  • 461ea6b796 Better document use of ident on localhost, per Tom Lane's idea. Bruce Momjian 2001-07-11 20:32:11 +00:00
  • 357d9bdce5 Move export to a separate line, per Peter E. Bruce Momjian 2001-07-11 19:36:41 +00:00
  • 153f400676 Instead of believing SOMAXCONN from the system header files (which is a lie on many Unixen), invoke listen() with MIN(MaxBackends*2, 10000). The clamp value 10000 is configurable in config.h.in, if that proves to be necessary --- hopefully it won't. Tom Lane 2001-07-11 19:03:07 +00:00
  • d946b2083a I updated the patch to use the SET AUTHORIZATION { INVOKER | DEFINER } terminology. Also, the function owner is now determined and saved at compile time (no gotchas here, right?)/ Bruce Momjian 2001-07-11 18:54:19 +00:00
  • 11ac469f4a Remove direct calls of index_insert(), instead use ExecInsertIndexTuples(). This makes VACUUM work properly with partial indexes, and avoids memory leakage with functional indexes. Also, suppress complaint about fewer index tuples than heap tuples when the index is a partial index. From Martijn van Oosterhout. Tom Lane 2001-07-11 18:38:07 +00:00
  • c4bde42522 The SQL preprocessor ecpg generates "initially deferrable" from INITIALLY DEFERRED in source code. cf. preproc.y:1455. Bruce Momjian 2001-07-11 17:31:30 +00:00
  • e41e0fc589 Move export PGDATA to the proper place. Quote some variable substitutions. Bruce Momjian 2001-07-11 16:16:52 +00:00
  • 443db06d84 Fix duplication of -D during pg_ctl restart, from Peter E's patch. Bruce Momjian 2001-07-11 04:57:34 +00:00
  • 62f5badebf Remove mention that PREPARE is not implemented. Bruce Momjian 2001-07-11 03:43:52 +00:00
  • 28aeb0a019 Update FAQ_DEV. Bruce Momjian 2001-07-11 02:13:20 +00:00
  • 6d5a9d05e0 Update FAQ. Bruce Momjian 2001-07-11 01:01:56 +00:00
  • 320b6db090 Changes from Vince Vielhaber to allow the optional clauses of CREATE USER and ALTER USER to appear in any order, not only the fixed order they used to be required to appear in. Also, some changes from Tom Lane to create a FULL option for VACUUM; it doesn't do anything yet, but I needed to change many of the same files to make that happen, so now seemed like a good time. Tom Lane 2001-07-10 22:09:29 +00:00
  • 21d73aa211 Update TODO list. Bruce Momjian 2001-07-10 21:36:09 +00:00
  • 8237d89c0f Support fake root install, separate build dir, dependency tracking, our choice of compiler and flags, uninstall, and peculiar Python installation layouts for PyGreSql. Also install into site-packages now, as officially recommended. And pgdb.py is also installed now, used to be forgotten. Peter Eisentraut 2001-07-10 16:33:02 +00:00
  • 975da0a75e Remove formatter's assumption that year would never exceed four digits. Enforce MAXTZLEN for all datestyles, not just some. Remove macro definitions that were redundant with datetime.h. Tom Lane 2001-07-10 01:41:47 +00:00
  • b1f10c84dc Ensure macros are adequately parenthesized. Tom Lane 2001-07-10 01:39:20 +00:00
  • fa9a95d6c4 Remove unnecessarily enthusiastic parenthesizing in reverse-listing of IS NULL, IS TRUE, and friends (my fault...) Tom Lane 2001-07-10 00:02:02 +00:00
  • cb052e0bf1 Fix rule rewriter so that new ordering of ON INSERT actions applies in cases of qualified rules as well as unqualified ones. Tweak rules test to avoid cluttering output with dummy SELECT results. Update documentation to match code. Tom Lane 2001-07-09 23:50:32 +00:00
  • 4fe42dfbc3 Add SHARE UPDATE EXCLUSIVE lock mode, coming soon to a VACUUM near you. Name chosen per pghackers discussion around 6/22/01. Tom Lane 2001-07-09 22:18:34 +00:00
  • 8902f49abb Update TODO list. Bruce Momjian 2001-07-09 21:39:51 +00:00
  • 4404c9aedd Add to replication. Bruce Momjian 2001-07-09 21:34:31 +00:00
  • c0e78467d8 Update TODO list. Bruce Momjian 2001-07-09 21:32:06 +00:00
  • 2366c34ad4 Update TODO list. Bruce Momjian 2001-07-09 21:29:58 +00:00
  • a1c6eb69e3 German message localization for JDBC Peter Eisentraut 2001-07-09 20:25:44 +00:00
  • c42bd5a046 Add replication emails. Bruce Momjian 2001-07-09 20:03:49 +00:00
  • 79c3d4b2c9 Update TODO list. Bruce Momjian 2001-07-09 19:57:29 +00:00
  • a48c3a3447 Document meaning of lossy column. Bruce Momjian 2001-07-09 18:35:52 +00:00
  • bb0db45302 postgresql.badint property name was probably meant to be postgresql.res.badint, since that's the name in the properties file. Peter Eisentraut 2001-07-09 16:59:50 +00:00
  • 082e1c7b95 Show islossy for index. Peter Eisentraut 2001-07-08 14:42:17 +00:00
  • b054fb3b2d Implement DatabaseMetaData.getCatalogs() Peter Eisentraut 2001-07-08 11:08:13 +00:00
  • 2d9ee0fc55 Bring DatabaseMetaData feature tests up to date: Peter Eisentraut 2001-07-08 08:31:08 +00:00
  • ea88062c29 Sync with jdbc2, remove gratuitous white space differences. Peter Eisentraut 2001-07-07 15:52:03 +00:00
  • dbf30bba4a Update TODO list. Bruce Momjian 2001-07-07 04:25:07 +00:00
  • 3355bba1e1 Update TODO list. Bruce Momjian 2001-07-07 04:23:17 +00:00
  • af3ce5daa4 Resolve a number of oddities in the Java build. First, remove the weird redirections between the build files, which didn't work completely. Now you just go to the directory of your choice and run make. Clean up the build files to have a logical order, fix the unnecessary rebuilds, prevent the deleting targets from removing files they're not responsible for. Ant 1.3 does not have a bug. It deletes directories just fine if you follow the documentation. Peter Eisentraut 2001-07-06 23:07:20 +00:00
  • 55432fedd2 Implement LockBufferForCleanup(), which will allow concurrent VACUUM to wait until it's safe to remove tuples and compact free space in a shared buffer page. Miscellaneous small code cleanups in bufmgr, too. Tom Lane 2001-07-06 21:04:26 +00:00
  • 1e9e5defc2 Use CONNECTION_OK to determine whether startup phase is complete. Peter Eisentraut 2001-07-06 19:04:23 +00:00
  • 4fc5b32b4b Update TODO list. Bruce Momjian 2001-07-06 18:23:10 +00:00
  • cff024120a Terminate message doesn't have a trailing zero byte. Peter Eisentraut 2001-07-06 18:01:22 +00:00
  • e77aaade34 Repair libpq to follow protocol by not sending Terminate messages before the startup exchange is complete. Also make sure that packets defined as single bytes aren't sent with a trailing '\0'. Peter Eisentraut 2001-07-06 17:58:53 +00:00
  • 9981b0f9ef Fire rule actions ON INSERT after original statement (if not INSTEAD). Jan Wieck 2001-07-06 13:40:47 +00:00
  • 852a26f79e Fix my old fault(returns auto variable reference). Hiroshi Inoue 2001-07-06 09:41:36 +00:00
  • a88408be08 Fix typo. createdb -t --> createdb -T Tatsuo Ishii 2001-07-06 02:13:04 +00:00
  • 21af10acb8 Fix typo. createdb -t --> createdb -T Tatsuo Ishii 2001-07-06 02:01:35 +00:00
  • fb0919fb83 Don't assume that max offset number stays fixed on a page when we're not holding a pin on the page. Use double instead of long to count rows in relation, so that code still works for > LONG_MAX rows in rel. Tom Lane 2001-07-05 19:33:35 +00:00
  • 6497a7fd71 Added GUC configuration options to control access statistics. Jan Wieck 2001-07-05 15:19:40 +00:00
  • 2f3bd9eb88 Check for jakarta-ant before ant, in case 'ant' is the screen saver program. Then, run a small reality test with $ANT to see whether it works. Peter Eisentraut 2001-07-04 21:22:55 +00:00
  • 499c81d3a3 Prohibit a column from appearing twice in a PRIMARY KEY or UNIQUE constraint. This case (a) is useless, (b) violates SQL92, and (c) is certain to cause a failure downstream when we try to create an index with duplicated column names. So give an appropriate error message instead of letting the index failure occur. Per report from Colin Strickland. NOTE: currently, CREATE INDEX fooi ON foo(f1,f1) still fails with 'cannot insert duplicate key' error. Should we change that too? What about functional indexes? Tom Lane 2001-07-04 17:36:54 +00:00
  • 5621ec0629 Remove ConnectionHook.java. No longer used, bad code. Bruce Momjian 2001-07-04 15:57:25 +00:00
  • 0e4d43f459 The attached patch removes some old and dead code (and some related misleading comments) from the PG_Stream class. Bruce Momjian 2001-07-04 15:09:54 +00:00
  • 5f5f8b97e2 This patch moves the setting of the timezone on the SimpleDateFormat object inside the initialization section instead of doing it everytime the setTimestamp method is called. Thanks to Dave Harkness for this suggestion. Bruce Momjian 2001-07-04 15:08:32 +00:00
  • 314207881b Attached is a patch to remove the ConnectionHook functionality and thus the JDK 1.3 dependency. For a further explanation see my posting to the JDBC list on Friday, explaining why this is being done. Bruce Momjian 2001-07-04 15:07:54 +00:00
  • 84587e93d8 Update TODO list. Bruce Momjian 2001-07-04 14:59:07 +00:00
  • 30ab5bd43d More message munging and localization for pg_dump, especially the --verbose messages, which had not been considered so far. Output to the terminal should okay now; comments written into the dump are still English only, which may or may not be the desirable thing. Peter Eisentraut 2001-07-03 20:21:50 +00:00
  • 3ec9fb893e Add a little more error checking and reporting to readDatum(). Tom Lane 2001-07-03 16:52:48 +00:00
  • 31c1fea6a8 Start the stats collector at a less randomly chosen time. Bad idea to start it before we have acquired the data directory lock; also a bad idea to start it before we have set up to catch SIGCHLD signals. Tom Lane 2001-07-03 16:52:12 +00:00
  • c8fe66dfb2 Don't go into infinite loop if /home/postgres/testversion/data directory is not writable. Tom Lane 2001-07-03 16:49:48 +00:00
  • 86bc2d91c3 Correct substring() example, found by Thomas T. Thai. Bruce Momjian 2001-07-03 02:42:18 +00:00
  • 42748087c1 First non-stub implementation of shared free space map. It's not super useful as yet, since its primary source of information is (full) VACUUM, which makes a concerted effort to get rid of free space before telling the map about it ... next stop is concurrent VACUUM ... Tom Lane 2001-07-02 20:50:46 +00:00
  • e0c8f4bbad In any case, it seems the REL7_1 branch needs the update too... Tom Lane 2001-07-02 19:34:41 +00:00
  • 755e367cb2 Update abstime expected results to match post-30-June-2001 reality. Probably the right fix is to remove 'current' special value entirely, but I don't want to see regression test failures until that happens. Tom Lane 2001-07-02 19:31:52 +00:00
  • a29f6c095c Make the found-a-buffer-when-we-were-expecting-to-extend-the-rel path actually work. It had been throwing an Assert as of my recent changes to bufmgr.c, but was not really right even before that AFAICT. Tom Lane 2001-07-02 18:47:18 +00:00
  • 109d50dd35 Under new theory of operation wherein postmaster forks children immediately, we will fork a child even if the database state does not permit connections to be accepted (eg, we are in recovery mode). The child process will correctly reject the connection and exit as soon as it's finished collecting the connection request message. However, this means that reaper() must be prepared to see child process exit signals even while it's waiting for startup or shutdown process to finish. As was, a connection request arriving during a database recovery or shutdown would cause postmaster abort. Tom Lane 2001-07-01 00:06:23 +00:00
  • 10e9cd2299 Allow default transaction isolation level (a.k.a. set session characteristics) to be set through GUC. Peter Eisentraut 2001-06-30 22:03:26 +00:00
  • e4a40cc353 fix markup Peter Eisentraut 2001-06-30 22:01:17 +00:00
  • b1c5b3459d Add missing dependency and fix thinko. Peter Eisentraut 2001-06-30 21:58:06 +00:00
  • 34d1cf8d35 The System V resources discussed here apply to NetBSD as well. In fact I just finished changing the GENERIC files and the options(4) man page on NetBSD to make this clearer. D'Arcy J.M. Cain 2001-06-30 21:15:57 +00:00
  • 55f8fc3bc6 portability enhancements Peter Eisentraut 2001-06-30 19:01:27 +00:00
  • 2ab0f11a79 NLS for the psql \d family of commands. (E.g., the column headers will have localized strings.) Also, modernize the system catalog queries where appropriate, e.g., with outer joins. Peter Eisentraut 2001-06-30 17:26:12 +00:00