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

Commit Graph

  • 94d8da8fec Translation updates Dennis Bjorklund 2004-04-02 13:47:56 +00:00
  • 03f0604643 Translation updates Dennis Bjorklund 2004-04-02 13:42:26 +00:00
  • 89ee5b89a6 Fix some more compatibility issues (ctype.h macros must never be passed signed chars...) Tom Lane 2004-04-02 00:41:18 +00:00
  • eeaef25ad6 Fix some portability issues with new float input code (didn't work on HPUX 11 ...) Tom Lane 2004-04-01 23:52:18 +00:00
  • 47fe0517fc Fix some portability issues (reliance on gcc-isms). Tom Lane 2004-04-01 23:44:38 +00:00
  • 51d1a12ed1 Fix portability issues with functions that don't match their declaration. Tom Lane 2004-04-01 23:35:35 +00:00
  • b3fcc816ae Add missing casts to unsigned char in recently-added isspace() calls. Tom Lane 2004-04-01 22:51:31 +00:00
  • 7df21fe8a8 Adjust expected regression outputs for plan changes caused by recent 'fuzzy cost comparison' patch. Mea culpa for not having noticed this when I committed the patch. Tom Lane 2004-04-01 21:59:45 +00:00
  • 375369acd1 Replace TupleTableSlot convention for whole-row variables and function results with tuples as ordinary varlena Datums. This commit does not in itself do much for us, except eliminate the horrid memory leak associated with evaluation of whole-row variables. However, it lays the groundwork for allowing composite types as table columns, and perhaps some other useful features as well. Per my proposal of a few days ago. Tom Lane 2004-04-01 21:28:47 +00:00
  • 8590a62b75 Improve comments on USERLIMIT GUC processing. Bruce Momjian 2004-04-01 14:25:47 +00:00
  • 076055ed10 Add description of log_statement_stats's function (total statement stats rather than per-stage stats). Bruce Momjian 2004-03-31 19:59:22 +00:00
  • a302b8e150 Back out tutorial changes: Bruce Momjian 2004-03-31 16:20:53 +00:00
  • 7d15b90e5b Add psql backslash command discussion. Bruce Momjian 2004-03-31 01:05:54 +00:00
  • b5db560c7a Add: Bruce Momjian 2004-03-31 01:04:49 +00:00
  • 07ff3afa2a Remove: Bruce Momjian 2004-03-31 01:01:38 +00:00
  • 7b43450931 Fix markup errors from recent patch. Bruce Momjian 2004-03-30 22:08:50 +00:00
  • aaad011940 1. In keeping with the recent discussion that there should be more said about views, stored procedures, and triggers, in the tutorial, I have added a bit of verbiage to that end. Bruce Momjian 2004-03-30 21:58:20 +00:00
  • cf9c2be7e8 Add: Bruce Momjian 2004-03-30 21:51:41 +00:00
  • 45edc20283 Add mention of how to use \df to find functions using/returning specific data types. Bruce Momjian 2004-03-30 15:54:33 +00:00
  • fd071bd478 Fix to_char for 1 BC. Previously it returned 1 AD. Bruce Momjian 2004-03-30 15:53:18 +00:00
  • f2c064afcb Cleanup vectors of GISTENTRY and eliminate problem with 64-bit strict-aligned boxes. Change interface to user-defined GiST support methods union and picksplit. Now instead of bytea struct it used special GistEntryVector structure. Teodor Sigaev 2004-03-30 15:45:33 +00:00
  • 8d9a28eeef Use fuzzy comparison of path costs in add_path(), so that paths with the same path keys and nearly equivalent costs will be considered redundant. The exact nature of the fuzziness may get adjusted later based on current discussions, but no one has shot a hole in the basic idea yet ... Tom Lane 2004-03-29 19:58:04 +00:00
  • 28455721ff Fix for bug with the jdbc driver not properly working with binary cursors and the V3 protocol. Modified Files: Tag: REL7_4_STABLE jdbc/org/postgresql/Driver.java.in jdbc/org/postgresql/core/BaseResultSet.java jdbc/org/postgresql/core/BaseStatement.java jdbc/org/postgresql/core/Field.java jdbc/org/postgresql/core/PGStream.java jdbc/org/postgresql/core/QueryExecutor.java jdbc/org/postgresql/jdbc1/AbstractJdbc1DatabaseMetaData.java jdbc/org/postgresql/jdbc1/AbstractJdbc1ResultSet.java jdbc/org/postgresql/jdbc1/AbstractJdbc1Statement.java jdbc/org/postgresql/jdbc1/Jdbc1CallableStatement.java jdbc/org/postgresql/jdbc1/Jdbc1PreparedStatement.java jdbc/org/postgresql/jdbc1/Jdbc1RefCursorResultSet.java jdbc/org/postgresql/jdbc1/Jdbc1ResultSet.java jdbc/org/postgresql/jdbc1/Jdbc1Statement.java jdbc/org/postgresql/jdbc2/AbstractJdbc2ResultSet.java jdbc/org/postgresql/jdbc2/Array.java jdbc/org/postgresql/jdbc2/Jdbc2CallableStatement.java jdbc/org/postgresql/jdbc2/Jdbc2PreparedStatement.java jdbc/org/postgresql/jdbc2/Jdbc2RefCursorResultSet.java jdbc/org/postgresql/jdbc2/Jdbc2ResultSet.java jdbc/org/postgresql/jdbc2/Jdbc2Statement.java jdbc/org/postgresql/jdbc3/AbstractJdbc3ResultSet.java jdbc/org/postgresql/jdbc3/Jdbc3CallableStatement.java jdbc/org/postgresql/jdbc3/Jdbc3PreparedStatement.java jdbc/org/postgresql/jdbc3/Jdbc3RefCursorResultSet.java jdbc/org/postgresql/jdbc3/Jdbc3ResultSet.java jdbc/org/postgresql/jdbc3/Jdbc3Statement.java jdbc/org/postgresql/test/jdbc2/Jdbc2TestSuite.java jdbc/org/postgresql/test/jdbc2/OID74Test.java Added Files: Tag: REL7_4_STABLE jdbc/org/postgresql/test/jdbc2/ServerCursorTest.java Barry Lind 2004-03-29 17:47:47 +00:00
  • d9a1b2548f Fixed possible segfault in type.c (by Juergen Cappel) Michael Meskes 2004-03-29 15:12:08 +00:00
  • 047a2cecff Fixed possible segfault in type.c (by Juergen Cappel) Michael Meskes 2004-03-29 15:11:58 +00:00
  • 80683f2a07 Update FAQ from Robert Treat Bruce Momjian 2004-03-29 05:07:20 +00:00
  • 7442defe4b Some further editorializing on README.CVS. Tom Lane 2004-03-28 06:09:14 +00:00
  • 5cb902cbfc Some further editorializing on README.CVS. Tom Lane 2004-03-28 06:09:08 +00:00
  • b803cf4320 Clean up thread test program. Bruce Momjian 2004-03-28 02:37:31 +00:00
  • db9a957618 Add test for thread-safe errno to thread test program. Bruce Momjian 2004-03-27 23:02:44 +00:00
  • 4f0d027e7d Add comment about psql \s (history display): Bruce Momjian 2004-03-27 18:01:40 +00:00
  • b295c0a085 Clean up function call arg appearance. Bruce Momjian 2004-03-27 17:59:35 +00:00
  • cfcdd31c5d Change small 'if/else' test to use Max(). Bruce Momjian 2004-03-27 17:32:42 +00:00
  • 513bbf4046 Fix brain-dead placement of global variable declaration. Tom Lane 2004-03-27 03:08:42 +00:00
  • 7820ee24c9 Now that we are allowing index opclasses to contain operators that are only stable and not immutable, pred_test_simple_clause has to guard against making invalid deductions. Add a test for immutability of the selected test_op. Tom Lane 2004-03-27 00:24:28 +00:00
  • 9169b57755 Add -D_REENTRANT for Solaris threading. Bruce Momjian 2004-03-26 18:24:16 +00:00
  • 79b805f6d5 Add -D_REENTRANT for Solaris threading. Bruce Momjian 2004-03-26 18:24:08 +00:00
  • 1090aa8cc7 More cross-reference work, other minor SGML fixes and improvements. Neil Conway 2004-03-26 03:18:28 +00:00
  • 52e33bab6f Update solaris for threading. Bruce Momjian 2004-03-25 22:13:44 +00:00
  • fda3449625 Update gcc solaris flags. Bruce Momjian 2004-03-25 22:12:37 +00:00
  • dbd5390ad4 Fix for SSL compile. Bruce Momjian 2004-03-25 21:48:59 +00:00
  • 7a944e41b4 Convert some GUC variable references to links. Tom Lane 2004-03-25 18:57:57 +00:00
  • eebdfcdbe6 1 Minimize memory allocation for void (but not null) value. 2 Add silly ordering for ts_vector to aim grouping, union, except etc. Don't use BTree opclass (tsvector_ops). Teodor Sigaev 2004-03-25 16:56:10 +00:00
  • fb411a4768 Minimize memory allocation for void (but not null) value. Teodor Sigaev 2004-03-25 16:50:49 +00:00
  • 457ad3925d Add a more useful error message for the case where someone tries to pass a whole row or record variable into a SQL function. Eventually this case should be made to actually work, but for now this is better than what it did before. Tom Lane 2004-03-24 23:38:49 +00:00
  • 8899a2aba9 Replace max_expr_depth parameter with a max_stack_depth parameter that is measured in kilobytes and checked against actual physical execution stack depth, as per my proposal of 30-Dec. This gives us a fairly bulletproof defense against crashing due to runaway recursive functions. Tom Lane 2004-03-24 22:40:29 +00:00
  • a09b9a36d3 Add: Bruce Momjian 2004-03-24 18:15:56 +00:00
  • 6a034c3322 Adjust error message wording per Andrew Dunstan's advice. Tom Lane 2004-03-24 15:20:54 +00:00
  • ce5273757b Make a cross-reference in the ALTER TABLE ref page into a <xref>. Neil Conway 2004-03-24 09:49:20 +00:00
  • c83cd6c1da Update description error text: Bruce Momjian 2004-03-24 04:07:31 +00:00
  • 51b488535e Here's a patch implementing the "thread method" to workaround the bug with socket calls in signal handlers (APC) on Win32. See details in mail to pgsql-hackers-win32 a couple of minutes ago. Bruce Momjian 2004-03-24 04:04:51 +00:00
  • b8fd6756e2 Allow unlink/rename of files open by another process on Win32, using a special Win32 open flag FILE_SHARE_DELETE. Bruce Momjian 2004-03-24 03:54:16 +00:00
  • d6bc5944a0 Fix a minor typo in the log_line_prefix docs and make a couple other tiny improvements. Neil Conway 2004-03-24 03:48:41 +00:00
  • 6daf396879 Add thread locking to SSL and Kerberos connections. Bruce Momjian 2004-03-24 03:45:00 +00:00
  • fcfa2c790a Document fallback to tcp/ip localhost connection from psql on ports without unix domain sockets (win32). Bruce Momjian 2004-03-24 03:27:46 +00:00
  • 017e3e244a Fix some whitespace formatting, and remove an overly-verbose parameter description: postgresql.conf is not the place for documentating the functionality of a GUC var. Neil Conway 2004-03-24 03:22:35 +00:00
  • 46c3e29b8e >>Also, what is the default connection mode of psql? It should probably be >>equivalent to "-h localhost", shouldn't it? >> >> > >Now that is something I had not thought of. Seems we can assume a Win32 >psql can never use unix domain sockets, so defaulting that to localhost >is a good solution too. Bruce Momjian 2004-03-24 03:10:29 +00:00
  • f23cce73b3 Use the new GUC variable default_with_oids in pg_dump, rather than using WITH/WITHOUT OIDS in dump files. This makes dump files more portable. Bruce Momjian 2004-03-24 03:06:08 +00:00
  • 533d0915cf Update the float8 regression tests: they should now pass on FreeBSD 4.x and (in theory) QNX. Thanks to Chris KL for the report. Neil Conway 2004-03-24 02:02:27 +00:00
  • 1c4da387ad PQresult should be PGresult. Tom Lane 2004-03-23 23:37:17 +00:00
  • 8ed89773c5 Fix small typo. Tom Lane 2004-03-23 22:57:09 +00:00
  • 121cf2b904 Repair misleading description of MOVE's command tag result. Tom Lane 2004-03-23 22:39:22 +00:00
  • f862c42009 Use dollar-quoting for function bodies, unless disabled with --disable-dollar-quoting. Tom Lane 2004-03-23 22:06:08 +00:00
  • 48b2802eee When changing select() calls for delays into pg_usleep(), two comments in s_lock.c were not updated, and still refers to select. Made my grep hit the wrong files, so I figured a simple patch was in order.. (other refs in the same comment block was changed..) Bruce Momjian 2004-03-23 21:39:46 +00:00
  • 24614a9880 Upgrade ALTER TABLE DROP COLUMN so that it can drop an OID column, and remove separate implementation of ALTER TABLE SET WITHOUT OIDS in favor of doing a regular DROP. Also, cause CREATE TABLE to account completely correctly for the inheritance status of the OID column. This fixes problems with dropping OID columns that have dependencies, as noted by Christopher Kings-Lynne, as well as making sure that you can't drop an OID column that was inherited from a parent. Tom Lane 2004-03-23 19:35:17 +00:00
  • 446b5476e5 Minor SGML improvements. Neil Conway 2004-03-23 13:21:41 +00:00
  • 9f894981da Fix typo in postmaster reference page: from Tom. Neil Conway 2004-03-23 06:09:00 +00:00
  • 7ce822372f fflush() FILE buffer to descriptor so stat call gets proper size in fseeko.c. Bruce Momjian 2004-03-23 05:27:02 +00:00
  • ee455f81a5 fflush() FILE buffer to descriptor so stat call gets proper size in fseeko.c. Bruce Momjian 2004-03-23 05:26:53 +00:00
  • fd4f3b3b62 Improve the locale and character set docs, add some <xref>s pointing to the character set docs where appropriate, and improve the postmaster reference page. Character set cross-refs suggested by Gavin Kistner. Neil Conway 2004-03-23 02:47:35 +00:00
  • b96509a3f3 Fix getpwuid_r call: Bruce Momjian 2004-03-23 02:04:33 +00:00
  • 5688e45979 Fix getpwuid_r call: Bruce Momjian 2004-03-23 02:03:55 +00:00
  • 2e45c143ef Replace the virtual_host and tcpip_socket parameters with a unified listen_addresses parameter, as per recent discussion. The default behavior is now to listen on localhost, which eliminates the need for the -i postmaster switch in many scenarios. Tom Lane 2004-03-23 01:23:48 +00:00
  • 0d88dd1e50 Before deciding we can use a socket for statistics collection, test to ensure that it actually passes data. This catches cases such as a kernel packet filter rule that makes the socket useless. Tom Lane 2004-03-22 23:55:29 +00:00
  • 6b198d61f8 Add missing extern for optind. Tom Lane 2004-03-22 16:46:28 +00:00
  • 3b7ca96c2c Clean up rather poor description of the difference between INHERITS and LIKE. Per gripe from Patrick Samson. Tom Lane 2004-03-22 16:18:50 +00:00
  • d81cd7032e Standardize output buffer size and display format for strftime; followup to complaint from Korean User's Group. Tom Lane 2004-03-22 15:34:22 +00:00
  • 682a6bd5eb Disasble threads on unixware until other platforms report a problem. Bruce Momjian 2004-03-22 14:53:43 +00:00
  • 6367ed4382 Increase xlog str_time() static string variable, per Korean User's Group. Bruce Momjian 2004-03-22 04:16:57 +00:00
  • f2cc5330cc In working through a pg_autovacuum problem with Joe Conway (which turned out to be the same problem reported by Cott Lang which the previous patch resolved) a new bug was uncovered when running with a debug level of greater than 1. Bruce Momjian 2004-03-22 03:57:19 +00:00
  • 2678395928 In working through a pg_autovacuum problem with Joe Conway (which turned out to be the same problem reported by Cott Lang which the previous patch resolved) a new bug was uncovered when running with a debug level of greater than 1. Bruce Momjian 2004-03-22 03:57:08 +00:00
  • 3ceda5eab3 I just noticed that \dp outputs "Table" to indicate relations (tables, sequences and views). This patch allows it to handle views and sequences. Bruce Momjian 2004-03-22 03:38:24 +00:00
  • a7f0747320 Adds DLLIMPORT modifier to check_function_bodies Bruce Momjian 2004-03-22 03:15:33 +00:00
  • 08c0aa7281 Add mention of "-D_POSIX_PTHREAD_SEMANTICS" enabling 5-arg getpwuid_r(). Bruce Momjian 2004-03-22 01:50:31 +00:00
  • 0de45c1c27 Add timestamp-versus-timestamptz cross-type comparison functions, flesh out the index operator classes to include these. In passing, fix erroneous volatility marking of ACL functions. Tom Lane 2004-03-22 01:38:18 +00:00
  • f938c2b91b Revise syntax-error reporting behavior to give pleasant results for errors in internally-generated queries, such as those submitted by plpgsql functions. Per recent discussions with Fabien Coelho. Tom Lane 2004-03-21 22:29:11 +00:00
  • bee3b2a0a0 Translation updates Dennis Bjorklund 2004-03-21 12:19:36 +00:00
  • 94fb33b115 Translation updates Dennis Bjorklund 2004-03-21 09:22:18 +00:00
  • 05649b88c7 Rewrite pg_dump's comment-dumping code to pull over all the comments in one query, rather than making a separate query for each object that could have a comment. This costs relatively little space (a few tens of K typically) and saves substantial time in databases with many objects. I find it reduces the runtime of 'pg_dump -s regression' by about a third. Tom Lane 2004-03-20 20:09:45 +00:00
  • 3c06653fbd Repair multiple memory leaks in getTables(), including one that could easily exhaust memory on databases with more than a few hundred triggers. I don't expect any more releases of these old versions, but let's put the fix in CVS just so it's archived. Tom Lane 2004-03-20 18:12:50 +00:00
  • fbec0d7e94 Repair multiple memory leaks in getTables(), including one that could easily exhaust memory on databases with more than a few hundred triggers. I don't expect any more releases of these old versions, but let's put the fix in CVS just so it's archived. Tom Lane 2004-03-20 18:12:32 +00:00
  • c8aaa5ceec Remove suggestiong for using test for wal_sync_method. Bruce Momjian 2004-03-20 16:18:41 +00:00
  • 34ce6b41cf Always test getpwuid_r because HEAD always uses *_r if it finds them. Not an issue for 7.4.X. Bruce Momjian 2004-03-20 16:11:22 +00:00
  • 21a7569b1a Handle draft version of getpwuid_r() that accepts only four arguments. Bruce Momjian 2004-03-20 15:39:40 +00:00
  • aaf54d99f0 Handle draft version of getpwuid_r() that accepts only four arguments. Bruce Momjian 2004-03-20 15:39:27 +00:00
  • 6c7e6d2baa Add a usage example for has_function_privilege(). Tom Lane 2004-03-19 19:13:26 +00:00
  • 0fdc6c4cc0 Create a validator for plpgsql, so that some minimal syntax checking is done at creation time for plpgsql functions. Improve createlang and droplang to support adding/dropping validators for PLs. Initial steps towards producing a syntax error position from plpgsql syntax errors (this part is a work in progress, and will change depending on outcome of current discussions). Tom Lane 2004-03-19 18:58:07 +00:00
  • 74ffc77279 Code review for log_line_prefix patch. Cooperate with StringInfo instead of fighting it, avoid hard-wired (and wrong) assumption about max length of prefix, cause %l to actually work as documented, don't compute data we may not need. Tom Lane 2004-03-19 02:23:59 +00:00
  • 8726591720 Make test_fsync use optimizer flag. Bruce Momjian 2004-03-18 23:27:29 +00:00
  • cbaf1aaeba Fix log_executor_stats if() test. Bruce Momjian 2004-03-18 23:26:17 +00:00