Commit Graph

  • ce90c0f504 Fix typo in comment Tatsuo Ishii 2003-09-17 04:25:29 +00:00
  • 7e06dbe1c2 Make psql correctly track the effects of SET CLIENT_ENCODING commands. I thought I'd fixed this earlier, but I didn't get it right ... Tom Lane 2003-09-16 17:59:02 +00:00
  • 7b05ef5b63 fix typo in a comment Tatsuo Ishii 2003-09-16 07:47:06 +00:00
  • fc73264005 I don't care whether it's informix-compatible or not: #defining a word like 'date' in a public header file is a damn fool idea. Tom Lane 2003-09-16 04:32:28 +00:00
  • b8f8896888 Fix some problems with dropped columns in plpython trigger functions. Tom Lane 2003-09-16 01:07:51 +00:00
  • 8723e37a26 Since SPI_modifytuple's natts argument is the number of attributes to be changed, it should allow a zero value (implying no changes to make). Tom Lane 2003-09-16 00:50:09 +00:00
  • db18703b5a Fix LISTEN/NOTIFY race condition reported by Gavin Sherry. While a really general fix might be difficult, I believe the only case where AtCommit_Notify could see an uncommitted tuple is where the other guy has just unlistened and not yet committed. The best solution seems to be to just skip updating that tuple, on the assumption that the other guy does not want to hear about the notification anyway. This is not perfect --- if the other guy rolls back his unlisten instead of committing, then he really should have gotten this notify. But to do that, we'd have to wait to see if he commits or not, or make UNLISTEN hold exclusive lock on pg_listener until commit. Either of these answers is deadlock-prone, not to mention horrible for interactive performance. Do it this way for now. (What happened to that project to do LISTEN/NOTIFY in memory with no table, anyway?) Tom Lane 2003-09-15 23:33:43 +00:00
  • d73e1b33b5 Update regression test for message change. Tom Lane 2003-09-15 23:25:31 +00:00
  • daed6f4b94 Improve a couple of error messages per suggestions from Alvaro Herrera. Tom Lane 2003-09-15 22:28:58 +00:00
  • 7ce5f25b5b Translation updates Peter Eisentraut 2003-09-15 20:42:40 +00:00
  • 2d13472c9e OK, some of these syntax errors should be given other codes. Peter Eisentraut 2003-09-15 20:03:37 +00:00
  • baba02a84e tag her for beta3, as announced on Friday ... REL7_4_BETA3 PostgreSQL Daemon 2003-09-15 14:32:35 +00:00
  • 4d016a957d Okay, who left off the id= here? Tom Lane 2003-09-15 03:32:24 +00:00
  • 5f78d6cb77 LISTEN doesn't issue a warning for redundant listens anymore. Also, add some 'See Also' links. Tom Lane 2003-09-15 03:21:51 +00:00
  • 72ed916a1f Add errno value for thread *_r function call buffer too small. Improve thread comments. Bruce Momjian 2003-09-15 02:30:29 +00:00
  • 24d41a9efc NetBSD needs reentrant funcs. Bruce Momjian 2003-09-15 02:17:49 +00:00
  • a07c5a1225 Remove warnings for operations that have no effect when executed repeatedly. Peter Eisentraut 2003-09-15 00:26:31 +00:00
  • 2f9d32cded Run distprep target before creating list of files that contain translatable strings in the backend, so that .l and .y files are included. To that end, don't make the .pot file a prerequisite on distprep. Peter Eisentraut 2003-09-14 22:40:38 +00:00
  • 20aaf64252 Allow translation of SQL help in psql. Peter Eisentraut 2003-09-14 22:37:13 +00:00
  • 241cea18f7 Add missing support for Opteron (__x86_64__). Tom Lane 2003-09-14 20:21:18 +00:00
  • 3f43446e36 Persuade tsearch/tsearch2 to work (or at least pass their regression tests) when using flex 2.5.31. The fix is to *not* try to use palloc and pfree for allocations within the lexer; when you do that, the yy_buffer_stack gets freed at inopportune times. The code is already set up to do manual deallocation, so I see no particular advantage to using palloc anyway. Tom Lane 2003-09-14 18:44:23 +00:00
  • 0441e269ea Make pltcl create separate function objects when the same function is used as trigger on different relations. I am not convinced that Tcl actually has to have this, but it seems a good idea to make it be parallel to the other PLs that definitely do need it. Tom Lane 2003-09-14 17:25:54 +00:00
  • 96e63199f3 Fix plpython to generate separate cached procedure data for each relation, when the same function is used as a trigger on more than one relation. This avoids crashes due to differing rowtypes for different relations. Per bug report from Lance Thomas, 7-Feb-03. Tom Lane 2003-09-14 17:13:06 +00:00
  • efebe2605e Since I haven't gotten a reply, can someone REVERT the lines in src/Makefile.shlib that adds $(libdir)/$(soname) for port,eq,unixware to $(soname)? Bruce Momjian 2003-09-14 13:33:08 +00:00
  • 0e9b05bde9 expected results for dblink test seem to be out of date ... Tom Lane 2003-09-14 02:30:07 +00:00
  • 043be9ad96 Make contrib/seg work with flex 2.5.31. Fix it up to have a real btree operator class, too, since in PG 7.4 you can't GROUP without one. Tom Lane 2003-09-14 02:18:49 +00:00
  • 03e47392e0 Make contrib/cube work with flex 2.5.31. Fix it up to have a real btree operator class, too, since in PG 7.4 you can't GROUP without one. Tom Lane 2003-09-14 01:52:25 +00:00
  • b38c04335a Reconsider placement of MemoryContextCheck() call --- do after commit, not before, to avoid duplication of effort. Tom Lane 2003-09-14 00:03:32 +00:00
  • 4cf6e9e081 Avoid corner cases where aset.c would unnecessarily make malloc() requests of sizes that aren't powers of 2. Per observation from David Schultz, 28-Aug. Tom Lane 2003-09-13 22:25:38 +00:00
  • c472b8366f With Joe Conway's concurrence, remove srandom() call from normal_rand(). This was the last piece of code that took it upon itself to reset the random number sequence --- now we only have srandom() in postmaster start, backend start, and explicit setseed() operations. Tom Lane 2003-09-13 21:44:50 +00:00
  • 94a13b8a11 Okay, I've had it with mktime() bugs. While chasing Torello Querci's recent gripe, I discovered not one but two undocumented, undesirable behaviors of glibc's mktime. So, stop using it entirely, and always rely on inversion of localtime() to determine the local time zone. It's not even very much slower, as it turns out that mktime (at least in the glibc implementation) also does repeated reverse-conversions. Tom Lane 2003-09-13 21:12:38 +00:00
  • f51759064c Minor wording improvements. Tom Lane 2003-09-13 17:33:46 +00:00
  • bcd8986e7d Rename --without-spinlocks to --disable-spinlocks, per Peter. Bruce Momjian 2003-09-13 17:01:09 +00:00
  • cd47a4d3c4 With pg_autovacuum becoming increasingly popular it's important to have a working stats collector. This test is able to discover the problem that was present in 7.4 Beta 2. Bruce Momjian 2003-09-13 16:44:49 +00:00
  • c346ca8648 When I sent in the sslmode patch I forgot to update the comments/examples in pg_hba.conf. This patch remedies that, adds a brief explanation of the connection types, and adds a missing period in the docs. Bruce Momjian 2003-09-13 16:43:38 +00:00
  • d7635e5c4f autoconf/autoheader run. Bruce Momjian 2003-09-13 16:39:51 +00:00
  • 2056f8a7da pgindent C file, per patch request. Bruce Momjian 2003-09-13 16:27:38 +00:00
  • 3bf080daaf > OK, well as we wait on the fix for the stats system, let me submit my > patch for pg_autovacuum. This patch assumes that the stats system will > be fixed so that all inserts, updates and deletes performed on shared > tables reguardless of what database those commands were executed from, > will show up in the stats shown in each database. Bruce Momjian 2003-09-13 16:26:18 +00:00
  • b041d3e3a1 Attempt threading in this order: Bruce Momjian 2003-09-13 14:49:51 +00:00
  • 509a9cd3f9 More SQLState updates from Kim Ho at Redhat. Also a patch from Kris Jurka to correctly report SQLState support. Barry Lind 2003-09-13 04:02:16 +00:00
  • f8c365c8db Marginal hacks to make tables format more nicely. Tom Lane 2003-09-13 00:19:43 +00:00
  • a75ee43ce9 Mop-up for error-message updates in documentation. Tom Lane 2003-09-12 23:04:46 +00:00
  • 6e59122490 Update obsolete examples of error messages; various other minor editing. Tom Lane 2003-09-12 22:17:24 +00:00
  • 8b43e325eb Revert to our pre-7.4 behavior of identifying Unix-socket connections in ps status as '[local]', not as 'localhost' as the code has been doing recently. That's too easily confused with TCP loopback connections, and there is no good reason to change the behavior anyway. Tom Lane 2003-09-12 20:18:51 +00:00
  • b1d3de6b96 Someone (possibly me) foolishly reduced the response for failing to create a TCP/IP socket from FATAL to LOG. This was unwise; historically we have expected socket conflicts to abort postmaster startup. Conflicts on port numbers with another postmaster can only be detected reliably at the TCP socket level. Tom Lane 2003-09-12 19:33:59 +00:00
  • 9fc3b9330e Mark FreeBSD as non-thread-safe. Bruce Momjian 2003-09-12 16:49:34 +00:00
  • 17d15ddf75 Fix incorrect pfree in to_tsquery_name(), per Nigel Andrews. Tom Lane 2003-09-12 16:34:28 +00:00
  • 06e3ec7a54 Implement compiler #error if spinlock code not found, add configure flag to bypass the error, --without-spinlocks. Bruce Momjian 2003-09-12 16:10:27 +00:00
  • 69a46e9ce1 Enable Opteron/Itanium spinlocks. Bruce Momjian 2003-09-12 15:49:34 +00:00
  • cb8d423edb Remove WIN32 console. Bruce Momjian 2003-09-12 02:46:03 +00:00
  • 9182481bea Remove WIN32_CONSOLE support, at the request of the author. Bruce Momjian 2003-09-12 02:40:10 +00:00
  • aaafbdcfd3 Fix old mention of exec() in AttachSharedMemoryAndSemaphores comment. Bruce Momjian 2003-09-12 02:13:23 +00:00
  • 74e1bfe66d Remove derived files from WIN32_DEV branch. Bruce Momjian 2003-09-12 02:04:40 +00:00
  • e90b841915 More cleanup of Diagnostics sections. Tom Lane 2003-09-12 00:12:47 +00:00
  • fbb39c059e Small typo. Tom Lane 2003-09-11 23:15:51 +00:00
  • 8ff2005c67 Message in the other exit from acquire_sample_rows(), as per update from Mark Kirkwood. Also show the sample size. Tom Lane 2003-09-11 23:12:31 +00:00
  • 47c7f9ef1c Try to make recently-added analyze log message look something like the others in style. Tom Lane 2003-09-11 22:59:28 +00:00
  • 2a5b6a7c9b This patch fixes a few missed GUC variables that were still upper case, makes a few more small improvements to runtime.sgml, and makes some SGML conventions more consistent. Bruce Momjian 2003-09-11 21:42:20 +00:00
  • 3d48045ae1 > It quotes table names for vacuum and analyze, and uppercases the > keywords for clarity. Bruce Momjian 2003-09-11 19:01:18 +00:00
  • 188eda0df2 Consistenly lowercase GUC variable names, in docs and error messages. Bruce Momjian 2003-09-11 18:30:39 +00:00
  • 8e27be4310 This patch makes a few minor improvements to the docs: make the <varname> conventions more consistent, and improve the ANALYZE ref page. Bruce Momjian 2003-09-11 17:31:45 +00:00
  • 64a7b58aa0 This patch makes a number of improvements to the runtime config documentation. Bruce Momjian 2003-09-11 17:27:38 +00:00
  • ab19254618 Mention that pg_type_is_visible is used for domains as well. Bruce Momjian 2003-09-11 17:26:20 +00:00
  • a5e9e51fb0 on my timetravel.c I find a bug: after the ALTER TABLE mytable drop column last_column_of_table; Bruce Momjian 2003-09-11 17:25:14 +00:00
  • 92e100dd33 Here is a patch that removes contrib/array, leaving only the README with some examples of the new syntax and a reference to the documentation. Bruce Momjian 2003-09-11 17:15:27 +00:00
  • d768cb267b seemed like a typo in one of the appendix tables Bruce Momjian 2003-09-11 16:22:42 +00:00
  • fdd93470fa Fix missed message update, per Alvaro Herrera. Tom Lane 2003-09-11 02:40:13 +00:00
  • d6a9b4e0b5 Update row count for \? output, used by pager. Bruce Momjian 2003-09-10 21:35:55 +00:00
  • 9cb4a28f47 Improve error message for cp or rm failur during create/drop database, per recent discussions. Tom Lane 2003-09-10 20:24:09 +00:00
  • 2b56a9646a Add: Bruce Momjian 2003-09-10 20:17:21 +00:00
  • e303be78e8 Add: Bruce Momjian 2003-09-10 20:14:42 +00:00
  • 73cfa77edd This patch fixes a trivial typo in the CREATE FUNCTION ref page. Bruce Momjian 2003-09-10 20:13:45 +00:00
  • 336ebee2c0 copydir() is supposed to return on failure, not elog(ERROR). Reduce ERROR to WARNING so we keep control. Tom Lane 2003-09-10 20:12:01 +00:00
  • d16b877612 Add HINT if CREATE FUNCTION specifies a valid language, but the language isn't loaded into the database. Bruce Momjian 2003-09-10 19:59:23 +00:00
  • a72fce035d Add quotes to vacuum/analyze for upper/lowercase table names, per Matthew T. O'Connor. Bruce Momjian 2003-09-10 19:57:48 +00:00
  • 573f4500a3 Some uppercase type definitions were left. Michael Meskes 2003-09-10 18:03:08 +00:00
  • 0f310ee703 Here is a patch to make PostgreSQL use a full path in DT_SONAME for UnixWare. Bruce Momjian 2003-09-10 03:56:33 +00:00
  • a9953097f4 Clean up printability test in dbase code. Bruce Momjian 2003-09-10 00:33:51 +00:00
  • 22b305ad4a Add: Bruce Momjian 2003-09-10 00:03:23 +00:00
  • 33d4c828fd Some "feature not supported" errors are better syntax errors, because the feature they complain about isn't a feature or cannot be implemented without definitional changes. Peter Eisentraut 2003-09-09 23:22:21 +00:00
  • 3610f083c1 Improve wording of increasing page size. Bruce Momjian 2003-09-09 22:43:06 +00:00
  • d4019b7cd3 Remove a bunch of content-free Diagnostics sections, as per previous discussion. (Still have some work to do editing the remainder.) Tom Lane 2003-09-09 18:28:53 +00:00
  • 1815f6179d Update max tasble size to 32TB. Bruce Momjian 2003-09-09 18:25:44 +00:00
  • d0bfe7f100 Update comments about how locale settings are handled. Tom Lane 2003-09-09 15:19:31 +00:00
  • 62b53accd4 Clean up some unused import warnings in the example jdbc code Barry Lind 2003-09-09 11:24:04 +00:00
  • 2fab616866 Fixed a few bugs that came up on pgsql-interfaces. Michael Meskes 2003-09-09 10:54:44 +00:00
  • 5cdf771d8a Additional SQLState work for JDBC - thanks to Kim Ho at Redhat for input on this Barry Lind 2003-09-09 10:49:16 +00:00
  • fcdf0e22fc - Added Dave patch for Informix handling of numeric/int conversion. - Changed all new datatypes to lowercase. - Fixed rounding bug in numerical types. Michael Meskes 2003-09-09 10:46:42 +00:00
  • fd65be4a78 Fix a couple minor typos. Tom Lane 2003-09-08 23:17:15 +00:00
  • 6de93c0529 Update preface. Peter Eisentraut 2003-09-08 23:02:28 +00:00
  • e54965c0f8 Add: Bruce Momjian 2003-09-08 22:48:21 +00:00
  • 4427969315 "statenebt" ? Tom Lane 2003-09-08 22:33:13 +00:00
  • f176e37975 Document a bunch of formerly-undocumented date/time operators, including the SQL-spec OVERLAPS construct. Tom Lane 2003-09-08 19:38:02 +00:00
  • f1e76f4492 Update list of generated files. Bruce Momjian 2003-09-08 18:16:01 +00:00
  • 05dddf40c2 Opps, can't forget the new file. This is part of the last commit to apply the redhat patch for SQLState support. Barry Lind 2003-09-08 17:45:35 +00:00
  • 0378a269f3 This set of changes applies a patch from KHO at redhat to add some SQLState support to the jdbc driver. That patch needed some work: it assumed the sqlcode in a server message was fixed in its position, the patch lost the ability to pass exceptions, and the patch missed a couple of places where server errors where being received. In addition to fixing the above, I also added full support for the V3 protocol error message syntax, I reversed the order of arguments in the PSQLException constructor to more closely follow the constructors for SQLException, I changed the new constructors that take PSQLState to take Object for additional parameters as the old ones did. Still todo are to add SQLState values to all existing exceptions thrown in the driver and add support for parsing the V3 protocol format for notices. Barry Lind 2003-09-08 17:30:22 +00:00
  • fbfd687f0c List derived files. Bruce Momjian 2003-09-08 04:24:01 +00:00
  • c770338038 flex/bison stamp fix. Bruce Momjian 2003-09-08 01:55:52 +00:00
  • e702b04cf4 Avoid using s_addr as a local variable name, to work around broken system headers on Unixware. Tom Lane 2003-09-08 00:56:13 +00:00
  • 5b88ff87d7 Force flex/bison files to be new. Bruce Momjian 2003-09-07 23:40:52 +00:00