hcq/postgresql
1
0
Fork 0
mirror of https://git.postgresql.org/git/postgresql.git synced 2026-02-24 23:37:03 +08:00
Code Issues Packages Projects Releases Wiki Activity

Commit Graph

  • 530f997e6e Update linux/mips port. Bruce Momjian 2003-10-26 00:22:51 +00:00
  • 823240bf64 update linux ports for arm, s390, itanium. Bruce Momjian 2003-10-26 00:21:04 +00:00
  • d3423926c8 Update for port freebsd/alpha. Bruce Momjian 2003-10-26 00:00:40 +00:00
  • e9cd1c771f Get Tru64/cc to compile. Need to add -ieee so that it doesn't choke on 0.0/0.0. That option appears to affect the regression test result as well. The compiler documentation doesn't recommend -O4 for universal use, so let's stick to the conservative -O (== -O2) by default. Peter Eisentraut 2003-10-25 20:18:53 +00:00
  • 8e8816c777 Translation update Peter Eisentraut 2003-10-25 18:18:19 +00:00
  • 002e7b3789 Translation updates Peter Eisentraut 2003-10-25 18:03:21 +00:00
  • 378f59904a Fix CFLAGS selection to actually work. Add test to detect whether gcc's option -fno-strict-aliasing is available. Peter Eisentraut 2003-10-25 15:32:11 +00:00
  • 6db0a6b035 Remove socket credentials defines not referenced. Bruce Momjian 2003-10-25 03:48:47 +00:00
  • 1919b62058 Update Netbsd/i386 port. Bruce Momjian 2003-10-25 03:23:47 +00:00
  • 561a8ca808 Update ports for Solaris. Bruce Momjian 2003-10-25 03:17:43 +00:00
  • e69b2f3b0e Remove weird test in ccsym Bruce Momjian 2003-10-24 21:28:52 +00:00
  • e0ca78fb87 Update openbsd port. Bruce Momjian 2003-10-24 21:09:08 +00:00
  • cded27cacd Don't reference pthread.h unless we have threads enabled, per Peter. Bruce Momjian 2003-10-24 20:48:10 +00:00
  • 863d793fa3 Update for osX 10.3. Bruce Momjian 2003-10-24 20:44:19 +00:00
  • 7d4844f247 Update ports for freebsd, cygwin. Bruce Momjian 2003-10-24 20:39:09 +00:00
  • 2034a87a53 Use AROPT, not hard-coded flags. Peter Eisentraut 2003-10-24 20:31:43 +00:00
  • 2a9986f7d5 Update Linux/Sparc 32-bit port. Bruce Momjian 2003-10-24 16:30:53 +00:00
  • 7672a1056d Update Linux x86 port. Bruce Momjian 2003-10-24 16:29:00 +00:00
  • b97e0aa650 Update OSX port. Bruce Momjian 2003-10-24 15:56:29 +00:00
  • 79c0082d70 Mark BSD/OS as working in 7.4. Bruce Momjian 2003-10-24 15:31:29 +00:00
  • 739839b7f7 Move pre-7.3 platforms to unsupported. Bruce Momjian 2003-10-24 15:30:52 +00:00
  • b3be5e65e8 Translation updates Peter Eisentraut 2003-10-24 12:07:56 +00:00
  • 43b472f83f Move 2phase discussion to 7.5 queue, not TODO.detail. Bruce Momjian 2003-10-24 03:24:56 +00:00
  • 1c6f65db84 Move 2phase discussion to 7.5 queue, not TODO.detail. Bruce Momjian 2003-10-24 03:24:32 +00:00
  • 21b1d41ef3 Add 2-phase TODO.detail. Bruce Momjian 2003-10-24 03:21:37 +00:00
  • 2a197c7cce Add TODO.detail: Bruce Momjian 2003-10-24 03:20:36 +00:00
  • 9059d82770 Update INSTALL to say beta5. Bruce Momjian 2003-10-23 16:40:14 +00:00
  • 747df1a35e Remove obsolete information about altering default optimization flags for gcc. Per comment from original author, Brian Gallew: "Ancient history. Kill it fast." Tom Lane 2003-10-23 13:58:43 +00:00
  • cdbf9b328e Move docs about index cost estimation functions and writing a procedural language handler to the 'Internals' area, per my proposal of yesterday. Clean up the trigger documentation a bit. Push SPI chapter to the end of its part, and reorder the Internals chapters into what seems a more sensible order (at the moment anyway). Tom Lane 2003-10-22 22:28:10 +00:00
  • b8400c7f52 Here is a documentation patch that makes zulu, etc. all more consistent. Bruce Momjian 2003-10-22 18:10:53 +00:00
  • 269df29e8b Release notes updates from Neil Conway. Bruce Momjian 2003-10-22 17:27:14 +00:00
  • 70f567d571 Add: Bruce Momjian 2003-10-22 17:14:39 +00:00
  • 0634c01e3a Add missing semicolon, per Johann Uhrmann. Avoids warnings from newer bisons. Tom Lane 2003-10-22 16:43:42 +00:00
  • 4377a9afc3 Add mention that "today" doesn't work as column default anymore. Bruce Momjian 2003-10-22 05:09:12 +00:00
  • 7533e455f0 up configure to beta5 REL7_4_BETA5 PostgreSQL Daemon 2003-10-22 04:16:39 +00:00
  • 336297e676 Another example-to-documentation difference. Maybe we can find a better way to keep these in sync... Tom Lane 2003-10-22 03:50:27 +00:00
  • 2744abb736 Ooops, missed updating this part of the complex-datatype example. Tom Lane 2003-10-21 23:28:42 +00:00
  • 6fbb14a174 Update the complex-datatype example to V1 function calling conventions, and add binary send/receive functions. Fix some other grottiness such as failure to mark the C functions STRICT. Tom Lane 2003-10-21 22:51:14 +00:00
  • 6c7c493a09 For some reason, the preface mentions just six of the seven major parts of the book. Fix it. Tom Lane 2003-10-21 22:47:54 +00:00
  • 2b23bf376b Fix built-in SQL-language functions to ensure that referenced names are properly schema-qualified. Tom Lane 2003-10-21 16:23:16 +00:00
  • d4273a5205 Remove: Bruce Momjian 2003-10-21 15:51:41 +00:00
  • d8e3515f63 Update: Bruce Momjian 2003-10-21 15:48:56 +00:00
  • 7eb67fc98b Cope with platforms that offer LONGLONG_MIN in place of the C99-spec LLONG_MIN. One example is AIX, per report from Andreas. Tom Lane 2003-10-21 15:34:34 +00:00
  • c9f8c2fd04 Revert to 7.3-and-before practice of only including <fcntl.h> in c.h on Windows; per complaint from Andreas that it breaks AIX build. Tom Lane 2003-10-21 15:32:58 +00:00
  • 10add9d8ca Fix findLastBuiltinOid_V70() to deliver correct result when running against a 7.0 server. Tom Lane 2003-10-21 04:46:28 +00:00
  • d58c70c6ae Update per Tom: Bruce Momjian 2003-10-21 02:48:09 +00:00
  • 2f603a8b0c Add release info about dollar signs to migration section: Bruce Momjian 2003-10-21 01:25:31 +00:00
  • fd90da7f94 Update catalog version after information schema changes. Peter Eisentraut 2003-10-20 21:39:37 +00:00
  • 3b64171edb Complain if pg_restore is given both -d and -f options; this suggests the user is confused about whether -f is input or output file. Tom Lane 2003-10-20 21:05:12 +00:00
  • 98c7f157f2 It is possible for ResolveNew to be used to insert a sublink into a subquery that didn't previously have one. We have traditionally made the caller of ResolveNew responsible for updating the hasSubLinks flag of the outermost query, but this fails to account for hasSubLinks in subqueries. Fix ResolveNew to handle this. We might later want to change the calling convention of ResolveNew so that it can fix the outer query too, simplifying callers. But I went with the localized fix for now. Per bug report from J Smith, 20-Oct-03. Tom Lane 2003-10-20 20:02:30 +00:00
  • 1df7a455dd It is possible for ResolveNew to be used to insert a sublink into a subquery that didn't previously have one. We have traditionally made the caller of ResolveNew responsible for updating the hasSubLinks flag of the outermost query, but this fails to account for hasSubLinks in subqueries. Fix ResolveNew to handle this. We might later want to change the calling convention of ResolveNew so that it can fix the outer query too, simplifying callers. But I went with the localized fix for now. Per bug report from J Smith, 20-Oct-03. Tom Lane 2003-10-20 20:01:59 +00:00
  • 17841ddbbf Improve error reporting in parseTypeString(), motivated by confusing behavior reported by Martin Marques. Tom Lane 2003-10-20 17:25:42 +00:00
  • 3b72087bf6 Install dummy sqlda.h file since this is needed for compatibility. Michael Meskes 2003-10-20 12:54:29 +00:00
  • 41e6e36719 When building shared libraries on HPUX with gcc, forcibly include -lgcc to ensure any needed compiler support routines are included. This is arguably appropriate on *every* gcc platform, but for the moment I'll take the conservative approach of only doing it on a platform where it's provably useful. Per complaint from Heiko Lehmann, 13-Feb-03, as well as personal experience --- contrib/pgstattuple has never worked for me, but it does now. Tom Lane 2003-10-20 01:34:33 +00:00
  • 6f169057de Save_r, Save_t should be static not global variables. Tom Lane 2003-10-19 23:43:51 +00:00
  • 5319ba3803 Update README file to show 7.4 oidjoins relationships. The regression test was updated previously, but documentation is lagging. Tom Lane 2003-10-19 22:15:32 +00:00
  • 9dfdbef345 Adjust libpq to avoid deadlock when both client and server want to send data, and both have filled the transmission buffers. One scenario where this can happen was illustrated here: http://archives.postgresql.org/pgsql-hackers/2003-04/msg00979.php Tom Lane 2003-10-19 21:36:41 +00:00
  • d5353acbc3 Check for both Informix modes when parsing include files. Michael Meskes 2003-10-19 13:22:33 +00:00
  • 9d77708d83 Cleanup on --help-config: Now called --describe-config, no further options, machine readable, without headers, not sorted. Parameter descriptions adjusted to fit first sentence + rest convention. Peter Eisentraut 2003-10-18 22:59:09 +00:00
  • e341cdb085 Further work on information_schema. _pg_keyissubset() wasn't quite fully search-path-proof yet; also, element_types view did not work for parameters and result types of functions, because it didn't generate the object_name for the function the same way the data_type_privileges view does. While at it, centralize dependencies on INDEX_MAX_KEYS/ FUNC_MAX_ARGS into a function returning setof int, so that it will be easier to fix information_schema for nonstandard values of these parameters. Tom Lane 2003-10-18 19:06:10 +00:00
  • eda80f09ff Repair interaction between IN-join processing and subselect pullup that I inadvertently broke a few days ago (per report from Sean Thomas). Add regression test case to try to catch any similar breakage in future. Tom Lane 2003-10-18 16:52:15 +00:00
  • c02036b1d8 Simplify loop test to avoid bug in AIX compiler, per Andreas. Tom Lane 2003-10-18 15:38:06 +00:00
  • 9ea6d0fc80 Information schema fixes: Use pg_get_constraintdef instead of pg_constraint.consrc Use UNION ALL instread of UNION Make use of regclass type for getting OID of system catalogs Add schema qualifications where necessary Fix typos Peter Eisentraut 2003-10-18 12:53:35 +00:00
  • f2f7107024 Must free the pgParameterStatus chain in freePGconn(). My fault, well spotted by Neil Conway. Tom Lane 2003-10-18 05:02:06 +00:00
  • 0a4048646b Document all the system views created by initdb (several of these were never documented anywhere, sigh). Centralize the detailed documentation of system views into catalogs.sgml, and provide cross-references. Tom Lane 2003-10-17 22:38:20 +00:00
  • e5c2c97892 Add a listing of our SQLSTATE error codes to the documentation. Link to it from some appropriate places. Tom Lane 2003-10-17 18:57:01 +00:00
  • 34ed505966 Fix busted markup. Tom Lane 2003-10-17 18:29:55 +00:00
  • bbba5080b5 Fix elog tab-insertion code to insert tabs only where wanted. Tom Lane 2003-10-17 16:49:03 +00:00
  • 1b7ac7f130 Remove automatic '()' in other branch of UNION as well. Peter Eisentraut 2003-10-17 11:52:06 +00:00
  • fe1b5034dd Adjust display of actual runtimes in EXPLAIN output to use three fractional digits, and label it 'ms' not 'msec', for consistency with psql's \timing display. Per recent discussions. Tom Lane 2003-10-17 01:14:26 +00:00
  • fa2356a1ac Use pg_get_constraintdef() rather than pg_constraint.consrc; this is a portion of a patch recently submitted by Christopher Kings-Lynne. Applied by agreement that this is a bug fix. Tom Lane 2003-10-17 00:57:04 +00:00
  • dec4ed311a Add note deprecating use of consrc. Tom Lane 2003-10-17 00:55:17 +00:00
  • 44430dbc15 Fix bugs in referential_constraints view. Peter Eisentraut 2003-10-16 23:46:17 +00:00
  • 4a48c671d2 There should not be an automatic '()' after a function name when tab-completing. Peter Eisentraut 2003-10-16 23:45:29 +00:00
  • 52b59a7bec Set attstattarget to -1 for all system catalog columns. All but a few of the entries used to be zero, which I think I had deliberately done in the name of saving cycles during ANALYZE, but it was really a rather foolish decision. Some of the more complex views in information_schema were getting really bad plans for lack of statistics on the columns they were joining over. Tom Lane 2003-10-16 22:52:22 +00:00
  • 64c1fc7257 Avoid division by zero in estimate_num_groups() when table has no rows. Tom Lane 2003-10-16 21:37:54 +00:00
  • 624292aa35 Ensure that all places that are complaining about exhaustion of shared memory say 'out of shared memory'; some were doing that and some just said 'out of memory'. Also add a HINT about increasing max_locks_per_transaction where relevant, per suggestion from Sean Chittenden. (The former change does not break the strings freeze; the latter does, but I think it's worth doing anyway.) Tom Lane 2003-10-16 20:59:35 +00:00
  • 2ec74435cd Cause tab completion to do something moderately reasonable with mixed-case identifiers --- it will now complete these correctly with double quoting. Fix a few other issues in passing. Tom Lane 2003-10-16 20:03:09 +00:00
  • 9ad637f749 Add mention of SIGHUP on the postmaster manual page. Bruce Momjian 2003-10-16 17:38:01 +00:00
  • 90b2202975 Fix bad interaction between NOTIFY processing and V3 extended query protocol, per report from Igor Shevchenko. NOTIFY thought it could do its thing if transaction blockState is TBLOCK_DEFAULT, but in reality it had better check the low-level transaction state is TRANS_DEFAULT as well. Formerly it was not possible to wait for the client in a state where the first is true and the second is not ... but now we can have such a state. Minor cleanup in StartTransaction() as well. Tom Lane 2003-10-16 16:50:41 +00:00
  • 839cea8814 Minor copy-editing. Tom Lane 2003-10-16 04:52:21 +00:00
  • a9c1ff66da Add: Bruce Momjian 2003-10-16 04:12:53 +00:00
  • 60feaa261f Fix SGML markup. Bruce Momjian 2003-10-16 04:11:53 +00:00
  • 352f29b17b This patch adds another item to the "migration to 7.4" list in the HISTORY file, and attributes the shared-buffer-alignment change to Manfred Spraul. Bruce Momjian 2003-10-16 03:55:31 +00:00
  • 62fdc3dd60 I have run pg_autovacuum on AIX, so that can, at least loosely, be considered "tested." Bruce Momjian 2003-10-16 03:47:28 +00:00
  • 37278c063f Cause the default CFLAGS to be -O2 -fno-strict-aliasing when using gcc, per recent pghackers discussions. Also ensure that explicitly setting CFLAGS in the configure environment will be honored. Tom Lane 2003-10-15 22:23:56 +00:00
  • 3992f1c50b Translation updates Peter Eisentraut 2003-10-15 10:00:20 +00:00
  • e9b2b56c23 New translation Peter Eisentraut 2003-10-15 09:49:07 +00:00
  • 578774d5f5 Translation update Peter Eisentraut 2003-10-15 09:45:34 +00:00
  • dee5b779fa New translation Peter Eisentraut 2003-10-15 09:39:04 +00:00
  • 77c1791a58 Use PQescapeString to ensure that tab-completion queries are not messed up by quotes or backslashes in words that are being matched to database names (per gripe from Ian Barwick, though I didn't use his patch). Also fix possible memory leakage if _complete_with_query isn't run to completion (not clear if that can happen or not, but be safe). Tom Lane 2003-10-14 22:47:12 +00:00
  • 2a0f1c08d5 Remove void* in MemSet until we understand the gcc 3.3.1 problem better. Bruce Momjian 2003-10-14 19:08:00 +00:00
  • fca71f4406 Add compile -O flag only for non-debug mode, per Tom Bruce Momjian 2003-10-14 00:48:09 +00:00
  • d18ba3f452 pull_up_subqueries() should copy the subquery before starting to modify it. Not sure why I'd thought it would be a good idea to do differently way back when, but Greg Stark exposed the folly of doing so ... Tom Lane 2003-10-13 23:48:16 +00:00
  • 4a39057e59 Back out makeNode() patch to fix gcc 3.3.1 warning. Bruce Momjian 2003-10-13 22:47:15 +00:00
  • 014a0a3da1 Remove registration message, after discussion concluded that it was of little use. Peter Eisentraut 2003-10-13 21:39:41 +00:00
  • 27318d8873 Translation update Peter Eisentraut 2003-10-13 21:38:37 +00:00
  • 87299583a5 Determine max_connections first, then see how large shared_buffers can be made, to avoid corner cases where max_connections ends up unreasonably small because shared_buffers is hogging too much shmem space. Per pghackers discussion about a week ago. Also, fix the copy-newlines problem in a more robust way, by using COPY FROM filename instead of COPY FROM STDIN; per a suggestion from Peter. Tom Lane 2003-10-13 21:06:44 +00:00
  • e7261c46aa Adjust setRelhassubclassInRelation() to not perform actual heap_update when the pg_class.relhassubclass value is already correct. This should avoid most cases of the 'tuple concurrently updated' problem that Robert Creager recently complained about. Also remove a bunch of dead code in StoreCatalogInheritance() --- it was still computing the complete list of direct and indirect inheritance ancestors, though that list has not been needed since we got rid of the pg_ipl catalog. Tom Lane 2003-10-13 20:02:52 +00:00
  • 4a2c34d4a0 Use makeNode() to allocate structures that have to be cast to Node *, rather than allocating them on the stack. Bruce Momjian 2003-10-12 23:19:21 +00:00