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

Commit Graph

  • b800196230 Fix typo in comment, as noted by Weiping He. Tom Lane 2003-07-14 20:34:18 +00:00
  • de98a7e23a The default values for shared_buffers and max_connections are now 1000 and 100 respectively, if the platform will allow it. initdb selects values that are not too large to allow the postmaster to start, and places these values in the installed postgresql.conf file. This allows us to continue to start up out-of-the-box on platforms with small SHMMAX, while having somewhat-realistic default settings on platforms with reasonable SHMMAX. Per recent pghackers discussion. Tom Lane 2003-07-14 20:00:23 +00:00
  • 8460000069 Whoops, missed committing this change to match cosmetic changes in ascii.c. Tom Lane 2003-07-14 16:58:24 +00:00
  • 90011a8918 Fix a *second* buffer overrun bug in to_ascii(). Grumble. Tom Lane 2003-07-14 16:41:56 +00:00
  • 537c1c1983 Fix a *second* buffer overrun bug in to_ascii(). Grumble. Tom Lane 2003-07-14 16:41:46 +00:00
  • b1eb992cc5 Fix a *second* buffer overrun bug in to_ascii(). Grumble. Tom Lane 2003-07-14 16:41:38 +00:00
  • 6eb27d16b6 Missed one rule in syncinc preproc.y which resulted in reduce/reduce conflicts. Michael Meskes 2003-07-14 12:18:25 +00:00
  • e895eb197d - Synced preproc.y with gram.y - Init sqlca in ECPGprepare(). - Added CLOSE DATABASE for Informix compatibility. Michael Meskes 2003-07-14 10:16:45 +00:00
  • cbdda3e2a9 Add description for new GUC context. Bruce Momjian 2003-07-09 17:57:47 +00:00
  • 18936ef372 Argh! Missed one file. Michael Meskes 2003-07-09 14:53:18 +00:00
  • abfa8ae54f Fixed some Informix compat functions so they handle NULL resp. indicators better. Michael Meskes 2003-07-09 13:49:38 +00:00
  • 4afcba05de Doc update for LOG_MIN_DURATION_STATEMENT set to zero. Bruce Momjian 2003-07-09 08:52:56 +00:00
  • 0ecc8ac425 Add special checks for non-super-user setting LOG_MIN_DURATION_STATEMENT to zero. Bruce Momjian 2003-07-09 08:51:19 +00:00
  • bf889e649a Add new USERLIMIT GUC source level so certain options can be disabled or increased only by super-users. Bruce Momjian 2003-07-09 06:47:34 +00:00
  • 6896bfa86c Applied patch from Kim Ho @ redhat.com to make support for setObject() more spec complient with regards to various data/time/timestamp objects Barry Lind 2003-07-09 05:12:04 +00:00
  • f207718b0c More informix fixes. Michael Meskes 2003-07-08 12:11:35 +00:00
  • fee6fd7f65 Fix segfault in connect in informix mode. Michael Meskes 2003-07-08 07:13:48 +00:00
  • 91d60637cf "char *" of course is not the same as "char []". So I had to fix the way ecpg treated the second one. Michael Meskes 2003-07-07 12:15:33 +00:00
  • 841b4a2d55 tm2timestamp should return -1, not elog, on overflow. (In the backend this is merely an API inconsistency, but in ecpg it's fatal.) Also, fix misconceived overflow test in HAVE_INT64_TIMESTAMP case. Tom Lane 2003-07-04 18:21:14 +00:00
  • 3abbce39d5 Fix missing code for HAVE_INT64_TIMESTAMP. Tom Lane 2003-07-04 18:15:10 +00:00
  • b700a672fe Add --help-config facility to dump information about GUC parameters without needing a running backend. Reorder postgresql.conf.sample to match new layout of runtime.sgml. This commit re-adds work lost in Wednesday's crash. Tom Lane 2003-07-04 16:41:22 +00:00
  • efbbd107c7 Add #include <limits.h> (re-add lost change from Wednesday). Tom Lane 2003-07-04 16:28:03 +00:00
  • c7fddd3072 date, interval and timestamp data should be quoted. Michael Meskes 2003-07-04 12:00:52 +00:00
  • 23e4fc18a7 Fixed informix behaviour for select without into. Michael Meskes 2003-07-04 11:30:48 +00:00
  • 79fafdf49c Some early work on error message editing. Operator-not-found and function-not-found messages now distinguish the cases no-match and ambiguous-match, and they follow the style guidelines too. Tom Lane 2003-07-04 02:51:34 +00:00
  • cdb8a844e6 Fix bug I introduced in recent rewrite of NUMERIC code: numeric to integer conversions gave the wrong answer for values with stripped trailing zeroes, such as 10000000. Tom Lane 2003-07-03 19:41:47 +00:00
  • b89140a7ec Do honest transformation and preprocessing of LIMIT/OFFSET clauses, instead of the former kluge whereby gram.y emitted already-transformed expressions. This is needed so that Params appearing in these clauses actually work correctly. I suppose some might claim that the side effect of 'SELECT ... LIMIT 2+2' working is a new feature, but I say this is a bug fix. Tom Lane 2003-07-03 19:07:54 +00:00
  • 455891bf96 Code review for UPDATE tab SET col = DEFAULT patch ... whack it around so it has some chance of working in rules ... Tom Lane 2003-07-03 16:34:26 +00:00
  • 7b1885bf98 Fixed initialization bug and added postgres_fe.h to pgtypeslib. Michael Meskes 2003-07-02 07:57:36 +00:00
  • b837c99210 Support polymorphic functions in plpgsql. Along the way, replace linked-list search of function cache with hash-table lookup. By Joe Conway. Tom Lane 2003-07-01 21:47:09 +00:00
  • cc3002313f Fix ecpg typo --- change ;; to ;. Bruce Momjian 2003-07-01 19:58:23 +00:00
  • e3b1b6c0cd Aggregates can be polymorphic, using polymorphic implementation functions. It also works to create a non-polymorphic aggregate from polymorphic functions, should you want to do that. Regression test added, docs still lacking. By Joe Conway, with some kibitzing from Tom Lane. Tom Lane 2003-07-01 19:10:53 +00:00
  • 02b5d8e371 Dept. of second thoughts: supporting inlining of polymorphic SQL functions takes only a few more lines of code than preventing it, so might as well support it. Tom Lane 2003-07-01 19:07:02 +00:00
  • dc8dec6a70 Fix documentation comment about restricted environments, per Kevin Jacobs. Tom Lane 2003-07-01 13:52:29 +00:00
  • e0016db7d2 STRENGH => STRENGTH, per Jon Jensen. Tom Lane 2003-07-01 13:49:47 +00:00
  • 2bdd2e5dcf Use ISO dates in pgtypeslib by default. Applied patch by Philip Yarra to fix some thread issues. Added a new data type "decimal" which is mostly the same as our "numeric" but uses a fixed length array to store the digits. This is for compatibility with Informix and maybe others. Michael Meskes 2003-07-01 12:40:52 +00:00
  • f973b74583 Department of second thoughts: even if we can't run the full parser on a SQL function with polymorphic inputs, we can at least run the raw parser to catch silly syntactic errors. Tom Lane 2003-07-01 01:28:32 +00:00
  • c5faf2cf3c Translation update Peter Eisentraut 2003-07-01 00:05:49 +00:00
  • d6d07a0eea SQL functions can have arguments and results declared ANYARRAY or ANYELEMENT. The effect is to postpone typechecking of the function body until runtime. Documentation is still lacking. Tom Lane 2003-07-01 00:04:39 +00:00
  • 71e9f3b07f Change EXECUTE INTO to CREATE TABLE AS EXECUTE. Peter Eisentraut 2003-07-01 00:04:31 +00:00
  • df08f5c003 patches by Kim Ho to fix getByte, getSort if input has decimal or whitespace setObject if object is a BIT boolean not on list of SQLKeywords Dave Cramer 2003-06-30 21:10:55 +00:00
  • ede1734cf8 Update contrib/Makefile's list of subdirectories that it does not try to build. Tom Lane 2003-06-30 20:02:53 +00:00
  • 142cb7b3f4 Put back inappropriately-removed entry for earthdistance subdirectory. Tom Lane 2003-06-30 19:58:57 +00:00
  • 6115224448 Rename plpython to plpythonu, and update documentation to reflect its now-untrusted status. Tom Lane 2003-06-30 18:31:42 +00:00
  • 219e29784d Add GUC option log_error_verbosity to control which fields of error reports get put into the postmaster log. Options are TERSE, DEFAULT, VERBOSE, with the same behavior as implemented on the client side in libpq. Tom Lane 2003-06-30 16:47:02 +00:00
  • a3cac5a3bf Minor jdbc doc updates submitted by Kris Jurka Barry Lind 2003-06-30 16:39:42 +00:00
  • 9af05a9d10 Patches applied: 1) Patch from Kris Jurka to fix IPv6 parsing of the jdbc URL 2) Patch from Kris Jurka to fix an ArrayIndexOutOfBounds error when calling moveToCurrentRow while currentRow is "beforeFirst" 3) Patch from Kim Ho to fix add some bounds checking in setMaxRows(), setQueryTimeout(), setFetchSize() Barry Lind 2003-06-30 16:38:30 +00:00
  • 835bb975d8 Restructure building of join relation targetlists so that a join plan node emits only those vars that are actually needed above it in the plan tree. (There were comments in the code suggesting that this was done at some point in the dim past, but for a long time we have just made join nodes emit everything that either input emitted.) Aside from being marginally more efficient, this fixes the problem noted by Peter Eisentraut where a join above an IN-implemented-as-join might fail, because the subplan targetlist constructed in the latter case didn't meet the expectation of including everything. Along the way, fix some places that were O(N^2) in the targetlist length. This is not all the trouble spots for wide queries by any means, but it's a step forward. Tom Lane 2003-06-29 23:05:05 +00:00
  • cf883ea95c - Made sure Informix style decimal vars are initialized. They use a fixed amount of digits and not an allocated one. So we have to work around. PostgreSQL numeric type remains the same. - In INFORMIX_SE mode with autcommit set, make all cursors be "with hold". Is this really they way SE behaves? Michael Meskes 2003-06-29 16:52:58 +00:00
  • 4355d4fb21 Information schema views for group privileges, some corrections on column privileges. Peter Eisentraut 2003-06-29 15:14:41 +00:00
  • ae20518c7e It was comparing the wrong pair of columns, which triggered the previously mentioned bug. Peter Eisentraut 2003-06-29 10:18:26 +00:00
  • 823bd7d129 Add missing PO files from last commit. Peter Eisentraut 2003-06-29 10:13:13 +00:00
  • 9aeb1eff24 Just another sync. Michael Meskes 2003-06-29 09:25:19 +00:00
  • bee217924d Support expressions of the form 'scalar op ANY (array)' and 'scalar op ALL (array)', where the operator is applied between the lefthand scalar and each element of the array. The operator must yield boolean; the result of the construct is the OR or AND of the per-element results, respectively. Tom Lane 2003-06-29 00:33:44 +00:00
  • df7618020b Merge PO file updates from 7.3 branch. Peter Eisentraut 2003-06-28 22:31:01 +00:00
  • 2f80f81e5e Make information schema aware of arrays. Peter Eisentraut 2003-06-28 20:50:08 +00:00
  • c1fad341b4 Add: Bruce Momjian 2003-06-28 18:05:12 +00:00
  • e8902f00cc Group ISBN/ISSN definitions. Bruce Momjian 2003-06-28 00:36:40 +00:00
  • f9ebf36970 Update psql for some features of new FE/BE protocol. There is a client-side AUTOCOMMIT mode now: '\set AUTOCOMMIT off' supports SQL-spec commit behavior. Get rid of LO_TRANSACTION hack --- the LO operations just work now, using libpq's ability to track the transaction status. Add a VERBOSE variable to control verboseness of error message display, and add a %T prompt-string code to show current transaction-block status. Superuser state display in the prompt string correctly follows SET SESSION AUTHORIZATION commands. Control-C works to get out of COPY IN state. Tom Lane 2003-06-28 00:12:40 +00:00
  • ea20397b79 When using new protocol, PQexec can get out of a COPY IN or COPY OUT state by itself, so do so. Tom Lane 2003-06-28 00:06:01 +00:00
  • bf75f1a063 Adjust pgtest grep. Bruce Momjian 2003-06-27 22:04:50 +00:00
  • 757b718476 Update pgtest to use 'gmake check'. Bruce Momjian 2003-06-27 21:46:20 +00:00
  • ea886339b8 Add is_superuser parameter reporting, soon to be used by psql. Tom Lane 2003-06-27 19:08:38 +00:00
  • 3e0bdfadc3 Document kernel changes needed for BSD/OS 4.3. Bruce Momjian 2003-06-27 18:20:50 +00:00
  • 7f1249a8d2 Fix compile warnings. Tom Lane 2003-06-27 17:07:03 +00:00
  • 7dc5472d48 Missing calls to PQclear in large_obj.c and describe.c. Tom Lane 2003-06-27 16:55:23 +00:00
  • b256f24264 First batch of object rename commands. Peter Eisentraut 2003-06-27 14:45:32 +00:00
  • 5bac7d11dd Remove as duplicate: Bruce Momjian 2003-06-27 04:35:41 +00:00
  • 7e741ba39c Add: Bruce Momjian 2003-06-27 02:48:44 +00:00
  • b3c0551eda Create real array comparison functions (that use the element datatype's comparison functions), replacing the highly bogus bitwise array_eq. Create a btree index opclass for ANYARRAY --- it is now possible to create indexes on array columns. Arrange to cache the results of catalog lookups across multiple array operations, instead of repeating the lookups on every call. Add string_to_array and array_to_string functions. Remove singleton_array, array_accum, array_assign, and array_subscript functions, since these were for proof-of-concept and not intended to become supported functions. Minor adjustments to behavior in some corner cases with empty or zero-dimensional arrays. Tom Lane 2003-06-27 00:33:26 +00:00
  • 0c985ab5a8 Add comment pointing out that XLByteToPrevSeg macro is not broken. Tom Lane 2003-06-26 18:23:07 +00:00
  • 4505653e54 Added just another compatibility level for Informix. Michael Meskes 2003-06-26 11:37:05 +00:00
  • b143210639 Wrap LONG_LONG_MIN redfinition around HAVE_LONG_LONG_INT_64. Bruce Momjian 2003-06-26 01:45:04 +00:00
  • 095a0c83d5 Fix compile problem for missing LONG_LONG_MIN on BSD/OS. Bruce Momjian 2003-06-26 01:33:23 +00:00
  • 9279a802c4 Add: Bruce Momjian 2003-06-25 21:56:55 +00:00
  • ae81bb3cdc sync Bruce Momjian 2003-06-25 21:55:44 +00:00
  • 1f97063901 sync Bruce Momjian 2003-06-25 21:47:53 +00:00
  • bcb716854c sync Bruce Momjian 2003-06-25 21:47:24 +00:00
  • 7b65bdc1e4 sync Bruce Momjian 2003-06-25 21:46:10 +00:00
  • 7370eefd20 sync Bruce Momjian 2003-06-25 21:45:40 +00:00
  • a83fe08bcb sync Bruce Momjian 2003-06-25 21:45:06 +00:00
  • c1026d0460 Add: Bruce Momjian 2003-06-25 21:42:07 +00:00
  • a130d624b4 Add: Bruce Momjian 2003-06-25 21:40:48 +00:00
  • ec67d2a3fe Back out rserv changes that would allow limit of replicated tables --- not ready yet. Bruce Momjian 2003-06-25 21:37:53 +00:00
  • 111d8e522b Back out array mega-patch. Bruce Momjian 2003-06-25 21:30:34 +00:00
  • 621691d816 In ISO datestyle, never emit just HH:MM, always emit HH:MM:SS or HH:MM:SS.SSS... when there is a nonzero part-of-a-day field in an interval value. The seconds part used to be suppressed if zero, but there's no equivalent behavior for timestamp, and since we're modeling this format on timestamp it's probably wrong. Per complaint and patch from Larry Rosenman. Tom Lane 2003-06-25 21:14:15 +00:00
  • d2ba12b4ef sync Bruce Momjian 2003-06-25 21:08:06 +00:00
  • 944ad408c5 sync Bruce Momjian 2003-06-25 21:07:28 +00:00
  • a26839ab9a sync Bruce Momjian 2003-06-25 21:06:29 +00:00
  • 263b42f289 Don't generate 'zero' typeids in the output from gen_cross_product. This is no longer necessary or appropriate since we don't use zero typeid as a wildcard anymore, and it fixes a nasty performance problem with functions with many parameters. Per recent example from Reuven Lerner. Tom Lane 2003-06-25 20:07:54 +00:00
  • 5cf18b1ae3 Don't generate 'zero' typeids in the output from gen_cross_product. This is no longer necessary or appropriate since we don't use zero typeid as a wildcard anymore, and it fixes a nasty performance problem with functions with many parameters. Per recent example from Reuven Lerner. Tom Lane 2003-06-25 20:07:39 +00:00
  • 91e6f51afb 'third' -> 'fourth' where needed, per Joe Conway. Tom Lane 2003-06-25 18:13:50 +00:00
  • 6f30d5665c The remaining files ... Michael Meskes 2003-06-25 17:55:50 +00:00
  • 8d8b9401b8 remove including of postgres_fe.h Michael Meskes 2003-06-25 16:12:27 +00:00
  • 60050936ff sync. Bruce Momjian 2003-06-25 15:01:14 +00:00
  • 54fae9c20a Some systems need another header file included. Michael Meskes 2003-06-25 11:51:18 +00:00
  • fd3ca524eb Implemented Informix special way to treat NULLs, removed warnings, synced. Michael Meskes 2003-06-25 10:44:21 +00:00
  • ff4c69e021 Fix up JOIN .. USING with domains Bruce Momjian 2003-06-25 04:32:03 +00:00
  • faa8c75799 Done: Bruce Momjian 2003-06-25 04:23:59 +00:00
  • f7827bdcf1 Done: Bruce Momjian 2003-06-25 04:19:35 +00:00