Commit Graph

  • 8e0f8630a6 Remove example of SQL-standard syntax for GRANT/REVOKE --- was causing confusion. Bruce Momjian 2007-04-07 03:48:25 +00:00
  • 5f3fbe14f3 In docs, Symetric -> Symmetric. Bruce Momjian 2007-04-07 03:34:36 +00:00
  • 9af03980cf Done: Bruce Momjian 2007-04-07 03:08:20 +00:00
  • d6e3bb63cb Done: Bruce Momjian 2007-04-07 02:48:16 +00:00
  • b396df8485 Don't remove the 'alias' field from flattened rangetable entries; there are some corner cases where this is needed by ruleutils.c for proper display of variables during EXPLAIN. Tom Lane 2007-04-06 22:57:20 +00:00
  • f02a82b6ad Make 'col IS NULL' clauses be indexable conditions. Tom Lane 2007-04-06 22:33:43 +00:00
  • 146c83c045 Fix some now-obsolete comments about the space used by various data types. Tom Lane 2007-04-06 19:22:38 +00:00
  • e1f1a5358b Only run contrib check if there is a Makefile Andrew Dunstan 2007-04-06 13:44:39 +00:00
  • e574f2a029 Enhance pgbench -l option to add timestamp. Patch contributed by Greg Smith. Along with Japanese doc updation by Tasuo Ishii. Tatsuo Ishii 2007-04-06 09:16:16 +00:00
  • 7e96269a82 Various pgbench enhancements. Patch contributed by ITAGAKI Takahiro. Tatsuo Ishii 2007-04-06 08:49:44 +00:00
  • 37a609b27f Now that core functionality is depending on autoconf's AC_C_BIGENDIAN to be right, there seems precious little reason to have a pile of hand-maintained endianness definitions in src/include/port/*.h. Get rid of those, and make the couple of places that used them depend on WORDS_BIGENDIAN instead. Tom Lane 2007-04-06 05:36:51 +00:00
  • 3e23b68dac Support varlena fields with single-byte headers and unaligned storage. Tom Lane 2007-04-06 04:21:44 +00:00
  • d44163953c Update XML error message text for missing libxml; update regression output to match. Bruce Momjian 2007-04-05 13:53:24 +00:00
  • ab94cc92e4 Continue running contrib regression tests if one fails, and exit with errorlevel 1 is >= 1 checks failed. Magnus Hagander 2007-04-05 12:31:36 +00:00
  • 4c40130296 Make sure list of tests is cleared out before getting the new list of tests. Per Andrew Dunstan. Magnus Hagander 2007-04-05 12:10:40 +00:00
  • bd097ccdd4 Add URL for: Bruce Momjian 2007-04-05 02:08:53 +00:00
  • 43666e8216 Improve documentation/warning when --with-libxml is not used in the installation. Bruce Momjian 2007-04-05 01:46:27 +00:00
  • 618aec735c improve test headings Andrew Dunstan 2007-04-04 20:53:44 +00:00
  • 5dbd9c9c53 Re-add FAQ item 3.7 which was accidentally removed in previous commit: Bruce Momjian 2007-04-04 19:26:58 +00:00
  • e687c4c3c7 Don't install files for xml2 when building without libxml. Andrew Dunstan 2007-04-04 18:45:59 +00:00
  • 3b93fba823 Remove plpython casts C source code casts: Bruce Momjian 2007-04-04 17:28:11 +00:00
  • 8f296ebea7 Don't install files for sslinfo when building without openssl. Per Andrew Dunstan. Magnus Hagander 2007-04-04 16:34:43 +00:00
  • cd39718446 Document how to identify an invalid index after a failed CREATE INDEX CONCURRENTLY. Bruce Momjian 2007-04-03 22:38:35 +00:00
  • 9c9b619473 Remove the CheckpointStartLock in favor of having backends show whether they are in their commit critical sections via flags in the ProcArray. Checkpoint can watch the ProcArray to determine when it's safe to proceed. This is a considerably better solution to the original problem of race conditions between checkpoint and transaction commit: it speeds up commit, since there's one less lock to fool with, and it prevents the problem of checkpoint being delayed indefinitely when there's a constant flow of commits. Heikki, with some kibitzing from Tom. Tom Lane 2007-04-03 16:34:36 +00:00
  • fb4279e99c Done: Bruce Momjian 2007-04-03 15:51:36 +00:00
  • bfe8b89e41 Allow pl/pythonu >= version 2.3 to return boolean, rather than 1/0. Bruce Momjian 2007-04-03 15:50:58 +00:00
  • 749167cf2a Allow PL/PythonU to compile on Python 2.5. Change needed because of API changes in Python. Bruce Momjian 2007-04-03 13:37:22 +00:00
  • 9665dd92b8 Update comment for new thread_test location. Bruce Momjian 2007-04-03 12:55:23 +00:00
  • b3005276eb Decouple the values of TOAST_TUPLE_THRESHOLD and TOAST_MAX_CHUNK_SIZE. Add the latter to the values checked in pg_control, since it can't be changed without invalidating toast table content. This commit in itself shouldn't change any behavior, but it lays some necessary groundwork for experimentation with these toast-control numbers. Tom Lane 2007-04-03 04:14:26 +00:00
  • 4fea0ca8f3 Update: Bruce Momjian 2007-04-03 04:12:00 +00:00
  • d542bde900 Update: Bruce Momjian 2007-04-03 02:17:11 +00:00
  • 401bc9cfcb Add: Bruce Momjian 2007-04-03 01:25:12 +00:00
  • f4cc73731d Add: Bruce Momjian 2007-04-03 01:21:06 +00:00
  • aa8fb12498 Add URL for: Bruce Momjian 2007-04-03 01:16:24 +00:00
  • 133d1d4f45 Add URL for: Bruce Momjian 2007-04-02 23:25:20 +00:00
  • 5d8a23403f Add URL for: Bruce Momjian 2007-04-02 22:50:19 +00:00
  • 17285959c1 Add URL for: Bruce Momjian 2007-04-02 22:49:03 +00:00
  • 3a7d66b48a Add: Bruce Momjian 2007-04-02 22:46:10 +00:00
  • f16f89a616 Allow NOTIFY/LISTEN/UNLISTEN to only take relation names, not schema.relation, because the notify code only honors the relation name. schema.relation will now generate a syntax error. Bruce Momjian 2007-04-02 22:20:53 +00:00
  • 325feaef7f Check length of enum literals on definition and input to make sure they will fit in a name field and not cause syscache errors. Andrew Dunstan 2007-04-02 22:14:17 +00:00
  • ffb27446cc Pl/python -> Pl/PythonU: Bruce Momjian 2007-04-02 21:28:10 +00:00
  • 5c706f1c98 Add: Bruce Momjian 2007-04-02 21:25:34 +00:00
  • ecd12df117 Add: Bruce Momjian 2007-04-02 21:10:53 +00:00
  • d6bac1e8e9 Add item: Bruce Momjian 2007-04-02 20:43:40 +00:00
  • 3e8ff14506 Add URL for: Bruce Momjian 2007-04-02 20:10:16 +00:00
  • 47d61a572f Fix check_sql_fn_retval to allow the case where a SQL function declared to return void ends with a SELECT, if that SELECT has a single result that is also of type void. Without this, it's hard to write a void function that calls another void function. Per gripe from Peter. Tom Lane 2007-04-02 18:49:49 +00:00
  • 40d7f86074 Fix check_sql_fn_retval to allow the case where a SQL function declared to return void ends with a SELECT, if that SELECT has a single result that is also of type void. Without this, it's hard to write a void function that calls another void function. Per gripe from Peter. Tom Lane 2007-04-02 18:49:41 +00:00
  • 3ac7d76096 Fix check_sql_fn_retval to allow the case where a SQL function declared to return void ends with a SELECT, if that SELECT has a single result that is also of type void. Without this, it's hard to write a void function that calls another void function. Per gripe from Peter. Tom Lane 2007-04-02 18:49:36 +00:00
  • 9a527f1848 Fix check_sql_fn_retval to allow the case where a SQL function declared to return void ends with a SELECT, if that SELECT has a single result that is also of type void. Without this, it's hard to write a void function that calls another void function. Per gripe from Peter. Tom Lane 2007-04-02 18:49:29 +00:00
  • cac01fc038 Done: Bruce Momjian 2007-04-02 17:18:44 +00:00
  • bf56e8a79f > o Add PQexecf() that allows complex parameter substitution > > http://archives.postgresql.org/pgsql-hackers/2007-03/msg01803.php Bruce Momjian 2007-04-02 17:15:39 +00:00
  • 626b4416b9 Put documentation on XML data type and functions in better positions. Add some index terms. Peter Eisentraut 2007-04-02 15:27:02 +00:00
  • b7d3a84539 xcopy can only deal with forward-slashed paths when it's quoted - needed for "vcregress check" to work. Per report from Dave Page. Magnus Hagander 2007-04-02 12:11:26 +00:00
  • a75602e4c6 Fix caching of unsuccessful initialization of parser or configuration. Per report from Listmail <lists@peufeu.com> Teodor Sigaev 2007-04-02 11:43:30 +00:00
  • 51fb9106e0 Fix caching of unsuccessful initialization of parser or configuration. Per report from Listmail <lists@peufeu.com> Teodor Sigaev 2007-04-02 11:43:11 +00:00
  • 368cc140d9 Fix caching of unsuccessful initialization of parser or configuration. Per report from Listmail <lists@peufeu.com> Teodor Sigaev 2007-04-02 11:42:44 +00:00
  • 100beb0dea Fix caching of unsuccessful initialization of parser or configuration. Per report from Listmail <lists@peufeu.com> Teodor Sigaev 2007-04-02 11:42:25 +00:00
  • 9477f12ea8 Fix caching of unsuccessful initialization of parser or configuration. Per report from Listmail <lists@peufeu.com> Teodor Sigaev 2007-04-02 11:42:04 +00:00
  • 57690c6803 Support enum data types. Along the way, use macros for the values of pg_type.typtype whereever practical. Tom Dunstan, with some kibitzing from Tom Lane. Tom Lane 2007-04-02 03:49:42 +00:00
  • a482a3e58b Update catversion for new XML mapping functions Peter Eisentraut 2007-04-01 09:56:02 +00:00
  • b0fe9c20e9 Update SQL conformance for SQL to XML mappings Peter Eisentraut 2007-04-01 09:42:57 +00:00
  • 0b75afda92 Mapping schemas and databases to XML and XML Schema. Peter Eisentraut 2007-04-01 09:00:26 +00:00
  • ae8072a404 Complete cleaning Peter Eisentraut 2007-04-01 08:56:58 +00:00
  • 335feca441 Add some instrumentation to the bgwriter, through the stats collector. New view pg_stat_bgwriter, and the functions required to build it. Magnus Hagander 2007-03-30 18:34:56 +00:00
  • f9ce21f94c Update Japanese FAQ. Bruce Momjian 2007-03-30 03:46:53 +00:00
  • 4dd2d9192d Update SSL description for when SSL root.crt/server.crt is required; add link to libpq SSL does from server docs. Bruce Momjian 2007-03-30 03:19:19 +00:00
  • 2ebfe9a818 Update SSL description for when SSL root.crt/server.crt is required; add link to libpq SSL does from server docs. Bruce Momjian 2007-03-30 03:19:02 +00:00
  • 0e95abd64c Fix oversight in coding of _bt_start_vacuum: we can't assume that the LWLock will be released by transaction abort before _bt_end_vacuum gets called. If either of these "can't happen" errors actually happened, we'd freeze up trying to acquire an already-held lock. Latest word is that this does not explain Martin Pitt's trouble report, but it still looks like a bug. Tom Lane 2007-03-30 00:13:05 +00:00
  • 8875d0987d Fix oversight in coding of _bt_start_vacuum: we can't assume that the LWLock will be released by transaction abort before _bt_end_vacuum gets called. If either of these "can't happen" errors actually happened, we'd freeze up trying to acquire an already-held lock. Latest word is that this does not explain Martin Pitt's trouble report, but it still looks like a bug. Tom Lane 2007-03-30 00:12:59 +00:00
  • 452427d0fd pg_char_to_encoding() was redundant in initdb because pg_valid_server_encoding() returns the same result if the encoding is valid. Bruce Momjian 2007-03-29 22:46:42 +00:00
  • 31f0bacb44 Add to: Bruce Momjian 2007-03-29 21:44:39 +00:00
  • 84045144e7 Add: Bruce Momjian 2007-03-29 21:43:34 +00:00
  • 81622ac36e Install include files Magnus Hagander 2007-03-29 20:48:26 +00:00
  • 418834f60d Update: Bruce Momjian 2007-03-29 20:24:34 +00:00
  • 9456a60f52 Update item: Bruce Momjian 2007-03-29 20:23:56 +00:00
  • 972e20b429 exec_parse_message neglected to copy parameter type array into the required memory context when handling client-specified parameter types for an unnamed statement. Per report from Kris Jurka. Tom Lane 2007-03-29 19:10:10 +00:00
  • 96b171903d Make ECPG regression tests use native threading instead of pthreads, now that ecpglib supports it. Change configure (patch from Bruce) and msvc build system to no longer require pthreads on win32, since all parts of postgresql can be thread-safe using the native platform functions. Magnus Hagander 2007-03-29 15:30:52 +00:00
  • ddcb5bbf76 - Added patch by Magnus Hagander <magnus@hagander.net> to use native win32 threads. - Fixed regression tests to run threading tests. Michael Meskes 2007-03-29 12:02:24 +00:00
  • fba8113c1b Teach CLUSTER to skip writing WAL if not needed (ie, not using archiving) --- Simon. Also, code review and cleanup for the previous COPY-no-WAL patches --- Tom. Tom Lane 2007-03-29 00:15:39 +00:00
  • 4591fb1aa8 Code cleanup for the new regexp UDFs: we can hardcode the OID and some properties of the "text" type, and then simplify the code accordingly. Patch from Jeremy Drake. Neil Conway 2007-03-28 22:59:37 +00:00
  • 74b667ad42 Replace 4-clause licensed blf.[ch] with blowfish implementation from PuTTY with is under minimal BSD/MIT license. Marko Kreen. Neil Conway 2007-03-28 22:48:58 +00:00
  • 7d4c9a5793 Add the "recheck" logic to autovacuum worker code. The worker first builds its table list and then rechecks pgstat before vacuuming each table to verify that no one has vacuumed the table in the meantime. Alvaro Herrera 2007-03-28 22:17:12 +00:00
  • 685badd213 Fix compiler warnings in ereport messages on mingw. ITAGAKI Takahiro Magnus Hagander 2007-03-28 08:06:11 +00:00
  • 553c7aeebf Add URL for: Bruce Momjian 2007-03-28 02:17:45 +00:00
  • 0565579c5b Fix uninitialized-variable bug. Tom Lane 2007-03-28 01:28:34 +00:00
  • bf94076348 Fix array coercion expressions to ensure that the correct volatility is seen by code inspecting the expression. The best way to do this seems to be to drop the original representation as a function invocation, and instead make a special expression node type that represents applying the element-type coercion function to each array element. In this way the element function is exposed and will be checked for volatility. Per report from Guillaume Smet. Tom Lane 2007-03-27 23:21:12 +00:00
  • 87564ffc6a Install import libraries used to link to libpq, ecpg and the backend. Magnus Hagander 2007-03-27 21:47:10 +00:00
  • f1a596bdfb Cosmetic changes: rename some struct fields, and move the fetching of pgstat table entries to a separate routine. Don't pass the pgstat database entry to do_autovacuum; rather, have it fetch it by itself. Alvaro Herrera 2007-03-27 20:36:03 +00:00
  • 1678e16cb3 Remove item due to lack of interest: Bruce Momjian 2007-03-27 17:27:01 +00:00
  • d3afd68051 Add: Bruce Momjian 2007-03-27 15:36:40 +00:00
  • b8f856512e Fix typo in Makefile. Bruce Momjian 2007-03-27 14:29:51 +00:00
  • b190aae9ad Fix typo, ensable -> enable, per Steve Gieseking. Tom Lane 2007-03-27 03:25:43 +00:00
  • 2dd336bba5 Fix typo, ensable -> enable, per Steve Gieseking. Tom Lane 2007-03-27 03:25:35 +00:00
  • 856b87c294 Fix typo, ensable -> enable, per Steve Gieseking. Tom Lane 2007-03-27 03:25:28 +00:00
  • 06d5fddfbf Add documentation for pulling the CVS repository using rsync, and mention cvsup last. Bruce Momjian 2007-03-27 01:45:22 +00:00
  • 64652e8632 Update: Bruce Momjian 2007-03-26 23:48:43 +00:00
  • 997b3c1b5d Add: Bruce Momjian 2007-03-26 23:47:53 +00:00
  • 87d82561c5 Remove Andrew Yu copyright, with permission from author. Bruce Momjian 2007-03-26 21:51:15 +00:00
  • 9dd3ec6c3b Remove advertising clause from Berkeley BSD-licensed files, per instructions from Berkeley. Bruce Momjian 2007-03-26 21:44:11 +00:00
  • 357be8c974 Properly fix PORTNAME in configure. Bruce Momjian 2007-03-26 21:30:56 +00:00