Commit Graph

  • 1f7cb07905 BSD/OS has new precision, and negative zeros now. Bruce Momjian 2001-05-10 23:46:25 +00:00
  • 507a3444df Update TODO list. Bruce Momjian 2001-05-10 23:35:50 +00:00
  • 07dfc6970a Up version to force initdb to fix regression problems. Bruce Momjian 2001-05-10 22:39:24 +00:00
  • 8a4a8027eb Update TODO list. Bruce Momjian 2001-05-10 22:36:52 +00:00
  • 642107d5ba Avoid unnecessary lseek() calls by cleanups in md.c. mdfd_lstbcnt was not being consulted anywhere, so remove it and remove the _mdnblocks() calls that were used to set it. Change smgrextend interface to pass in the target block number (ie, current file length) --- the caller always knows this already, having already done smgrnblocks(), so it's silly to do it over again inside mdextend. Net result: extension of a file now takes one lseek(SEEK_END) and a write(), not three lseeks and a write. Tom Lane 2001-05-10 20:38:49 +00:00
  • a26ad8a643 Update TODO list. Bruce Momjian 2001-05-10 20:28:48 +00:00
  • d228278c6e Update TODO list. Bruce Momjian 2001-05-10 20:26:45 +00:00
  • a871e36944 Update TODO list. Bruce Momjian 2001-05-10 17:29:55 +00:00
  • 1c6db74d80 Update TODO list. Bruce Momjian 2001-05-10 17:20:10 +00:00
  • ffd0599c7a Add mention in README of Oracle. Bruce Momjian 2001-05-10 15:52:27 +00:00
  • 0d2c4d5a17 Add oracle conversion utility ora2pg in /contrib/oracle. Bruce Momjian 2001-05-10 15:51:05 +00:00
  • c2a062b7fe Add dbase conversion utility to /contrib. Bruce Momjian 2001-05-10 14:41:23 +00:00
  • 72c8af51fd Move disabled message up to a higher makefile. Bruce Momjian 2001-05-10 03:00:11 +00:00
  • 3bcf19dc84 Another add. Bruce Momjian 2001-05-09 23:17:23 +00:00
  • fa8b0077ef Add new emails. Bruce Momjian 2001-05-09 23:15:55 +00:00
  • c23bc6fbb0 First cut at making indexscan cost estimates depend on correlation between index order and table order. Tom Lane 2001-05-09 23:13:37 +00:00
  • e02033572d Update TODO list. Bruce Momjian 2001-05-09 23:11:54 +00:00
  • 8ace5114dc This directory contains a module that implements the "Metaphone" code as a PostgreSQL user-defined function. The Metaphone system is a method of matching similar sounding names (or any words) to the same code. Bruce Momjian 2001-05-09 23:00:44 +00:00
  • 2c6373fafa Add --echo option to createlang and droplang. from Oliver Elphick Peter Eisentraut 2001-05-09 22:08:19 +00:00
  • 91e3b85529 Wow, I am getting good at this Makefile stuff. Peter may be OK with it. Bruce Momjian 2001-05-09 21:42:29 +00:00
  • a1a12b8a0c I think I got the pltcl Makefile unknown rules working properly. Bruce Momjian 2001-05-09 21:35:11 +00:00
  • bea7a88576 I have modifed heap.c so that it won't automatically generate duplicate constraint names. Bruce Momjian 2001-05-09 21:13:35 +00:00
  • 999a4d48d3 that's just me again, here's normal patch for KOI8_U to jdbc/Connection.java Bruce Momjian 2001-05-09 21:11:26 +00:00
  • 8678929c22 This patch should catch cases where the types in referencing and referenced columns of an fk constraint aren't comparable using '=' at constraint definition time rather than insert/update time. Bruce Momjian 2001-05-09 21:10:39 +00:00
  • a0458a91bf Update TODO list. Bruce Momjian 2001-05-09 20:40:30 +00:00
  • 0007be5da7 More cleanups to generate tcl unknown from Makefile. Bruce Momjian 2001-05-09 20:30:09 +00:00
  • 6c6ca047ed autoconf Bruce Momjian 2001-05-09 20:20:09 +00:00
  • 36f41c7126 Make tcl unknown configure from Makefile, not configure. Bruce Momjian 2001-05-09 20:19:30 +00:00
  • 14536f591d More --enable-pltcl-unknown renames. Bruce Momjian 2001-05-09 20:08:08 +00:00
  • 27f17e1485 Change to enable_pltcl_unknown mention. Bruce Momjian 2001-05-09 19:57:33 +00:00
  • ec9cc733ca Add TODO file. Bruce Momjian 2001-05-09 19:55:22 +00:00
  • 0bef7ba549 Add plpython code. Bruce Momjian 2001-05-09 19:54:38 +00:00
  • 6319f5da37 autoconf Bruce Momjian 2001-05-09 19:42:26 +00:00
  • acd16eadf5 Change --with-pltcl-unknown to --enable-pltcl-unknown Bruce Momjian 2001-05-09 19:41:57 +00:00
  • f598201348 Noticed a small bug in the code. Probably been there for some time. Note that the original code would consider things like UNIX domain sockets are regular files. Bruce Momjian 2001-05-09 19:28:31 +00:00
  • fae69dd183 autoconf Bruce Momjian 2001-05-09 19:21:14 +00:00
  • f7659a9c18 This patch adds a new configure option --with-pltcl-unknown which enables pltcl unknown support. Bruce Momjian 2001-05-09 19:19:00 +00:00
  • d8eade3784 Right-align \du user-id. Bruce Momjian 2001-05-09 17:57:42 +00:00
  • 68319f9103 Fix memory leak in new psql \du code. Bruce Momjian 2001-05-09 17:49:42 +00:00
  • b0546a2554 Fix libpq++'s FieldSize to return int, not short. Bruce Momjian 2001-05-09 17:46:11 +00:00
  • 9668b948f7 Add mention of getLength returning short. Bruce Momjian 2001-05-09 17:37:17 +00:00
  • a79b698adb Here's a version of my suggested diffs transplanted to 7.1 beta 5. I'm still looking at the best way to integrate Tom Vijlbrief's fixes (insofar as they're still needed); would 7.2 be a suitable time for incompatible API changes? Bruce Momjian 2001-05-09 17:29:10 +00:00
  • c8db55f78a Use ColId instead of Ident for SET SESSION AUTHORIZATION. Peter Eisentraut 2001-05-09 16:50:44 +00:00
  • c33b72e1e8 Fix remaining RI permission problems (cascaded update/delete, restrict, set null/default). Peter Eisentraut 2001-05-09 16:28:31 +00:00
  • 766a44f77f Mention new jdbc mailing list instead of interfaces list. Bruce Momjian 2001-05-09 15:51:37 +00:00
  • 1ef9338ab6 If it's true that the ALTER TABLE x ADD CONSTRAINT x CHECK (x) syntax is supported in 7.1.1, here is a patch to that alter_table.sgml that documents it. Bruce Momjian 2001-05-09 13:27:15 +00:00
  • 6cda3ad8fe Cause planner to make use of average-column-width statistic that is now collected by ANALYZE. Also, add some modest amount of intelligence to guesses that are used for varlena columns in the absence of any ANALYZE statistics. The 'width' reported by EXPLAIN is finally something less than totally bogus for varlena columns ... and, in consequence, hashjoin estimating should be a little better ... Tom Lane 2001-05-09 00:35:09 +00:00
  • b66a0cca57 Update runtime shared memory computations. Bruce Momjian 2001-05-08 21:09:47 +00:00
  • 1c1c58c76c Add SET SESSION AUTHORIZATION command. Peter Eisentraut 2001-05-08 21:06:43 +00:00
  • c50aa9db70 Mention SHELL usage in initdb. Bruce Momjian 2001-05-08 20:38:00 +00:00
  • 931e309402 Append and SubqueryScan nodes were not passing changed-parameter signals down to their children, leading to misbehavior if they had any children that paid attention to chgParam (most plan node types don't). Append's bug has been there a long time, but nobody had noticed because it used to be difficult to create a query where an Append would be used below the top level of a plan; so there were never any parameters getting passed down. SubqueryScan is new in 7.1 ... and I'd modeled its behavior on Append :-( Tom Lane 2001-05-08 19:48:02 +00:00
  • 5708a56729 Append and SubqueryScan nodes were not passing changed-parameter signals down to their children, leading to misbehavior if they had any children that paid attention to chgParam (most plan node types don't). Append's bug has been there a long time, but nobody had noticed because it used to be difficult to create a query where an Append would be used below the top level of a plan; so there were never any parameters getting passed down. SubqueryScan is new in 7.1 ... and I'd modeled its behavior on Append :-( Tom Lane 2001-05-08 19:47:02 +00:00
  • c3fa600d8c Need to factor out strdup.o for separate treatment since it's in a different directory. This makes dependency tracking work and copes with compilers that don't suport -c and -o together. Peter Eisentraut 2001-05-08 19:38:57 +00:00
  • 530dc73cd1 Remove pgadmin.sgml file. Bruce Momjian 2001-05-08 19:28:01 +00:00
  • 3044bc4043 Add new emails to file. Bruce Momjian 2001-05-08 19:21:46 +00:00
  • a5b17eb280 Remove LISP manual reference. Added to web "interfaces" page. Bruce Momjian 2001-05-08 19:14:52 +00:00
  • aea4f6f993 Update TODO list. Bruce Momjian 2001-05-08 19:01:55 +00:00
  • 82c9ce2c40 Small cleanup. Bruce Momjian 2001-05-08 19:00:26 +00:00
  • 04e14fa350 drop_function.sgml: =================== In Notes: Refer to CREATE FUNCTION for information on creating aggregate functions. ^^^^^^^^^^^^^^^^^^^ I assume it must read C function instead. Bruce Momjian 2001-05-08 17:51:30 +00:00
  • cd11d33a36 drop_function.sgml: =================== In Notes: Refer to CREATE FUNCTION for information on creating aggregate functions. ^^^^^^^^^^^^^^^^^^^ I assume it must read C function instead. Bruce Momjian 2001-05-08 17:35:57 +00:00
  • 857abb0e57 Add newlines around debug output in optimizer showing total costs. Bruce Momjian 2001-05-08 17:25:28 +00:00
  • 1c551683cb Run pgindent on ODBC code only, to reformat new comments. Bruce Momjian 2001-05-08 17:12:36 +00:00
  • 296e7ba2ba ODBC source code cleanup patch. Should match rest of PostgreSQL code better. Bruce Momjian 2001-05-08 17:06:18 +00:00
  • 062a79a990 Allow SHELL in Makefile.* to control initdb. Bruce Momjian 2001-05-08 16:28:46 +00:00
  • 70c1045719 Update readme about user registration. Bruce Momjian 2001-05-08 15:52:02 +00:00
  • 0b68b89b02 Fix paren typo in java. Bruce Momjian 2001-05-08 15:29:14 +00:00
  • 46c93bd532 Further cleanup of RAISE discussion; in particular, remove example that doesn't actually work. Tom Lane 2001-05-08 02:53:24 +00:00
  • 24baa1d95f Fix raise mention that %% output as %. Bruce Momjian 2001-05-08 02:26:09 +00:00
  • 8c2fca17d8 Un-break exec_move_row() for case that a NULL tuple and tupdesc are passed, which occurs when no rows are retrieved by a SELECT. Mea maxima culpa ... I should have caught this. Tom Lane 2001-05-08 01:02:03 +00:00
  • eb62f076d0 Un-break exec_move_row() for case that a NULL tuple and tupdesc are passed, which occurs when no rows are retrieved by a SELECT. Mea maxima culpa ... I should have caught this. Tom Lane 2001-05-08 01:00:53 +00:00
  • f4832defa9 Update RAISE manual concerning % format symbols. Bruce Momjian 2001-05-08 00:30:41 +00:00
  • a9ac332a4e Update TODO list. Bruce Momjian 2001-05-08 00:19:19 +00:00
  • c1983858c0 Update TODO list. Bruce Momjian 2001-05-08 00:14:15 +00:00
  • e86c31c74f Update RAISE mention in manual to take string/variable not format/identifier. Bruce Momjian 2001-05-08 00:09:22 +00:00
  • ef06003b06 Fix comment in file about 2*max_connections. Bruce Momjian 2001-05-07 23:32:55 +00:00
  • f7bfb5518d Shared library and GCC support for SCO OpenServer. Peter Eisentraut 2001-05-07 20:43:28 +00:00
  • 5fdae774a1 Add mention of functional indexes for case-insensitive comparisons. Bruce Momjian 2001-05-07 19:58:31 +00:00
  • 465cf168eb Fix remaining RI permission problems (cascaded update/delete, restrict, set null/default). Peter Eisentraut 2001-05-07 19:57:24 +00:00
  • 232724af0d Add \cd command to psql. Peter Eisentraut 2001-05-07 19:31:33 +00:00
  • ab420e2114 Update TODO list. Bruce Momjian 2001-05-07 18:40:59 +00:00
  • 415263b2d2 > Occasionally and without warning I get this from my daily vacuum > cronjob: > NOTICE: RegisterSharedInvalid: SI buffer overflow > NOTICE: InvalidateSharedInvalid: cache state reset > I don't understand what these mean. Should I be concerned about them > and what do they signify? Bruce Momjian 2001-05-07 17:20:19 +00:00
  • ef71c8fccf Update TODO list. Bruce Momjian 2001-05-07 17:05:17 +00:00
  • 84fd16516c Update FAQ to use new pgsql-cygwin@postgresql.org list. Bruce Momjian 2001-05-07 16:02:38 +00:00
  • f83f740a13 Solaris startup cleanup from Justin Clift Bruce Momjian 2001-05-07 15:55:27 +00:00
  • f905d65ee3 Rewrite of planner statistics-gathering code. ANALYZE is now available as a separate statement (though it can still be invoked as part of VACUUM, too). pg_statistic redesigned to be more flexible about what statistics are stored. ANALYZE now collects a list of several of the most common values, not just one, plus a histogram (not just the min and max values). Random sampling is used to make the process reasonably fast even on very large tables. The number of values and histogram bins collected is now user-settable via an ALTER TABLE command. Tom Lane 2001-05-07 00:43:27 +00:00
  • 7d7ab8a29b Fix collateral damage from previous (rev 1.49) patch. Peter Eisentraut 2001-05-06 21:44:32 +00:00
  • 9583aea9d0 Fix collateral damage from previous (rev 1.49) patch. Peter Eisentraut 2001-05-06 21:15:51 +00:00
  • 7038554c4e Allow 'psql -f -' to read from standard input. Peter Eisentraut 2001-05-06 17:38:32 +00:00
  • 84e8e5b427 Make prompt customization work with changeable Unix socket location. Peter Eisentraut 2001-05-06 17:21:11 +00:00
  • 36161b3086 not sure about this one ... but should have changelog in both versions ... Marc G. Fournier 2001-05-05 20:24:56 +00:00
  • ed65860638 add in the changelog file I forgot about REL7_1_1 Marc G. Fournier 2001-05-05 20:23:57 +00:00
  • 1564bd11e3 UPdate for release tomorrow. Bruce Momjian 2001-05-05 02:57:40 +00:00
  • e669b8d751 COMMIT_DELAY and COMMIT_SIBLINGS were missing from the list of WAL configuration parameters in chapter 3. Tom Lane 2001-05-04 23:11:37 +00:00
  • 8d2fe903b0 Update TODO list. Bruce Momjian 2001-05-04 22:08:53 +00:00
  • 28ac24e4dd Makefile should have automatic dependency for parser.o too, if it's going to have any at all. Tom Lane 2001-05-04 22:01:03 +00:00
  • 9278262181 Update TODO list. Bruce Momjian 2001-05-04 20:48:14 +00:00
  • e2e19ca0cd Seems like we should not hold off cancel/die interrupts while we are running deferred triggers. They are really part of the regular transaction, and they could take awhile. Tom Lane 2001-05-04 18:39:16 +00:00
  • 602b742507 Add missing tag. Bruce Momjian 2001-05-04 02:54:33 +00:00
  • f5ba72ea04 Consolidate several near-identical uses of mktime() into a single routine DetermineLocalTimeZone(). In that routine, be more wary of broken mktime() implementations than the original code was: don't allow mktime to change the already-set y/m/d/h/m/s information, and don't use tm_gmtoff if mktime failed. Possibly this will resolve some of the complaints we've been hearing from users of Middle Eastern timezones on RedHat. Tom Lane 2001-05-03 22:53:07 +00:00
  • 0cec2bb0cd BTW it does not add encodign it just patches existing one (KOI8) to support two - KOI8-R and KOI8-U (latter is superset of the former if not to take to the account pseudographics) Bruce Momjian 2001-05-03 21:38:45 +00:00