Commit Graph

  • 39b547f430 Prevent freshly-started backend from ignoring SIGUSR1, per race condition observed by Inoue. Also, don't call ProcRemove() from postmaster if we have detected a backend crash --- too risky if shared memory is corrupted. It's not needed anyway, considering we are going to reinitialize shared memory and semaphores as soon as the last child is dead. Tom Lane 2000-12-20 21:51:52 +00:00
  • e4d97cb70e Update info for BeOS and MacOS-X-darwin as supported platforms. Thomas G. Lockhart 2000-12-20 17:23:39 +00:00
  • 54f2b601ef rserv replication toolkit from Vadim Mikheev. Thomas G. Lockhart 2000-12-20 17:22:35 +00:00
  • 96edf0c185 Add rserv replication toolkit from Vadim Mikheev. Thomas G. Lockhart 2000-12-20 17:22:26 +00:00
  • d8231344f7 Utility to convert MySQL schema dumps to SQL92 and PostgreSQL conventions. Thomas G. Lockhart 2000-12-20 17:20:24 +00:00
  • 751959436c Finished build.xml and updated Driver.java.in and buildDriver to match how Makefile and ANT operate. Peter Mount 2000-12-20 16:22:49 +00:00
  • 1d46fb8035 Fix typo. Bruce Momjian 2000-12-20 15:44:00 +00:00
  • c6fc6cfa08 On Sunday 17 December 2000 15:07, Bruce Momjian wrote: > We need additions to alter_table.sgml for the new OWNER option mention > in the features list. Bruce Momjian 2000-12-20 03:19:24 +00:00
  • 827414276c Add mention of Alpha Bruce Momjian 2000-12-20 03:02:52 +00:00
  • e19f386116 Holloman -> Hollomon. Sorry. Bruce Momjian 2000-12-20 02:15:20 +00:00
  • 89996974a7 Add description about automatic encoding conversion between Unicode and other encodings. Tatsuo Ishii 2000-12-20 00:44:49 +00:00
  • 28e9e9a24e Rename --accounts-only to --globals-only, polish documentation. Peter Eisentraut 2000-12-19 22:12:47 +00:00
  • f824d4a363 Polish PL/Perl documentation. The README file got shrunk to being a pointer into the real documentation. Peter Eisentraut 2000-12-19 18:16:26 +00:00
  • 109cdbb4f7 Remove inclusions of <malloc.h>. Peter Eisentraut 2000-12-19 17:52:27 +00:00
  • f9698a938f Correct results of usage examples. Peter Eisentraut 2000-12-19 17:35:46 +00:00
  • 42d26fb9f7 Finally created ant build.xml file Peter Mount 2000-12-19 17:33:39 +00:00
  • e34d442dbb Mention fallback case for type coercion in description of function resolution procedure. Tom Lane 2000-12-19 00:54:59 +00:00
  • e4eb91048c Document the array_dims() function, and make some other small improvements in the docs for arrays. Tom Lane 2000-12-18 23:39:37 +00:00
  • 1f159e562b >> Here is a patch for the beos port (All regression tests are OK). >> xlog.c : special case for beos to avoid 'link' which does not work yet >> beos/sem.c : implementation of new sem_ctl call (GETPID) and a new >sem_op >> flag (IPCNOWAIT) >> dynloader/beos.c : add a verification of symbol validity (seem that the >> loader sometime return OK with an invalid symbol) >> postmaster.c : add beos forking support for the new checkpoint process >> postgres.c : remove beos special case for getrusage >> beos.h : Correction of a bas definition of AF_UNIX, misc defnitions >> >> >> thanks >> >> >> cyril Bruce Momjian 2000-12-18 18:45:05 +00:00
  • 5491233f52 Ensure that 'errno' is saved and restored by all signal handlers that might change it. Experimentation shows that the signal handler call mechanism does not save/restore errno for you, at least not on Linux or HPUX, so this is definitely a real risk. Tom Lane 2000-12-18 17:33:42 +00:00
  • c431db9714 Updates for 7.1 branding. Bruce Momjian 2000-12-18 16:30:07 +00:00
  • 77145ac824 - Synced gram.y and preproc.y. - Synced keyword.c. - Added several small patches from Christof. Michael Meskes 2000-12-18 11:33:55 +00:00
  • 97cfb9d606 Make sure make_rels_by_clause_joins doesn't return multiple references to same joinrel. Although make_rels_by_joins doesn't mind, GEQO has an Assert that doesn't like this. Tom Lane 2000-12-18 06:50:51 +00:00
  • cf35a70495 Large objects in single "table". Bruce Momjian 2000-12-18 04:32:09 +00:00
  • 708c1114ea Updates from Tom Lane. Bruce Momjian 2000-12-18 04:20:44 +00:00
  • cf6dbd8e47 Fix upgrade mention to 7.1. Bruce Momjian 2000-12-18 04:07:10 +00:00
  • c77e2e42fb Tweak regressplans.sh to use any already-set PGOPTIONS. Tom Lane 2000-12-18 02:45:47 +00:00
  • 42d5e34e77 Repair mishandling of PRIMARY KEY declaration that references an inherited column, per bug report from Elphick 12/15/00. Tom Lane 2000-12-18 01:37:56 +00:00
  • a626b78c89 Clean up backend-exit-time cleanup behavior. Use on_shmem_exit callbacks to ensure that we have released buffer refcounts and so forth, rather than putting ad-hoc operations before (some of the calls to) proc_exit. Add commentary to discourage future hackers from repeating that mistake. Tom Lane 2000-12-18 00:44:50 +00:00
  • 8c8ed4f456 Add missing tags. Peter Eisentraut 2000-12-17 17:50:46 +00:00
  • ec6a367e90 Bump version to 7.1. (No "beta1", since we're just going to forget to change it again anyway.) Peter Eisentraut 2000-12-17 11:25:58 +00:00
  • a4e29286b3 Update SysV IPC information. Peter Eisentraut 2000-12-17 11:22:00 +00:00
  • 7b9fe96812 Update type-coercion discussions to reflect current reality. Tom Lane 2000-12-17 05:55:26 +00:00
  • c501e9aabe Misc. cleanups. Tom Lane 2000-12-17 05:50:23 +00:00
  • 96ff0cb0c4 Outer join updates, miscellaneous polishing. Tom Lane 2000-12-17 05:47:57 +00:00
  • cfa4d4d040 Tweak select_common_type() to deal with possibility of multiple preferred types in a category --- it was taking the last preferred type among the inputs, rather than the first one as intended. Tom Lane 2000-12-17 04:32:29 +00:00
  • 0c2629efaa Update some obsolete info about GEQO. Tom Lane 2000-12-16 22:44:47 +00:00
  • a238cb5a8a Add 7.1 features list Bruce Momjian 2000-12-16 20:12:42 +00:00
  • 6a0f486a25 A little wordsmithing in the pattern-matching section. Tom Lane 2000-12-16 19:33:23 +00:00
  • d316f22267 Add note that COALESCE and NULLIF are shorthand forms of CASE. Tom Lane 2000-12-16 18:33:13 +00:00
  • cf00d59335 Clean up some bogosities in description of target lists. Tom Lane 2000-12-16 18:22:53 +00:00
  • 9cf0a82fc3 Fix linker options for ODBC driver. See comment in src/interfaces/odbc/GNUmakefile. Peter Eisentraut 2000-12-16 18:14:25 +00:00
  • 2a81896a2a Fix rules to re-generate config.h. The examples in the Autoconf manual are flawed because the timestamp file is already updated when Makefile.global is remade, and the rule for config.h never gets run. Peter Eisentraut 2000-12-16 13:03:25 +00:00
  • ad4fd77a5f Restructure performance tips into a single chapter ('populating a database' was way too small to make a chapter). Add a section about using JOIN syntax to direct the planner. Tom Lane 2000-12-16 02:29:36 +00:00
  • 85934d1bdb Remove current->old mapping. Bruce Momjian 2000-12-15 23:36:20 +00:00
  • 4df6dc4801 Update TODO list. Bruce Momjian 2000-12-15 22:45:09 +00:00
  • 12691d92dc Update TODO list. Bruce Momjian 2000-12-15 22:40:34 +00:00
  • 3699791fa8 Update TODO list. Bruce Momjian 2000-12-15 22:03:40 +00:00
  • e2331b7ff7 Update TODO list. Bruce Momjian 2000-12-15 21:46:54 +00:00
  • 1940230392 Update TODO list. Bruce Momjian 2000-12-15 21:46:41 +00:00
  • 23bd779176 Change ET_WARN to ET_NOTICE to match internal codes, leave message as WARNING. Fix German FAQ mention about warning. Bruce Momjian 2000-12-15 20:01:55 +00:00
  • 7d6af50f43 Make algorithm for resolving UNKNOWN function/operator inputs be insensitive to the order of arguments. Per pghackers discussion 12/10/00. Tom Lane 2000-12-15 19:22:03 +00:00
  • ff783fbae0 here is a patch fixing today's bug report: Bruce Momjian 2000-12-15 19:15:09 +00:00
  • 0cf37659c4 there is one problem with Zoltan patches commited into the tree: if we set autocommit off and issued COMMIT (or ROLLBACK) on a connection new transaction is not started Bruce Momjian 2000-12-15 19:11:28 +00:00
  • 326fbd8837 List .o file explicitly as dependency, to work around a gmake bug (intermediate .o file gets deleted and rebuild on next make invocation). Peter Eisentraut 2000-12-15 18:50:35 +00:00
  • b260c18cbc Remove obsolete comment. Tom Lane 2000-12-15 18:02:47 +00:00
  • 207f6ed3f1 Print the error message before attempting to reset the connection after a backend crash. Peter Eisentraut 2000-12-15 17:54:43 +00:00
  • 352cd1f1c5 Remove a few remaining vestiges of elog(WARN). Tom Lane 2000-12-15 04:08:15 +00:00
  • 4ea746a84f Bugfix Jan Wieck 2000-12-14 23:51:35 +00:00
  • c3641483c3 Merge functions and operators chapters. Lots of updates. Peter Eisentraut 2000-12-14 22:30:56 +00:00
  • ea166f1146 Planner speedup hacking. Avoid saving useless pathkeys, so that path comparison does not consider paths different when they differ only in uninteresting aspects of sort order. (We had a special case of this consideration for indexscans already, but generalize it to apply to ordered join paths too.) Be stricter about what is a canonical pathkey to allow faster pathkey comparison. Cache canonical pathkeys and dispersion stats for left and right sides of a RestrictInfo's clause, to avoid repeated computation. Total speedup will depend on number of tables in a query, but I see about 4x speedup of planning phase for a sample seven-table query. Tom Lane 2000-12-14 22:30:45 +00:00
  • db11f4382a Make sure to not handle deactivated system indexes Hiroshi Inoue 2000-12-14 07:02:42 +00:00
  • 468a970409 Change StoreCatalogInheritance() to work from a list of parent relation OIDs rather than names. Aside from being simpler and faster, this way doesn't blow up in the face of 'create temp table foo () inherits (foo)'. Which is a rather odd thing to do, but it seems some people want to. Tom Lane 2000-12-14 00:41:09 +00:00
  • 780992316f Fix thinko for case of outer join where inner table is empty: should output first outer tuple before advancing... Tom Lane 2000-12-13 23:45:46 +00:00
  • 47e229760a Update TODO list. Bruce Momjian 2000-12-13 04:02:15 +00:00
  • 8b4c54ef3e Update TODO list. Bruce Momjian 2000-12-13 04:01:27 +00:00
  • 17b843d677 Cache eval cost of qualification expressions in RestrictInfo nodes to avoid repeated evaluations in cost_qual_eval(). This turns out to save a useful fraction of planning time. No change to external representation of RestrictInfo --- although that node type doesn't appear in stored rules anyway. Tom Lane 2000-12-12 23:33:34 +00:00
  • 77c443f8cd Update TODO list. Bruce Momjian 2000-12-12 20:28:00 +00:00
  • 36da236eb3 In 'Joins between classes' in Section 5 of the tutorial we have, in the first paragraph: Bruce Momjian 2000-12-12 16:47:52 +00:00
  • 1045304a3b Revise SELECT reference page for outer joins, subselect in FROM, ISO-compliant UNION/INTERSECT/EXCEPT. Revise discussion of rule rewriter to reflect new subselect-in-FROM implementation of views. Miscellaneous other cleanups. Tom Lane 2000-12-12 05:07:59 +00:00
  • c4e3b0c3aa Links to CUBE, SEG contrib items Tom Lane 2000-12-11 20:40:59 +00:00
  • a3694b420f Gene Selkov's SEG datatype (GiST example code) Tom Lane 2000-12-11 20:40:33 +00:00
  • 9892ddf5ee Gene Selkov's CUBE datatype (GiST example code) Tom Lane 2000-12-11 20:39:15 +00:00
  • 5bb4f723d2 Remove elog for online log files. Vadim B. Mikheev 2000-12-11 19:27:42 +00:00
  • f01f08b8b5 Make all ODBCVER = 2.50 Bruce Momjian 2000-12-11 19:06:11 +00:00
  • b9110b97d9 Allow resultmap file to be missing, for use in contrib self-tests. Tom Lane 2000-12-11 19:00:33 +00:00
  • 01b5efa5e3 Fix ODBC compile, prevent ODBCVER warning, though the version numbers go not match. Bruce Momjian 2000-12-11 18:51:26 +00:00
  • 0cbfde72fe Change to Negator. Bruce Momjian 2000-12-11 18:26:37 +00:00
  • dae369d390 elog(LOG)-->elog(DEBUG) for skipped logs. Vadim B. Mikheev 2000-12-11 18:02:25 +00:00
  • 70c5fdd2f6 Add Darwin-specific geometry test file. Tom Lane 2000-12-11 16:45:16 +00:00
  • 2cf8064af8 Tweak Darwin patch to get right include order. Tom Lane 2000-12-11 16:35:59 +00:00
  • 6ef0219c34 Resolve complie error(was my fault). Hiroshi Inoue 2000-12-11 09:14:03 +00:00
  • a8824ff257 *redo: Heap move* neglects to set t_cmin for MOVED_IN tuples. Hiroshi Inoue 2000-12-11 05:25:23 +00:00
  • d81fd94d40 Fix ILIKE bug (only in multi-byte case) Tatsuo Ishii 2000-12-11 05:00:18 +00:00
  • e8caadefc4 Update TODO list. Bruce Momjian 2000-12-11 01:44:37 +00:00
  • 41fe2a2a03 Darwin porting patches from Peter Bierman <bierman@apple.com> Tom Lane 2000-12-11 00:49:54 +00:00
  • 839de3c577 Here is patch to the ODBC driver to update the version to 2.5 and allow all forms of foreign keys be exposed to SQLForeignKeys. This patch is in addition to the ones I mailed yesterday (forget had I changed that as well....) Bruce Momjian 2000-12-10 23:54:28 +00:00
  • f8abefe460 Here is a diff to info.c in interfaces/odbc that updates SQLForeignKeys to return foreign key information based on the pg_trigger system table. I have tested the patch with (what I believe) is all possible primary/foreign key combinations -- however I may have missed some, so if anyone feels like taking the patch for a test drive, here are some useful links: Bruce Momjian 2000-12-10 22:59:10 +00:00
  • e19c8acce1 Backout right-hand/left-hand. Bruce Momjian 2000-12-10 22:37:27 +00:00
  • d5470aba5c in catalog.sgml line 1324: "left-hand" should be "right-hand" Bruce Momjian 2000-12-10 22:35:56 +00:00
  • 8651dc10a5 Add mention of \d+ to comment. Bruce Momjian 2000-12-10 21:56:00 +00:00
  • c9b17d0815 Correct one description, add one. Peter Eisentraut 2000-12-10 21:19:02 +00:00
  • 7c1959cbd9 Fix typo Bruce Momjian 2000-12-10 20:47:34 +00:00
  • 3f45ce9671 Update TODO list. Bruce Momjian 2000-12-09 23:25:52 +00:00
  • 10f400ccee Fixes for examples from Thomas Diffenbach Bruce Momjian 2000-12-09 22:59:25 +00:00
  • 8fdd794d97 Portability fix from Ryan Kirkpatrick's Alpha patches. I believe this is the only diff not accounted for by fmgr rewrite... Tom Lane 2000-12-09 20:40:57 +00:00
  • 228c1e74a7 Suppress compiler warnings. Tom Lane 2000-12-09 20:32:44 +00:00
  • 457f0b8919 Add fulltextindex TODO list. Bruce Momjian 2000-12-09 15:52:11 +00:00
  • 9ed7237110 Update FAQ_DEV. Bruce Momjian 2000-12-09 04:57:31 +00:00
  • a860a403a9 Fix a bug in conversion from big5 to EUC_TW (CNS 11643-1992 Plane 3) Thanks Chih-Chang Hsieh <cch@cc.kmu.edu.tw> for finding the bug. Tatsuo Ishii 2000-12-09 04:30:04 +00:00