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

Commit Graph

  • b6c881ce62 Update regression tests for new referential integrity error message wording ("table" added). Bruce Momjian 2005-12-28 23:17:09 +00:00
  • c104cd2038 Fix plperl validator to honor check_function_bodies: when that is OFF, we want it to check the argument/result data types and no more. In particular, libperl shouldn't get initialized in this case. Tom Lane 2005-12-28 18:34:16 +00:00
  • 15093bf2d8 Move plpgsql's fetchArgInfo() into funcapi.c, and rename to get_func_arg_info() for consistency with other names there. This code will probably be useful to other PLs when they start to support OUT parameters, so better to have it in the main backend. Also, fix plpgsql validator to detect bogus OUT parameters even when check_function_bodies is off. Tom Lane 2005-12-28 18:11:25 +00:00
  • 776d63f975 Mention "table" in "violates foreign key constraint" message that was lacking it. Perhaps it was suppressed because of line length considerations, but "table" should appear. Bruce Momjian 2005-12-28 16:47:21 +00:00
  • a4e5169994 Remove silly use of DLLIMPORT. Tom Lane 2005-12-28 16:38:38 +00:00
  • 5fcf4a9c03 Add COPY CSV test that tests CSV output of \. Bruce Momjian 2005-12-28 15:07:13 +00:00
  • 54e5caa440 Add COPY CSV test that tests CSV output of \. Bruce Momjian 2005-12-28 15:07:02 +00:00
  • c54fee814f Update COPY CSV \. wording for externally created files. Bruce Momjian 2005-12-28 14:38:43 +00:00
  • 9c72df4e86 Update COPY CSV \. wording for externally created files. Bruce Momjian 2005-12-28 14:38:32 +00:00
  • c7fc2ccf63 Add regression tests for CSV and \., and add automatic quoting of a single column dump that has a \. value, so the load works properly. I also added documentation describing this issue. Bruce Momjian 2005-12-28 05:38:27 +00:00
  • 6fa335721a Update: Bruce Momjian 2005-12-28 03:59:39 +00:00
  • 87289ff35c Add regression tests for CSV and \., and add automatic quoting of a single column dump that has a \. value, so the load works properly. I also added documentation describing this issue. Bruce Momjian 2005-12-28 03:25:32 +00:00
  • 1b184c990f Done: Bruce Momjian 2005-12-28 02:12:25 +00:00
  • 6e07709760 Implement SQL-compliant treatment of row comparisons for < <= > >= cases (previously we only did = and <> correctly). Also, allow row comparisons with any operators that are in btree opclasses, not only those with these specific names. This gets rid of a whole lot of indefensible assumptions about the behavior of particular operators based on their names ... though it's still true that IN and NOT IN expand to "= ANY". The patch adds a RowCompareExpr expression node type, and makes some changes in the representation of ANY/ALL/ROWCOMPARE SubLinks so that they can share code with RowCompareExpr. Tom Lane 2005-12-28 01:30:02 +00:00
  • a37422e042 Increase amount of shared buffers initdb tries to allocate to 4000, and add logic to try max_fsm_pages up to 200000, plus accompanying minor docs changes. Andrew Dunstan 2005-12-27 23:54:01 +00:00
  • 3f99c2d5a7 Our code had: Bruce Momjian 2005-12-27 18:10:57 +00:00
  • a598385f3b Our code had: Bruce Momjian 2005-12-27 18:10:48 +00:00
  • a4a4b8bb02 Protect ADD and HEADER symbols from conflicting with MIPS includes. Bruce Momjian 2005-12-27 04:00:08 +00:00
  • a2384d008a More uses of IS_HIGHBIT_SET() macro. Bruce Momjian 2005-12-26 19:30:45 +00:00
  • 6840cccd11 Rename pg_make_encrypted_password to PQencryptPassword. Peter Eisentraut 2005-12-26 14:58:06 +00:00
  • 5c9a46f605 Add: Bruce Momjian 2005-12-26 05:14:52 +00:00
  • 97e1535fba Various cosmetic code cleanup for PL/Python: Neil Conway 2005-12-26 04:28:48 +00:00
  • 261114a23f I have added these macros to c.h: Bruce Momjian 2005-12-25 02:14:19 +00:00
  • a4d69a410d Minor doc tweak: "NOT NULL" is redundant with "SERIAL" in example. Neil Conway 2005-12-25 01:41:15 +00:00
  • c45eb53642 Spell fix. Andrew. Bruce Momjian 2005-12-24 19:29:38 +00:00
  • 5c28913e6a Update why unified diff is _sometimes_ better. Bruce Momjian 2005-12-24 18:37:17 +00:00
  • 9b28021cc6 Previous commit message should have been: Bruce Momjian 2005-12-24 18:23:02 +00:00
  • 1aecda002e Add Bruce Momjian 2005-12-24 18:21:34 +00:00
  • e5392a43f8 Alignment cleanup. Bruce Momjian 2005-12-24 18:11:30 +00:00
  • d8a8183456 Formatting cleanups. Bruce Momjian 2005-12-24 17:19:40 +00:00
  • 0658a6a634 Formatting cleanup. Bruce Momjian 2005-12-24 16:49:48 +00:00
  • 951f2bdd23 Fix long standing Asian multibyte charsets bug. See: Tatsuo Ishii 2005-12-24 12:08:10 +00:00
  • b2af5a28cc Fix long standing Asian multibyte charsets bug. See: Tatsuo Ishii 2005-12-24 10:40:55 +00:00
  • 95da30b20f Fix long standing Asian multibyte charsets bug. See: Tatsuo Ishii 2005-12-24 10:11:32 +00:00
  • ab2d8c41ff Fix long standing Asian multibyte charsets bug. See: Tatsuo Ishii 2005-12-24 09:42:30 +00:00
  • 804f6b8fc9 Fix long standing Asian multibyte charsets bug. See: Tatsuo Ishii 2005-12-24 09:35:36 +00:00
  • 5343bcadd6 Fix for rearranging encoding id ISO-8859-5 to ISO-8859-8. Also make the code more robust by searching for target encoding in the internal charset map. Tatsuo Ishii 2005-12-24 00:49:18 +00:00
  • 7d732f06cc Wups, fat-fingered the calculation the first time. Update comment in postgresql.conf.sample too. Tom Lane 2005-12-23 23:28:35 +00:00
  • b1bff7e6fa Update info about shared memory space calculation to match CVS tip's behavior. Tom Lane 2005-12-23 23:02:26 +00:00
  • 988fe9f7dd Fix make_relative_path() to support cases where target_path and bin_path differ by more than the last directory component. Instead of insisting that they match up to the last component, accept whatever common prefix they have, and try to replace the non-matching part of bin_path with the non-matching part of target_path in the actual executable's path. In one way this is tighter than the old code, because it insists on a match to the part of bin_path we want to substitute for, rather than blindly stripping one directory component from the executable's path. Per gripe from Martin Pitt and subsequent discussion. Tom Lane 2005-12-23 22:34:33 +00:00
  • 13d954d744 Fix make_relative_path() to support cases where target_path and bin_path differ by more than the last directory component. Instead of insisting that they match up to the last component, accept whatever common prefix they have, and try to replace the non-matching part of bin_path with the non-matching part of target_path in the actual executable's path. In one way this is tighter than the old code, because it insists on a match to the part of bin_path we want to substitute for, rather than blindly stripping one directory component from the executable's path. Per gripe from Martin Pitt and subsequent discussion. Tom Lane 2005-12-23 22:34:27 +00:00
  • 936d43d842 Fix make_relative_path() to support cases where target_path and bin_path differ by more than the last directory component. Instead of insisting that they match up to the last component, accept whatever common prefix they have, and try to replace the non-matching part of bin_path with the non-matching part of target_path in the actual executable's path. In one way this is tighter than the old code, because it insists on a match to the part of bin_path we want to substitute for, rather than blindly stripping one directory component from the executable's path. Per gripe from Martin Pitt and subsequent discussion. Tom Lane 2005-12-23 22:34:22 +00:00
  • 98b3c3c450 Allow CREATE/ALTER ROLE PASSWORD NULL to allow restoring the default state of having no password. Peter Eisentraut 2005-12-23 16:46:39 +00:00
  • dcc7da8d5e Fix for rearranging encoding id ISO-8859-5 to ISO-8859-8. Also make the code more robust by searching for target encoding in the internal charset map. Tatsuo Ishii 2005-12-23 02:11:02 +00:00
  • ea9b028dc7 Add an officially exported libpq function to encrypt passwords, and modify the previous \password patch to use it instead of depending on a not-officially-exported function. Per discussion. Tom Lane 2005-12-23 01:16:38 +00:00
  • e80f9dfa80 Add quotes around search_path "$user" so that SHOW output can be used in SET. Bruce Momjian 2005-12-23 00:38:04 +00:00
  • 2f1a78e200 Update item: Bruce Momjian 2005-12-22 23:05:32 +00:00
  • cd726e1cf8 Adjust string comparison so that only bitwise-equal strings are considered equal: if strcoll claims two strings are equal, check it with strcmp, and sort according to strcmp if not identical. This fixes inconsistent behavior under glibc's hu_HU locale, and probably under some other locales as well. Also, take advantage of the now-well-defined behavior to speed up texteq, textne, bpchareq, bpcharne: they may as well just do a bitwise comparison and not bother with strcoll at all. Tom Lane 2005-12-22 22:50:29 +00:00
  • 0862aeaeec Adjust string comparison so that only bitwise-equal strings are considered equal: if strcoll claims two strings are equal, check it with strcmp, and sort according to strcmp if not identical. This fixes inconsistent behavior under glibc's hu_HU locale, and probably under some other locales as well. Also, take advantage of the now-well-defined behavior to speed up texteq, textne, bpchareq, bpcharne: they may as well just do a bitwise comparison and not bother with strcoll at all. Tom Lane 2005-12-22 22:50:22 +00:00
  • faefc812f8 Adjust string comparison so that only bitwise-equal strings are considered equal: if strcoll claims two strings are equal, check it with strcmp, and sort according to strcmp if not identical. This fixes inconsistent behavior under glibc's hu_HU locale, and probably under some other locales as well. Also, take advantage of the now-well-defined behavior to speed up texteq, textne, bpchareq, bpcharne: they may as well just do a bitwise comparison and not bother with strcoll at all. Tom Lane 2005-12-22 22:50:14 +00:00
  • e6242ba176 Adjust string comparison so that only bitwise-equal strings are considered equal: if strcoll claims two strings are equal, check it with strcmp, and sort according to strcmp if not identical. This fixes inconsistent behavior under glibc's hu_HU locale, and probably under some other locales as well. Also, take advantage of the now-well-defined behavior to speed up texteq, textne, bpchareq, bpcharne: they may as well just do a bitwise comparison and not bother with strcoll at all. Tom Lane 2005-12-22 22:50:07 +00:00
  • 656beff590 Adjust string comparison so that only bitwise-equal strings are considered equal: if strcoll claims two strings are equal, check it with strcmp, and sort according to strcmp if not identical. This fixes inconsistent behavior under glibc's hu_HU locale, and probably under some other locales as well. Also, take advantage of the now-well-defined behavior to speed up texteq, textne, bpchareq, bpcharne: they may as well just do a bitwise comparison and not bother with strcoll at all. Tom Lane 2005-12-22 22:50:00 +00:00
  • f545a05704 Update interval documenation to mention the storage system used. Bruce Momjian 2005-12-22 21:45:30 +00:00
  • 7b53b45a64 Update interval documenation to mention the storage system used. Bruce Momjian 2005-12-22 21:45:19 +00:00
  • 14e9a17f0a Add documentation example of using interval multiplication with 'days'. Bruce Momjian 2005-12-21 23:23:09 +00:00
  • 2ddac948f8 Add documentation example of using interval multiplication with 'days'. Bruce Momjian 2005-12-21 23:22:55 +00:00
  • 2469b99665 Add additional example for interval multiplication. Bruce Momjian 2005-12-21 16:02:44 +00:00
  • 3086f6e4f0 Add additional example for interval multiplication. Bruce Momjian 2005-12-21 16:02:24 +00:00
  • ba6e1b2e72 Fix word's length in pg_regexec call Teodor Sigaev 2005-12-21 13:08:14 +00:00
  • dacf7e774d Fix word's length in pg_regexec call Teodor Sigaev 2005-12-21 13:07:38 +00:00
  • 7ac8a4be89 Multibyte encodings support for ISpell dictionary Teodor Sigaev 2005-12-21 13:05:49 +00:00
  • e3b9852728 Teach planner how to rearrange join order for some classes of OUTER JOIN. Per my recent proposal. I ended up basing the implementation on the existing mechanism for enforcing valid join orders of IN joins --- the rules for valid outer-join orders are somewhat similar. Tom Lane 2005-12-20 02:30:36 +00:00
  • 1a6aaaa6c4 Fix broken markup. Tom Lane 2005-12-20 00:51:45 +00:00
  • b16566d771 Add new psql command \password for changing role password with client-side password encryption. Also alter createuser command to the same effect. Peter Eisentraut 2005-12-18 02:17:16 +00:00
  • ea771743c8 Fix typo. Bruce Momjian 2005-12-17 21:08:24 +00:00
  • 8d26730a9a Update s_lock.c comments. Bruce Momjian 2005-12-17 20:39:16 +00:00
  • 70cab220c8 Update ASM comments. Bruce Momjian 2005-12-17 20:15:43 +00:00
  • 25af534ea1 Remove item: Bruce Momjian 2005-12-17 19:03:24 +00:00
  • 3282b6338b Update: Bruce Momjian 2005-12-17 18:07:01 +00:00
  • 16843ba33c Add mention of possible patent problems with star joins, per Joshua Drake: Bruce Momjian 2005-12-17 17:04:41 +00:00
  • 9e9a844f55 Add: Bruce Momjian 2005-12-17 16:43:11 +00:00
  • 927f57687f Add more function to TODO: Bruce Momjian 2005-12-17 14:18:33 +00:00
  • eae75beb71 Update: Bruce Momjian 2005-12-17 04:10:47 +00:00
  • 91e9e74f90 Update FAQ, second version. Bruce Momjian 2005-12-17 03:21:00 +00:00
  • 2475a5d8c1 Update Japanese FAQ. Bruce Momjian 2005-12-17 03:20:12 +00:00
  • 56ea9ad11f Add: Bruce Momjian 2005-12-17 01:48:37 +00:00
  • 228b1f8e01 Add URL for Solaris qsort() bug. Bruce Momjian 2005-12-17 00:35:50 +00:00
  • 87a02848b5 Update doc mention that Solaris qsort() might be fixed. Bruce Momjian 2005-12-17 00:33:33 +00:00
  • 42a24b64ba Add a note to Win32 gettimeofday() emulation, per Qingqing Zhou. Alvaro Herrera 2005-12-16 21:55:27 +00:00
  • cb77a9ea53 Force update. Bruce Momjian 2005-12-16 18:56:55 +00:00
  • 1c7347f897 Fix some typos in the TODO list. Neil Conway 2005-12-16 18:44:07 +00:00
  • fb3dbdf986 Rethink prior patch to filter out dead backend entries from the pgstats file. The original code probed the PGPROC array separately for each PID, which was not good for large numbers of backends: not only is the runtime O(N^2) but most of it is spent holding ProcArrayLock. Instead, take the lock just once and copy the active PIDs into an array, then use qsort and bsearch so that the lookup time is more like O(N log N). Tom Lane 2005-12-16 04:03:40 +00:00
  • 660fcf0f67 Back-patch 7.4 change to show that freebsd 5 and up don't need float8-small-is-zero. Per Mark Kirkwood. Tom Lane 2005-12-15 05:43:35 +00:00
  • b1ea82fee1 Defend against crash while processing Describe Statement or Describe Portal messages, when client attempts to execute these outside a transaction (start one) or in a failed transaction (reject message, except for COMMIT/ROLLBACK statements which we can handle). Per report from Francisco Figueiredo Jr. Tom Lane 2005-12-14 17:07:00 +00:00
  • 1200fc58a7 Defend against crash while processing Describe Statement or Describe Portal messages, when client attempts to execute these outside a transaction (start one) or in a failed transaction (reject message, except for COMMIT/ROLLBACK statements which we can handle). Per report from Francisco Figueiredo Jr. Tom Lane 2005-12-14 17:06:51 +00:00
  • ba7fd49de5 Defend against crash while processing Describe Statement or Describe Portal messages, when client attempts to execute these outside a transaction (start one) or in a failed transaction (reject message, except for COMMIT/ROLLBACK statements which we can handle). Per report from Francisco Figueiredo Jr. Tom Lane 2005-12-14 17:06:37 +00:00
  • 4ce6be4f5e Defend against crash while processing Describe Statement or Describe Portal messages, when client attempts to execute these outside a transaction (start one) or in a failed transaction (reject message, except for COMMIT/ROLLBACK statements which we can handle). Per report from Francisco Figueiredo Jr. Tom Lane 2005-12-14 17:06:28 +00:00
  • ec8c876bde Fix a *different* problem with whole-row Vars afflicting 8.0 branch. This is a back-port of a fix made to markTargetListOrigin() on 2005-04-25. Tom Lane 2005-12-14 16:30:20 +00:00
  • 599e225c11 Fix problem with whole-row Vars referencing sub-select outputs, per example from Jim Dew. Add some simple regression tests, since this is an area we seem to break regularly :-( Tom Lane 2005-12-14 16:28:49 +00:00
  • 426292663a Fix problem with whole-row Vars referencing sub-select outputs, per example from Jim Dew. Add some simple regression tests, since this is an area we seem to break regularly :-( Tom Lane 2005-12-14 16:28:32 +00:00
  • 93bcee8d4e Remove unused HAVE_STRUCT_SOCKCRED code, which was causing a duplicate- variable-definition error on recent FreeBSDen (evidently, that platform also HAS_STRUCT_CMSGCRED). Backport of 7.4 fix dated 2003-10-25. Tom Lane 2005-12-13 03:36:14 +00:00
  • f82e2baef6 Use a proper enum for tri-valued variables. Bruce Momjian 2005-12-12 15:48:04 +00:00
  • 59b89e9cc7 Document tri-valued variables in createdb, +1, -1, 0. Bruce Momjian 2005-12-12 15:41:52 +00:00
  • baf4e187ef Update wording, query -> statement: Bruce Momjian 2005-12-12 13:36:36 +00:00
  • cb4ea994c6 Improve support of multibyte encoding: - tsvector_(in|out) - tsquery_(in|out) - to_tsvector - to_tsquery, plainto_tsquery - 'simple' dictionary Teodor Sigaev 2005-12-12 11:10:12 +00:00
  • ec0baf949e Divide the lock manager's shared state into 'partitions', so as to reduce contention for the former single LockMgrLock. Per my recent proposal. I set it up for 16 partitions, but on a pgbench test this gives only a marginal further improvement over 4 partitions --- we need to test more scenarios to choose the number of partitions. Tom Lane 2005-12-11 21:02:18 +00:00
  • be8100d64e Implement IS NOT DISTINCT FROM, update the regression tests and docs. Patch from Pavel Stehule, minor fixups by myself. Neil Conway 2005-12-11 10:54:28 +00:00
  • c10593149a Remove item: Bruce Momjian 2005-12-11 02:16:25 +00:00
  • f23e9f7a54 Teach deparsing of CASE expressions to cope with the simplified forms that simplify_boolean_equality() may leave behind. This is only relevant if the user writes something a bit silly, like CASE x=y WHEN TRUE THEN. Per example from Michael Fuhr; may or may not explain bug #2106. Tom Lane 2005-12-10 19:21:17 +00:00
  • 2617551431 Teach deparsing of CASE expressions to cope with the simplified forms that simplify_boolean_equality() may leave behind. This is only relevant if the user writes something a bit silly, like CASE x=y WHEN TRUE THEN. Per example from Michael Fuhr; may or may not explain bug #2106. Tom Lane 2005-12-10 19:21:03 +00:00