hcq/postgresql
1
0
Fork 0
mirror of https://git.postgresql.org/git/postgresql.git synced 2026-03-01 17:57:00 +08:00
Code Issues Packages Projects Releases Wiki Activity

Commit Graph

  • be6e9f6266 Add: Bruce Momjian 2004-12-02 19:32:57 +00:00
  • e9c03c3b1b Disallow the combination VACUUM FULL FREEZE for safety's sake, for the reasons I outlined in pghackers a few days ago. Tom Lane 2004-12-02 19:28:49 +00:00
  • bbf29949c3 Add: Bruce Momjian 2004-12-02 18:13:47 +00:00
  • f7bae20d67 Don't bother adding to cflags/cppflags, just set them because configure handles that, and make solaris debug use no optimization. Bruce Momjian 2004-12-02 18:11:40 +00:00
  • 22c21bab92 Wording improvement. Bruce Momjian 2004-12-02 17:39:54 +00:00
  • 91cf5ef550 Document that btrim()'s second parameter is optional, and defaults to spaces. Bruce Momjian 2004-12-02 17:14:54 +00:00
  • 40b6d68951 Update Brazilian FAQ. Bruce Momjian 2004-12-02 15:49:25 +00:00
  • 8408f65252 Rework libpq threaded SIGPIPE handling to avoid interference with calling applications. This is done by blocking sigpipe in the libpq thread and using sigpending/sigwait to possibily discard any sigpipe we generated. Bruce Momjian 2004-12-02 15:32:54 +00:00
  • e02ef267fc Fix a potential free() of string literal in oid2name, per report from Michael Fuhr. Along the way, fix a bunch of accesses to uninitialized memory, add a mystrdup() routine and use it to cleanup some code. Neil Conway 2004-12-02 06:14:50 +00:00
  • b383c1db85 Add: Bruce Momjian 2004-12-02 04:40:37 +00:00
  • 64b5789497 This is a little patch to correct the documentation on CVS. The URL for downloading CVS at cyclic.com site is long defunct, and I changed the text to not overtly recommend CVS 1.10, a now fairly old version. Neil Conway 2004-12-02 04:12:12 +00:00
  • ec2fce1880 Update Japanese FAQ. Bruce Momjian 2004-12-02 03:46:47 +00:00
  • 6ba32b24b2 Teach regex_fixed_prefix() the correct handling of advanced regex escapes --- they aren't simply quoted characters. Problem noted by Antti Salmela. Also fix problem with incorrect handling of multibyte characters when followed by a quantifier. Tom Lane 2004-12-02 02:45:24 +00:00
  • 76e8a87f15 Teach regex_fixed_prefix() the correct handling of advanced regex escapes --- they aren't simply quoted characters. Problem noted by Antti Salmela. Also fix problem with incorrect handling of multibyte characters when followed by a quantifier. Tom Lane 2004-12-02 02:45:07 +00:00
  • 4e91824b94 Make some adjustments to reduce platform dependencies in plan selection. In particular, there was a mathematical tie between the two possible nestloop-with-materialized-inner-scan plans for a join (ie, we computed the same cost with either input on the inside), resulting in a roundoff error driven choice, if the relations were both small enough to fit in sort_mem. Add a small cost factor to ensure we prefer materializing the smaller input. This changes several regression test plans, but with any luck we will now have more stability across platforms. Tom Lane 2004-12-02 01:34:18 +00:00
  • ee9007a2e1 Allow libpq to build on MS Visual Studio .NET 2003 on Windows XP. Bruce Momjian 2004-12-01 23:42:26 +00:00
  • eebece7d0d Update French FAQ. Bruce Momjian 2004-12-01 22:17:16 +00:00
  • d237a12e49 Fix timestamptz_age() to do calculation in local timezone not GMT, per bug 1332. Tom Lane 2004-12-01 19:57:56 +00:00
  • 1e6457dfce Fix timestamptz_age() to do calculation in local timezone not GMT, per bug 1332. Tom Lane 2004-12-01 19:57:49 +00:00
  • 4828445d3c Clarify documentation of age() functions. Tom Lane 2004-12-01 19:32:12 +00:00
  • 5374d097de Change planner to use the current true disk file size as its estimate of a relation's number of blocks, rather than the possibly-obsolete value in pg_class.relpages. Scale the value in pg_class.reltuples correspondingly to arrive at a hopefully more accurate number of rows. When pg_class contains 0/0, estimate a tuple width from the column datatypes and divide that into current file size to estimate number of rows. This improved methodology allows us to jettison the ancient hacks that put bogus default values into pg_class when a table is first created. Also, per a suggestion from Simon, make VACUUM (but not VACUUM FULL or ANALYZE) adjust the value it puts into pg_class.reltuples to try to represent the mean tuple density instead of the minimal density that actually prevails just after VACUUM. These changes alter the plans selected for certain regression tests, so update the expected files accordingly. (I removed join_1.out because it's not clear if it still applies; we can add back any variant versions as they are shown to be needed.) Tom Lane 2004-12-01 19:00:56 +00:00
  • b7bcea64ec Add: Bruce Momjian 2004-12-01 17:39:18 +00:00
  • 7f20a59201 Update with Gavin's additions. Bruce Momjian 2004-12-01 17:21:58 +00:00
  • 4b9a12b1e9 Remove question mark on COPY CSV fix: Bruce Momjian 2004-11-30 22:15:21 +00:00
  • a6c1377085 Add \n to end of output for psql \s with no history file name. Bruce Momjian 2004-11-30 20:00:34 +00:00
  • f02a21b19b Update Turkish FAQ. Bruce Momjian 2004-11-30 19:42:38 +00:00
  • 8b9a9c9a68 Removed: Bruce Momjian 2004-11-30 19:32:24 +00:00
  • f44c64c727 Quote SHELL arguments only on Win32. Bruce Momjian 2004-11-30 19:01:28 +00:00
  • ff5b6c98bf Add: Bruce Momjian 2004-11-30 18:20:35 +00:00
  • aef2d0d86c Fix readline/libedit selection code to prefer readline over libedit reliably (ie, regardless of which libraries they depend on). Also make sure that we don't select headers that obviously belong to the wrong one of the two libraries. This was discussed back around 4-Sep but seems to have slipped through the cracks. The header selection could be checked more closely, perhaps, but let's see if this is good enough. Tom Lane 2004-11-30 06:13:04 +00:00
  • c3df447a03 Update wording: Bruce Momjian 2004-11-30 05:06:33 +00:00
  • 89d922b190 Updated TODO list description: Bruce Momjian 2004-11-30 05:03:47 +00:00
  • 0548046e12 Add: Bruce Momjian 2004-11-30 04:33:14 +00:00
  • 72cf815c0a Add: Bruce Momjian 2004-11-30 03:53:00 +00:00
  • 16c46870b7 Fix a few typos in comments. Neil Conway 2004-11-30 03:50:29 +00:00
  • 844cb60f1a Add: Bruce Momjian 2004-11-30 03:27:10 +00:00
  • af434fcdf4 Update plperl to use ereport() not elog() for user-facing messages, so that they will be translatable. Give messages some semblance of conformance to the style guide. Tom Lane 2004-11-29 20:11:06 +00:00
  • 71929165e8 Add: < > * Allow cross-compiling by generating the zic database on the target system Bruce Momjian 2004-11-29 03:17:30 +00:00
  • 66cd815063 Clean up initdb's error handling so that it prints something more useful than just \'failed\' when there's a problem. Per gripe from Chris Albertson. Tom Lane 2004-11-29 03:05:03 +00:00
  • b2fcef64af Update Turkish FAQ. Bruce Momjian 2004-11-29 03:04:31 +00:00
  • 5548122829 Add comment explaining possible compiler warning: Bruce Momjian 2004-11-29 03:01:54 +00:00
  • eeed2274e5 Add: Bruce Momjian 2004-11-29 02:29:28 +00:00
  • 86c8cc6d22 Typo fixes. Bruce Momjian 2004-11-29 01:58:10 +00:00
  • ee814b4511 Have initdb display relative paths to start postmaster if used to invoke initdb, and display in a path-native way. Bruce Momjian 2004-11-29 01:14:45 +00:00
  • db086aa962 Make pg_dumplo schema-aware. Karel Zak Tom Lane 2004-11-28 23:49:49 +00:00
  • 0b9f48daf2 Avoid scribbling on original parsetree during DECLARE CURSOR. This prevents problems when the DECLARE is in a portal and is executed repeatedly, as is possible in v3 protocol. Per analysis by Oliver Jowett, though I didn't use his patch exactly. Tom Lane 2004-11-28 22:16:49 +00:00
  • 839484f9f5 Avoid scribbling on original parsetree during DECLARE CURSOR. This prevents problems when the DECLARE is in a portal and is executed repeatedly, as is possible in v3 protocol. Per analysis by Oliver Jowett, though I didn't use his patch exactly. Tom Lane 2004-11-28 22:16:31 +00:00
  • 3ad9f45c89 Add description: Bruce Momjian 2004-11-28 05:12:19 +00:00
  • 2ba6cbc358 Mega-clarifications from Joachim Wieland. Bruce Momjian 2004-11-28 04:56:04 +00:00
  • 99b735cc03 Work around lack of NLS support in libpgport by making those components who use it scan the relevant source files for their own catalog. It creates a bit of duplicate work for translators, but it gets the job done for now. Peter Eisentraut 2004-11-27 22:44:15 +00:00
  • a420b76ca5 Correctly name the Windows operating systems Peter Eisentraut 2004-11-27 21:56:05 +00:00
  • 49cbef7947 Update of conformance information to SQL:2003 by Troels Arvin, Simon Riggs, Elein Mustain Peter Eisentraut 2004-11-27 21:27:08 +00:00
  • 90c3ebe4d7 Fix HAVE_OPTRESET to be HAVE_INT_OPTRESET. Typos spotted by Lorne Sunley. Tom Lane 2004-11-27 18:51:08 +00:00
  • 77ab4761ad Add web development faq item. Bruce Momjian 2004-11-27 06:02:53 +00:00
  • df21a52950 Add mention of Cygwin. Update version number. Bruce Momjian 2004-11-27 05:15:21 +00:00
  • 3aa9776d95 Add to CPPFLAGS/CFLAGS in template files, don't over-ride them. Bruce Momjian 2004-11-27 05:03:26 +00:00
  • b82323e05e This adds mention of my latest tweak to the tsearch2/pg_trgm integration. It is much better to create a word list of unstemmed words than stemmed ones. Tom Lane 2004-11-27 00:01:02 +00:00
  • c2e5631760 RelOptInfo.pages should really be declared as BlockNumber, not long. Tom Lane 2004-11-26 21:08:35 +00:00
  • f5778c63e5 Install Tcl regex fixes to sync our regex engine with Tcl 8.4.8 (up from 8.4.1). This corrects some curious regex bugs, though not the greediness issue I was hoping to find a solution for :-( Tom Lane 2004-11-24 22:57:09 +00:00
  • d4c4d28427 Install Tcl regex fixes to sync our regex engine with Tcl 8.4.8 (up from 8.4.1). This corrects some curious regex bugs, though not the greediness issue I was hoping to find a solution for :-( Tom Lane 2004-11-24 22:56:54 +00:00
  • 38929bc06a Our interface code for Spencer's regexp package was checking for regexp error conditions during regexp compile, but not during regexp execution; any sort of "can't happen" errors would be treated as no-match instead of being reported as they should be. Noticed while trying to duplicate a reported Tcl bug. Tom Lane 2004-11-24 22:44:27 +00:00
  • 236404fcd1 Our interface code for Spencer's regexp package was checking for regexp error conditions during regexp compile, but not during regexp execution; any sort of "can't happen" errors would be treated as no-match instead of being reported as they should be. Noticed while trying to duplicate a reported Tcl bug. Tom Lane 2004-11-24 22:44:07 +00:00
  • cf796cc702 A client_encoding specification coming from the connection request has to be processed by GUC before InitPostgres, because any required lookup of the encoding conversion function has to be done during InitializeClientEncoding. So, I broke this last week by moving GUC processing to after InitPostgres :-(. What we can do as a compromise is process non-SUSET variables during command line scanning (the same as before), and postpone the processing of only SUSET variables. None of the SUSET variables need to be set before InitPostgres. Tom Lane 2004-11-24 19:51:05 +00:00
  • 5597fee8d7 Avoid getting bit by roundoff error while checking $Safe::VERSION. Per report from Mark Kirkwood. Tom Lane 2004-11-24 18:47:38 +00:00
  • e17766c12e Trivial fix for a bug introduced in r1.94 of help.c: we want to only include "\s" in \? output when readline is enabled, but that commit supressed "\s" whether readline was enabled or not. Neil Conway 2004-11-24 04:58:42 +00:00
  • 4acc97d7e4 Assert that BufferIsPinned() in IncrBufferRefCount(), rather than using a home-brewed combination of assertions that boiled down to the same thing. Neil Conway 2004-11-24 02:56:17 +00:00
  • dec2c77c1f Prevent pgcrypto from successfully compiling if no valid random source has been defined. Previously, pgcrypto would compile but would be unusable. Neil Conway 2004-11-23 23:44:08 +00:00
  • 2663e0c2e9 New translations Peter Eisentraut 2004-11-23 23:13:26 +00:00
  • 98f5efe774 Translation updates Peter Eisentraut 2004-11-23 22:16:04 +00:00
  • fab33917f4 Clean files generated by htmlhelp target. Peter Eisentraut 2004-11-23 21:41:24 +00:00
  • a4cf1ba6a1 Add htmlhelp stylesheet and build target. Peter Eisentraut 2004-11-23 16:27:59 +00:00
  • 28e9b26f4d Further plperl cleanup: be more paranoid about checking the type of data returned from Perl. Consolidate multiple bits of code to convert a Perl hash to a tuple, and drive the conversion off the keys present in the hash rather than the tuple column names, so we detect error if the hash contains keys it shouldn't. (This means keys not in the hash will silently default to NULL, which seems ok to me.) Fix a bunch of reference-count leaks too. Tom Lane 2004-11-23 00:21:24 +00:00
  • 25fcfdf6f4 The beginnings of a regression test for plperl. Right now it only covers return value processing, but that was the most broken stuff... Tom Lane 2004-11-22 20:32:59 +00:00
  • f5206262c8 Try to instill some sanity in plperl's function result processing. Get rid of static variables for SETOF result, don't crash when called from non-FROM context, eliminate dead code, etc. Tom Lane 2004-11-22 20:31:53 +00:00
  • 90f6f4b4b4 Fix typo in release notes. Michael Fuhr. Neil Conway 2004-11-22 07:30:22 +00:00
  • 5776feab0a update us to beta5 REL8_0_0BETA5 PostgreSQL Daemon 2004-11-22 03:06:35 +00:00
  • de8113fcdb Update release notes for recent changes; also minor editorialization. Tom Lane 2004-11-22 00:37:59 +00:00
  • 294c34bb9d Fix rounding problem in dynahash.c's decision about when the target fill factor has been exceeded. We usually run with ffactor == 1, but the way the test was coded, it wouldn't split a bucket until the actual fill factor reached 2.0, because of use of integer division. Change from > to >= so that it will split more aggressively when the table starts to get full. Tom Lane 2004-11-21 22:57:00 +00:00
  • 7f1711f29d Reduce the default size of the PortalHashTable in order to save a few cycles during transaction exit. A typical session probably wouldn't have as many as half a dozen portals open at once, so the original value of 64 seems far larger than needed. Tom Lane 2004-11-21 22:48:01 +00:00
  • 183e8b911c While fixing plperl and pltcl, I realized plpgsql wasn't doing subtransactions quite right either: the ReleaseCurrentSubTransaction call should occur inside the PG_TRY, so that the proper path is taken if an error occurs during subtransaction commit. This assumes that AbortSubTransaction can cope with the state left behind if CommitSubTransaction fails partway through, but we were already requiring that. Tom Lane 2004-11-21 22:27:34 +00:00
  • 32c97fd58f Suppress remaining compile warnings, and add a comment about why it's not really broken. Andrew Dunstan Tom Lane 2004-11-21 22:13:37 +00:00
  • 35f4994133 Fix plperl and pltcl error handling per my previous proposal. SPI operations are now run as subtransactions, so that errors in them can be reported as ordinary Perl or Tcl errors and caught by the normal error handling convention of those languages. Also do some minor code cleanup in pltcl.c: extract a large chunk of duplicated code in pltcl_SPI_execute and pltcl_SPI_execute_plan into a shared subroutine. Tom Lane 2004-11-21 21:17:07 +00:00
  • a3b663dfea Fix typo. Bruce Momjian 2004-11-20 22:28:39 +00:00
  • c584103f56 Patch of 2004-03-30 corrected date_part(timestamp) for extracting the year from a BC date, but failed to make the same fix in date_part(timestamptz). Tom Lane 2004-11-20 22:12:44 +00:00
  • 19dacd4492 Fix typo, per Bruno Wolff. Tom Lane 2004-11-20 21:44:24 +00:00
  • a34d76ef65 Fix up makefile dependencies for pg_config_paths.h. Tom Lane 2004-11-20 21:13:06 +00:00
  • 3e3f283e31 Avoid scanning the relcache during AtEOSubXact_RelationCache when there is nothing to do, which is most of the time. This is another simple improvement to cut subtransaction entry/exit overhead. Tom Lane 2004-11-20 20:19:52 +00:00
  • 8ecbc46bdb Reduce the default size of the local lock hash table. There's usually no need for it to be nearly as big as the global hash table, and since it's not in shared memory it can grow if it does need to be bigger. By reducing the size, we speed up hash_seq_search(), which saves a significant fraction of subtransaction entry/exit overhead. Tom Lane 2004-11-20 20:16:54 +00:00
  • 193a97c2d3 Fix plperl's elog() function to convert elog(ERROR) into Perl croak(), rather than longjmp'ing clear out of Perl and thereby leaving Perl in a broken state. Also some minor prettification of error messages. Still need to do something with spi_exec_query() error handling. Tom Lane 2004-11-20 19:07:40 +00:00
  • d5013ab50f Fix one more place where we were expecting lcons() to be nondestructive to the original List; per report from Sebastian BÎck. I think this is the last such bug --- I examined every lcons() call in the backend and the rest seem OK --- but it's nervous-making that we're still finding 'em so many months after the List rewrite went in. Tom Lane 2004-11-20 17:59:31 +00:00
  • 0b5c72d9ba On some HPUX versions/hardware, it seems we need to include libgcc.a in the regression test shared libraries. Tom Lane 2004-11-20 03:52:00 +00:00
  • 83fea34b5b Fix unportable isdigit() call --- must cast arg to unsigned char. Tom Lane 2004-11-20 02:09:47 +00:00
  • 8a7025f0bb Move pgstat_report_tabstat() call so that stats are not reported to the collector until the transaction commits. Per recent discussion, this should avoid confusing autovacuum when an updating transaction runs for a long time. Tom Lane 2004-11-20 00:48:58 +00:00
  • e719591ea3 Make sure we produce a useful error message for the case where the postgresql.crt file simply isn't there, too. Tom Lane 2004-11-20 00:35:13 +00:00
  • 7506677b62 Improve error reporting for SSL connection failures. Remove redundant free operations in client_cert_cb --- openssl will also attempt to free these structures, resulting in core dumps. Tom Lane 2004-11-20 00:18:18 +00:00
  • 88969ea11a Fix incorrect documentation of plperl's method for accessing the number of rows processed by a SPI query (David Fetter); also some other minor editorial cleanup (Tom Lane). Tom Lane 2004-11-19 23:22:54 +00:00
  • 8e57975219 Clean up rpath handling for HPUX --- we can't use the cc-style rpath switch syntax when calling ld directly. Tom Lane 2004-11-19 21:27:42 +00:00
  • 466fb06739 Set rpath for plperl and plpython to ensure we can find the .so files for the languages even when not installed in a standard directory. pltcl may need this treatment as well, but we don't have the right path conveniently available, so I'll leave it alone as long as there aren't actual reports of trouble. Tom Lane 2004-11-19 19:23:01 +00:00
  • a9ddd649df Modify the platform-specific makefiles so that macro 'rpath' is defined in terms of macro 'rpathdir', as I proposed a few weeks ago. In itself this commit shouldn't change the behavior at all, but it opens the door to using special rpaths for the PL shared libraries, as seems to be needed for plperl in particular. Tom Lane 2004-11-19 00:41:39 +00:00
  • b6038484f8 Fix memory clobber problem reported by John Hansen: plperl_safe_init() may expand the Perl stack, therefore we must SPAGAIN to reload the local stack pointer after calling it. Also a couple other marginal readability improvements. Tom Lane 2004-11-18 21:35:42 +00:00