hcq/postgresql
1
0
Fork 0
mirror of https://git.postgresql.org/git/postgresql.git synced 2026-03-07 20:57:15 +08:00
Code Issues Packages Projects Releases Wiki Activity

Commit Graph

  • 9d388e1f39 Fix a pair of related issues with estimation of inequalities that involve binary-compatible relabeling of one or both operands. examine_variable should avoid stripping RelabelType from non-variable expressions, so that they will continue to have the correct type; and convert_to_scalar should just use that type and ignore the other input type. This isn't perfect but it beats failing entirely. Per example from Michael Fuhr. Tom Lane 2005-03-26 20:55:39 +00:00
  • bb34970f91 Use a bitmapset instead of a list for duplicate-column checking in checkInsertTargets(). Avoids O(N^2) behavior on wide target lists. Tom Lane 2005-03-26 06:28:59 +00:00
  • 9e5238137d Rewrite rewriteTargetList() to avoid O(N^2) behavior on wide target lists. Tom Lane 2005-03-26 05:53:01 +00:00
  • d4f727808f Make additional stamps for 8.0.2. Bruce Momjian 2005-03-26 05:05:23 +00:00
  • 507fc3c554 Tag for 8.0.2beta1 PostgreSQL Daemon 2005-03-26 03:46:33 +00:00
  • 9b31b4ac29 Add Windows-specific variant comparison file. Tom Lane 2005-03-26 03:38:11 +00:00
  • 4377648b9f Add Windows-specific variant comparison file. Tom Lane 2005-03-26 03:38:01 +00:00
  • cc31f7e7f4 Add another ORDER BY to rules test to eliminate platform-specific output ordering. Tom Lane 2005-03-26 02:14:54 +00:00
  • 58a02c9905 Add another ORDER BY to rules test to eliminate platform-specific output ordering. Tom Lane 2005-03-26 02:14:43 +00:00
  • bdb2d697a7 Prevent to_char(interval) from dumping core on month-related formats when a zero-month interval is given. Per discussion with Karel. Tom Lane 2005-03-26 00:42:56 +00:00
  • 536b3af7e3 Prevent to_char(interval) from dumping core on month-related formats when a zero-month interval is given. Per discussion with Karel. Tom Lane 2005-03-26 00:42:44 +00:00
  • 12fa5c57ac Prevent to_char(interval) from dumping core on month-related formats when a zero-month interval is given. Per discussion with Karel. Tom Lane 2005-03-26 00:42:21 +00:00
  • 209bc96ff6 Prevent to_char(interval) from dumping core on month-related formats when a zero-month interval is given. Per discussion with Karel. Also, some desultory const-labeling of constant tables. More could be done along that line. Tom Lane 2005-03-26 00:41:45 +00:00
  • fccde77ecb Prevent to_char(interval) from dumping core on month-related formats when a zero-month interval is given. Per discussion with Karel. Also, some desultory const-labeling of constant tables. More could be done along that line. Tom Lane 2005-03-26 00:41:31 +00:00
  • a7032690f9 Use 'cp' and 'chmod' in place of 'install' to install header files. This reduces header file install from 8 seconds to 0.40 seconds. Bruce Momjian 2005-03-25 23:22:54 +00:00
  • e341a52037 Add Bruce Momjian 2005-03-25 23:13:22 +00:00
  • 869825c4f2 Remove lazy_update_relstats; go back to having VACUUM just record the actual number of unremoved tuples as pg_class.reltuples. The idea of trying to estimate a steady state condition still seems attractive, but this particular implementation crashed and burned ... Tom Lane 2005-03-25 22:51:42 +00:00
  • 73ed6d61bd Remove lazy_update_relstats; go back to having VACUUM just record the actual number of unremoved tuples as pg_class.reltuples. The idea of trying to estimate a steady state condition still seems attractive, but this particular implementation crashed and burned ... Tom Lane 2005-03-25 22:51:31 +00:00
  • adb1a6e95b Improve EXPLAIN ANALYZE to show the time spent in each trigger when executing a statement that fires triggers. Formerly this time was included in "Total runtime" but not otherwise accounted for. As a side benefit, we avoid re-opening relations when firing non-deferred AFTER triggers, because the trigger code can re-use the main executor's ResultRelInfo data structure. Tom Lane 2005-03-25 21:58:00 +00:00
  • 08890b407e Fix resource owner code to generate catcache and relcache leak warnings when open references remain during normal cleanup of a resource owner. This restores the system's ability to warn about leaks to what it was before 8.0. Not really a user-level bug, but helpful for development. Tom Lane 2005-03-25 18:30:28 +00:00
  • 7751c06852 Have libpgport link before libpq so that PG client applications are more immunte to changes in libpq's usage of pgport between major versions. Bruce Momjian 2005-03-25 18:18:41 +00:00
  • 6b7ef076b5 Have libpgport link before libpq so that PG client applications are more immunte to changes in libpq's usage of pgport between major versions. Bruce Momjian 2005-03-25 18:17:14 +00:00
  • 42a00ef3b8 Fix two bugs in change_owner_recurse_to_sequences: it was grabbing an overly strong lock on pg_depend, and it wasn't closing the rel when done. The latter bug was masked by the ResourceOwner code, which is something that should be changed. Tom Lane 2005-03-25 18:04:47 +00:00
  • 410fede0dd Fix two bugs in change_owner_recurse_to_sequences: it was grabbing an overly strong lock on pg_depend, and it wasn't closing the rel when done. The latter bug was masked by the ResourceOwner code, which is something that should be changed. Tom Lane 2005-03-25 18:04:34 +00:00
  • ae7c18d1ae Update and copy-edit description of privileges. Tom Lane 2005-03-25 16:39:03 +00:00
  • 6d3f74d801 Update and copy-edit description of privileges. Tom Lane 2005-03-25 16:38:58 +00:00
  • f87592fce7 Add missing min/max parameters to DefineCustomIntVariable() and DefineCustomRealVariable(). Thomas Hallgren Tom Lane 2005-03-25 16:17:39 +00:00
  • 519cef22bf Add missing min/max parameters to DefineCustomIntVariable() and DefineCustomRealVariable(). Thomas Hallgren Tom Lane 2005-03-25 16:17:28 +00:00
  • 88f07b183f Fix to_date to behave reasonably when CC and YY fields are both used. Karel Zak Tom Lane 2005-03-25 16:08:50 +00:00
  • 6e26c00297 Fix to_date to behave reasonably when CC and YY fields are both used. Karel Zak Tom Lane 2005-03-25 16:08:40 +00:00
  • c90578a1d6 Make initialization of special trigger variables a little more readable. Correct one mis-setting of freeval (which could at worst leak a few bytes until the trigger exits, so it's no big deal). Tom Lane 2005-03-25 01:45:42 +00:00
  • 87a4f9b6a3 Print URL in printed output.. Bruce Momjian 2005-03-25 01:01:14 +00:00
  • 07ebb9fba9 Add URL of how to report bugs: Bruce Momjian 2005-03-25 00:51:04 +00:00
  • 8416036f5f Kerberos fixes from Magnus Hagander --- in theory Kerberos 5 auth should work on Windows now. Also, rename set_noblock to pg_set_noblock; since it is included in libpq, the former name polluted application namespace. Tom Lane 2005-03-25 00:35:20 +00:00
  • e6befdc9d1 Kerberos fixes from Magnus Hagander --- in theory Kerberos 5 auth should work on Windows now. Also, rename set_noblock to pg_set_noblock; since it is included in libpq, the former name polluted application namespace. Tom Lane 2005-03-25 00:34:31 +00:00
  • cb2a2fd8d0 Revert ill-conceived change of libpq linkage --- breaks ecpg. Tom Lane 2005-03-24 23:54:01 +00:00
  • 46be09e91a Revert ill-conceived change of libpq linkage --- breaks ecpg. Tom Lane 2005-03-24 23:53:48 +00:00
  • 3e65431bc1 array_map can't use the fn_extra field of the provided fcinfo struct as its private storage, because that belongs to the function that it is supposed to call. Per report from Ezequiel Tolnay. Tom Lane 2005-03-24 21:51:04 +00:00
  • e1fc33969a array_map can't use the fn_extra field of the provided fcinfo struct as its private storage, because that belongs to the function that it is supposed to call. Per report from Ezequiel Tolnay. Tom Lane 2005-03-24 21:50:52 +00:00
  • 0dca4fcb0e array_map can't use the fn_extra field of the provided fcinfo struct as its private storage, because that belongs to the function that it is supposed to call. Per report from Ezequiel Tolnay. Tom Lane 2005-03-24 21:50:38 +00:00
  • d5595f986d Force PG client applications to link to non-shared libpgport before linking to libpq. This insulates applications from changes in libpq's usage of libpgport functions. Bruce Momjian 2005-03-24 19:33:40 +00:00
  • 8269ad4ffe Force PG client applications to link to non-shared libpgport before linking to libpq. This insulates applications from changes in libpq's usage of libpgport functions. Bruce Momjian 2005-03-24 19:33:32 +00:00
  • b741e9d419 Tweak planner to use a minimum size estimate of 10 pages for a never-yet-vacuumed relation. This restores the pre-8.0 behavior of avoiding seqscans during initial data loading, while still allowing reasonable optimization after a table has been vacuumed. Several regression test cases revert to 7.4-like behavior, which is probably a good sign. Per gripes from Keith Browne and others. Tom Lane 2005-03-24 19:15:11 +00:00
  • 208ec47ba3 Tweak planner to use a minimum size estimate of 10 pages for a never-yet-vacuumed relation. This restores the pre-8.0 behavior of avoiding seqscans during initial data loading, while still allowing reasonable optimization after a table has been vacuumed. Several regression test cases revert to 7.4-like behavior, which is probably a good sign. Per gripes from Keith Browne and others. Tom Lane 2005-03-24 19:14:49 +00:00
  • 7604267de8 Set socket timer to 58 instead of 60 minutes for hour-old cleaners: Bruce Momjian 2005-03-24 18:16:17 +00:00
  • dd0702a399 Fix python regression testing script to bail out early if language creation fails ... no point in running the tests. Tom Lane 2005-03-24 17:23:39 +00:00
  • 7e1c6f177e Fix python regression testing script to bail out early if language creation fails ... no point in running the tests. Tom Lane 2005-03-24 17:23:34 +00:00
  • 35411a878b Adjust plpython to convert \r\n and \r to \n in Python scripts, per recent discussion concluding that this is the Right Thing. Add regression test check for this behavior. Michael Fuhr Tom Lane 2005-03-24 17:22:44 +00:00
  • 00aa8ed47a Adjust plpython to convert \r\n and \r to \n in Python scripts, per recent discussion concluding that this is the Right Thing. Add regression test check for this behavior. Michael Fuhr Tom Lane 2005-03-24 17:22:34 +00:00
  • 218705958a Touch postmaster log file every hour, rather than every 10 minutes, to prevent complaints from laptop users who don't like their hard drives starting up every 10 minutes. Bruce Momjian 2005-03-24 05:19:05 +00:00
  • 2104f9af87 Add: < > * Add GUC to issue notice about queries that use unjoined tables Bruce Momjian 2005-03-24 05:15:59 +00:00
  • 291cd954fb Change Win32 O_SYNC method to O_DSYNC because that is what the method currently does. This is now the default Win32 wal sync method because we perfer o_datasync to fsync. Bruce Momjian 2005-03-24 04:37:07 +00:00
  • b1f57d88f5 Change Win32 O_SYNC method to O_DSYNC because that is what the method currently does. This is now the default Win32 wal sync method because we perfer o_datasync to fsync. Bruce Momjian 2005-03-24 04:36:20 +00:00
  • 0275b3f783 Update INTERVAL items. Bruce Momjian 2005-03-24 03:50:24 +00:00
  • 3781b72c22 Add missing error checking in readdir() loops. Tom Lane 2005-03-24 02:11:33 +00:00
  • 0ca91482fa Add missing error checking in readdir() loops. Tom Lane 2005-03-24 02:11:20 +00:00
  • c58071a5d1 Change ANSI to ISO standard: Bruce Momjian 2005-03-24 02:11:06 +00:00
  • 50ce8ab9fc Revert changes to CREATE TRIGGER and ALTER TABLE ADD FOREIGN KEY locking, per request from Tom. Neil Conway 2005-03-24 00:03:26 +00:00
  • 8abba63859 Update wording: Bruce Momjian 2005-03-23 22:57:02 +00:00
  • d5dd9dbbfe Update item on ambiguous INTERVAL syntax: Bruce Momjian 2005-03-23 21:49:52 +00:00
  • a15699b9e0 Update ANSI INTERVAL section: Bruce Momjian 2005-03-23 21:10:02 +00:00
  • 63b0d7b35f Add note about risks involved in replaying CREATE TABLESPACE commands from WAL. A couple other grammatical improvements too. Tom Lane 2005-03-23 19:39:06 +00:00
  • 87ba04eeaf Add note about risks involved in replaying CREATE TABLESPACE commands from WAL. A couple other grammatical improvements too. Tom Lane 2005-03-23 19:38:53 +00:00
  • ce49ae9041 Previous "64-bit fix" for intagg didn't actually work. This is already fixed properly in CVS tip, but we need a band-aid for back branches. Per report from Ron Mayer. Tom Lane 2005-03-23 19:07:18 +00:00
  • b4fd104204 Previous "64-bit fix" for intagg didn't actually work. This is already fixed properly in CVS tip, but we need a band-aid for back branches. Per report from Ron Mayer. Tom Lane 2005-03-23 19:07:03 +00:00
  • a4500f3262 Previous "64-bit fix" for intagg didn't actually work. This is already fixed properly in CVS tip, but we need a band-aid for back branches. Per report from Ron Mayer. Tom Lane 2005-03-23 19:06:54 +00:00
  • d27061a3ab Update numbers in example: Bruce Momjian 2005-03-23 17:05:22 +00:00
  • 70d782e64c Update: Bruce Momjian 2005-03-23 16:38:55 +00:00
  • f30c76ce8d Adjust CREATE TRIGGER and ALTER TABLE ... ADD FOREIGN KEY to acquire ExclusiveLock rather than AccessExclusiveLock. This will allow concurrent SELECT queries to proceed on the table. Per discussion with Andrew at SuperNews. Neil Conway 2005-03-23 07:44:57 +00:00
  • ac323044cf Add: Bruce Momjian 2005-03-23 06:11:57 +00:00
  • f6c1f990ab Assign: > o Update pg_dump and psql to use the new COPY libpq API (Christopher) Bruce Momjian 2005-03-23 05:50:58 +00:00
  • 9be9c1fb0c Add: Bruce Momjian 2005-03-23 05:49:22 +00:00
  • 3113d38bec Add INTERVAL items: Bruce Momjian 2005-03-23 05:42:40 +00:00
  • e96ab26277 Remove duplicate: Bruce Momjian 2005-03-23 02:50:56 +00:00
  • b7c2258833 Add: Bruce Momjian 2005-03-23 02:49:42 +00:00
  • 0b2adc1e5f Add: Bruce Momjian 2005-03-23 02:41:29 +00:00
  • 09c165e41e Remove: < o Update to use the newer COPY syntax Bruce Momjian 2005-03-23 02:21:01 +00:00
  • ee10720834 Add for pg_dump: Bruce Momjian 2005-03-23 02:14:11 +00:00
  • aab0159cfb Add: Bruce Momjian 2005-03-23 01:25:07 +00:00
  • 4201ba2459 Remove: Bruce Momjian 2005-03-23 00:36:14 +00:00
  • 5869e883ee WAL must log CREATE and DROP DATABASE operations *without* using any explicit paths, so that the log can be replayed in a data directory with a different absolute path than the original had. To avoid forcing initdb in the 8.0 branch, continue to accept the old WAL log record types; they will never again be generated however, and the code can be dropped after the next forced initdb. Per report from Oleg Bartunov. We still need to think about what it really means to WAL-log CREATE TABLESPACE commands: we more or less have to put the absolute path into those, but how to replay in a different context?? Tom Lane 2005-03-23 00:04:25 +00:00
  • cad86e253b WAL must log CREATE and DROP DATABASE operations *without* using any explicit paths, so that the log can be replayed in a data directory with a different absolute path than the original had. To avoid forcing initdb in the 8.0 branch, continue to accept the old WAL log record types; they will never again be generated however, and the code can be dropped after the next forced initdb. Per report from Oleg Bartunov. We still need to think about what it really means to WAL-log CREATE TABLESPACE commands: we more or less have to put the absolute path into those, but how to replay in a different context?? Tom Lane 2005-03-23 00:03:37 +00:00
  • bd9b4a9d46 Use InitFunctionCallInfoData() macro instead of MemSet in performance critical places in execQual. By Atsushi Ogawa; some minor cleanup by moi. Tom Lane 2005-03-22 20:13:09 +00:00
  • 94e03330cb Create a routine PageIndexMultiDelete() that replaces a loop around PageIndexTupleDelete() with a single pass of compactification --- logic mostly lifted from PageRepairFragmentation. I noticed while profiling that a VACUUM that's cleaning up a whole lot of deleted tuples would spend as much as a third of its CPU time in PageIndexTupleDelete; not too surprising considering the loop method was roughly O(N^2) in the number of tuples involved. Tom Lane 2005-03-22 06:17:03 +00:00
  • 1cef5beeea Fix quote_ident to use quote_identifier rather than its own, not quite up-to-speed logic; in particular this will cause it to quote names that match keywords. Remove unnecessary multibyte cruft from quote_literal (all backend-internal encodings are 8-bit-safe). Tom Lane 2005-03-21 16:29:31 +00:00
  • 775d28302c Fix quote_ident to use quote_identifier rather than its own, not quite up-to-speed logic; in particular this will cause it to quote names that match keywords. Remove unnecessary multibyte cruft from quote_literal (all backend-internal encodings are 8-bit-safe). Tom Lane 2005-03-21 16:29:20 +00:00
  • 6a8eb1a7b6 pgcrypto update: Neil Conway 2005-03-21 05:24:52 +00:00
  • 19b676869a pgcrypto update: Neil Conway 2005-03-21 05:22:14 +00:00
  • 1ea9169b42 pgcrypto update: Neil Conway 2005-03-21 05:21:04 +00:00
  • b160d6b9dc pgcrypto update: Neil Conway 2005-03-21 05:19:55 +00:00
  • fa332a06ec * construct "struct {} list [] = {}" confuses pgindent - split those. It was a bad style to begin with, and now several loops can be clearer. * pgcrypto.c: Fix function comments * crypt-gensalt.c, crypt-blowfish.c: stop messing with errno * openssl.c: use px_free instead pfree * px.h: make redefining px_alloc/px_realloc/px_free easier Neil Conway 2005-03-21 05:18:46 +00:00
  • 3cc8661232 Remove support for libmhash/libmcrypt. Neil Conway 2005-03-21 05:17:16 +00:00
  • ee4ddac137 Convert index-related tuple handling routines from char 'n'/' ' to bool convention for isnull flags. Also, remove the useless InsertIndexResult return struct from index AM aminsert calls --- there is no reason for the caller to know where in the index the tuple was inserted, and we were wasting a palloc cycle per insert to deliver this uninteresting value (plus nontrivial complexity in some AMs). I forced initdb because of the change in the signature of the aminsert routines, even though nothing really looks at those pg_proc entries... Tom Lane 2005-03-21 01:24:04 +00:00
  • fe7015f5e8 Change the return value of HeapTupleSatisfiesUpdate() to be an enum, rather than an integer, and fix the associated fallout. From Alvaro Herrera. Neil Conway 2005-03-20 23:40:34 +00:00
  • 9e0dd84596 On Windows, use QueryPerformanceCounter instead of gettimeofday for EXPLAIN ANALYZE instrumentation. Magnus Hagander Tom Lane 2005-03-20 22:27:52 +00:00
  • 354049c709 Remove unnecessary calls of FlushRelationBuffers: there is no need to write out data that we are about to tell the filesystem to drop. smgr_internal_unlink already had a DropRelFileNodeBuffers call to get rid of dead buffers without a write after it's no longer possible to roll back the deleting transaction. Adding a similar call in smgrtruncate simplifies callers and makes the overall division of labor clearer. This patch removes the former behavior that VACUUM would write all dirty buffers of a relation unconditionally. Tom Lane 2005-03-20 22:00:54 +00:00
  • 683f60da3d Add mention of why malloc() has to be used in snprintf.c. Bruce Momjian 2005-03-20 13:54:53 +00:00
  • 8c72526fe9 Department of second thoughts. Remove FRONTEND from snprintf.c because snprintf is called before the memory system is started. We have to just malloc/free. There are no elogs in the code so we should be fine. Bruce Momjian 2005-03-20 03:53:39 +00:00
  • 169adfcf74 Fix typo in Makefile. Bruce Momjian 2005-03-20 02:44:45 +00:00
  • 83ebbfac75 Another change for FRONTEND snprintf.c. Bruce Momjian 2005-03-20 02:40:28 +00:00