Commit Graph

  • 7703e55c32 Make the default pg_hba.conf include an entry for ::1 only if configure set HAVE_IPV6. Per recent discussions. Tom Lane 2003-09-07 03:36:03 +00:00
  • f4ed650996 load_file() has to remove pre-existing shlibs that match the new file on either name or inode; otherwise load_external_function() won't do anything. At least on Linux, it appears that recompiling a shlib leads to a new file with a different inode, so the old code failed to detect a match. Tom Lane 2003-09-07 02:18:01 +00:00
  • 3e20a72603 Make all valid uses of the COLLATE clause yield the same result: a syntax error. There is no point in providing some kind of forward compatibility now, because no one can tell what a future implementation will look like. Peter Eisentraut 2003-09-06 14:01:51 +00:00
  • 4060f07578 Rename variables for clarity. Bruce Momjian 2003-09-06 01:41:56 +00:00
  • 92aa462247 Second try at IPv4-to-v6 mapping code; avoid assuming that the struct returned by getaddrinfo_all will have enough room for an IPv6 address. Tom Lane 2003-09-05 23:07:21 +00:00
  • 3c9bb8886d Allow IPv4-format entries in pg_hba.conf to match IPv6 connections that have IPv4-embedded-in-IPv6 addresses. Per idea of Andreas Pflug. Tom Lane 2003-09-05 20:31:36 +00:00
  • 23d07fa357 Done: Bruce Momjian 2003-09-05 19:52:10 +00:00
  • e26af972b5 ifdef out pqGetpwuid() because Win32 doesn't have struct passwd. Bruce Momjian 2003-09-05 17:43:40 +00:00
  • cec1333bba Add WIN32 URL. Bruce Momjian 2003-09-05 16:43:13 +00:00
  • ba7ee1db3b Add missing space. Tom Lane 2003-09-05 16:13:38 +00:00
  • 702c91b4ff This fixes three minor typos in hba.c. Bruce Momjian 2003-09-05 03:57:13 +00:00
  • b0ba70df83 Update information about Linux's overcommit memory behavior. Bruce Momjian 2003-09-05 02:54:09 +00:00
  • 5b49f9025a Add: Bruce Momjian 2003-09-05 02:51:55 +00:00
  • 04aabb034f Clean up WIN32_CONSOLE code. Bruce Momjian 2003-09-05 02:31:10 +00:00
  • 248af40d6d Update as done: Bruce Momjian 2003-09-05 02:20:50 +00:00
  • 2dc9437160 Enable Win32 to compile libpq again, and enable SSL compiles on that platform. Bruce Momjian 2003-09-05 02:08:36 +00:00
  • 1709fde56a Improve prototype casting for thread calls. Bruce Momjian 2003-09-05 01:53:41 +00:00
  • 8ac3510a4c Add: Bruce Momjian 2003-09-05 01:10:07 +00:00
  • 8af31863e9 Add: Bruce Momjian 2003-09-05 00:50:40 +00:00
  • 7a3693716d Reimplement hash index locking algorithms, per my recent proposal to pghackers. This fixes the problem recently reported by Markus KrÌutner (hash bucket split corrupts the state of scans being done concurrently), and I believe it also fixes all the known problems with deadlocks in hash index operations. Hash indexes are still not really ready for prime time (since they aren't WAL-logged), but this is a step forward. Tom Lane 2003-09-04 22:06:27 +00:00
  • ca43f71ca5 Avoid consuming unreasonable amounts of memory when GRANT has many grantees. Tom Lane 2003-09-04 15:53:04 +00:00
  • fe055e9280 Looks like plperl has same bug as pltcl. Tom Lane 2003-09-04 15:16:39 +00:00
  • 9dbfcc2261 Fix some problems with dropped columns in pltcl functions. Tom Lane 2003-09-04 15:10:10 +00:00
  • 6d239ee4b4 Allow non-super users to set log_duration to true, then false, when the administrator has not turned it on, and fix other PGC_USERLIMIT variables. Bruce Momjian 2003-09-04 05:11:20 +00:00
  • b8245766ab Re-upper case CHECKPOINT_SEGMENTS. Bruce Momjian 2003-09-04 03:38:55 +00:00
  • cac43aefd8 Lowercase CHECKPOINT_SEGMENTS. Bruce Momjian 2003-09-04 00:36:46 +00:00
  • adb13f231b Add: Bruce Momjian 2003-09-03 23:01:47 +00:00
  • 38eb18092c Tighten casting of function call pointers for threads. Bruce Momjian 2003-09-03 22:34:08 +00:00
  • ee4ae6ceb2 Add note that a for loop where the lower bound is greater than the upper bound is valid but does nothing. Peter Eisentraut 2003-09-03 22:17:07 +00:00
  • 29a20145fd Pass session_authorization to the client and make psql update its prompt accordingly. Peter Eisentraut 2003-09-03 22:05:09 +00:00
  • 4e85f760e6 Done: Bruce Momjian 2003-09-03 21:27:21 +00:00
  • 4928856fc4 Mark unixware as verified. Bruce Momjian 2003-09-03 20:54:21 +00:00
  • e57c9fa6b8 Add Unixware as verified. Bruce Momjian 2003-09-03 20:51:40 +00:00
  • 1129eab9c7 Update German FAQ. Bruce Momjian 2003-09-03 20:28:14 +00:00
  • 47e6609c54 Mark BSD/OS as verified not needing reentrant function names. Bruce Momjian 2003-09-03 19:40:56 +00:00
  • 2310dd3af2 Add reporting of specificy threading failure functions. Bruce Momjian 2003-09-03 19:36:31 +00:00
  • 4cc247f74b Add test for thread-safeness of libc functions. Bruce Momjian 2003-09-03 19:30:31 +00:00
  • 64b9dfa56f Back-patch the other part of Karel's formatting bug fix. Tom Lane 2003-09-03 19:01:35 +00:00
  • c351729e1e Mark Unixware as not requiring *_r functions. Bruce Momjian 2003-09-03 17:55:43 +00:00
  • b96e32ebf8 Work around ENOTEMPTY being an alias for EEXIST on some platforms. Tom Lane 2003-09-03 15:49:42 +00:00
  • e6d6713ceb Repair problems with to_char() overrunning its input string. From Karel Zak. Tom Lane 2003-09-03 15:00:07 +00:00
  • 5840b89373 Repair problems with to_char() overrunning its input string. From Karel Zak. Tom Lane 2003-09-03 14:59:41 +00:00
  • 5ac2d7c0eb In _bt_check_unique() loop, don't bother applying _bt_isequal() to killed items; just skip to the next item immediately. Only check for key equality when we reach a non-killed item or the end of the index page. This saves key comparisons when there are lots of killed items, as for example in a heavily-updated table that's not been vacuumed lately. Seems to be a win for pgbench anyway. Tom Lane 2003-09-02 22:10:16 +00:00
  • 30b4abf5d0 Remove outdated CLI things. Peter Eisentraut 2003-09-02 21:45:37 +00:00
  • b916cc435a Cause standalone backend (including bootstrap case) to read the GUC config file if it exists. This was already discussed as being a good idea, and now seems the cleanest way to deal with initdb-time failures on machines with small SHMMAX. (The submitted patches instead modified initdb.sh to pass the correct sizing parameters, but that would still leave standalone backends prone to failure later. An admin who needs to use a standalone backend has enough trouble already, he shouldn't have to manually configure its shmem settings...) Tom Lane 2003-09-02 19:04:12 +00:00
  • d70610c4ee Several fixes for hash indexes that involve changing the on-disk index layout; therefore, this change forces REINDEX of hash indexes (though not a full initdb). Widen hashm_ntuples to double so that hash space management doesn't get confused by more than 4G entries; enlarge the allowed number of free-space-bitmap pages; replace the useless bshift field with a useful bmshift field; eliminate 4 bytes of wasted space in the per-page special area. Tom Lane 2003-09-02 18:13:32 +00:00
  • 8b2450c831 Fix a couple typos, add some more comments. Tom Lane 2003-09-02 03:29:01 +00:00
  • 39673ca47b Rewrite hashbulkdelete() to make it amenable to new bucket locking scheme. A pleasant side effect is that it is *much* faster when deleting a large fraction of the indexed tuples, because of elimination of redundant hash_step activity induced by hash_adjscans. Various other continuing code cleanup. Tom Lane 2003-09-02 02:18:38 +00:00
  • 5f65345a57 Do not pass server_encoding to the client. Peter Eisentraut 2003-09-01 23:04:49 +00:00
  • f10a9033bf Clean up after pygresql removal: adjust/remove documentation and remove unneeded configure work. Peter Eisentraut 2003-09-01 23:01:49 +00:00
  • 65c2d427fb Preliminary cleanup for hash index code (doesn't attack the locking problem yet). Fix a couple of bugs that would only appear if multiple bitmap pages are used, including a buffer reference leak and incorrect computation of bit indexes. Get rid of 'overflow address' concept, which accomplished nothing except obfuscating the code and creating a risk of failure due to limited range of offset field. Rename some misleadingly-named fields and routines, and improve documentation. Tom Lane 2003-09-01 20:26:34 +00:00
  • eaeb8621f8 Add some internals documentation for hash indexes, including an explanation of the remarkably confusing page addressing scheme. The file also includes my planned-but-not-yet-implemented revision of the hash index locking scheme. Tom Lane 2003-09-01 20:24:49 +00:00
  • 2fb6e84bae Add mention of OID wraparound. Bruce Momjian 2003-09-01 16:47:58 +00:00
  • 05f4b03b23 Fixed two bugs in pgtypes library. Michael Meskes 2003-09-01 12:37:40 +00:00
  • 11c2f1900a Rename DoIt to changeVar, for clarity. Bruce Momjian 2003-09-01 04:15:51 +00:00
  • defc7a972d Translation update Peter Eisentraut 2003-08-31 17:38:06 +00:00
  • c326d8f4f2 Add/edit index entries. Peter Eisentraut 2003-08-31 17:32:24 +00:00
  • cf8e916968 Set LC_ALL=C when running collateindex.pl to get predictable sort order. Peter Eisentraut 2003-08-31 17:28:39 +00:00
  • 5a288903b9 Guard against pgindent changing =- to = -. Bruce Momjian 2003-08-30 14:59:34 +00:00
  • ceacae7734 Fix unixware template --- had spaces around equals. Bruce Momjian 2003-08-30 03:19:47 +00:00
  • 7e2a4cfe63 Make documentation of pg_restore's -N, -o, -r switches bear some slight resemblance to their actual behavior. Tom Lane 2003-08-28 20:44:02 +00:00
  • 209a8d63df pg_dump and pg_restore -r had managed to diverge on the ordering of different object types. Fix, and centralize logic to try to prevent the same mistake in future. Tom Lane 2003-08-28 20:21:34 +00:00
  • 80bc61c849 Ensure that FK constraints are dumped after primary/unique constraints, rather than relying on OID order of pg_constraint entries. Per gripe from Greg Stark. Tom Lane 2003-08-28 18:59:06 +00:00
  • ce2ab4131a Fix stupid typo (mine I suppose) in CopyGetData. Per report from Dave Cramer. Tom Lane 2003-08-28 13:52:34 +00:00
  • 61366a9503 More accuracy works with stopwords in queries Teodor Sigaev 2003-08-28 12:23:24 +00:00
  • d1031cdef2 Adjust date/time input parsing code to correctly distinguish the four SQLSTATE error codes required by SQL99 (invalid format, datetime field overflow, interval field overflow, invalid time zone displacement value). Also emit a HINT about DateStyle in cases where it seems appropriate. Per recent gripes. Tom Lane 2003-08-27 23:29:29 +00:00
  • 3722226070 Add "override" for make variable JADEFLAGS, since upper directory passes this variable on the command line. Peter Eisentraut 2003-08-27 22:58:54 +00:00
  • 535980aa40 Major cleanup of SPI chapter Peter Eisentraut 2003-08-27 22:13:35 +00:00
  • 64a32f9df8 Department of second thoughts: can't reorder merge-join clauses. Tom Lane 2003-08-27 12:44:12 +00:00
  • 743f667f00 Update URL for 7.3 changes: Bruce Momjian 2003-08-27 03:35:35 +00:00
  • 14ef1c8603 update to beta2 REL7_4_BETA2 PostgreSQL Daemon 2003-08-27 02:35:38 +00:00
  • f2c2943aae Share PG_DIAG_* macros between client and server and use them internally. Peter Eisentraut 2003-08-27 00:33:34 +00:00
  • 73e3edf2e6 Push subplan clauses to the back in qual lists for join plans, not only scan plans. Per observation from Rod Taylor. Tom Lane 2003-08-26 22:56:51 +00:00
  • 147c16497b Call it Linux, not GNU/Linux. Bruce Momjian 2003-08-26 21:31:11 +00:00
  • 1de9615a58 Use separate SQLSTATE codes for file not found/file exists, rather than lumping them into ERRCODE_UNDEFINED_OBJECT/ERRCODE_DUPLICATE_OBJECT. This seems reasonable since 'object' was meant to refer to 'object in the database' and a file is outside the database. Per request from Dave Cramer. Tom Lane 2003-08-26 21:15:27 +00:00
  • 0b511f07e3 psql's HISTSIZE from .psqlrc do not want to be set so I did it for psql that HISTSIZE might take effect from my .psqlrc Bruce Momjian 2003-08-26 18:35:31 +00:00
  • 1e100176c4 This patch adds a new regression test for the UPDATE command. Right now all that is tested is Rod Taylor's recent addition to allow this syntax: Bruce Momjian 2003-08-26 18:32:23 +00:00
  • 47a4e2ed1c Fixed connect statement with username in variable. Michael Meskes 2003-08-26 16:09:02 +00:00
  • cd0f42e87c Attached is a (very small) patch to make analyze display some interesting info in verbose mode about the analyzed relation (pages, rows per block and rows). Bruce Momjian 2003-08-26 15:38:42 +00:00
  • f63cbccac7 Mop-up for previous change to determine default shared_buffers and max_connections at initdb time. Get rid of DEF_NBUFFERS and DEF_MAXBACKENDS macros, which aren't doing anything useful anymore, and put more likely defaults into postgresql.conf.sample. Tom Lane 2003-08-26 15:38:25 +00:00
  • 9116f6c91a fix module name in MODULE_PATHNAME substitution Teodor Sigaev 2003-08-26 10:01:02 +00:00
  • 06bbd98a15 Attempt to fix setMaxFieldSize() logic that was checked in yesterday. I think this should fix the problem, but since I don't have a reproducable test case, I can't be sure. This problem is reported by Kim Ho of redhat, who will test this fix. This also includes a test case for the original functionality. Barry Lind 2003-08-26 06:50:39 +00:00
  • 3e51c1553c Add the Brazilian time zone abbreviations BRT, BRST, FNT, FNST. ACT and ACST were already present. AMT and AMST conflict with the existing entries for Armenia; no change there for the moment. Tom Lane 2003-08-25 23:30:27 +00:00
  • 412c57b15f Allow parsing of time and timetz inputs to accept the documented input syntax '040506' for '04:05:06', as well as '0405' for '04:05:00'. This has been broken since 7.2 but was only recently complained of. Tom Lane 2003-08-25 22:47:34 +00:00
  • 3b87c1f8b6 Translation updates Peter Eisentraut 2003-08-25 21:29:53 +00:00
  • a17f2d76cc Refactor code so that to_date() does not call to_timestamp() and then perform a timestamp-to-date coercion. Instead both routines share a subroutine that delivers the parsing result as a struct tm. This avoids problems with timezone dependency of to_date's result, and should be at least marginally faster too. Tom Lane 2003-08-25 16:13:27 +00:00
  • 4b02f3c4eb Synced parser and fixed a bug in error output to log file. Michael Meskes 2003-08-25 13:44:00 +00:00
  • 048cb1ce6b Add: Bruce Momjian 2003-08-25 04:10:59 +00:00
  • f3dda96452 Fix unixware thread test. Bruce Momjian 2003-08-25 02:48:25 +00:00
  • 0c9f978c0c Fix GB18030 to UTF-8 mapping table Tatsuo Ishii 2003-08-25 01:46:16 +00:00
  • eb4dded09e Add quotes to += of unixware threads define. Bruce Momjian 2003-08-24 23:21:05 +00:00
  • 55b5fc9a9a Add: Bruce Momjian 2003-08-24 22:57:21 +00:00
  • 2495365df1 Applied patches from Oliver Jowett to fix the following bugs: - adds a finalizer method to AbstractJdbc1Statement to clean up in the case of poor user code which fails to close the statement object - fix ant build file to correctly detect dependencies across jdbc1/jdbc2/jdbc3 - fix a coupld of server prepared statement bugs and added regression test for them Applied patch from Kim Ho: - adds support for get/setMaxFieldSize(). Also fixed build.xml to provide a better error message in the event that an older version of the driver exists in the classpath when trying to build. Barry Lind 2003-08-24 22:10:09 +00:00
  • ba91f3b1de Fix translation mistake. Peter Eisentraut 2003-08-24 21:26:54 +00:00
  • 478bb0268f Fix translation mistake. Peter Eisentraut 2003-08-24 21:26:34 +00:00
  • 903fe8fc6f Translation updates Peter Eisentraut 2003-08-24 21:18:53 +00:00
  • 693aad413b Change warnings for non-existing or pre-existing cursors to errors. Peter Eisentraut 2003-08-24 21:02:43 +00:00
  • c3664c0c00 Add macros for error result fields to libpq. Peter Eisentraut 2003-08-24 18:36:38 +00:00
  • b4ab39ff05 Fix GB18030 to UTF-8 mapping table Tatsuo Ishii 2003-08-24 05:18:04 +00:00
  • 0fc3b22125 Fix GB18030 to UTF-8 mapping table Tatsuo Ishii 2003-08-24 05:13:40 +00:00