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

Commit Graph

  • 0bc291e03c Fix thinko (revealed by gcc warning). Tom Lane 2001-08-07 15:55:16 +00:00
  • 7739cde4f6 Russian translation by Serguei Mokhov Peter Eisentraut 2001-08-07 11:41:17 +00:00
  • 957eea278e Czech translation for psql from Karel Zak Peter Eisentraut 2001-08-07 11:28:18 +00:00
  • 50036e85b3 Add a check for end of client connection before expecting a password response, to avoid noise in the server log. Peter Eisentraut 2001-08-07 10:44:16 +00:00
  • 2f4759d5ce Doesn't seem to be much point in keeping this README up to date anymore, since it's completely redundant with regress.sgml. I think we agreed to remove it awhile back, actually, but no one got around to doing it. Tom Lane 2001-08-06 22:55:00 +00:00
  • af3487e9bf Update now-obsolete example of platform-specific regression comparison files. Tom Lane 2001-08-06 22:53:26 +00:00
  • bf51b8608b Use a fixed error message for ERANGE to avoid duplicate test result files. Add some resultmap entries for SCO OpenServer. Peter Eisentraut 2001-08-06 21:55:16 +00:00
  • 80185f4b5b Seems like a bad idea to free() a string we are about to use in an error message. Tom Lane 2001-08-06 18:17:42 +00:00
  • 246793469e Modify partial-index-predicate applicability tester to test whether clauses are equal(), before trying to match them up using btree opclass inference rules. This allows it to recognize many simple cases involving non-btree operations, for example 'x IS NULL'. Clean up code a little. Tom Lane 2001-08-06 18:09:45 +00:00
  • 7d6fbe15a2 Evaluate LIMIT/OFFSET expressions with ExecEvalExprSwitchContext, not ExecEvalExpr, to avoid possible memory leak. Tom Lane 2001-08-06 18:05:07 +00:00
  • 5558e15ce5 Do not pre-expand localedir as substituted in the makefile, so that 'make install prefix=elsewhere' works. Peter Eisentraut 2001-08-06 15:46:44 +00:00
  • 4e75fcb80c update from upstream Peter Eisentraut 2001-08-06 13:58:26 +00:00
  • f487e3da68 Check that the data directory does not have group or world access; remove a similar check on postgresql.conf. Peter Eisentraut 2001-08-06 13:45:15 +00:00
  • 46e252141b Add QueryIsRule gram.y reset. Bruce Momjian 2001-08-06 05:42:48 +00:00
  • 172ef1632e Surely the pg_stat interrogation functions must not be marked proiscachable. Tom Lane 2001-08-06 01:25:32 +00:00
  • 4cba72ccc8 Show index predicate when doing \d on a partial index. Tom Lane 2001-08-05 22:13:46 +00:00
  • e8f1097361 Endeavor to make pgstats buffer process (a) safe and (b) useful. Make sure it exits immediately when collector process dies --- in old code, buffer process would hang around and compete with the new buffer process for packets. Make sure it doesn't block on writing the pipe when the collector falls more than a pipeload behind. Avoid leaking pgstats FDs into every backend. Tom Lane 2001-08-05 02:06:50 +00:00
  • 5181d37e4c Remove no-longer-needed fcntl call (I'm not sure it *ever* did anything useful, in fact). Tom Lane 2001-08-05 01:22:16 +00:00
  • d1c9633060 Back out LOCK A,B,C patch at Tom's suggestion. Bruce Momjian 2001-08-04 22:01:39 +00:00
  • eb610fb8f1 Compile fix for jdbc1. Bruce Momjian 2001-08-04 19:46:56 +00:00
  • 3e51868226 This patch is because Hurd does not support NOFILE. It is against current cvs. Bruce Momjian 2001-08-04 19:42:34 +00:00
  • e9ea1255c0 This patch adds the following to the FTI module: Bruce Momjian 2001-08-04 19:41:00 +00:00
  • 16365ac75b Add LOCK A,B,C functionality as LOCK A;LOCK B;LOCK C; as agreed. Bruce Momjian 2001-08-04 19:39:00 +00:00
  • 0bfc64b387 Looks okay in a quick glance, except error message spelling is poor: Bruce Momjian 2001-08-04 19:36:45 +00:00
  • f368c94fd6 1. Fixed error with empty array ( '{}' ), test data changed to include such data 2. Test a dimension of an array ( we support only one-dimension) Bruce Momjian 2001-08-04 19:35:32 +00:00
  • f8683e8a9c > 1) When a row is retrieved, and then a SQL_FETCH_FIRST is issued, the check > in convert.c > does not consider the fact that the value in the field has been altered to > be a '1' if the > backend handed it a 't'. The net result being that the first row on any > subsequent queries > has all it's boolean set to 0. Bruce Momjian 2001-08-04 19:33:49 +00:00
  • 184505bbfc Attached is a patch that does the following: Bruce Momjian 2001-08-04 19:32:04 +00:00
  • dad8e410d0 Fix handling of SIGCHLD, per recent pghackers discussion: on some platforms system(2) gets confused unless the signal handler is set to SIG_DFL, not SIG_IGN. pgstats.c now uses pqsignal() as it should, not signal(). Also, arrange for the stats collector process to show a reasonable ID in 'ps', rather than looking like a postmaster. Tom Lane 2001-08-04 00:14:43 +00:00
  • 2b769c8212 Fix residual breakage from Windows socket-errno patch: the routines that should use regular errno, not WSAGetLastError(), now do so again. Tom Lane 2001-08-03 22:11:39 +00:00
  • 886d7dec79 Fix win32.mak to support MULTIBYTE build --- it was pulling in several backend files that it shouldn't anymore, causing compile failures. Per report from Darko Prenosil. Tom Lane 2001-08-03 22:09:55 +00:00
  • fd61fbe837 For some reason, CREATE TYPE has only accepted alignment specifications of 'int4' and 'double'. Add 'char' and 'int2' to allow user-defined types to access the full set of supported alignments. Tom Lane 2001-08-03 20:47:40 +00:00
  • 7df68bdd50 Back-patch fixes for dumping user-defined types and dumping comments on views. Tom Lane 2001-08-03 20:14:07 +00:00
  • 8f0ee46dcb Fix pg_dump so that comments on views are dumped in the proper sequence. Dump the alignment and storage information for user-defined types (how'd that manage to slip through the cracks?), and don't dump 'shell' types that don't have typisdefined set. Fix badly broken logic for dependencies of type definitions (did not work for more than one user-defined type...). Avoid memory leakage within pg_dump by being more careful to release storage used by PQExpBuffer objects. Tom Lane 2001-08-03 19:43:05 +00:00
  • 42fbb6dbe7 Clean up various memory leaks within plpgsql, and re-enable the exec_eval_simple_expr shortcut, which was diked out in 7.1 because it leaked too much space. CVS tip now leaks no memory in Chris Ruprecht's example, which formerly leaked to the tune of 500 MB. (Much of this is work that Jan already did; this commit just cleans up around the edges.) Tom Lane 2001-08-02 21:31:23 +00:00
  • f59f3c8899 Add a SPI_copytupledesc function that parallels SPI_copytuple --- ie, it copies the tupdesc into upper-executor memory. This is necessary for returning tuple descriptors without leaking all of lower exec memory. Tom Lane 2001-08-02 18:08:43 +00:00
  • ba4d223cd9 Tweak memory context sizing for saved SPI plans. Tom Lane 2001-08-02 16:05:23 +00:00
  • ecaa2e01b7 Fix some poor decisions about sizing of trigger-related memory contexts. Tom Lane 2001-08-02 15:59:28 +00:00
  • 84d2c518fe I noticed that pltcl didn't have any way to get to SPI_lastoid like plpgsql does.. I started using pltcl a lot because I like to decide when and how my queries get planned.. so I put one together really quick Bruce Momjian 2001-08-02 15:45:55 +00:00
  • d00b272299 Even though SO_PEERCRED is probably totally unportable, might as well declare the getsockopt parameter as ACCEPT_TYPE_ARG3 to be consistent with our other uses of getsockopt. Tom Lane 2001-08-02 14:39:35 +00:00
  • 49435fb98f Remove SO_PASSCRED step in ident_unix --- according to Helge Bahmann, that call is not needed to prepare for SO_PEERCRED. Also, simplify code so that #ifdef SO_PEERCRED appears in only one place, to make it easier to support other platforms with variants of this capability. Tom Lane 2001-08-02 14:27:40 +00:00
  • cb90b2dacb Digging through previous discussion of this patch, I note where Peter E. points out how silly it is to use Autoconf to test for a preprocessor symbol, when one can equally easily #ifdef on the symbol itself. Accordingly, revert configure to prior state and do it that way. Tom Lane 2001-08-01 23:52:50 +00:00
  • bc042e0a77 Support ident authentication on local (Unix) socket connections, if the system supports SO_PEERCRED requests for Unix sockets. This is an amalgamation of patches submitted by Helge Bahmann and Oliver Elphick, with some editorializing by yours truly. Tom Lane 2001-08-01 23:25:39 +00:00
  • 7208518720 Attached is a trivial patch to add ANALYZE to the tab complete file in psql. Bruce Momjian 2001-08-01 18:45:50 +00:00
  • ea72cc4e11 Attached ia a patch to enable window size detection code of psql for Solaris platform. Bruce Momjian 2001-08-01 18:44:54 +00:00
  • 938236a297 The fti.pl supplied with the fulltextindex module generate ALL possible substrings of two characters or greater, and is case-sensitive. Bruce Momjian 2001-08-01 18:40:12 +00:00
  • 8c6761acc7 Message typo was fixed in sources, but not in de.po. Tom Lane 2001-08-01 14:07:41 +00:00
  • b332dc358b When invoked with -i (initialize mode), split the copy command every 10000 tuples, rather than one big copy. This will prevent generating too much WAL logs. Tatsuo Ishii 2001-08-01 01:08:17 +00:00
  • da872534ac Add mention of SIGHUP for pg_ident.conf. Bruce Momjian 2001-08-01 00:52:19 +00:00
  • 8ef0aa170f Add documentation changes for new pg_hba.conf behavior. Bruce Momjian 2001-08-01 00:48:52 +00:00
  • 77896d1fc9 Cleanup code for preparsing pg_hba.conf and pg_ident.conf. Store line number in the data structure so that we can give at least a minimally useful idea of where the mistake is when we issue syntax error messages. Move the ClientAuthentication() call to where it should have been in the first place, so that postmaster memory releasing can happen in a reasonable place also. Update obsolete comments, correct one real bug (auth_argument was not picked up correctly). Tom Lane 2001-07-31 22:55:45 +00:00
  • 0889bd00bd Further thought shows that has_distinct_on_clause() needs to take much more care with resjunk tlist entries than it was doing. The original coding ignored resjunk entries entirely, but a resjunk entry that is in either the distinctClause or sortClause lists indicates that DISTINCT ON was used. It's important for ruleutils.c to get this right, else we may dump views using DISTINCT ON incorrectly. Tom Lane 2001-07-31 20:16:33 +00:00
  • a1e17cd5c5 Fix optimizer to not try to push WHERE clauses down into a sub-SELECT that has a DISTINCT ON clause, per bug report from Anthony Wood. While at it, improve the DISTINCT-ON-clause recognizer routine to not be fooled by out- of-order DISTINCT lists. Also, back-patch earlier fix to not push down into sub-SELECT with LIMIT. Tom Lane 2001-07-31 18:39:13 +00:00
  • 421467cdc8 Fix optimizer to not try to push WHERE clauses down into a sub-SELECT that has a DISTINCT ON clause, per bug report from Anthony Wood. While at it, improve the DISTINCT-ON-clause recognizer routine to not be fooled by out- of-order DISTINCT lists. Tom Lane 2001-07-31 17:56:31 +00:00
  • 6fbf442d5a Update 'translate' function description. translate does character set mapping, not character strings. Bruce Momjian 2001-07-31 17:09:30 +00:00
  • a54f0e8d5c Update info on pg_hba.conf comments. Bruce Momjian 2001-07-31 15:45:20 +00:00
  • 6a6da4f291 Update TODO list. Bruce Momjian 2001-07-31 13:21:31 +00:00
  • 6d0d838ceb Remove WIN32_NON_BLOCKING_CONNECTIONS tests, since we don't need 'em anymore. Tom Lane 2001-07-31 02:14:49 +00:00
  • c4c194f100 Fix unportable coding for FRONTEND case. Tom Lane 2001-07-31 02:02:45 +00:00
  • 267a8f82bf Change SQL commands embedded in the initdb script from the style echo "command" | postgres to the style postgres <<EOF command EOF This makes the script more legible (IMHO anyway) by reducing the need to escape quotes, and allows us to execute successive SQL commands in a single standalone-backend run, rather than needing to start a new standalone backend for each command. With all the CREATE VIEWs that are getting done now, this makes for a rather substantial reduction in the runtime of initdb. (Some of us do initdb often enough to care how long it runs ;-).) Tom Lane 2001-07-31 01:16:09 +00:00
  • 9c2b1a92b5 Update TODO list. Bruce Momjian 2001-07-30 17:58:25 +00:00
  • 27f9d6ee2e Update TODO list. Bruce Momjian 2001-07-30 16:48:48 +00:00
  • cc54c68906 autoconf Bruce Momjian 2001-07-30 15:08:31 +00:00
  • 173dbaf11f Open Unix 8 patch (Caldera Unixware). Still needs updated autoconf. Bruce Momjian 2001-07-30 15:01:00 +00:00
  • 113bb9b5ac XML conversion utility, requires expat library. Bruce Momjian 2001-07-30 14:59:02 +00:00
  • d4cafeba31 Patch to add comments to Linux startup script. Bruce Momjian 2001-07-30 14:52:42 +00:00
  • 509f5d241a This patch merges the identical methods from the JDBC1 and JDBC2 connection implementations (org.postgresql.jdbc[1|2].Connection) into their superclass (org.postgresql.Connection). Bruce Momjian 2001-07-30 14:51:19 +00:00
  • 462b7d46d1 Load pg_hba.conf and pg_ident.conf on startup and SIGHUP into List of Lists, and use that for user validation. Bruce Momjian 2001-07-30 14:50:24 +00:00
  • d6b1a407f4 Arrange for GRANT/REVOKE on a view to be dumped at the right time, namely after the view definition rather than before it. Bug introduced in 7.1 by changes to dump stuff in OID ordering. Tom Lane 2001-07-29 22:12:49 +00:00
  • 8d464d05d7 Arrange for GRANT/REVOKE on a view to be dumped at the right time, namely after the view definition rather than before it. Bug introduced in 7.1 by changes to dump stuff in OID ordering. Tom Lane 2001-07-29 22:12:23 +00:00
  • 94cb3fd875 Suppress gcc warning in USE_LOCALE case. Tom Lane 2001-07-22 22:01:04 +00:00
  • 732a3ee8eb Move EncodingTest.java file. Bruce Momjian 2001-07-21 21:27:41 +00:00
  • a7eba9ca7a DatabaseMetaData.getColumns() doesn't appear to get the default value for each column. Here is a context diff of CVS which should fix it. Bruce Momjian 2001-07-21 18:57:08 +00:00
  • eec08cddb4 Great, here is a context diff of CVS for implementing the get/setCatalog methods in Connection - note: I've updated setCatalog(String catalog) from my previous diff so it checks whether it is already connected to the specified catalog. Bruce Momjian 2001-07-21 18:56:17 +00:00
  • ff21a8e5c8 JDBC encoding additions. Bruce Momjian 2001-07-21 18:52:11 +00:00
  • 12f59470a1 Remove libpq TODO.detail. We don't need it any more because the item is done. Bruce Momjian 2001-07-21 04:41:29 +00:00
  • bf3fcf3de9 Update TODO list. Bruce Momjian 2001-07-21 04:41:08 +00:00
  • f6d523c1f2 Update TODO list. Bruce Momjian 2001-07-21 04:40:07 +00:00
  • ca5a516279 I downloaded new source for lib (only few hours old !!!), and made changes on this new source to make non-blocking connection work. I tested it, and PQSendQuery and PQGetResult are working fine. Bruce Momjian 2001-07-21 04:32:42 +00:00
  • 54bf5da7d7 Source formatting cleanup. Bruce Momjian 2001-07-21 00:29:56 +00:00
  • d4042234f9 Update TODO list. Bruce Momjian 2001-07-20 20:51:31 +00:00
  • 8c79f3c4a3 i've spotted a following problem using DBD::Pg under win32. winsock functions do not set errno, so some normal conditions are treated as fatal errors. e.g. fetching large tuples fails, as at some point recv() returns EWOULDBLOCK. here's a patch, which replaces errno with WSAGetLastError(). i've tried to to affect non-win32 code. Bruce Momjian 2001-07-20 17:45:06 +00:00
  • 8f75c1b0c7 Update TODO list. Bruce Momjian 2001-07-20 16:14:55 +00:00
  • e741737fc3 Update TODO list. Bruce Momjian 2001-07-20 16:07:32 +00:00
  • 32aa093c44 Update TODO list. Bruce Momjian 2001-07-20 14:31:28 +00:00
  • 551d8a46ce Update TODO list. Bruce Momjian 2001-07-20 14:29:56 +00:00
  • 00faa575b0 Update TODO list. Bruce Momjian 2001-07-20 14:23:33 +00:00
  • 8a59f336bb Minor performance improvement in MultiRecordFreeSpace. Tom Lane 2001-07-19 21:25:37 +00:00
  • 7d4d5c00f0 Arrange to recycle old XLOG log segment files as new segment files, rather than deleting them only to have to create more. Steady state is 2*CHECKPOINT_SEGMENTS + WAL_FILES + 1 segment files, which will simply be renamed rather than constantly deleted and recreated. To make this safe, added current XLOG file/offset number to page header of XLOG pages, so that an un-overwritten page from an old incarnation of a logfile can be reliably told from a valid page. This change means that if you try to restart postmaster in a CVS-tip database after installing the change, you'll get a complaint about bad XLOG page magic number. If you don't want to initdb, run contrib/pg_resetxlog (and be sure you shut down the old postmaster cleanly). Tom Lane 2001-07-19 02:12:35 +00:00
  • 8b77efdded Update TODO list. Bruce Momjian 2001-07-18 15:37:34 +00:00
  • ccf193f1a5 New-style vacuum neglected to update pg_class statistics about indexes if there were no deletions to do. Tom Lane 2001-07-18 00:46:25 +00:00
  • 75586cb584 Disallow non-cachable functions in functional indexes and in index predicates. Per suggestion from Hiroshi. Tom Lane 2001-07-17 21:53:01 +00:00
  • 84a3634411 Avoid assuming that pg_index table entries have unique OIDs, or even that they have OIDs at all (the primary key for this table is indexrelid, not OID). Simplify overly complex query to get name of primary key. Tom Lane 2001-07-17 00:30:35 +00:00
  • ed5c4e4a14 Improve documentation about reasoning behind the order of operations in GetSnapshotData, GetNewTransactionId, CommitTransaction, AbortTransaction, etc. Correct race condition in transaction status testing in HeapTupleSatisfiesVacuum --- this wasn't important for old VACUUM with exclusive lock on its table, but it sure is important now. All per pghackers discussion 7/11/01 and 7/12/01. Tom Lane 2001-07-16 22:43:34 +00:00
  • ffbd97c8ac Update TODO list. Bruce Momjian 2001-07-16 21:18:14 +00:00
  • 1bd3dd0c5f Fix fault in message. Peter Eisentraut 2001-07-16 20:05:51 +00:00
  • 220b261f4d Remove some unused node symbols Bruce Momjian 2001-07-16 19:12:58 +00:00
  • 784def9e8e More EXTEND INDEX removal. Bruce Momjian 2001-07-16 19:07:40 +00:00
  • 40db52af34 Do not push down quals into subqueries that have LIMIT/OFFSET clauses, since the added qual could change the set of rows that get past the LIMIT. Per discussion on pgsql-sql 7/15/01. Tom Lane 2001-07-16 17:57:02 +00:00
  • 8ba3548ebf Update TODO list. Bruce Momjian 2001-07-16 14:34:26 +00:00
  • f31dc0ada7 Partial indexes work again, courtesy of Martijn van Oosterhout. Note: I didn't force an initdb, figuring that one today was enough. However, there is a new function in pg_proc.h, and pg_dump won't be able to dump partial indexes until you add that function. Tom Lane 2001-07-16 05:07:00 +00:00