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

  • 5d42962bd3 Update ports. Bruce Momjian 2002-10-26 20:04:55 +00:00
  • 3518fbe86f Add missing semicolons to a few PG_FUNCTION_INFO_V1 calls. Tom Lane 2002-10-26 15:01:01 +00:00
  • 0ed0a9ddc0 Update BSD/OS as supported platform. Bruce Momjian 2002-10-26 02:17:05 +00:00
  • a77b862c09 Add dummy variable declaration to PG_FUNCTION_INFO_V1() to prevent 'empty declaration' warnings from compilers that care about such things. Per discussion back before 7.2 release; we didn't do it then because we'd already missed all the beta cycle ... Tom Lane 2002-10-25 22:17:32 +00:00
  • ba963c651b Remove #warning directive, which is nonstandard and isn't really buying us anything to make it worth the porting risk. Per discussion quite some time ago. Tom Lane 2002-10-25 22:08:44 +00:00
  • ed7be7292e Add: Bruce Momjian 2002-10-25 19:03:04 +00:00
  • 3fd6d3260f Change to fseeko(), per Philip. Bruce Momjian 2002-10-25 03:47:30 +00:00
  • 7ab25fffac Patch submitted by Kris Jurka to fix arrayindexoutofbounds exception caused by improper array initialization. Barry Lind 2002-10-25 02:54:37 +00:00
  • fc5c577e34 Allow fseeko in pg_dump only if fseeko() will work for all supported file sizes. Bruce Momjian 2002-10-25 01:33:17 +00:00
  • 2908a838ac Code review for connection timeout patch. Avoid unportable assumption that tv_sec is signed; return a useful error message on timeout failure; honor PGCONNECT_TIMEOUT environment variable in PQsetdbLogin; make code obey documentation statement that timeout=0 means no timeout. Tom Lane 2002-10-24 23:35:55 +00:00
  • bd19e8f604 Fix some places that were unportably assuming struct timeval's tv_sec field is signed. Clean up casting. Tom Lane 2002-10-24 23:19:13 +00:00
  • c3086c8f53 Function-call-style type coercions should be treated as explicit coercions, not implicit ones. For example, 'select abstime(1035497293)' should succeed because there is an explicit binary coercion from int4 to abstime. Tom Lane 2002-10-24 22:09:00 +00:00
  • 6b704bf501 Add note about sort order of character datatypes being locale-dependent, per suggestion from Nicolaus Erichsen. Tom Lane 2002-10-24 21:19:15 +00:00
  • 3a0fde3b51 Make link to schema inspection functions more clear. Tom Lane 2002-10-24 21:10:58 +00:00
  • 266a280584 Add introductory sections explaining what each book is about. Remove Y2K statement. Peter Eisentraut 2002-10-24 17:48:54 +00:00
  • b171f5956e Fix include for NetBSD. Bruce Momjian 2002-10-24 04:48:08 +00:00
  • 68214218be Add prototype include to fseeko.c. Bruce Momjian 2002-10-24 04:33:46 +00:00
  • 4668d54f0b Add fseeko for NetBSD. Bruce Momjian 2002-10-24 03:11:05 +00:00
  • d36caf103b Stamp for 7.3 beta3. Bruce Momjian 2002-10-24 03:03:37 +00:00
  • b093f8825d Fix include files for new PageOutput call. Bruce Momjian 2002-10-24 01:33:50 +00:00
  • f142b09151 Add fseeko/ftello prototypes for BSD/OS only to c.h. Bruce Momjian 2002-10-23 23:37:47 +00:00
  • 3675d064c9 Add mention of postgres signals to reference page Bruce Momjian 2002-10-23 23:33:08 +00:00
  • 586510f774 Improve coding style of new function. Bruce Momjian 2002-10-23 21:39:27 +00:00
  • 6b9d496988 Make BSD/OS fseeko thread-safe. Bruce Momjian 2002-10-23 21:16:17 +00:00
  • c9984ab79d Add comments on bsd/os handling. Bruce Momjian 2002-10-23 20:59:03 +00:00
  • dc4d18e056 Add fseeko/ftello using fsetpos/fgetpos for BSD/OS. Bruce Momjian 2002-10-23 20:56:24 +00:00
  • 641b658c26 Page \h output and centralize psql paging code in PageOutput(). Bruce Momjian 2002-10-23 19:23:57 +00:00
  • 30963fc200 Perform transaction cleanup operations in a less ad-hoc, more principled order; in particular ensure that all shared resources are released before we release transaction locks. The code used to release locks before buffer pins, which might explain an ancient note I have about a bufmgr assertion failure I'd seen once several years ago, and been unable to reproduce since. (Theory: someone trying to drop a relation might be able to reach FlushRelationBuffers before the last user of the relation had gotten around to dropping his buffer pins.) Tom Lane 2002-10-22 22:44:36 +00:00
  • 68c8bce69e Updated German FAQ, from Ian Barwick Bruce Momjian 2002-10-22 21:44:51 +00:00
  • 7305aa0171 create_index test must run after create_misc test. Tom Lane 2002-10-22 20:20:10 +00:00
  • 0bd223291f Update build system. Peter Eisentraut 2002-10-22 20:03:09 +00:00
  • 1c23cf4371 Update for test changes. Peter Eisentraut 2002-10-22 20:01:15 +00:00
  • 7d970df60e Add DLLIMPORT declarations required by contrib with asserts enabled. Peter Eisentraut 2002-10-22 20:00:48 +00:00
  • 2b287020f4 Allow 8-byte off_t to properly pg_dump, from Philip Warner with mods by Bruce. Bruce Momjian 2002-10-22 19:15:23 +00:00
  • 19cc7bcbe5 Specify that we need bison >= 1.50. Tom Lane 2002-10-22 13:46:59 +00:00
  • f3e1937e5d Move libpgeasy.sgml to gborg. Bruce Momjian 2002-10-21 23:14:10 +00:00
  • 9761f1a07e Move odbc.sgml to gborg ODBC project. Bruce Momjian 2002-10-21 23:10:09 +00:00
  • 200b151615 Fix places that were using IsTransactionBlock() as an (inadequate) check that they'd get to commit immediately on finishing. There's now a centralized routine PreventTransactionChain() that implements the necessary tests. Tom Lane 2002-10-21 22:06:20 +00:00
  • f724c164d3 Add: Bruce Momjian 2002-10-21 20:35:07 +00:00
  • b6f0c50232 Small update for the removal of some memory leaks in plpython SGML example. Bruce Momjian 2002-10-21 20:34:09 +00:00
  • b825a8f025 When I removed the cube based stuff from eathdistance I accidentally left a reference to cube in a comment in the regression test (that also shows up in the expected output). This doesn't cause any real problem, but people who read the comment might be confused. Attached is a diff to remove the reference. Bruce Momjian 2002-10-21 20:33:21 +00:00
  • 2110be0465 Cleanup for CLUSTERDB failure: Bruce Momjian 2002-10-21 20:32:33 +00:00
  • e49c1a9234 Fix ALTER TABLE ... ADD COLUMN for inheritance cases. Bruce Momjian 2002-10-21 20:31:52 +00:00
  • b47c3598d4 Remove unnecessary (and inadequate) check of IsTransactionBlock() in pgstat_vacuum_tabstat(). Assume that caller (namely, VACUUM) has done the appropriate state checking beforehand. Tom Lane 2002-10-21 19:59:14 +00:00
  • a20e49bea8 Avoid using IsTransactionBlock() in DeferredTriggerSetState(); no real need for this optimization, and it's too easily fooled anyway. Tom Lane 2002-10-21 19:55:49 +00:00
  • e16f04cf72 Make CREATE/ALTER/DROP USER/GROUP transaction-safe, or at least pretty nearly so, by postponing write of flat password file until transaction commit. Tom Lane 2002-10-21 19:46:45 +00:00
  • de9d7f4bd5 Add DLLIMPORT declarations needed by contrib modules. Peter Eisentraut 2002-10-21 18:57:35 +00:00
  • 0530d7a24b Need sys/param.h for endianness macros. Peter Eisentraut 2002-10-21 18:56:30 +00:00
  • 6adf38ac8c Might need to link with -lcrypt. Peter Eisentraut 2002-10-21 18:55:10 +00:00
  • b91f9042b0 Add guards against double inclusion. Peter Eisentraut 2002-10-21 18:53:20 +00:00
  • 20f77d79a2 Translation updates Peter Eisentraut 2002-10-21 18:51:03 +00:00
  • 7a35d304e9 Remove obsoleted stuff merged in from branch. Peter Eisentraut 2002-10-21 18:05:24 +00:00
  • cc4f576957 Improve ECPG documentation. Peter Eisentraut 2002-10-21 18:04:05 +00:00
  • cf8da4e9f0 Merged ecpg_big_bison back into HEAD Michael Meskes 2002-10-21 13:09:31 +00:00
  • 79382cb91f Update multibyte Japanese document Tatsuo Ishii 2002-10-21 05:14:06 +00:00
  • 210a039d4f Since ANY is a reserved word, better suggest that ANY be quoted when used for the input type of an aggregate. Tom Lane 2002-10-21 04:33:39 +00:00
  • 156408e97b Fix documented sizes of geometric types. Tom Lane 2002-10-21 02:12:08 +00:00
  • a92df3a208 Fix example of doing a restore. Tom Lane 2002-10-21 02:11:37 +00:00
  • e5cf1a8a26 SET autocommit no longer needed in /contrib because pg_regress.sh does it automatically now on regression session startup. Bruce Momjian 2002-10-21 01:42:14 +00:00
  • 189c3481c4 Updates from Ian Barwick. Bruce Momjian 2002-10-21 00:47:44 +00:00
  • 24af7929ce Done: Bruce Momjian 2002-10-21 00:36:24 +00:00
  • 20d31fd609 Completely remove /contrib/retep, with Peter's approval; now on Source Forge. Bruce Momjian 2002-10-21 00:35:41 +00:00
  • 9c7cd8ba15 First step to removing /contrib/retep, with Peter Mount's approval. Bruce Momjian 2002-10-21 00:12:46 +00:00
  • 76cadb59fe Remove trailing blanks in cvs.sgml. Bruce Momjian 2002-10-20 20:58:02 +00:00
  • 13416a1f8f Fix potential problem with btbulkdelete deleting an indexscan's current item, if the page containing the current item is split while the indexscan is stopped and holds no read-lock on the page. The current item might move right onto a page that the indexscan holds no pin on. In the prior code this would allow btbulkdelete to reach and possibly delete the item, causing 'my bits moved right off the end of the world!' when the indexscan finally resumes. Fix by chaining read-locks to the right during _bt_restscan and requiring btbulkdelete to LockBufferForCleanup on every page it scans, not only those with deletable items. Per my pghackers message of 25-May-02. (Too bad no one could think of a better way.) Tom Lane 2002-10-20 20:47:31 +00:00
  • 4d1aaedac0 Fix core dump recently introduced into pgbench. Tom Lane 2002-10-20 19:38:10 +00:00
  • 29eabaa958 Returns exit status 1 if invalid encoding name or encoding number is given. Tatsuo Ishii 2002-10-20 11:33:48 +00:00
  • c918be6a17 Update description of numeric constants to match 7.3 reality. Miscellaneous other copy-editing. Tom Lane 2002-10-20 05:05:46 +00:00
  • 2b2cf392fe Update char/varchar()/text/bytea to mention they have similar performance characteristics. Bruce Momjian 2002-10-20 02:58:56 +00:00
  • 06b297938d Applied patch from Teofilis Martisius to improve performance. Also removed some unused files and fixed the which needed a small change after the previous patch to build.xml. Barry Lind 2002-10-20 02:55:50 +00:00
  • e9f07b14e1 Add: Bruce Momjian 2002-10-20 02:51:21 +00:00
  • c650d52e14 Update Japanese FAQ, from Jun Kuwamura. Bruce Momjian 2002-10-20 02:37:49 +00:00
  • 55c6f06991 Add: Bruce Momjian 2002-10-20 02:30:04 +00:00
  • f1c0071d5a Add warning that autocommit=off is not well-supported yet. Tom Lane 2002-10-20 01:43:32 +00:00
  • ab901c60c8 Move BeOS and QNX4 to unsupported-platform list, until someone cares to expend the effort to update them for new semaphore code. Tom Lane 2002-10-20 01:38:18 +00:00
  • a044e2abdd Rule rewriter was doing the wrong thing with conditional INSTEAD rules whose conditions might yield NULL. The negated qual to attach to the original query is properly 'x IS NOT TRUE', not 'NOT x'. This fix produces correct behavior, but we may be taking a performance hit because the planner is much stupider about IS NOT TRUE than it is about NOT clauses. Future TODO: teach prepqual, other parts of planner how to cope with BooleanTest clauses more effectively. Tom Lane 2002-10-20 00:58:55 +00:00
  • 6d6b582850 Disallow aggregate functions in rule WHERE clauses. Per gripe from Fritz Lehmann-Grube back in January. Tom Lane 2002-10-20 00:31:53 +00:00
  • ea794574f1 Applied patch submitted by Mike Beachy to give a better error message if configure hasn't been run before trying to build. Also cleaned up the README file and removed some obsolete files. Barry Lind 2002-10-20 00:10:55 +00:00
  • 272bf59d29 Fix inconsistent formatting. Tom Lane 2002-10-19 23:09:20 +00:00
  • 93dca0d224 Fix incomplete definition of ALTER TABLE ADD/DROP CONSTRAINT syntax. Add some verbiage about recent tweaks to behavior of ADD and DROP COLUMN when there are descendant tables. Tom Lane 2002-10-19 22:51:45 +00:00
  • 4a67565b37 Fix within-function memory leaks in the various PLs' interfaces to SPI_prepare: they all save the prepared plan into topCxt, and so the procCxt copy that's actually returned by SPI_prepare ought to be freed. Diagnosis and plpython fix by Nigel Andrews, followup for other PLs by Tom Lane. Tom Lane 2002-10-19 22:10:58 +00:00
  • 30c2b5ec72 Applied patch submitted by Kris Jurka to result in a better error message under some circumstances and handle negative money values better. Barry Lind 2002-10-19 22:10:36 +00:00
  • 78b13fee45 Fix pltcl self-test for recent changes to elog. Tom Lane 2002-10-19 22:01:45 +00:00
  • ba7c2d2b00 Backed out part of the change from 1.6. The attempt to support int8 binds in such a way that indexes on int8 columns would be used (by quoting the value) caused other problems. Will need to wait for the backend to properly fix the root problem. Barry Lind 2002-10-19 21:53:42 +00:00
  • 76d09f4610 Fix case where a function in FROM returns a scalar type, but is referred to with whole-tuple syntax. Tom Lane 2002-10-19 21:23:20 +00:00
  • 0d93e385b0 Make psql's \df display functions that return sets as having return type 'setof something'; formerly you could not tell at all that the function returns set. Tom Lane 2002-10-19 20:50:44 +00:00
  • 60992456ed Invert logic in pg_exec_query_string() so that we set a snapshot for all utility statement types *except* a short list, per discussion a few days ago. Add missing SetQuerySnapshot calls in VACUUM and REINDEX, and guard against calling REINDEX DATABASE from a function (has same problem as VACUUM). Tom Lane 2002-10-19 20:15:09 +00:00
  • c1f91a38e2 Fix rewrite code so that rules are in fact executed in order by name, rather than being reordered according to INSTEAD attribute for implementation convenience. Also, increase compiled-in recursion depth limit from 10 to 100 rewrite cycles. 10 seems pretty marginal for situations where multiple rules exist for the same query. There was a complaint about this recently, so I'm going to bump it up. (Perhaps we should make the limit a GUC parameter, but that's too close to being a new feature to do in beta.) Tom Lane 2002-10-19 19:00:47 +00:00
  • 757b98fda8 Back out Alvaro's patch until regression tests pass. Bruce Momjian 2002-10-19 03:01:09 +00:00
  • c0f7dcdac1 Fix range-query estimation to not double-exclude NULLs, per gripe from Ray Ontko 28-June-02. Also, fix prefix_selectivity for NAME lefthand variables (it was bogusly assuming binary compatibility), and adjust make_greater_string() to not call pg_mbcliplen() with invalid multibyte data (this last per bug report that I can't find at the moment, but it was in July '02). Tom Lane 2002-10-19 02:56:16 +00:00
  • a3cb8746d9 Add: Bruce Momjian 2002-10-19 02:31:10 +00:00
  • 1a63cc5e90 Fix compile failure caused by new patch. Bruce Momjian 2002-10-19 02:25:51 +00:00
  • 64acc5e3f1 Remove mention of utils/getopt.c. Not used anymore. Bruce Momjian 2002-10-19 02:23:26 +00:00
  • 8e6b5c8b27 It includes -Support for mirroring tables in different Schema's -Improved documentation for compiling with 7.1.x and 7.2.x -Fixes a buffer overrun bug. Bruce Momjian 2002-10-19 02:16:40 +00:00
  • cabad378fc > Huh, I don't know where I got the idea you were (or someone else was?) > in the position that attislocal should be reset. I'll clean everything > up and submit the patch I had originally made. Bruce Momjian 2002-10-19 02:09:45 +00:00
  • bab3d29fba This patch adds some missing functions for float8 math operations, specifically ceil(), floor(), and sign(). There may be other functions that need to be added, but this is a start. I've included some simple regression tests. Bruce Momjian 2002-10-19 02:08:19 +00:00
  • 5c6a5fe18b Make regression tests safe for autocommit = 'off'. Bruce Momjian 2002-10-19 01:35:43 +00:00
  • 5a0a79d694 Add missing #include <errno.h>. Tom Lane 2002-10-19 00:25:36 +00:00
  • 44dc9c1faa Fix psql's \copy to accept table names containing schemas, as well as a column list. Bring its parsing of quoted names and quoted strings somewhat up to speed --- I believe it now handles all non-error cases the same way the backend would, but weird boundary conditions are not necessarily done the same way. Tom Lane 2002-10-19 00:22:14 +00:00
  • 4cff161703 Improve formatting of --help output. Peter Eisentraut 2002-10-18 22:05:36 +00:00