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

Commit Graph

  • d707495452 Fix thinko in recent patch to change temp-table permissions behavior: this is an aclmask function and does not have the same return convention as aclcheck functions. Also adjust the behavior so that users without CREATE TEMP permission still have USAGE permission on their session's temp schema. This allows privileged code to create a temp table and make it accessible to code that's not got the same privilege. (Since the default permissions on a table are no-access, an explicit grant on the table will still be needed; but I see no reason that the temp schema itself should prohibit such access.) Tom Lane 2004-05-28 16:17:14 +00:00
  • a6ea6457fa Stat function now can show statistics per weight of lexemes Teodor Sigaev 2004-05-28 15:36:49 +00:00
  • 1b9ef0025d Fix some typos I introduced in WIN32-only code late last night. Thanks to Thomas Hallgren. Tom Lane 2004-05-28 15:14:03 +00:00
  • 42d069886f New version. Add support for int2, int8, float4, float8, timestamp with/without time zone, time with/without time zone, date, interval, oid, money and macaddr, char, varchar/text, bytea, numeric, bit, varbit, inet/cidr types for GiST Teodor Sigaev 2004-05-28 10:43:32 +00:00
  • 1a321f26d8 Code review for EXEC_BACKEND changes. Reduce the number of #ifdefs by about a third, make it work on non-Windows platforms again. (But perhaps I broke the WIN32 code, since I have no way to test that.) Fold all the paths that fork postmaster child processes to go through the single routine SubPostmasterMain, which takes care of resurrecting the state that would normally be inherited from the postmaster (including GUC variables). Clean up some places where there's no particularly good reason for the EXEC and non-EXEC cases to work differently. Take care of one or two FIXMEs that remained in the code. Tom Lane 2004-05-28 05:13:32 +00:00
  • 37da0ba0e0 Seems we forgot the installdirs target in this makefile. Tom Lane 2004-05-28 03:53:33 +00:00
  • 2ac8c96ecb Make sure elog behaves sanely if invoked before GUC initializes. Tom Lane 2004-05-28 03:11:15 +00:00
  • d7013b0f15 On WIN32, don't choke when setlocale(LC_MESSAGES, "") returns NULL. Per report from Magnus. Tom Lane 2004-05-27 19:19:05 +00:00
  • 16974ee910 Get rid of the former rather baroque mechanism for propagating the values of ThisStartUpID and RedoRecPtr into new backends. It's a lot easier just to make them all grab the values out of shared memory during startup. This helps to decouple the postmaster from checkpoint execution, which I need since I'm intending to let the bgwriter do it instead, and it also fixes a bug in the Win32 port: ThisStartUpID wasn't getting propagated at all AFAICS. (Doesn't give me a lot of faith in the amount of testing that port has gotten.) Tom Lane 2004-05-27 17:12:57 +00:00
  • bb44a7c525 pgindent files for Tom. Bruce Momjian 2004-05-27 15:07:41 +00:00
  • 83526ccf06 Cleanup for Win32 pgkill. Bruce Momjian 2004-05-27 14:39:33 +00:00
  • 6f21f4adaa Move pgkill out into /port so pg_ctl can use it on Win32. Bruce Momjian 2004-05-27 13:08:57 +00:00
  • d157b7bbc7 Document new pg_ctl 'kill' command, specificially for Win32. Bruce Momjian 2004-05-27 03:50:25 +00:00
  • f3d6d948c7 Change pg_ctl to be in C. This was the final shell script and is helpful for the Win32 port. Bruce Momjian 2004-05-27 03:37:55 +00:00
  • c792cbcc26 Recommend ALTER TABLE ... TYPE as the best way to reclaim space occupied by deleted columns. The old method involving UPDATE and VACUUM FULL will be considerably less efficient. Tom Lane 2004-05-27 03:30:11 +00:00
  • 92b0b080eb Add an index entry for "Performance Tips". Patch from Alvaro Herrera. Neil Conway 2004-05-27 01:00:40 +00:00
  • 4646a8f32f Reduce the minimum allocable chunk size to 8 bytes (from 16). Now that ListCells are only 8 bytes instead of 12 (on 4-byte-pointer machines anyway), it's worth maintaining a separate freelist for 8-byte objects. Remembering that alloc chunks carry 8 bytes of overhead, this should reduce the net storage requirement for a long List by about a third. Tom Lane 2004-05-26 19:44:15 +00:00
  • 0858ed20d2 A couple other cosmetic cleanups in new List stuff. Tom Lane 2004-05-26 19:30:17 +00:00
  • 437063bdc4 Move setlocale() outside of NLS-only defines. Bruce Momjian 2004-05-26 19:00:31 +00:00
  • d96c374648 Use new forboth() macro to make loop coding a bit clearer. Tom Lane 2004-05-26 18:54:08 +00:00
  • ffef9b8c50 AIX doc addition: Bruce Momjian 2004-05-26 18:51:43 +00:00
  • 84b64ab569 Fix problems in pg_autovacuum: Bruce Momjian 2004-05-26 18:48:37 +00:00
  • b5cf1b6a21 Fix problems in pg_autovacuum: Bruce Momjian 2004-05-26 18:48:25 +00:00
  • 1cf9d7bd24 Renumber to prevent duplicate oids. Update catalog version. Bruce Momjian 2004-05-26 18:37:33 +00:00
  • 97d625dd1c *) inet_(client|server)_(addr|port)() and necessary documentation for the four functions. Bruce Momjian 2004-05-26 18:35:51 +00:00
  • 51227f8d9d Use a cleaner substitute for the inability to apply length() to the tail of a list. Per private discussion with Neil. Tom Lane 2004-05-26 18:35:41 +00:00
  • c924c065cd [ Backpatch to 7.4.X.] Bruce Momjian 2004-05-26 18:27:23 +00:00
  • 0d5364fd98 Fix problem with doing 7.0.X dumps on character varying[] fields. Bruce Momjian 2004-05-26 18:24:22 +00:00
  • 4807619251 Renumber bit/boolean aggregates to remove duplicates. Bruce Momjian 2004-05-26 18:14:36 +00:00
  • fafd5640d1 Recent commits added created files that weren't getting deleted by 'make clean'. Tom Lane 2004-05-26 17:24:07 +00:00
  • f6c5da977c Add <limits.h>, per Magnus. Tom Lane 2004-05-26 16:16:03 +00:00
  • 8096fe45ce The added aggregates are: Bruce Momjian 2004-05-26 15:26:28 +00:00
  • 3dc37cd8d6 The patch adresses the TODO list item "Allow external interfaces to extend the GUC variable set". Bruce Momjian 2004-05-26 15:07:41 +00:00
  • cfbfdc557d This patch implement the TODO [ALTER DATABASE foo OWNER TO bar]. It was necessary to touch in grammar and create a new node to make home to the new syntax. The command is also supported in E CPG. Doc updates are attached too. Only superusers can change the owner of the database. New owners don't need any aditional privileges. Bruce Momjian 2004-05-26 13:57:04 +00:00
  • d0b4399d81 Reimplement the linked list data structure used throughout the backend. Neil Conway 2004-05-26 04:41:50 +00:00
  • 18d0d10563 Please apply this minor patch to the cvs HEAD of dbmirror Jan Wieck 2004-05-26 00:08:26 +00:00
  • f240d37229 Add FRONTEND to ecpglib. Bruce Momjian 2004-05-25 21:20:44 +00:00
  • 2a70ec1bdf Allow relative paths as long as the hardcoded path matches the bin path up to the last bin directory name. Bruce Momjian 2004-05-25 20:47:41 +00:00
  • bfb77c15ca Tweaks per discussion with Magnus: suppress chatter on unpatched MinGW systems, add verbose logging (at DEBUG4) to help identify why a given time zone is not matched. Tom Lane 2004-05-25 19:46:21 +00:00
  • 360dcb1341 Fix erroneous error message printout when a configuration file contains an overlength token. Printout was always garbage and could dump core entirely :-(. Per report from Martin Pitt. Tom Lane 2004-05-25 19:11:26 +00:00
  • 957b90ed6a Fix erroneous error message printout when a configuration file contains an overlength token. Printout was always garbage and could dump core entirely :-(. Per report from Martin Pitt. Tom Lane 2004-05-25 19:11:14 +00:00
  • c826991dd7 Fix set_pglocale to properly pass my_exec_path to get_locale_path instead of argv0. Bruce Momjian 2004-05-25 18:18:29 +00:00
  • 76c50c080b Add code to identify_system_timezone() to try all zones in the zic database, not just ones that we cons up POSIX names for. This looks grim but it seems to take less than a second even on a relatively slow machine, and since it only happens once during postmaster startup, that seems acceptable. Tom Lane 2004-05-25 18:08:59 +00:00
  • 17ff18141c Add exec.c to ecpg library because path.c now uses it. Bruce Momjian 2004-05-25 17:35:51 +00:00
  • 88ca65d76b Skip settting LC_ALL in the backend. Bruce Momjian 2004-05-25 01:42:08 +00:00
  • 228897774c Make the locale location relocatable. Bruce Momjian 2004-05-25 01:00:30 +00:00
  • 244ee0c0f2 Remove pstrdup() call from exec.c because DLLIMPORT flag on CurrentMemoryContext caused compile problems. Bruce Momjian 2004-05-24 22:35:37 +00:00
  • fcbc95b9a2 Make validate_exec take a const char *, for gcc 3.4, which is more strict. Bruce Momjian 2004-05-24 20:23:50 +00:00
  • daac2d2c48 Update Russian FAQ. Bruce Momjian 2004-05-24 15:14:52 +00:00
  • 2b3f6ecdf5 Clarify an entry in the 7.4 release notes. Neil Conway 2004-05-24 04:54:22 +00:00
  • ffd1880bb4 Add: Bruce Momjian 2004-05-24 03:23:00 +00:00
  • 3661d1d6e0 This patch fixes the find_my_exec code for pgstat backends. Required for TZ stuff (and possibly others) to work in the pgstat backends. Bruce Momjian 2004-05-24 02:47:47 +00:00
  • dc39937762 Rewrite identify_system_timezone() to give it better-than-chance odds of correctly identifying the system's daylight-savings transition rules. This still begs the question of how to look through the zic database to find a matching zone definition, but at least now we'll have some chance of recognizing the match when we find it. Tom Lane 2004-05-24 02:30:29 +00:00
  • 82695df3b7 Remove a few $filter() calls that were not needed. Bruce Momjian 2004-05-24 01:01:38 +00:00
  • 17edb84056 Seems we had the wrong sign convention for the default Etc/GMTx zone names. Per report from Alvaro. Tom Lane 2004-05-23 23:26:53 +00:00
  • 9e0fcc2ad5 Avoid calling select_default_timezone() when backing out an unwanted TZ setting. This is a temporary kluge to keep Alvaro happy; eventually we should fix the TZ library API to make the problem really go away. Tom Lane 2004-05-23 23:12:11 +00:00
  • f9df1b28e8 Use case-insensitive comparison so that explicitly setting timezone=unknown in postgresql.conf does the right thing. variable.c got this right, but not pgtz.c ... Tom Lane 2004-05-23 22:24:08 +00:00
  • 256d4639c9 A few cosmetic fixes and code cleanup. Neil Conway 2004-05-23 22:20:10 +00:00
  • 9d6570b8a4 New two-stage sampling method for ANALYZE, as per discussions a few weeks ago. This should give significantly better results when the density of live tuples is not uniform throughout a table. Manfred Koizar, with minor kibitzing from Tom Lane. Tom Lane 2004-05-23 21:24:02 +00:00
  • 27edff700e Still another place to make the world safe for zero-column tables: remove the ancient (and always pretty dodgy) assumption in parse_clause.c that a query can't have an empty targetlist. Tom Lane 2004-05-23 17:10:54 +00:00
  • a712570880 Make --without-docdir configure option actually work, per Manfred. Tom Lane 2004-05-23 15:24:32 +00:00
  • 5fc1046f2f Fix broken markup. Tom Lane 2004-05-23 15:13:43 +00:00
  • ebfc56d3fb Handle impending sinval queue overflow by means of a separate signal (SIGUSR1, which we have not been using recently) instead of piggybacking on SIGUSR2-driven NOTIFY processing. This has several good results: the processing needed to drain the sinval queue is a lot less than the processing needed to answer a NOTIFY; there's less contention since we don't have a bunch of backends all trying to acquire exclusive lock on pg_listener; backends that are sitting inside a transaction block can still drain the queue, whereas NOTIFY processing can't run if there's an open transaction block. (This last is a fairly serious issue that I don't think we ever recognized before --- with clients like JDBC that tend to sit with open transaction blocks, the sinval queue draining mechanism never really worked as intended, probably resulting in a lot of useless cache-reset overhead.) This is the last of several proposed changes in response to Philip Warner's recent report of sinval-induced performance problems. Tom Lane 2004-05-23 03:50:45 +00:00
  • 4d86ae4260 For multi-table ANALYZE, use per-table transactions when possible (ie, when not inside a transaction block), so that we can avoid holding locks longer than necessary. Per trouble report from Philip Warner. Tom Lane 2004-05-22 23:14:38 +00:00
  • 05ce2d738f Reduce pg_listener lock taken by NOTIFY et al from AccessExclusiveLock to ExclusiveLock. This still serializes the operations of this module, but doesn't conflict with concurrent ANALYZE operations. Per trouble report from Philip Warner a few weeks ago. Tom Lane 2004-05-22 21:58:41 +00:00
  • e26c403fd0 Reduce pg_listener lock taken by NOTIFY et al from AccessExclusiveLock to ExclusiveLock. This still serializes the operations of this module, but doesn't conflict with concurrent ANALYZE operations. Per trouble report from Philip Warner a few weeks ago. Tom Lane 2004-05-22 21:58:24 +00:00
  • 323a45099a Fix to install correctly in vpath build case. Tom Lane 2004-05-22 21:02:32 +00:00
  • bfa1171c84 Fix a few more minor errors in the 7.4 release notes. Neil Conway 2004-05-22 11:06:55 +00:00
  • 76e70108e7 Fix typo in an entry in the 7.4 release notes. Neil Conway 2004-05-22 09:48:15 +00:00
  • b1ea9811b3 Fix for vpath builds. Tom Lane 2004-05-22 02:15:08 +00:00
  • 4fb9aa43f6 Clean up failure to remove exec.o on 'make clean'. Tom Lane 2004-05-22 02:14:28 +00:00
  • 3983869439 Use wide-character library routines, if available, for upper/lower/initcap functions. This allows these functions to work correctly with Unicode and other multibyte encodings. Per prior discussion. Tom Lane 2004-05-22 00:34:51 +00:00
  • add8b70dda Handle inclusion of port modules 'correctly', viz the same way libpq does it. Fixes OS X, which needs path.c. It may be that Win32 needs some more port modules, but they are easily added. Tom Lane 2004-05-21 21:56:02 +00:00
  • d584db6086 pgindent did a pretty awful job on the timezone code, particularly with respect to doubly-starred comment blocks. Do some manual cleanup. Tom Lane 2004-05-21 20:59:10 +00:00
  • 13f96c4b6b Put path configuration information into a .h file instead of cluttering several different module Makefiles with it. Also, do any adjustment of installation paths during configure, rather than every time Makefile.global is read. Tom Lane 2004-05-21 20:56:50 +00:00
  • 748a15a8ea Probably need sys/time.h here too to be safe. Tom Lane 2004-05-21 16:22:38 +00:00
  • e6319d1d28 Put back #include <sys/time.h> in files that seem to need it on Linux. Tom Lane 2004-05-21 16:08:47 +00:00
  • ff0b706b13 Fix random breakage in exec.c for platforms where strdup is a macro. Tom Lane 2004-05-21 16:06:23 +00:00
  • 962c362495 Fixed DEALLOCATE PREPARE to use correct function call Michael Meskes 2004-05-21 13:50:59 +00:00
  • 79c3bf4984 - Fixed DEALLOCATE PREPARE to use correct function call - Made sure connect statement does not accept single char variable, but only strings. Michael Meskes 2004-05-21 13:50:12 +00:00
  • 0a19fb42c2 Pgindent timezone file, per request from Tom. Bruce Momjian 2004-05-21 12:30:25 +00:00
  • 63bd0db121 Integrate src/timezone library for all platforms. There is more we can and should do now that we control our own destiny for timezone handling, but this commit gets the bulk of the picayune diffs in place. Magnus Hagander and Tom Lane. Tom Lane 2004-05-21 05:08:06 +00:00
  • 260b513fc3 Add mention of why -lpgport is needed in ecpglib (dllwrap). Bruce Momjian 2004-05-21 03:12:03 +00:00
  • 928e73ea62 Add -lpgport to ecpglib link only on win32. Other platforms have problems with it. Bruce Momjian 2004-05-21 03:10:47 +00:00
  • 9bfee3adee Revert addition of -lpgport, which breaks the build on platforms that are sticky about non-PIC code in shared libraries. Windows will have to find another solution (probably similar to the way libpq does it). Tom Lane 2004-05-21 00:14:38 +00:00
  • 58c42f37ab benign change ...added space to end of line PostgreSQL Daemon 2004-05-20 23:49:41 +00:00
  • a551c3d0f5 attempt at a multi file commit, to seee how it formats PostgreSQL Daemon 2004-05-20 22:54:19 +00:00
  • ee20fd4621 just testing activitymail ... only added a space here so that the commit would pick it up PostgreSQL Daemon 2004-05-20 22:44:16 +00:00
  • 7d717f2471 Rename static variables to avoid possible name conflicts on systems with dirty standard headers (eg AIX). Tom Lane 2004-05-20 17:13:52 +00:00
  • 40296aa2ec Remove pyton, spell check fix: Bruce Momjian 2004-05-20 16:36:14 +00:00
  • 8027065660 Updates from Tom: Bruce Momjian 2004-05-20 15:57:26 +00:00
  • 3255851e6a Small variable rename in exec.c. Bruce Momjian 2004-05-20 15:38:11 +00:00
  • ceceeffe1e Clean up find_my_exec to work cleaner. Bruce Momjian 2004-05-20 15:35:41 +00:00
  • 868404b859 Fix speling. Tom Lane 2004-05-20 15:07:30 +00:00
  • bb206b6dce Update SCO FAQ. Bruce Momjian 2004-05-20 04:19:26 +00:00
  • 3e485d0ea1 Add: Bruce Momjian 2004-05-20 04:10:44 +00:00
  • 4714dcb06c Remove item: Bruce Momjian 2004-05-20 03:27:16 +00:00
  • 5f55347e33 Add: Bruce Momjian 2004-05-20 02:58:18 +00:00
  • f92630bdca Add: Bruce Momjian 2004-05-20 02:07:50 +00:00
  • 0ca0099139 Add: Bruce Momjian 2004-05-20 02:01:00 +00:00