hcq/postgresql
1
0
Fork 0
mirror of https://git.postgresql.org/git/postgresql.git synced 2026-02-12 17:37:07 +08:00
Code Issues Packages Projects Releases Wiki Activity

Commit Graph

  • 3db4056e22 Fix problems with parentheses around sub-SELECT --- for the last time, I hope. I finally realized that we were going at it backwards: when there are excess parentheses, they need to be treated as part of the sub-SELECT, not as part of the surrounding expression. Although either choice yields an unambiguous grammar, only this way produces a grammar that is LALR(1). With the old approach we were guaranteed to fail on either 'SELECT (((SELECT 2)) + 3)' or 'SELECT (((SELECT 2)) UNION SELECT 2)' depending on which way we resolve the initial shift/reduce conflict. With the new way, the same reduction track can be followed in both cases until we have advanced far enough to know whether we are done with the sub-SELECT or not. Tom Lane 2001-01-15 20:36:36 +00:00
  • efd6cade83 Tweak heap_update/delete so that we do not hold the buffer context lock on the old tuple's page while we are doing TOAST pushups. Tom Lane 2001-01-15 05:29:19 +00:00
  • 0b5d194aaa Minor coding cleanups. Tom Lane 2001-01-14 22:21:54 +00:00
  • a904181a46 Another go-round on making GetRawDatabaseInfo behave as well as it can, given the fundamental restriction of not looking at transaction commit data in pg_log. Use code that is actually based on tqual.c rather than ad-hoc tests. Also write the tuple fetch loop using standard access macros rather than ad-hoc code. Tom Lane 2001-01-14 22:21:05 +00:00
  • 8a0c9b17a5 pg_database's datpath column must not be marked toastable, because GetRawDatabaseInfo() won't cope with a compressed path spec (much less a moved-off one). I'm not going to force an initdb for this change, because it's noncritical --- we're not actually using datpath at all right now. But it seems a good idea to apply the fix while I'm thinking about it. Tom Lane 2001-01-14 22:17:22 +00:00
  • a3cac3a03b Need to do BufferSync at end of DROP DATABASE as well as CREATE DATABASE. Otherwise, newly connecting backends will still think the deleted DB is valid, and will generate unexpected error messages. Tom Lane 2001-01-14 22:14:10 +00:00
  • c0f069944f Make aclcontains() do something that's at least vaguely reasonable: it now returns true if the aclitem argument exactly matches any one of the elements of the aclitem[] argument. Per complaint from Wolff 1/10/01. Tom Lane 2001-01-14 19:23:27 +00:00
  • 36839c1927 Restructure backend SIGINT/SIGTERM handling so that 'die' interrupts are treated more like 'cancel' interrupts: the signal handler sets a flag that is examined at well-defined spots, rather than trying to cope with an interrupt that might happen anywhere. See pghackers discussion of 1/12/01. Tom Lane 2001-01-14 05:08:17 +00:00
  • 7bfec168bf Back-patch fix for crash in GetRawDatabaseInfo(), just in case someone else needs it. Tom Lane 2001-01-14 03:16:12 +00:00
  • 027f144e39 Terminology cleanup: class -> table, instance -> row, attribute -> column, etc. Peter Eisentraut 2001-01-13 23:58:55 +00:00
  • 0651a5799d Backed out: Bruce Momjian 2001-01-13 18:52:42 +00:00
  • 526427f6d3 Add information about bit types. Adjust some other things to promote SQL type names over internal type names. Peter Eisentraut 2001-01-13 18:34:51 +00:00
  • 475c1452b1 Attached is a set of patches for a couple of bugs dealing with timestamps in JDBC. Bruce Momjian 2001-01-13 05:18:05 +00:00
  • 20dfd50c41 More cleanup. Bruce Momjian 2001-01-13 04:58:53 +00:00
  • 160675ecee Relax test on typmod matching between a table and its proposed ON SELECT rule. Needed to avoid failure when reloading a 7.0 pg_dump of a view that has a NUMERIC column. Tom Lane 2001-01-13 03:58:28 +00:00
  • f8bdef0780 Windows wants shared libraries in PATH. Peter Eisentraut 2001-01-13 03:25:48 +00:00
  • 25c0ffb9ec check one last time for any erros ... Marc G. Fournier 2001-01-13 03:17:05 +00:00
  • 2a6c08228f New shell for the to be written CHECKPOINT documentation, so the summary shows up in psql now. Peter Eisentraut 2001-01-13 03:11:12 +00:00
  • 1fc331bbc2 ignore his too Marc G. Fournier 2001-01-13 03:11:07 +00:00
  • 3c085b1b35 and this time? Marc G. Fournier 2001-01-13 03:09:43 +00:00
  • d5e66044ad try this again ... Marc G. Fournier 2001-01-13 03:08:02 +00:00
  • 16cc90ccdb Clean up garbage. Peter Eisentraut 2001-01-13 02:18:31 +00:00
  • bc615509ac Surely one README file is enough. Peter Eisentraut 2001-01-13 02:14:32 +00:00
  • 93cf749f40 Update pgcvslog to fix problem with duplicate narratives. Bruce Momjian 2001-01-13 01:49:35 +00:00
  • 3f8ea17810 okay, this appears to work ... Marc G. Fournier 2001-01-13 00:57:06 +00:00
  • daa78233d0 Surely we don't need a 7.0.3 makefile in 7.1. Peter Eisentraut 2001-01-12 22:36:57 +00:00
  • a32542a1c0 Update information about compiling extension modules. Peter Eisentraut 2001-01-12 22:15:32 +00:00
  • 6162432de9 Add more critical-section calls: all code sections that hold spinlocks are now critical sections, so as to ensure die() won't interrupt us while we are munging shared-memory data structures. Avoid insecure intermediate states in some code that proc_exit will call, like palloc/pfree. Rename START/END_CRIT_CODE to START/END_CRIT_SECTION, since that seems to be what people tend to call them anyway, and make them be called with () like a function call, in hopes of not confusing pg_indent. I doubt that this is sufficient to make SIGTERM safe anywhere; there's just too much code that could get invoked during proc_exit(). Tom Lane 2001-01-12 21:54:01 +00:00
  • be8477bc37 Update TODO list. Bruce Momjian 2001-01-12 17:57:57 +00:00
  • ab1c71d02b Update TODO list. Bruce Momjian 2001-01-12 17:48:18 +00:00
  • d63e41e9b2 Fixed handling of renamed columns in PK constraints Philip Warner 2001-01-12 15:41:29 +00:00
  • ed7f37b7b1 Add to DROP todo. Bruce Momjian 2001-01-12 05:37:37 +00:00
  • 3fbd4d4bb2 Update TODO list. Bruce Momjian 2001-01-12 05:32:38 +00:00
  • 1c7d752824 Update TODO list. Bruce Momjian 2001-01-12 05:23:10 +00:00
  • 359459a44d Bring CREATE TABLE syntax synopsis into line with reality; update a bunch of old or poorly-worded documentation. Tom Lane 2001-01-12 05:06:40 +00:00
  • 06ef1ef2ec - Check ntuples == 1 for various SELECT statements. - Fix handling of --tables=* (multiple tables never worked properly, AFAICT) - strdup() the current user in DB routines - Check results of IO routines more carefully. - Check results of PQ routines more carefully. Philip Warner 2001-01-12 04:32:07 +00:00
  • 565639cde0 Preserve constraints and column defaults during CLUSTER. Wish they were all this easy ... Tom Lane 2001-01-12 01:22:21 +00:00
  • 1db943b3ca commit Oleg and Teodor's RD-tree implementation ... this provides the regression tests for the GiST changes ... this should be integrated into the regular regression tests similar to Vadim's SPI contrib stuff ... Marc G. Fournier 2001-01-12 00:16:26 +00:00
  • 0ad7db4be4 New feature: 1. Support of variable size keys - new algorithm of insertion to tree (GLI - gist layrered insertion). Previous algorithm was implemented as described in paper by Joseph M. Hellerstein et.al "Generalized Search Trees for Database Systems". This (old) algorithm was not suitable for variable size keys and could be not effective ( walking up-down ) in case of multiple levels split Bug fixed: 1. fixed bug in gistPageAddItem - key values were written to disk uncompressed. This caused failure if decompression function does real job. 2. NULLs handling - we keep NULLs in tree. Right way is to remove them, but we don't know how to inform vacuum about index statistics. This is just cosmetic warning message (like in case with R-Tree), but I'm not sure how to recognize real problem if we remove NULLs and suppress this warning as Tom suggested. 3. various memory leaks Marc G. Fournier 2001-01-12 00:12:58 +00:00
  • 7cd971183c #ifdef out entire file for newer Cygwin versions. Peter Eisentraut 2001-01-11 23:32:03 +00:00
  • 9b19224666 Add DLLIMPORT to TransactionCommandContext. Peter Eisentraut 2001-01-11 23:28:34 +00:00
  • c340c21865 Remove useless DLLIMPORT (only needed in header files). Peter Eisentraut 2001-01-11 23:27:05 +00:00
  • be64674a0d Update TODO list. Bruce Momjian 2001-01-11 21:07:07 +00:00
  • 57d32518d1 reduce HISTORY changes from this list too Marc G. Fournier 2001-01-11 04:13:30 +00:00
  • 9b725151e9 remove all the TODO updates, which drops of 12k from the file ... Marc G. Fournier 2001-01-11 04:12:32 +00:00
  • 21ac86a230 using cvs2cl.pl, generate a list of changes from beta1->beta3 ... Marc G. Fournier 2001-01-11 04:00:59 +00:00
  • 5508ef30e2 Make checks for global variables (sys_nerr, timezone) safe against getting optimized away completely. Peter Eisentraut 2001-01-10 17:07:18 +00:00
  • 09a160d579 Removed a no longer needed SetWaitingForLock() call in DeadLockCheck(). Hiroshi Inoue 2001-01-10 01:24:19 +00:00
  • 412cb388b3 Do The Right Thing (tm) if asked to cluster a temp table. Previous code would cluster, but table would magically lose its tempness. Tom Lane 2001-01-10 01:12:28 +00:00
  • 353f71a331 Synced preproc.y with gram.y. Michael Meskes 2001-01-09 19:46:05 +00:00
  • 8eed998a65 Remove -L$(libdir) from DLLLIBS to prevent linking with an old version (i.e., 7.0.3) of libpostgres.a. From Jason Tishler <jt@dothill.com>. Peter Eisentraut 2001-01-09 18:45:41 +00:00
  • c3f9371956 Add configure check for sys_nerr, to end all discussions. Peter Eisentraut 2001-01-09 18:40:15 +00:00
  • af26d6a4a2 Update TODO list. Bruce Momjian 2001-01-09 18:06:07 +00:00
  • e586026d10 The KAME files md5.* and sha1.* have the following changelog entry: Bruce Momjian 2001-01-09 16:07:14 +00:00
  • f906597e50 Apply proper sql.sgml change. Bruce Momjian 2001-01-09 16:05:21 +00:00
  • 777137b7a9 Attached is a doc patch for doc/src/sgml/sql.sgml. Bruce Momjian 2001-01-09 15:48:18 +00:00
  • 5e505af184 Update TODO list. Bruce Momjian 2001-01-09 15:37:39 +00:00
  • 5d42c0f3ac A patch for doc/src/sgml/plsql.sgml to add a little more info about PL/pgSQL EXECUTE. Bruce Momjian 2001-01-09 15:26:16 +00:00
  • df389d161d Approaching the current documentation from a position of ignorance, I find it ambiguous. I propose something along the lines of the following patch to clarify it. Thanks. Bruce Momjian 2001-01-09 14:23:40 +00:00
  • 941139bd07 Update TODO list. Bruce Momjian 2001-01-09 14:12:34 +00:00
  • 7cbb1a4bf5 Update TODO list. Bruce Momjian 2001-01-09 13:52:02 +00:00
  • ed56c6f1a1 Update TODO list. Bruce Momjian 2001-01-09 13:48:03 +00:00
  • 460a9f8a68 jump version to beta3 ... beta2 was created and pulled due to a couple of large-ish bugs that Tom and Vadim were able to fix, but to avoid any confusion, beta2 was removed ... and for tag'ng purposes, beta3 is being created ... REL7_1_BETA3 PostgreSQL Daemon 2001-01-09 13:11:32 +00:00
  • eea348b72b Add a README file for multi-byte. This file is contributed by Chih-Chang Hsieh <cch@cc.kmu.edu.tw>, written in traditional Chinese (Big5). Tatsuo Ishii 2001-01-09 09:54:11 +00:00
  • 7edff1618e Disable query cancel during HandleDeadLock(). Hiroshi Inoue 2001-01-09 09:38:57 +00:00
  • 4b59366e57 1. Checkpoint.undo may be after checkpoint itself: - no more elog(STOP) in StartupXLOG(); - both checkpoint' undo & redo are used to define oldest on-line log file. 2. Ability to pre-allocate a few log files at checkpoint time (wal_files option). Off by default. Vadim B. Mikheev 2001-01-09 06:24:33 +00:00
  • 329001a2ff Update TODO list. Bruce Momjian 2001-01-09 06:16:23 +00:00
  • 31a81ea8ec README.mb has been unified into SGML documents. Tatsuo Ishii 2001-01-09 04:40:31 +00:00
  • 07c741e61c Fix oversight in planning of GROUP queries: when an expression is used as both a GROUP BY item and an output expression, the top-level Group node should just copy up the evaluated expression value from its input, rather than re-evaluating the expression. Aside from any performance benefit this might offer, this avoids a crash when there is a sub-SELECT in said expression. Tom Lane 2001-01-09 03:48:51 +00:00
  • 4cb0950cfe Fix small but critical typo ... Tom Lane 2001-01-09 02:15:16 +00:00
  • f19238e027 Prevent vacuumdb from trying to vacuum template0. Tom Lane 2001-01-08 23:02:36 +00:00
  • 10fb290aca Document the system attributes ctid and tableoid, which for some reason were never yet mentioned anywhere in our documentation. Improve explanations of the other system attributes, too. Tom Lane 2001-01-08 22:07:47 +00:00
  • 6334ef86a7 Document that we don't support ORDER BY with general expressions on the output of UNION/INTERSECT/EXCEPT. Tom Lane 2001-01-08 21:30:37 +00:00
  • 005ad6cdd6 Add rudimentary section about controlling kernel's file and process limits. Peter Eisentraut 2001-01-08 21:01:54 +00:00
  • 745f0c21e5 Remove compiler warning about uninitialized warnings. Bruce Momjian 2001-01-08 20:54:24 +00:00
  • bf74477b05 check for failure after vacuuming each DB, not only the last one. Tom Lane 2001-01-08 20:32:27 +00:00
  • b95f81a54a Add some debugging support code (ifdef'd out in normal use). Tom Lane 2001-01-08 18:34:44 +00:00
  • e2586c3c62 LockBuffer should not elog while holding buffer's cntx_lock. Tom Lane 2001-01-08 18:31:49 +00:00
  • 6adc255f8a Keep relations open until they are no longer needed. Hiroshi Inoue 2001-01-08 03:14:58 +00:00
  • 1112a2a084 Make outfuncs/readfuncs treat OIDs properly as unsigned values. Clean up inconsistent coding practices for handling Index values and booleans, too. Tom Lane 2001-01-08 00:31:43 +00:00
  • a4ddbbd1a4 Correct nasty error in heap_update: it was releasing the buffer refcount before calling RelationInvalidateHeapTuple(), which is bad because the latter needs to look at the tuple data, which is in the shared disk buffer. If another backend manages to recycle the buffer while this is going on, we will compute the wrong hashindex for the tuple or maybe even crash outright. Must hold buffer refcount until afterwards. (This bug is not in 7.0.*; seems to be have introduced during WAL changes.) Tom Lane 2001-01-07 22:14:31 +00:00
  • 542b7c6445 Clear QueryCancel and ProcDiePending at start of proc_exit, to ensure that leftover cancel/die requests cannot interfere with exit activities. Tom Lane 2001-01-07 04:30:41 +00:00
  • cb7ce7d0e3 Fix recent breakage of query-cancel logic, see my pghackers message of 6 Jan 2001 21:55. Tom Lane 2001-01-07 04:17:29 +00:00
  • 6781aa4707 tag configure as beta2 .. REL7_1_BETA2 PostgreSQL Daemon 2001-01-07 02:23:25 +00:00
  • 4ced15ece4 Resultmap updates for OpenBSD, per report from bpalmer@crimelabs.net. Tom Lane 2001-01-07 01:14:35 +00:00
  • 4057b64f32 Modify readfuncs so that recursive use of stringToNode will not crash and burn. Just for added luck, change reading of CONST nodes so that we do not need to consult pg_type rows while reading them; this means that no database access occurs during stringToNode. This requires changing the order in which const-node fields are written, which means an initdb is forced. Tom Lane 2001-01-07 01:08:48 +00:00
  • 1402201463 Clean up checking of relkind for ALTER TABLE and LOCK TABLE commands. Disallow cases like adding constraints to sequences :-(, and eliminate now-unnecessary search of pg_rewrite to decide if a relation is a view. Tom Lane 2001-01-07 00:05:22 +00:00
  • deb21f0f80 Log memory context stats to stderr when reporting a 'Memory exhausted' error, so as to provide a starting point for debugging. Tom Lane 2001-01-06 21:59:39 +00:00
  • e69b8d4655 Fix memory leak in relcache handling of rules: allocate rule parsetrees in per-entry sub-memory-context, where they were supposed to go, rather than in CacheMemoryContext where the code was putting them. Must've suffered a severe brain fade when I wrote this :-( Tom Lane 2001-01-06 21:53:18 +00:00
  • ca88243952 Use more portable syntax for 'find'. Peter Eisentraut 2001-01-06 21:24:01 +00:00
  • 41fde54603 Polish help output. Allow --help to work with BSD getopts. Peter Eisentraut 2001-01-06 20:57:26 +00:00
  • 24a4aff68e No need for screen_size to be static. Tom Lane 2001-01-06 17:43:01 +00:00
  • 8c3d7715bc Simplify rules to build man pages so they run a lot faster and create less noise. Peter Eisentraut 2001-01-06 16:54:16 +00:00
  • 5eee6f1ba6 Update multibyte Japanese doc for 7.1. Tatsuo Ishii 2001-01-06 12:38:28 +00:00
  • bc0afb715d EXECUTE documentation, from "Robert B. Easter" <reaster@comptechnews.com>. I threw in spell check run over the whole file. Peter Eisentraut 2001-01-06 12:26:08 +00:00
  • 3942ee389c Update section on SQL syntax. (Still a lot to be done though.) Add appendix with comprehensive list of key words. Peter Eisentraut 2001-01-06 11:58:56 +00:00
  • 3ff76734f6 Simplify the rules that explicitly allowed TYPE as a type name (which is no longer the case). Add AND and TRAILING to ColLabel. All key words except AS are now at least ColLabel's. Peter Eisentraut 2001-01-06 10:50:02 +00:00
  • 96bd67f61d Bring CREATE RULE reference page into some semblance of agreement with what's actually implemented. Tom Lane 2001-01-06 04:14:35 +00:00
  • a6944611e2 Fix copy to make it more robust against unexpected character sequences. This is done by disabling multi-byte awareness when it's not necessary. This is kind of a workaround, not a perfect solution. However, there is no ideal way to parse broken multi-byte character sequences. So I guess this is the best way what we could do right now... Tatsuo Ishii 2001-01-06 03:33:17 +00:00
  • 4451ed3dfe init_irels() is changed to be called in RelationCacheInitializePhase2() so that transactional control could guarantee the consistency. Hiroshi Inoue 2001-01-06 01:48:59 +00:00