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

Commit Graph

  • 293ab5abf3 Fix spacing. Bruce Momjian 2002-08-14 02:51:13 +00:00
  • 9f19f3c836 Added: Bruce Momjian 2002-08-14 02:49:42 +00:00
  • 969e0246ed Add Cyrillic and other encodings for encoding conversion. Patches submitted by Kaori Inaba (i-kaori@sra.co.jp). Tatsuo Ishii 2002-08-14 02:45:10 +00:00
  • d3bd1a00bc Remove namedatalen from TODO.detail. No longer needed. Bruce Momjian 2002-08-14 02:28:30 +00:00
  • e9a0de8b3f Done: Bruce Momjian 2002-08-14 02:24:47 +00:00
  • c028c2a703 Put back old code. Bruce Momjian 2002-08-13 21:04:36 +00:00
  • f340648939 Update for longer NAMEDATALEN. Bruce Momjian 2002-08-13 20:41:13 +00:00
  • 46bb23ac01 Change NAMEDATALEN to 64, INDEX_MAX_KEYS/MAX_FUNC_ARGS to 32, per discussion on hackers. Bruce Momjian 2002-08-13 20:40:44 +00:00
  • f8b4a2e0f0 Fix tuple-chain-moving tests to handle marked-for-update tuples correctly (they are not part of a chain). When failing to find a parent tuple in an update chain, emit a warning and abandon repair_frag, but do not give an error as before. This should eliminate the infamous 'No one parent tuple was found' failure, which we now realize is not a can't-happen condition but a perfectly valid database state. Per recent pghackers discussion. Tom Lane 2002-08-13 20:14:24 +00:00
  • 0affc29e1e Make sure that t_ctid is reset to equal t_self in heap_delete and heap_mark4update; this avoids situations where a deleted tuple might look like it is chained to something else. Also, cause all the WAL redo routines to set t_ctid to equal t_self, rather than leaving it undefined as before. Make heap_xlog_clean set the page's LSN and SUI correctly. All per past discussions in pghackers, ranging back to last December. Tom Lane 2002-08-13 20:11:03 +00:00
  • 1e4c4f9eb7 Remove obsolete uses of lanispl. Only used in pg_dump now, but can be removed altogether if pg_dump doesn't need it anymore. Peter Eisentraut 2002-08-13 17:22:08 +00:00
  • ccf15026e6 Add bitmap index mention. Bruce Momjian 2002-08-13 05:08:35 +00:00
  • b6d8df67d3 Update: Bruce Momjian 2002-08-13 04:32:28 +00:00
  • 282a5884de Correct description of sequence privileges. Peter Eisentraut 2002-08-12 20:02:09 +00:00
  • c024fa4cb5 Remove use of __P so that <sys/cdefs.h> is not needed. Per suggestion from Martin Renters. Tom Lane 2002-08-12 15:24:07 +00:00
  • 1ccc2451c6 Convert possibly-unsafe sprintf's to snprintf's. Tom Lane 2002-08-12 14:47:46 +00:00
  • b47c4ddc7f Buffer-overrun paranoia. Tom Lane 2002-08-12 14:35:26 +00:00
  • 55ca02f447 Restructure rowtype-parameter handling to eliminate need for possibly- overflowable buffer for 'name%rowtype'; not to mention avoid problems with mixed-case type names and other special cases. Tom Lane 2002-08-12 14:25:07 +00:00
  • 77a7e9968b Change memory-space accounting mechanism in tuplesort.c and tuplestore.c to make a reasonable attempt at accounting for palloc overhead, not just the requested size of each memory chunk. Since in many scenarios this will make for a significant reduction in the amount of space acquired, partially compensate by doubling the default value of SORT_MEM to 1Mb. Per discussion in pgsql-general around 9-Jun-2002.. Tom Lane 2002-08-12 00:36:12 +00:00
  • e44beef712 Code review of CLUSTER patch. Clean up problems with relcache getting confused, toasted data getting lost, etc. Tom Lane 2002-08-11 21:17:35 +00:00
  • 9bccdf17f7 Create/drop cast now requires ownership of at least one of the types. Peter Eisentraut 2002-08-11 17:44:12 +00:00
  • 014a86ac47 Editorial improvements. Tom Lane 2002-08-11 02:43:57 +00:00
  • 74ce5c93c7 Make cluster regress test functional. Tom Lane 2002-08-11 02:06:32 +00:00
  • 13e838f1d9 Neil's patch was supposed to remove this, too. Tom Lane 2002-08-11 00:18:59 +00:00
  • 2e10863bf5 Now that we allow ANALYZE to run inside a transaction block, the locks it takes could be held for quite awhile after the analyze step completes. Rethink locking of pg_statistic in light of this fact. The original scheme took an exclusive lock on pg_statistic, which was okay when the lock could be expected to be released shortly, but that doesn't hold anymore. Back off to a normal writer's lock (RowExclusiveLock). This allows concurrent ANALYZE of nonoverlapping sets of tables, at the price that concurrent ANALYZEs of the same table may fail with 'tuple concurrently updated'. Tom Lane 2002-08-11 00:08:48 +00:00
  • 5c3102d6d1 Mention ANALYZE after CLUSTER. Bruce Momjian 2002-08-10 21:03:33 +00:00
  • d1c6416223 Update with newer version of CLUSTER patch posted August 8. Bruce Momjian 2002-08-10 21:00:34 +00:00
  • 8db20b4a5d Remove error files. Bruce Momjian 2002-08-10 20:49:37 +00:00
  • 87cfb8eb29 Fixed very stupid but important bug: mixing calls of some founctions from contrib/tsearch and contrib/ltree :) Bruce Momjian 2002-08-10 20:46:24 +00:00
  • be2de3b9c8 The patch solves this problem, I hope... Bruce Momjian 2002-08-10 20:45:48 +00:00
  • 0d916a4b60 > create view pg_locks as select l.relation, l.database, l.backendpid, > l.mode, l.isgranted from pg_lock_info() as l(relation oid, database oid, > backendpid int4, mode text, isgranted bool); > ERROR: badly formatted planstring "COLUMNDEF "... > Bruce Momjian 2002-08-10 20:44:48 +00:00
  • 7dc40a2be0 Major improvement in CLUSTER which preserves table characteristics using relfilenode. Bruce Momjian 2002-08-10 20:43:46 +00:00
  • 181ca96e7a August 6, 2002 1. Reworked patch from Andrey Oktyabrski (ano@spider.ru) with functions: icount, sort, sort_asc, uniq, idx, subarray operations: #, +, -, |, & Bruce Momjian 2002-08-10 20:38:29 +00:00
  • c5354dff20 This patch removes a lot of unused code related to assertions and error handling, and simplifies the code that remains. Apparently, the code that left Berkeley had a whole "error handling subsystem", which exceptions and whatnot. Since we don't use that anymore, there's no reason to keep it around. Bruce Momjian 2002-08-10 20:29:18 +00:00
  • 8be9bd83ac psql prints its version number in its startup message, per recent discussion. Also, cause the \timing command to display time in a format consistent with the backend's EXPLAIN ANALYZE output. Tom Lane 2002-08-10 19:35:01 +00:00
  • a5e6e99357 Allow schema-qualified operator names to be used in the optional arguments of CREATE OPERATOR. Tom Lane 2002-08-10 19:01:53 +00:00
  • f1d820494c Fix failure to relink postmaster executable in the first make run if only a single source file a few directories deep in the backend tree has changed. Peter Eisentraut 2002-08-10 17:59:28 +00:00
  • 029aa97f2d Make sure all clients have the same understanding of default user name and database. In particular, make script wrappers understand the PGDATABASE environment variable. Peter Eisentraut 2002-08-10 16:57:32 +00:00
  • 60ac5b805e Get rid of double PQclear(res) in error path. Tom Lane 2002-08-10 16:01:16 +00:00
  • 273ae97052 Add a sanity check to make sure that all system catalogs that have OIDs also have a unique index on OID. Tom Lane 2002-08-10 15:54:04 +00:00
  • 039cb47988 psql backslash commands are schema-aware. Pattern matching behavior follows recent pghackers discussion. This commit includes all the relevant fixes from Greg Mullane's patch of 24-June. Tom Lane 2002-08-10 03:56:24 +00:00
  • 6ce4a4e3e1 Make sure monetary, numeric, and time locale categories are set to C and are only activated temporarily to read out formatting information. Peter Eisentraut 2002-08-09 22:52:04 +00:00
  • 9c5dacc5e9 Column ordering in \d output should agree with sort ordering; per Joe Conway's patch of 20-July. Tom Lane 2002-08-09 18:06:57 +00:00
  • 4ab8e69094 has_table_privilege spawns scions has_database_privilege, has_function_privilege, has_language_privilege, has_schema_privilege to let SQL queries test all the new privilege types in 7.3. Also, add functions pg_table_is_visible, pg_type_is_visible, pg_function_is_visible, pg_operator_is_visible, pg_opclass_is_visible to test whether objects contained in schemas are visible in the current search path. Do some minor cleanup to centralize accesses to pg_database, as well. Tom Lane 2002-08-09 16:45:16 +00:00
  • 65dc2e0d8c Change LOCK statements to start new transaction in auto-commit off mode. Hiroshi Inoue 2002-08-09 10:04:21 +00:00
  • 41e7328068 Done: Bruce Momjian 2002-08-08 23:50:38 +00:00
  • 54916d57b3 Add: Bruce Momjian 2002-08-08 23:20:11 +00:00
  • 3b78826bb5 Make the standard system views schema-aware. I did not force an initdb via catversion ... but the rules regression test will fail until you do an initdb. Tom Lane 2002-08-08 19:39:05 +00:00
  • 5e825139e4 Arrange to collect statistics on a few more system catalog columns. Tom Lane 2002-08-08 19:37:11 +00:00
  • 9459db8ea9 Cause view/rule display to work as expected after rename of an underlying table or column, or of an output column of the view itself. Tom Lane 2002-08-08 17:00:19 +00:00
  • d176fad580 Some improvements in geometric-operators documentation. Tom Lane 2002-08-08 14:29:07 +00:00
  • f84002176f Fix bug in encoding conversion table Tatsuo Ishii 2002-08-08 08:21:52 +00:00
  • 697b472099 Address build problems on cygwin and (hopefully) AIX. Tatsuo Ishii 2002-08-08 07:47:43 +00:00
  • 3c63578a7e Load and keep conversion function info when SET CLIENT_ENCODING TO is executed to prevent database access while performing encoding conversion. Tatsuo Ishii 2002-08-08 06:35:26 +00:00
  • b53c851655 Remove #ifdef MULTIBYTE Tatsuo Ishii 2002-08-08 06:32:26 +00:00
  • b084cc3504 Cause schema-qualified FROM items and schema-qualified variable references to behave according to SQL92 (or according to my current understanding of same, anyway). Per pghackers discussion way back in March 2002: thread 'Do FROM items of different schemas conflict?' Tom Lane 2002-08-08 01:44:31 +00:00
  • e42f8e32e9 Clean up plpgsql identifier handling: process quoted identifiers correctly, truncate to NAMEDATALEN where needed, allow whitespace around dots in qualified identifiers. Get rid of T_RECFIELD and T_TGARGV token categories, which weren't accomplishing anything except to create room for sins of omission in the grammar, ie, places that should have allowed them and didn't. Fix a few other bugs en passant. Tom Lane 2002-08-08 01:36:05 +00:00
  • 13e8be42bd parseTypeString wasn't quite paranoid enough. Tom Lane 2002-08-08 01:22:35 +00:00
  • c1003339d6 Fix permission checking for temp-table namespace. Tom Lane 2002-08-07 21:45:02 +00:00
  • dfef56a92f Improve 'failed to initialize' messages. Tom Lane 2002-08-07 17:26:24 +00:00
  • e52a98091f Updated translation from Dennis Bjorklund <db@zigo.dhs.org> Peter Eisentraut 2002-08-06 21:13:44 +00:00
  • ba053de197 Still more paranoia in PageAddItem: disallow specification of an item offset past the last-used-item-plus-one, since that would result in leaving uninitialized holes in the item pointer array. AFAICT the only place that was depending on this was btree index build, which was being cavalier about when to fill in the P_HIKEY pointer; easily fixed. Also a small performance improvement: shuffle itemid's by means of memmove, not a one-at-a-time loop. Tom Lane 2002-08-06 19:41:23 +00:00
  • 4038e8610c Remove no-longer-used PageManagerMode enum. Tom Lane 2002-08-06 19:37:10 +00:00
  • b74f61aabe Move pg_convert3 declaration to suppress compile warning. Really pg_convert3 does not belong in a backend/catalog file at all, IMHO; it should be in utils/adt. Tom Lane 2002-08-06 14:11:06 +00:00
  • 6206a880cf Add SQL99 CONVERT() function. Tatsuo Ishii 2002-08-06 05:40:47 +00:00
  • 34f03b1630 Patch for current CVS. It add test of lca() to ltree test suite. Bruce Momjian 2002-08-06 05:35:29 +00:00
  • 683b0d3add Of course, the simple change has ripple effects! Here's a patch for the rangefunc regression test for the new behavior. Bruce Momjian 2002-08-06 05:34:46 +00:00
  • 4f63e11646 >> Hm. I'd sort of expect the "z" to become both the table and column >> alias in this case. What do you think? > > I guess that would make sense. I'll make a separate patch just for that > change if that's OK. > Bruce Momjian 2002-08-06 05:34:10 +00:00
  • dd6513a5b6 The attached patch disallows the use of coldeflists for functions that don't return type RECORD. It also catches a core dump condition when a function returning RECORD had an alias list instead of a coldeflist. Bruce Momjian 2002-08-06 05:33:29 +00:00
  • 7b30ed8fa4 This patch fixes two typos in the documentation for the newly added START TRANSACTION command. Bruce Momjian 2002-08-06 05:32:16 +00:00
  • a6c7681997 This patch changes the behavior of PostgreSQL so that if any queries are executed in an implicitely aborted transaction (e.g. after an occur occurs), we return an error (and not just a warning). For example: Bruce Momjian 2002-08-06 05:24:04 +00:00
  • 5df307c778 Restructure local-buffer handling per recent pghackers discussion. The local buffer manager is no longer used for newly-created relations (unless they are TEMP); a new non-TEMP relation goes through the shared bufmgr and thus will participate normally in checkpoints. But TEMP relations use the local buffer manager throughout their lifespan. Also, operations in TEMP relations are not logged in WAL, thus improving performance. Since it's no longer necessary to fsync relations as they move out of the local buffers into shared buffers, quite a lot of smgr.c/md.c/fd.c code is no longer needed and has been removed: there's no concept of a dirty relation anymore in md.c/fd.c, and we never fsync anything but WAL. Still TODO: improve local buffer management algorithms so that it would be reasonable to increase NLocBuffer. Tom Lane 2002-08-06 02:36:35 +00:00
  • 35cd432b18 Forgot to add/remove files. Peter Eisentraut 2002-08-05 19:44:58 +00:00
  • 6f4a9fb119 Add User's Guide chapters on Data Definition and Data Manipulation. Still needs to be filled with more information, but it gives us a framework to have a User's Guide with complete coverage of the basic SQL operations. Move arrays into data type chapter, inheritance into DDL chapter (for now). Peter Eisentraut 2002-08-05 19:43:31 +00:00
  • 15fe086fba Restructure system-catalog index updating logic. Instead of having hardwired lists of index names for each catalog, use the relcache's mechanism for caching lists of OIDs of indexes of any table. This reduces the common case of updating system catalog indexes to a single line, makes it much easier to add a new system index (in fact, you can now do so on-the-fly if you want to), and as a nice side benefit improves performance a little. Per recent pghackers discussion. Tom Lane 2002-08-05 03:29:17 +00:00
  • 07f9682de4 Preliminary code review for anonymous-composite-types patch: fix breakage of functions returning domain types, update documentation for typtype, move get_typtype to lsyscache.c (actually, resurrect the old version), add defense against creating pseudo-typed table columns, fix some bogus list-parsing in grammar. Issues remain with respect to alias handling and type checking; Joe is on those. Tom Lane 2002-08-05 02:30:50 +00:00
  • ac1a3dcf24 Fix compilation problem with assert checking enabled for recent xlog location feature. Thomas G. Lockhart 2002-08-05 01:24:16 +00:00
  • 0fe931a3e0 Code review for anonymous-functions patch --- clean up some confusion in checkretval about which paths are for base or complex return type. Tom Lane 2002-08-05 00:21:27 +00:00
  • 44582cd879 Temporary solution for XLogDir breakage. Tom Lane 2002-08-04 23:56:01 +00:00
  • 1be014313a Fix merge failures for anonymous-type patch. From Joe Conway. Tom Lane 2002-08-04 23:49:59 +00:00
  • e053d2071d Fix broken pg_backend_pid reference, per Joe Conway. Tom Lane 2002-08-04 23:46:38 +00:00
  • 32465bfc75 Another backend_pid rename. Bruce Momjian 2002-08-04 20:01:33 +00:00
  • 58c227693d Fix compile failures for FRS composite tyhpe patch until Joe can fix it. Bruce Momjian 2002-08-04 20:00:15 +00:00
  • d7859a9570 Rename backend_pid to pg_backend_pid, move docs to monitoring section. Bruce Momjian 2002-08-04 19:51:30 +00:00
  • 9218689b69 Attached are two patches to implement and document anonymous composite types for Table Functions, as previously proposed on HACKERS. Here is a brief explanation: Bruce Momjian 2002-08-04 19:48:11 +00:00
  • 35d39ba081 Fix obsolete comment. Tom Lane 2002-08-04 18:12:15 +00:00
  • ffef720670 Minor clarification or fix of typos. Thomas G. Lockhart 2002-08-04 06:54:10 +00:00
  • c755f6027f Implement WAL log location control using "-X" or PGXLOG. Thomas G. Lockhart 2002-08-04 06:53:10 +00:00
  • eb121ba2cf Implement IS OF and IS NOT OF type predicate. Can now do queries of the form: SELECT value IS OF (integer, float8); Define macros for handling typmod manipulation for date/time types. Should be more robust than all of that brute-force inline code. Rename macros for masking and typmod manipulation to put TIMESTAMP_ or INTERVAL_ in front of the macro name, to reduce the possibility of name space collisions. Allow bit string constants without fully-specified length declaration. Try implementing CREATE TABLE/OF as a mapping to inheritance. May be appropriate, or may be replace later with something more exactly like one might expect from databases without the feature. Thomas G. Lockhart 2002-08-04 06:51:23 +00:00
  • 7c1e67bd52 Implement IS OF type predicate. Can now do queries of the form: select value IS OF (integer, float8); Thomas G. Lockhart 2002-08-04 06:46:12 +00:00
  • b71310d8e0 Add guard code to protect from buffer overruns on long date/time input strings. Should go back in and look at doing this a bit more elegantly and (hopefully) cheaper. Probably not too bad anyway, but it seems a shame to scan the strings twice: once for length for this buffer overrun protection, and once to parse the line. Remove use of pow() in date/time handling; was already gone from everything *but* the time data types. Define macros for handling typmod manipulation for date/time types. Should be more robust than all of that brute-force inline code. Rename macros for masking and typmod manipulation to put TIMESTAMP_ or INTERVAL_ in front of the macro name, to reduce the possibility of name space collisions. Thomas G. Lockhart 2002-08-04 06:44:47 +00:00
  • e025bb7a72 Define macros for handling typmod manipulation for date/time types. Should be more robust than all of that brute-force inline code. Rename macros for masking and typmod manipulation to put TIMESTAMP_ or INTERVAL_ in front of the macro name, to reduce the possibility of name space collisions. Thomas G. Lockhart 2002-08-04 06:42:18 +00:00
  • 043f9eb90a Implement hex literal conversion to bit string literal. May not be the long-term solution (some continuing discussion with Peter E.) but better than the current mapping of a conversion to integer which I'd put in years ago before we had any bit string types at all. This is already supported in the bit string implementation elsewhere. Thomas G. Lockhart 2002-08-04 06:36:18 +00:00
  • ce5dc562e6 Allow bit string constants without fully-specified length declaration. Implement conversion between 8-byte integers and bit strings. Similar to what is done for 4-byte integers. Thomas G. Lockhart 2002-08-04 06:33:59 +00:00
  • af704cdfb4 Implement WAL log location control using "-X" or PGXLOG. Thomas G. Lockhart 2002-08-04 06:26:38 +00:00
  • a19d9d3c4c Add IS OF type predicate. Thomas G. Lockhart 2002-08-04 06:17:29 +00:00
  • 6045f39bfd Add Myannar Time, Iran Time variant name, and Marquesas Time. Thomas G. Lockhart 2002-08-04 06:15:45 +00:00
  • 0a4fc8556c Fix broken markup. Tom Lane 2002-08-04 05:46:02 +00:00
  • 5f9ba042a7 Neil's patch claimed a column list didn't work for COPY BINARY. Which was true when he submitted it, but is so no longer. Tom Lane 2002-08-04 05:22:02 +00:00
  • 7926259de3 Add missing file; new docs for start_transaction. Bruce Momjian 2002-08-04 05:14:06 +00:00