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

Commit Graph

  • 04287daa83 Add wording so people know PANIC is really "off" for log_min_error_statement. Bruce Momjian 2002-10-03 02:26:49 +00:00
  • 71e74a2f58 Re-enable pg_resetxlog to accept -l values in hexadecimal (it used to be able to do that, but the ability seems to have got lost in the shuffle). Add a -o nextOID switch for completeness. Improve the documentation to explain how and why to use these switches. Tom Lane 2002-10-02 21:30:13 +00:00
  • 388ad64dc7 pg_resetxlog was missing support for the pg_control fields added in 7.3. Tom Lane 2002-10-02 19:45:47 +00:00
  • b813d143ae Alter scale selection for NUMERIC division and transcendental functions so that precision of result is always at least as good as you'd get from float8 arithmetic (ie, always at least 16 digits of accuracy). Per pg_hackers discussion a few days ago. Tom Lane 2002-10-02 19:21:26 +00:00
  • c74c7e604c Turn GUC log_min_error_statement off by default by setting it to PANIC. Bruce Momjian 2002-10-02 16:27:57 +00:00
  • fd972e7f7e test files added by Kris Jurka Dave Cramer 2002-10-01 16:11:30 +00:00
  • 361f1e1656 Pass less-unsafe parameters to Darwin's NSLinkModule. While this change prevents a backend coredump when loading a broken shlib, it also seems to suppress the error messages that might help debug the problem :-(. Perhaps someone would like to supply a 'linkEdit' hook to get the best of both worlds. But in the meantime, backend crash trumps error reporting. Tom Lane 2002-10-01 05:06:44 +00:00
  • 1a4431777b Fixed test suite to call PoolingDataSourceTest which was missed Barry Lind 2002-10-01 04:36:00 +00:00
  • 5aa14def55 Applied doc patch to jdbc doc which documents support for datasources patch submitted by ammulder@alumni.princeton.edu Barry Lind 2002-10-01 04:09:13 +00:00
  • 4526d2183f Brand 7.2.3. REL7_2_3 Bruce Momjian 2002-10-01 03:34:29 +00:00
  • 04957acd91 Update FAQ for 7.2.3 version. Bruce Momjian 2002-10-01 03:28:56 +00:00
  • 9227bc5e5b Update HISTORY/release.sgml for 7.2.3. Bruce Momjian 2002-10-01 03:24:17 +00:00
  • fbc48fac11 Update HISTORY/release.sgml for 7.2.3. Bruce Momjian 2002-10-01 03:23:05 +00:00
  • 7c553901d7 schema awareness patch provided by Kris Jurka Dave Cramer 2002-10-01 00:39:02 +00:00
  • 407517f039 Back-patch fixes to work around broken mktime() in recent glibc releases. Tom Lane 2002-09-30 20:57:11 +00:00
  • 96464fa37c Back-patch fix for bad SIGUSR2 interrupt handling during backend shutdown. Tom Lane 2002-09-30 20:47:22 +00:00
  • c6ec2a8ba5 Back-patch fix for correct TAS operation on multi-CPU PPC machines. Tom Lane 2002-09-30 20:24:53 +00:00
  • c9e3806e57 Back-patch fix for 'can't wait without a PROC structure' failures: remove separate ShutdownBufferPoolAccess exit callback, and do the work in ProcKill instead, before we delete MyProc. Tom Lane 2002-09-30 20:18:59 +00:00
  • c80d09f123 Back-patch fix to ensure a checkpoint occurs before truncating CLOG, even if no recent WAL activity has occurred. Tom Lane 2002-09-30 19:55:08 +00:00
  • a829ad1570 Back-patch fix to not change pg_database.datvacuumxid or truncate CLOG when an unprivileged user runs VACUUM. Tom Lane 2002-09-30 19:45:57 +00:00
  • 2a1e4a9006 Add Bear's SSL comments. Bruce Momjian 2002-09-29 04:06:54 +00:00
  • 6d0d15c451 Make the world at least somewhat safe for zero-column tables, and remove the special case in ALTER DROP COLUMN to prohibit dropping a table's last column. Tom Lane 2002-09-28 20:00:19 +00:00
  • 23616b47d5 ARGH! Tom Lane 2002-09-27 20:57:08 +00:00
  • 3468ed586a > Fix clusterdb to be schema-aware Bruce Momjian 2002-09-27 17:51:10 +00:00
  • d2d0f42040 Use heap_formtuple not heap_addheader to construct pg_index tuples. heap_addheader is wrong because it doesn't cope with varlena fields, notably indpred. Tom Lane 2002-09-27 15:05:23 +00:00
  • cb253de21a Don't mess with HEAP_XMAX_INVALID in heaptuple.c routines; there is no reason to worry about the tuple commit status bits until the tuple is inserted in a relation by heapam.c. Also, improve comments for heap_addheader(). Tom Lane 2002-09-27 15:04:08 +00:00
  • 0b1b377569 Have -d5 -d0 not affect the extra variables set with -d5. Bruce Momjian 2002-09-27 03:59:00 +00:00
  • 1fe4cbb9db Make postgres -d0 set server_min_messages to notice. Reset doesn't work at this area in the code. Bruce Momjian 2002-09-27 03:34:15 +00:00
  • dcc59f8ed6 Simplify SSL certificate instructions. Bruce Momjian 2002-09-27 02:04:39 +00:00
  • b2ab1e6bc9 Ensure that before truncating CLOG, we force a checkpoint even if no recent WAL activity has occurred. Without this, it's possible that a later crash might leave tuples on disk with un-updated commit status bits. Tom Lane 2002-09-26 22:58:34 +00:00
  • c87469e64a Fix problems with loss of tuple commit status bits during WAL redo of VACUUM FULL tuple moves. Store full-width t_infomask in WAL, rather than storing low 8 bits and expecting to be able to reconstruct upper bits. While at it, remove redundant t_oid field from WAL headers (the OID, if present, is now recorded in the data portion of the tuple). WAL version number bumped --- this does not force an initdb, you can instead run pg_resetxlog after a clean shutdown of the old postmaster. Tom Lane 2002-09-26 22:46:29 +00:00
  • 72f8efdc98 Back out /pl memory leak patch. Wait for new version. Bruce Momjian 2002-09-26 05:39:03 +00:00
  • ff5d4cbfca Clean up SSL compiler warnings. Bruce Momjian 2002-09-26 05:37:58 +00:00
  • 603f601269 Attached is a patch to contrib/dbmirror that fixes a bug that was causing the postmaster to crash when the trigger was running on a table without a primary key. Bruce Momjian 2002-09-26 05:24:30 +00:00
  • b2c34e2bd1 I have attached the pltcl patch again, just in case. For the sake of clarity let's say this patch superscedes the previous one. Bruce Momjian 2002-09-26 05:23:26 +00:00
  • 5ad4faf13a This patch removes a use of uninitialized memory in lmgr/lock.c, by adding a missing sprintf(). Bruce Momjian 2002-09-26 05:18:30 +00:00
  • 3c104bc4ed Pass postmaster -d down to the postgres backend to trigger special -d handling in the backend. Bruce Momjian 2002-09-26 05:17:00 +00:00
  • 15b95cf872 Allow SSL to work withouth client-side certificate infrastructure. Bruce Momjian 2002-09-26 04:41:55 +00:00
  • c889c9c901 Enhance the description of user and database management. Reduce the number of forward references in the admin guide. Peter Eisentraut 2002-09-25 21:16:10 +00:00
  • 8a6fab412e Remove ShutdownBufferPoolAccess exit callback, and do the work in ProcKill instead, where we still have a PGPROC with which to wait on LWLocks. This fixes 'can't wait without a PROC structure' failures occasionally seen during backend shutdown (I'm surprised they weren't more frequent, actually). Add an Assert() to LWLockAcquire to help catch any similar mistakes in future. Fix failure to update MyProcPid for standalone backends and pgstat processes. Tom Lane 2002-09-25 20:31:40 +00:00
  • 691aefcf42 Shouldn't be here ... Tom Lane 2002-09-25 14:27:16 +00:00
  • 4852dd9d61 Stamp configure for beta2. Bruce Momjian 2002-09-25 13:23:15 +00:00
  • df88a3cfc5 Install proper earthdistance file, regression passes. Bruce Momjian 2002-09-25 13:04:48 +00:00
  • 7bf1c8b0ad Applied patch from Aaron Mulder (ammulder@alumni.princeton.edu) that fixes jdbc datasource support for jdk1.4/jdbc3 Barry Lind 2002-09-25 07:01:31 +00:00
  • 65bf5a39e0 Add missing earthdistance regression test files. Bruce Momjian 2002-09-25 03:46:04 +00:00
  • a6c00af4c8 Make PL/pgSQL capitalization consistent. Bruce Momjian 2002-09-24 23:37:42 +00:00
  • c6367df506 Change default privileges for languages and functions to be PUBLIC USAGE and PUBLIC EXECUTE, respectively. Per discussion about easing updates from prior versions. Tom Lane 2002-09-24 23:14:25 +00:00
  • e92bec2844 Update some obsolete comments and column descriptions. Tom Lane 2002-09-24 21:26:44 +00:00
  • 12bb3679db Remove useless O_DIROPEN stuff. Peter Eisentraut 2002-09-24 20:20:10 +00:00
  • 8c3ab663ab Tweak conversion names to follow the established naming scheme, and document that scheme. Peter Eisentraut 2002-09-24 20:14:59 +00:00
  • 87eb561c88 Add earthdistance regression file. Bruce Momjian 2002-09-24 20:09:33 +00:00
  • 83fd58dff0 Add missing correction of sublevelsup when pulling up a subquery. Fixes problem with cases like SELECT * FROM foo t WHERE NOT EXISTS (SELECT remoteid FROM (SELECT f1 as remoteid FROM foo WHERE f1 = t.f1) AS t1) Tom Lane 2002-09-24 18:38:23 +00:00
  • 44f68fc7bd Fix broken markup. Tom Lane 2002-09-23 23:20:38 +00:00
  • 233ecca7c9 Further thinking about heap_mark4update: in HeapTupleSelfUpdated case, executor should not return the tuple as successfully marked, because in fact it's been deleted. Not clear that this case has ever been seen in practice (I think you'd have to write a SELECT FOR UPDATE that calls a function that deletes some row the SELECT will visit later...) but we should be consistent. Also add comments to several other places that got it right but didn't explain what they were doing. Tom Lane 2002-09-23 22:57:44 +00:00
  • 0d3be98ae9 Move PyGreSQL usage documentation from README into DocBook. Some other editing. Peter Eisentraut 2002-09-23 21:10:13 +00:00
  • 5fa3418304 Disallow VACUUM, ANALYZE, TRUNCATE on temp tables belonging to other backends. Given that temp tables now store data locally in the local buffer manager, these things are not going to work safely. Tom Lane 2002-09-23 20:43:41 +00:00
  • c99f820053 Tweak dblink functions to use int4 arguments instead of int2, to avoid having to write explicit casts. From Joe Conway. Tom Lane 2002-09-23 18:03:32 +00:00
  • 245b3d7d5c Add: Bruce Momjian 2002-09-23 14:52:28 +00:00
  • d4123865a3 Update HISTORY for 7.3beta2. Bruce Momjian 2002-09-23 05:25:38 +00:00
  • 8ffec958bc Add win32 rename discussion to archives. Bruce Momjian 2002-09-23 01:59:40 +00:00
  • 909a8377db The valid return value should be MODIFY instead of MODIFIED. The error message said so :-) Bruce Momjian 2002-09-23 01:51:02 +00:00
  • f9a1ea6fa7 Obviously noone has ever tested the doubling of availiable result ids up to reaching the hard limit. After opening 16(=current REST_START value) results via pg_exec, the next pg_exec tries to find an empty slot forever :-( . In PgSetResultId file pgtclId.c in the for loop there has to be done a break, if res_max ist reached. The piece of code should look like if (resid == connid->res_max) { resid = 0; break; /* the break as to be added */ } Bruce Momjian 2002-09-23 01:43:23 +00:00
  • 2816141978 Nothing. Bruce Momjian 2002-09-23 01:39:05 +00:00
  • bc1088c28a Get rid of bogus use of heap_mark4update in reindex operations (cf. recent bug report). Fix processing of nailed-in-cache indexes; it appears that REINDEX DATABASE has been broken for months :-(. Tom Lane 2002-09-23 00:42:48 +00:00
  • df3e7b3a51 In UpdateStats(), don't bother to update the pg_class row if it already contains the correct statistics. This is a partial solution for the problem of allowing concurrent CREATE INDEX commands: unless they commit at nearly the same instant, the second one will see the first one's pg_class updates as committed, and won't try to update again, thus avoiding the 'tuple concurrently updated' failure. Tom Lane 2002-09-22 23:03:58 +00:00
  • 1d01d484c1 Remove commas for compatibility with newer releases of bison. Tom Lane 2002-09-22 21:56:47 +00:00
  • 67ddac35db Remove commas for compatibility with newer bisons. Tom Lane 2002-09-22 21:54:31 +00:00
  • c5a09067d8 Remove extraneous | ... while bison 1.28 doesn't object, newer versions do. Tom Lane 2002-09-22 21:51:18 +00:00
  • 0582874506 Remove commas from %type and %token lists, for compatibility with newer versions of bison. Tom Lane 2002-09-22 21:44:43 +00:00
  • 2972fd5d83 Translation updates, some messages tweaked. Peter Eisentraut 2002-09-22 20:57:21 +00:00
  • 3503f19eeb RelationClearRelation must reset rd_targblock and update rd_nblocks even when dealing with a nailed-in-cache relation; otherwise, following VACUUM truncation of a system catalog, other backends might have unreasonably large values of these fields. Tom Lane 2002-09-22 20:56:28 +00:00
  • 286fb25243 Make \dS work more like it used to, viz, show only system objects. Tom Lane 2002-09-22 20:44:22 +00:00
  • fce573ae16 I haven't seen any objections, so here is a patch. It removes "#define YYERROR_VERBOSE" from contrib/cube and contrib/seg, and adjusts the expected output accordingly. Hopefully this will consistently pass across multiple bison versions. Tom Lane 2002-09-22 20:08:51 +00:00
  • 0b620e33db server_min_messages and friends should have valid values at bootup. Tom Lane 2002-09-22 19:52:38 +00:00
  • c328b6dd8b Replace pg_attribute.attisinherited with attislocal and attinhcount columns, to allow more correct behavior in multiple-inheritance cases. Patch by Alvaro Herrera, review by Tom Lane. Tom Lane 2002-09-22 19:42:52 +00:00
  • 634e440b58 Fix busted markup. Tom Lane 2002-09-22 18:47:24 +00:00
  • 9946b83ded Bring SIMILAR TO and SUBSTRING into some semblance of conformance with the SQL99 standard. (I'm not sure that the character-class features are quite right, but that can be fixed later.) Document SQL99 and POSIX regexps as being different features; provide variants of SUBSTRING for each. Tom Lane 2002-09-22 17:27:25 +00:00
  • ac355d558e Move most of the error checking for foreign-key constraints out of parse analysis and into the execution code (in tablecmds.c). This eliminates a lot of unreasonably complex code that needed to have two or more execution paths in case it was dealing with a not-yet-created table column vs. an already-existing one. The execution code is always dealing with already-created tables and so needs only one case. This also eliminates some potential race conditions (the table wasn't locked between parse analysis and execution), makes it easy to fix the gripe about wrong referenced-column names generating a misleading error message, and lets us easily add a dependency from the foreign-key constraint to the unique index that it requires the referenced table to have. (Cf. complaint from Kris Jurka 12-Sep-2002 on pgsql-bugs.) Tom Lane 2002-09-22 00:37:09 +00:00
  • e303a2dbe8 Add last-ditch defense against attempts to compile datetime code with -ffast-math. Tom Lane 2002-09-21 19:52:41 +00:00
  • eb3adab568 Provide an upgrade strategy for dump files containing functions declared with OPAQUE. CREATE LANGUAGE, CREATE TRIGGER, and CREATE TYPE will all accept references to functions declared with OPAQUE --- but they will issue a NOTICE, and will modify the function entries in pg_proc to have the preferred type-safe argument or result types instead of OPAQUE. Per recent pghackers discussions. Tom Lane 2002-09-21 18:39:26 +00:00
  • bc49968764 Add more appropriate markup. Peter Eisentraut 2002-09-21 18:32:54 +00:00
  • 7233aae50b Fix PPC s_lock operations to work correctly on multi-CPU machines. Need 'isync' during TAS and 'sync' during S_UNLOCK. Tom Lane 2002-09-21 00:14:05 +00:00
  • 826692788d Back-patch fix for failure to dump views containing FULL JOIN USING. The bug is not present in CVS tip due to cleanup of JOIN handling, but 7.2.* is broken. Tom Lane 2002-09-20 21:37:07 +00:00
  • b2735fcd52 Performance improvement for MultiRecordFreeSpace on large relations --- avoid O(N^2) behavior. Problem noted and fixed by Stephen Marshall <smarshall@wsicorp.com>, with some help from Tom Lane. Tom Lane 2002-09-20 19:56:01 +00:00
  • de96cd5e3a Revision Peter Eisentraut 2002-09-20 18:39:41 +00:00
  • 105907f7dc Put in defense against gcc -ffast-math. Peter Eisentraut 2002-09-20 18:38:57 +00:00
  • 316d4e29b2 Code review for check-domain-constraints-in-COPY patch. Do correct thing when default expression for a domain is being used. Avoid repetitive catalog lookups. Tom Lane 2002-09-20 16:56:02 +00:00
  • 4e5c2a8d52 Update regression expected results for to_char() change. Tom Lane 2002-09-20 16:44:55 +00:00
  • 5d115bb548 Change domain patch to COERCE_IMPLICIT_CAST, per Tom. Bruce Momjian 2002-09-20 15:43:03 +00:00
  • a1199e0c4c Fix compile error from Rod's patch. Bruce Momjian 2002-09-20 15:29:44 +00:00
  • 0e25360f1b Synced yet again. Deactivated backend prepare/execute/deallocate for the time being. github/ecpg_big_bison ecpg_big_bison Michael Meskes 2002-09-20 06:19:07 +00:00
  • 0adb4169ca Done: Bruce Momjian 2002-09-20 03:57:57 +00:00
  • c27d95e25d The patch fix bug described in TODO: Bruce Momjian 2002-09-20 03:57:09 +00:00
  • c51a049ef2 Tom Lane wrote: > I see in your recent bytea-LIKE patch > > if (datatype != BYTEAOID && pg_database_encoding_max_length() > 1) > len = pg_mbcliplen((const unsigned char *) workstr, len, len - 1); > else > len -= -1; > > Surely there's one too many minus signs in that last? Bruce Momjian 2002-09-20 03:55:40 +00:00
  • 192b0c94f2 This patch cleans up some of the code in src/util/adt/formatting.c, fixes a few minor bugs (typos, potential buffer overruns, etc.), and fixes some spelling/grammar mistakes. Bruce Momjian 2002-09-20 03:54:57 +00:00
  • ec63143f81 Tiny patch fixing small documentation typo. Bruce Momjian 2002-09-20 03:54:21 +00:00
  • 229eebd559 This patch fixes two typos in src/backend/storage/ipc/README. Bruce Momjian 2002-09-20 03:53:55 +00:00
  • 07a6fa9df1 Fixed this problem and added regression tests in domain.sql. Bruce Momjian 2002-09-20 03:52:50 +00:00
  • 24bebf0b72 I have included fixes to declare some floating point constants as double instead of int, change the calculation method to use the haversine formula which is more accurrate for short distances, added a grant to public for geo_distance and added a regression test. Bruce Momjian 2002-09-20 03:47:22 +00:00
  • a834cbe1e9 > I'm not sure why NDirectFileRead/NDirectFileWrite are unused at the > moment, but they used to be used; I think the correct response is to > put back the missing counter increments, not rip out the counters. Bruce Momjian 2002-09-20 03:45:08 +00:00