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

Commit Graph

  • 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
  • 682b128993 Fix NOT NULL option for plpgsql variables (doesn't look like it could ever have worked...) Tom Lane 2001-01-06 01:43:01 +00:00
  • 0ad5e43772 Fix misplaced strdup(), which could lead to error messages referencing deallocated memory later on. Tom Lane 2001-01-06 01:39:01 +00:00
  • 81d08fcffe Rename and document some invalidation routines to make it clearer that they don't themselves flush any cache entries, only add to to-do lists that will be processed later. Tom Lane 2001-01-05 22:54:37 +00:00
  • 2fb6cc9045 Remove not-really-standard implementation of CREATE TABLE's UNDER clause, and revert documentation to describe the existing INHERITS clause instead, per recent discussion in pghackers. Also fix implementation of SQL_inheritance SET variable: it is not cool to look at this var during the initial parsing phase, only during parse_analyze(). See recent bug report concerning misinterpretation of date constants just after a SET TIMEZONE command. gram.y really has to be an invariant transformation of the query string to a raw parsetree; anything that can vary with time must be done during parse analysis. Tom Lane 2001-01-05 06:34:23 +00:00
  • e62c38d0fc Disallow creation of a child table by a user who does not own the parent table, per pghackers discussion around 22-Dec-00. Tom Lane 2001-01-05 02:58:16 +00:00
  • de9b43f3f5 Back-patch fix for 'btree: failed to add item to the page in _bt_sort (2)' failure during index creation. This problem should be gone in current sources, but I just thought I'd commit the 7.0.* patch in case anyone else needs it. Tom Lane 2001-01-04 21:51:49 +00:00
  • 21775721bc Update TODO list. Bruce Momjian 2001-01-04 18:51:18 +00:00
  • 46e5daf586 Allow NetBSD's libedit to be used instead of GNU Readline. (This simply amounts to checking for -ledit instead of -lreadline.) Peter Eisentraut 2001-01-04 17:58:48 +00:00
  • 257e17bc60 Correct path where to check for password file existance. Peter Eisentraut 2001-01-04 17:25:09 +00:00
  • f5a83d9f41 Update TODO list. Bruce Momjian 2001-01-04 08:24:59 +00:00
  • f2f7c068a5 Update TODO list. Bruce Momjian 2001-01-04 08:15:19 +00:00
  • db8c5f0ad4 Update TODO list. Bruce Momjian 2001-01-04 08:13:26 +00:00
  • afeb8c4819 Clean up some unnecessary fragility in EXECUTE command. Tom Lane 2001-01-04 02:38:02 +00:00
  • f9d6ffc5c4 Repair guaranteed core dump in SPI_exec(). Guess this routine wasn't used before ... Tom Lane 2001-01-04 02:36:52 +00:00
  • 3052a421d5 I neglected to remove a debug message,sorry. Hiroshi Inoue 2001-01-04 02:24:22 +00:00
  • ea608bfd3b pg_dump failed to handle backslashes embedded in function definitions (and most other places where it needed to output a string literal, too, except for data INSERT statements). Per bug report from Easter, 12/1/00. Tom Lane 2001-01-04 01:23:47 +00:00
  • 60500d58bc Fix breakage of rules using NOTIFY actions, per bug report and patch from sergiop@sinectis.com.ar. Tom Lane 2001-01-03 22:01:05 +00:00
  • 676cf18c5b New file format for COPY BINARY, in accordance with pghackers discussions of early December 2000. COPY BINARY is now TOAST-safe. Tom Lane 2001-01-03 20:04:10 +00:00
  • 8fd2e269f7 MakeRetrieveViewRuleName was scribbling on memory that didn't belong to it. Bad dog. Tom Lane 2001-01-03 18:43:09 +00:00
  • a8aa2f95b4 Repair always-broken date_part('quarter',timestamp). Previous result did not have correct month boundaries so anything near edge cases was suspect (e.g. April was in Q1 and July, August were lumped into Q2). Thanks to Denis Osadchy <osadchy@turbo.nsk.su> for the report. Thomas G. Lockhart 2001-01-03 16:48:02 +00:00
  • 39f987c568 Update TODO list. Bruce Momjian 2001-01-03 06:56:52 +00:00
  • b1cc64648a Update TODO list. Bruce Momjian 2001-01-03 02:23:22 +00:00
  • f0fc635220 Only update stamp-h if config.status actually looks at config.h. Peter Eisentraut 2001-01-02 22:13:05 +00:00
  • 6b75942c72 I've found a memory leak in libecpg of PostgreSQL 7.0.3. The leak is caused by the memory allocation in src/interfaces/ecpg/lib/execute.c in line 669 which is never freed. Adding a "free(array_query);" after PQexec in line 671 seems to fix the leak. Bruce Momjian 2001-01-02 22:03:02 +00:00
  • 3bdadd0426 Document tuple ordering differences as a possible cause of regression test 'failures'. Tom Lane 2001-01-02 05:56:02 +00:00
  • 1b8a219eef Clean up non-reentrant interface for hash_seq/HashTableWalk, so that starting a new hashtable search no longer clobbers any other search active anywhere in the system. Fix RelationCacheInvalidate() so that it will not crash or go into an infinite loop if invoked recursively, as for example by a second SI Reset message arriving while we are still processing a prior one. Tom Lane 2001-01-02 04:33:24 +00:00
  • 25d88e4c53 Tweak temporary-installation setup so that it doesn't break when the configured install --prefix begins with /data/... Tom Lane 2001-01-02 02:13:48 +00:00
  • 144ec3c148 Update geometry-alpha-precision.out per reports from Brent Verner and Adriaan Joubert. Tom Lane 2001-01-01 23:18:18 +00:00
  • 4300e290d8 Define HAVE_LIBZ only if we detect <zlib.h> as well as libz.a/.so. Otherwise, build falls over on a machine with a non-devel RPM of libz. Tom Lane 2001-01-01 23:10:09 +00:00
  • ad0169b1b7 CLUSTER forgot to create a TOAST table for the clustered relation. Tom Lane 2001-01-01 21:35:00 +00:00
  • 9315ff5549 Ensure attcacheoff is written out as -1 when writing pg_attribute tuples for a relation. Needed to prevent Assert failure in CLUSTER. Tom Lane 2001-01-01 21:33:31 +00:00
  • 473763e676 Update comment. Tom Lane 2001-01-01 21:22:54 +00:00
  • 19e68b5096 Mark geometric 'overlaps' operators (&&) as self-commutative. Tom Lane 2000-12-31 22:34:04 +00:00
  • 8972088dcb Fix typo in error message. Tom Lane 2000-12-31 22:24:14 +00:00
  • 52522850fe Don't say 'export PGHOST' or 'export PGPORT' unless we actually define those variables. Some shells will invent an empty-string definition in this case, which is not what we want. Tom Lane 2000-12-31 18:38:44 +00:00
  • e41b8a0fdd On further thought, we need a defense against empty PGPORT here too. Tom Lane 2000-12-31 18:23:21 +00:00
  • 45f92179d9 Ignore PGPORT environment variable if it is an empty string. Tom Lane 2000-12-31 18:15:58 +00:00
  • ff6012e275 Reverse #if test to be defined(__osf__) rather than not-any-of-a-lot- of-others. Tom Lane 2000-12-31 18:04:35 +00:00
  • 3b2b7eb19e Remove incorrect use of rl_special_prefixes until further evaluation. Peter Eisentraut 2000-12-31 11:57:58 +00:00
  • fada8ee41f NetBSD/Alpha porting fixes from tom@minnesota.com. Tom Lane 2000-12-31 03:34:01 +00:00
  • 4723b2b99b Be more careful about the difference between signed and unsigned ints. Bug is revealed by OID regress test on 64-bit platforms. Tom Lane 2000-12-30 19:17:47 +00:00
  • eedfac64dd Correct UNDER syntax. Peter Eisentraut 2000-12-30 19:11:45 +00:00
  • 59e2bf3c69 Correct UNDER syntax. Peter Eisentraut 2000-12-30 19:00:11 +00:00
  • 8188a9bebf Refinements Peter Eisentraut 2000-12-30 17:11:32 +00:00
  • 74e2bf95ec Remove C++ comment. Peter Eisentraut 2000-12-30 16:48:49 +00:00
  • 3e059b3802 1. WAL needs in zero-ed content of newly initialized page. 2. Log record for PageRepaireFragmentation now keeps array of !LP_USED offnums to redo cleanup properly. Vadim B. Mikheev 2000-12-30 15:19:57 +00:00
  • 2783bd50da Add mention of sysctl(8) for IPC tuning on Linux. Peter Eisentraut 2000-12-30 15:03:09 +00:00
  • 874b4fd618 Remove incorrect assert. Peter Eisentraut 2000-12-30 14:47:06 +00:00
  • c193f19a39 Fixed misprint in heap update WALoging. Vadim B. Mikheev 2000-12-30 06:52:34 +00:00
  • c0f9597b31 Imporve messages. Tatsuo Ishii 2000-12-30 06:10:43 +00:00
  • ee6a91682d Apparently, special float8 comparison file for Alpha is only needed when using vendor cc, not gcc. Tom Lane 2000-12-30 02:48:04 +00:00
  • f83b221598 Clean up spinlock assembly code slightly (just cosmetic improvements) for Alpha gcc case. For Alpha non-gcc case, replace use of __INTERLOCKED_TESTBITSS_QUAD builtin with __LOCK_LONG_RETRY and __UNLOCK_LONG. The former does not execute an MB instruction and therefore was guaranteed not to work on multiprocessor machines. The LOCK_LONG builtins produce code that is the same in all essential details as the gcc assembler code. Tom Lane 2000-12-30 02:34:56 +00:00
  • c23851bbe0 Paranoia about possible values of errno after a shmget/semget failure. In theory we should always get EEXIST if there's a key collision, but if the kernel code tests error conditions in a weird order, perhaps EACCES or EIDRM could occur too. Tom Lane 2000-12-30 01:20:55 +00:00
  • 2153d1c106 Remove obsolete and unportable enable_plpgsql script. createlang has been the supported and documented way to do this for a long time... Tom Lane 2000-12-30 00:50:44 +00:00
  • ab432f204a Fix unportable use of '!' in shell commands. Peter Eisentraut 2000-12-30 00:24:09 +00:00
  • aa44078e21 column and tuple numbers should be int not size_t. Tom Lane 2000-12-29 22:46:37 +00:00
  • 7f60b81e1a Fix failure in CreateCheckPoint on some Alpha boxes --- it's not OK to assume that TAS() will always succeed the first time, even if the lock is known to be free. Also, make sure that code will eventually time out and report a stuck spinlock, rather than looping forever. Small cleanups in s_lock.h, too. Tom Lane 2000-12-29 21:31:21 +00:00
  • 7d363c4c33 MUST update (in-memory) data page BEFORE XLogInsert to log NEW page content if WAL will decide to backup page. Vadim B. Mikheev 2000-12-29 20:47:17 +00:00
  • b05b981924 stamp-h needs to be made by config.status, not elsewhere, per recipe in Autoconf manual. In particular, touching it before creating config.status is guaranteed to lose. Tom Lane 2000-12-29 20:39:09 +00:00
  • b3c4f03c9c nbtree_xlog_newroot: set meta flag in meta page opaque. Vadim B. Mikheev 2000-12-29 08:08:59 +00:00
  • 49740c5fb9 Attached are patches for two fixes to reduce memory usage by the JDBC drivers. Bruce Momjian 2000-12-28 23:56:46 +00:00
  • a057cbec46 Qualify %.in rule to avoid triggering on configure.in, repair unportable attempt to install more than one file per 'install' invocation, clean up some other oddities. Peter Eisentraut 2000-12-28 17:34:52 +00:00
  • 7ceeeb662f New WAL version - CRC and data blocks backup. Vadim B. Mikheev 2000-12-28 13:00:29 +00:00
  • c996c7f573 Let's try this again on accepting the correct range of Oid input values for 64-bit platforms ... Tom Lane 2000-12-28 01:51:15 +00:00
  • 0a8da82576 Correct erroneous documentation of PQsetnonblocking(). Tom Lane 2000-12-28 00:16:11 +00:00
  • 8609d4abf2 Fix portability problems recently exposed by regression tests on Alphas. 1. Distinguish cases where a Datum representing a tuple datatype is an OID from cases where it is a pointer to TupleTableSlot, and make sure we use the right typlen in each case. 2. Make fetchatt() and related code support 8-byte by-value datatypes on machines where Datum is 8 bytes. Centralize knowledge of the available by-value datatype sizes in two macros in tupmacs.h, so that this will be easier if we ever have to do it again. Tom Lane 2000-12-27 23:59:14 +00:00
  • 97799fc475 Update TODO list. Bruce Momjian 2000-12-27 05:44:57 +00:00
  • 8b97d7a887 Only install the integrated HTML documentation set (not the individual books separately), in directory $(docdir)/html. Peter Eisentraut 2000-12-26 20:47:07 +00:00
  • f4e995e17f Add id attribute to sect1 tag. Peter Eisentraut 2000-12-26 20:12:49 +00:00
  • fa1640aea0 Fix some cross reference links. Peter Eisentraut 2000-12-26 00:10:37 +00:00
  • dccfd74935 Refine some things to create better looking man pages. Peter Eisentraut 2000-12-25 23:15:27 +00:00
  • e58badfbe7 Improve comments. Tom Lane 2000-12-23 19:55:16 +00:00
  • 7df721af0e Compute reasonable cost and output-row-count estimates for LIMIT plan nodes. Tom Lane 2000-12-23 18:49:41 +00:00
  • 37c55f9849 Some of the stuff documented here hasn't existed since Postgres95. Peter Eisentraut 2000-12-23 16:24:29 +00:00
  • fad813774a Update TODO list. Bruce Momjian 2000-12-23 14:48:57 +00:00
  • de3379503a Remove unused file (the information is already contained elsewhere). Peter Eisentraut 2000-12-23 11:10:55 +00:00
  • a412749812 Replace overly-cute coding with code that (a) has defined behavior according to the ANSI C spec, (b) gets the boundary conditions right, and (c) is about a third as long and three times more intelligible. Tom Lane 2000-12-23 04:05:31 +00:00
  • 90f42847b5 Small cleanup of temp-table handling. Disallow creation of a non-temp table that inherits from a temp table. Make sure the right things happen if one creates a temp table, creates another temp that inherits from it, then renames the first one. (Previously, system would end up trying to delete the temp tables in the wrong order.) Tom Lane 2000-12-22 23:12:07 +00:00
  • 7558da669f Make use of <email> tag for marking up email addresses. Peter Eisentraut 2000-12-22 21:51:58 +00:00
  • 0db1a951d5 Repair not-too-well-thought-out code to do rangechecking of OIDs on 64-bit machines. Also, make oidvectorin use the same code as oidin. Tom Lane 2000-12-22 21:36:09 +00:00
  • 369aace5f3 Avoid XLogFlush for clean buffers in BufferSync. Vadim B. Mikheev 2000-12-22 20:04:43 +00:00
  • 387d43113c Avoid using the terms 'installation', 'site', or 'instance' when referring to the thing you get from running initdb. That's called a database cluster (per SQL). Peter Eisentraut 2000-12-22 19:31:56 +00:00
  • 046848c272 Improve error message for case where DROP TABLE is rejected because table has a child table. Tom Lane 2000-12-22 19:21:37 +00:00
  • 1b555ce791 Replace incorrect uses of 'which' with 'that'. (so-called "wicked which") Peter Eisentraut 2000-12-22 18:57:50 +00:00
  • 04b31609b6 Add 'ONLY' to queries generated by RI triggers, so as to preserve pre-7.1 semantics of RI operations. Eventually we ought to look at making RI work properly across inheritance trees, but not for 7.1 ... Tom Lane 2000-12-22 18:35:09 +00:00
  • f4eef66741 Fix broken markup. Tom Lane 2000-12-22 18:06:46 +00:00
  • 61784c54b5 Change default output formatting for CIDR to be unabbreviated, per recommendation from Paul Vixie. Add a new abbrev() function to produce abbreviated format as text. No forced initdb, but new function is not available unless you do an initdb or add the pg_proc row manually. Tom Lane 2000-12-22 18:00:24 +00:00
  • 13b78a2400 - Fixed bug in a connect statement using varchars. - Synced parser. Michael Meskes 2000-12-22 12:43:14 +00:00
  • 1deb6e7d41 Fix PQsetdbLogin() backward compatibility problem. Tatsuo Ishii 2000-12-22 07:59:32 +00:00
  • 317215fc55 Clean up CREATE TYPE/OPERATOR/AGGREGATE productions, so that parser will not accept types named with operator names or vice versa. Tom Lane 2000-12-22 07:07:58 +00:00
  • 4ce226eeb7 In looking at the 7.1beta1 code for JDBC, I noticed that support was added to support character set encodings. However I noticed that the encoding that is used isn't obtained from the DB. Since Java uses unicode UCS2 internally the character set encoding is used to translate strings from/to the DB encoding. So it seems logical that the code would get the encoding from the DB instead of the current method of requiring the user pass it as a parameter. Bruce Momjian 2000-12-22 03:08:52 +00:00
  • 6cc842abd3 Revise lock manager to support "session level" locks as well as "transaction level" locks. A session lock is not released at transaction commit (but it is released on transaction abort, to ensure recovery after an elog(ERROR)). In VACUUM, use a session lock to protect the master table while vacuuming a TOAST table, so that the TOAST table can be done in an independent transaction. Tom Lane 2000-12-22 00:51:54 +00:00
  • b2145e9365 Get rid of the little "v"s in front of version numbers, substituting the full word "version" where appropriate. Peter Eisentraut 2000-12-21 22:55:27 +00:00
  • 8f89113d4b Updates Peter Eisentraut 2000-12-21 22:30:39 +00:00