hcq/postgresql
1
0
Fork 0
mirror of https://git.postgresql.org/git/postgresql.git synced 2026-03-26 02:18:27 +08:00
Code Issues Packages Projects Releases Wiki Activity

Commit Graph

  • 18cbc7aefc Use 0x01 for newlines in saved history. It was determined to be not used by multi-byte sequences, but futher invesetigation might prove this to be false. Bruce Momjian 2006-02-12 05:24:38 +00:00
  • f7d9874415 Clean up plpgsql grammar to make sure that check_assignable() is applied consistently. This is mostly cosmetic right at the moment because check_assignable() does nothing for ROW or RECORD datums, but that might not always be so. This also syncs several different places that read INTO target lists. They're just enough different that it seems impractical to factor them into a single routine, but they surely should be the same as much as possible. Tom Lane 2006-02-12 04:59:32 +00:00
  • 136c3b87ac Done: Bruce Momjian 2006-02-12 04:44:17 +00:00
  • f695750c43 Allow to_char() to print localized month and day names. Bruce Momjian 2006-02-12 04:44:15 +00:00
  • 3957cf6e71 As part of previous commit, add pg_restore option: Bruce Momjian 2006-02-12 04:07:25 +00:00
  • 0f57851e31 Add psql option: Bruce Momjian 2006-02-12 04:04:32 +00:00
  • 3884ede663 Done: Bruce Momjian 2006-02-12 03:56:13 +00:00
  • d5dd3d451e Add contrib/pg_freespacemap to display free space map information. Bruce Momjian 2006-02-12 03:55:53 +00:00
  • 6c0d4aabe2 Fix more fallout from line-wrap patch, to wit, arbitrarily changing the API of PQdsplen without bothering to fix its callers. Although ReportSyntaxErrorPosition could probably do with more smarts about handling control characters, for the moment I'll just get it back to handling tabs consistently. Tom Lane 2006-02-12 03:30:21 +00:00
  • f9a726aa88 I've created a new shared catalog table pg_shdescription to store comments on cluster global objects like databases, tablespaces, and roles. Bruce Momjian 2006-02-12 03:22:21 +00:00
  • 95dbf9c02f Undo changes of trailing space in recently-committed expected files. This is mostly just over-compulsiveness on my part, but the exercise did reveal one real bug: errors.out has a space difference now where it should not. Tom Lane 2006-02-12 03:10:04 +00:00
  • 3f9d2edddc Restore previous psql behavior of not printing useless trailing spaces after the data in the last column on a line. Tom Lane 2006-02-12 02:56:21 +00:00
  • 07bae9c099 Please find enclosed a patch that lets you use \c to connect (optionally) to a new host and port without exiting psql. This eliminates, IMHO, a surprise in that you can now connect to PostgreSQL on a differnt machine from the one where you started your session. This should help people who use psql as an administrative tool. Bruce Momjian 2006-02-12 02:54:30 +00:00
  • d52a57fc30 Actually there's a better way to do this, which is to count tuples during the vacuumcleanup scan that we're going to do anyway. Should save a few cycles (one calculation per page, not per tuple) as well as not having to depend on assumptions about heap and index being in step. I think this could probably be made to work for GIST too, but that code looks messy enough that I'm disinclined to try right now. Tom Lane 2006-02-12 00:18:17 +00:00
  • fd267c1ebc Skip ambulkdelete scan if there's nothing to delete and the index is not partial. None of the existing AMs do anything useful except counting tuples when there's nothing to delete, and we can get a tuple count from the heap as long as it's not a partial index. (hash actually can skip anyway because it maintains a tuple count in the index metapage.) GIST is not currently able to exploit this optimization because, due to failure to index NULLs, GIST is always effectively partial. Possibly we should fix that sometime. Simon Riggs w/ some review by Tom Lane. Tom Lane 2006-02-11 23:31:34 +00:00
  • a02f6ce33b Allow ALTER TABLE ... ALTER CONSTRAINT ... RENAME Bruce Momjian 2006-02-11 22:17:19 +00:00
  • 3fcb38f031 Done: > o -Allow ALTER TABLE ... ALTER CONSTRAINT ... RENAME Bruce Momjian 2006-02-11 22:17:17 +00:00
  • 97d37b7a22 Done: Bruce Momjian 2006-02-11 21:55:49 +00:00
  • 4cb27fef0a o Improve psql's handling of multi-line statements Bruce Momjian 2006-02-11 21:55:35 +00:00
  • fbb1daed93 Fix incorrect addition, subtraction, and overflow checking in new inet operators. Tom Lane 2006-02-11 20:39:59 +00:00
  • 77bb65d3fc Revert based on Tom's recommendation: Bruce Momjian 2006-02-11 17:14:09 +00:00
  • bf324946b3 Allow VACUUM to complete faster by avoiding scanning the indexes when no rows were removed from the heap by the VACUUM. Bruce Momjian 2006-02-11 16:59:09 +00:00
  • 85d8ee846b Update catalog version for INET additions. Bruce Momjian 2006-02-11 16:28:56 +00:00
  • 642c8cc470 Done: Bruce Momjian 2006-02-11 03:33:36 +00:00
  • 1372515271 Add INET/CIDR operators: and, or, not, plus int8, minus int8, and inet minus inet. Bruce Momjian 2006-02-11 03:32:41 +00:00
  • 9bf2ac2a40 Clean up signedness warnings and 64-bit bugs in recent psql printing patch. Martijn van Oosterhout and Tom Lane Tom Lane 2006-02-10 22:29:06 +00:00
  • fc9c20eb72 Make it possible to run initdb from an admin account on Windows, by giving up admin privileges (only works if newer than NT4). Tom Lane 2006-02-10 22:05:42 +00:00
  • a25cd81007 Enable pg_ctl to give up admin privileges when starting the server under Windows (if newer than NT4, else works same as before). Tom Lane 2006-02-10 22:00:59 +00:00
  • 9878d9a1f1 Check that SID is enabled while checking for Windows admin privileges. Magnus Tom Lane 2006-02-10 21:52:43 +00:00
  • b919f3fcbb Check that SID is enabled while checking for Windows admin privileges. Magnus Tom Lane 2006-02-10 21:52:34 +00:00
  • eb6d1270f1 Check that SID is enabled while checking for Windows admin privileges. Magnus Tom Lane 2006-02-10 21:52:21 +00:00
  • bce1d83ee5 Change search for default operator classes so that it examines all opclasses regardless of the current schema search path. Since CREATE OPERATOR CLASS only allows one default opclass per datatype regardless of schemas, this should have minimal impact, and it fixes problems with failure to find a desired opclass while restoring dump files. Per discussion at http://archives.postgresql.org/pgsql-hackers/2006-02/msg00284.php. Remove now-redundant-or-unused code in typcache.c and namespace.c, and backpatch as far as 8.0. Tom Lane 2006-02-10 19:01:33 +00:00
  • 2d26c4be8e Change search for default operator classes so that it examines all opclasses regardless of the current schema search path. Since CREATE OPERATOR CLASS only allows one default opclass per datatype regardless of schemas, this should have minimal impact, and it fixes problems with failure to find a desired opclass while restoring dump files. Per discussion at http://archives.postgresql.org/pgsql-hackers/2006-02/msg00284.php. Remove now-redundant-or-unused code in typcache.c and namespace.c, and backpatch as far as 8.0. Tom Lane 2006-02-10 19:01:22 +00:00
  • 3ac1ac58cc Change search for default operator classes so that it examines all opclasses regardless of the current schema search path. Since CREATE OPERATOR CLASS only allows one default opclass per datatype regardless of schemas, this should have minimal impact, and it fixes problems with failure to find a desired opclass while restoring dump files. Per discussion at http://archives.postgresql.org/pgsql-hackers/2006-02/msg00284.php. Remove now-redundant-or-unused code in typcache.c and namespace.c, and backpatch as far as 8.0. Tom Lane 2006-02-10 19:01:12 +00:00
  • b35fdaaa1a Clean up some signedness warnings. Tom Lane 2006-02-10 15:57:58 +00:00
  • 1a7be5cc7e Fix psql after newline patch for calloc(0). Bruce Momjian 2006-02-10 15:48:05 +00:00
  • b2be41a710 Fix fallout from psql line-wrapping patch. Tom Lane 2006-02-10 15:47:44 +00:00
  • 01f2172ec1 Allow "'" symbol in affixes ("'s" affix in english): it was diallowed during multibyte support work. Add line number to error output during affix file parsing. Teodor Sigaev 2006-02-10 12:56:14 +00:00
  • 12fca1f6fa Fix up remaining library checks. Peter Eisentraut 2006-02-10 11:35:47 +00:00
  • 011c520cb6 renew output of regression test accordingly to http://archives.postgresql.org/pgsql-committers/2006-02/msg00089.php Teodor Sigaev 2006-02-10 11:18:40 +00:00
  • af03b689dd Done: Bruce Momjian 2006-02-10 04:14:17 +00:00
  • c01999a557 Allow psql multi-line column values to align in the proper columns Bruce Momjian 2006-02-10 00:39:04 +00:00
  • 593763c086 This fixes pg_dump so that when using the '-O' no owners option it does not print the owner name in the object comment. Bruce Momjian 2006-02-09 20:52:13 +00:00
  • f28106381a Provide the libpq error message when PQputline or PQendcopy fails. Tom Lane 2006-02-09 18:28:43 +00:00
  • f9e03aa8e9 Provide the libpq error message when PQputline or PQendcopy fails. Tom Lane 2006-02-09 18:28:35 +00:00
  • ff2cc83f8a Provide the libpq error message when PQputline or PQendcopy fails. Tom Lane 2006-02-09 18:28:29 +00:00
  • 46a25ce6a9 1 Fix bug with very short word: prefix and suffix might be overlapped, sorry but fix can't be applyed to previous version: it's require refill tsvector... 2 Small optimize of load time for huge dictionaries 3 use palloc instead of malloc during load dict file Teodor Sigaev 2006-02-09 18:04:20 +00:00
  • a815a579f5 Use "bitwise" rather than "binary for AND/OR descriptions in \d, to match SGML documentation. Bruce Momjian 2006-02-09 14:53:51 +00:00
  • 14ebeee134 C++ comments are verboten. Per gripe from Kris Jurka. Tom Lane 2006-02-09 07:22:22 +00:00
  • a14302080f Reject out-of-range dates in date_in(). Tom Lane 2006-02-09 03:40:42 +00:00
  • f527f082c5 Reject out-of-range dates in date_in(). Tom Lane 2006-02-09 03:40:30 +00:00
  • 7ae2ccbc85 Reject out-of-range dates in date_in(). Tom Lane 2006-02-09 03:39:17 +00:00
  • 3cb312d873 Fix broken non-YYDEBUG case. Tom Lane 2006-02-09 00:56:57 +00:00
  • e3740d2c59 Added just another test case. Fixed missing continuation line character. Do not translate $-quoting. Bit field notation belongs to a variable not a variable list. Output of line number only done by one function. Michael Meskes 2006-02-08 09:10:05 +00:00
  • 115e5dd597 Remove ancient hack to work around a peculiarity of libcurses on HPUX. Since we now use libtermcap in preference to libcurses, no need for hack anymore. Tom Lane 2006-02-07 17:36:13 +00:00
  • ad177f10ee Source code cleanup. Bruce Momjian 2006-02-07 17:04:04 +00:00
  • e7a9ccdb6c I think that NUMERIC datatype has a problem in the performance that the format on Tuple(Numeric) and the format to calculate(NumericVar) are different. I understood that to reduce I/O. However, when many comparisons or calculations of NUMERIC are executed, the conversion of Numeric and NumericVar becomes a bottleneck. Bruce Momjian 2006-02-07 16:03:50 +00:00
  • 15be0b8cd1 Remove question mark: Bruce Momjian 2006-02-07 14:49:17 +00:00
  • 4d464076ff Make --version option print fixed program name. Peter Eisentraut 2006-02-07 11:36:36 +00:00
  • 50610ef8b5 Remove some checks for libraries that no one can identify. We'll see how that works out... Peter Eisentraut 2006-02-07 11:22:41 +00:00
  • 04a942e31e Split up wal-logging items: Bruce Momjian 2006-02-07 02:08:08 +00:00
  • cfcf54ac89 Fix HTML alignment in PQprint. Bruce Momjian 2006-02-07 00:26:38 +00:00
  • 8bf47f455f Fix HTML alignment in PQprint. Bruce Momjian 2006-02-07 00:26:15 +00:00
  • 72153c0582 Improve the tests to see if ScalarArrayOpExpr is strict. Original coding would basically punt in all cases for 'foo <> ALL (array)', which resulted in a performance regression for NOT IN compared to what we were doing in 8.1 and before. Per report from Pavel Stehule. Tom Lane 2006-02-06 22:21:12 +00:00
  • a6fefc866c Check number of affixes to prevent core dump with zero number of affixes Teodor Sigaev 2006-02-06 15:45:34 +00:00
  • 763b9c1901 Fix PQprint HTML tag, "centre" -> "center". Bruce Momjian 2006-02-06 02:23:17 +00:00
  • 9ce51f3aa6 Fix PQprint HTML tag, "centre" -> "center". Bruce Momjian 2006-02-06 02:23:07 +00:00
  • f9ce97c5a1 Fix pg_restore to properly discard COPY data when trying to continue after an error in a COPY statement. Formerly it thought the COPY data was SQL commands, and got quite confused. Tom Lane 2006-02-05 20:59:06 +00:00
  • 7d41ef1a92 Fix pg_restore to properly discard COPY data when trying to continue after an error in a COPY statement. Formerly it thought the COPY data was SQL commands, and got quite confused. Tom Lane 2006-02-05 20:58:57 +00:00
  • 8e4057cc7d Fix pg_restore to properly discard COPY data when trying to continue after an error in a COPY statement. Formerly it thought the COPY data was SQL commands, and got quite confused. Tom Lane 2006-02-05 20:58:47 +00:00
  • c75c372c58 Fix typo in configuration docs. Bruce Momjian 2006-02-05 18:19:33 +00:00
  • db5e39b2f0 Fix typo in configuration docs. Bruce Momjian 2006-02-05 18:19:14 +00:00
  • 336a6491aa Improve my initial, rather hacky implementation of joins to append relations: fix the executor so that we can have an Append plan on the inside of a nestloop and still pass down outer index keys to index scans within the Append, then generate such plans as if they were regular inner indexscans. This avoids the need to evaluate the outer relation multiple times. Tom Lane 2006-02-05 02:59:17 +00:00
  • 3bf6284f10 Update PL/pgSQL trigger example to be clearer about how to "merge" data into a table. Bruce Momjian 2006-02-05 02:48:20 +00:00
  • 354213c7f4 Update PL/pgSQL trigger example to be clearer about how to "merge" data into a table. Bruce Momjian 2006-02-05 02:47:53 +00:00
  • 3893127431 Fix constraint exclusion to work in inherited UPDATE/DELETE queries ... in fact, it will be applied now in any query whatsoever. I'm still a bit concerned about the cycles that might be expended in failed proof attempts, but given that CE is turned off by default, it's the user's choice whether to expend those cycles or not. (Possibly we should change the simple bool constraint_exclusion parameter to something more fine-grained?) Tom Lane 2006-02-04 23:03:20 +00:00
  • 48d9ad3722 Fix broken markup. Tom Lane 2006-02-04 22:38:39 +00:00
  • a13c1edb57 Added C bit fields to ecpg parser Added some default rules to lexer Added log output to prepare statement Added some more stuff to a test case Michael Meskes 2006-02-04 20:54:44 +00:00
  • f8b54fe6ed DROP IF EXISTS for ROLE/USER/GROUP Andrew Dunstan 2006-02-04 19:06:47 +00:00
  • 3fa9c416ed Issue a warning if a change-on-restart-only postgresql.conf value is modified and the server config files are reloaded Peter Eisentraut 2006-02-04 12:50:47 +00:00
  • bc6a824ca6 Update walcontrol item: Bruce Momjian 2006-02-04 03:23:21 +00:00
  • 3f8984039a Add to TODO.detail/walcontrol. Bruce Momjian 2006-02-04 03:22:36 +00:00
  • b3769066b8 In ecpg, automatically double single quotes in $$ strings because internally $$ strings are converted to single-quote strings. Bruce Momjian 2006-02-04 02:32:38 +00:00
  • 9190b4da5d Update Makefile for new thread_test location. Bruce Momjian 2006-02-04 01:04:20 +00:00
  • 9e66c3e6fe Move thread_test directory from /tools to /test so source-only tarballs have the directory for the configure test. Bruce Momjian 2006-02-04 01:00:02 +00:00
  • 0e04982e78 First attempt at removing some AC_CHECK_LIB(foo, main) calls. Peter Eisentraut 2006-02-04 00:42:54 +00:00
  • 8b109ebf14 Teach planner to convert simple UNION ALL subqueries into append relations, thereby sharing code with the inheritance case. This puts the UNION-ALL-view approach to partitioned tables on par with inheritance, so far as constraint exclusion is concerned: it works either way. (Still need to update the docs to say so.) The definition of "simple UNION ALL" is a little simpler than I would like --- basically the union arms can only be SELECT * FROM foo --- but it's good enough for partitioned-table cases. Tom Lane 2006-02-03 21:08:49 +00:00
  • a25b1decef Update tested AIX memset platforms. Bruce Momjian 2006-02-03 13:56:20 +00:00
  • ebd38e3c1d Allow MEMSET_LOOP_LIMIT to be set on a per-platform basis, and turn off MemSet on AIX by setting MEMSET_LOOP_LIMIT to zero. Bruce Momjian 2006-02-03 13:53:15 +00:00
  • 59bb147353 Update random() usage so ranges are inclusive/exclusive as required. Bruce Momjian 2006-02-03 12:45:47 +00:00
  • eb7bd06983 Prevent COPY from using newline or carriage return as delimiter or null. Disallow backslash as the delimiter in non-CVS mode. Bruce Momjian 2006-02-03 12:41:07 +00:00
  • 890707a537 Improve tab whitespace in file. Bruce Momjian 2006-02-03 05:38:35 +00:00
  • 46dfa5ec83 More spacing cleanups. Bruce Momjian 2006-02-02 03:51:41 +00:00
  • d63901c9d0 Source code alignment fixes for preproc.y. Bruce Momjian 2006-02-01 22:16:36 +00:00
  • a274239bce More alignment improvements. Bruce Momjian 2006-02-01 20:57:39 +00:00
  • 71b9df2bed Make pgc.l source code alignment consistent. Bruce Momjian 2006-02-01 20:56:44 +00:00
  • bd5d12a16b Add: Bruce Momjian 2006-02-01 17:32:45 +00:00
  • 47a86fa02d Add code comment about Linux stack randomization and shared memory. Bruce Momjian 2006-02-01 16:00:06 +00:00
  • 3002acda43 Fix const cast in get_progname(). Bruce Momjian 2006-02-01 12:42:30 +00:00
  • 180b23cb22 Fix const cast in get_progname(). Bruce Momjian 2006-02-01 12:42:00 +00:00