hcq/postgresql
1
0
Fork 0
mirror of https://git.postgresql.org/git/postgresql.git synced 2026-02-16 11:26:59 +08:00
Code Issues Packages Projects Releases Wiki Activity

Commit Graph

  • 58f6b951c2 Fix a lot of confusion between typlen and typmod. Didn't hurt too much back when only varlena types paid any attention to typmod ... Tom Lane 2001-10-19 19:43:19 +00:00
  • 861a679fc1 Set optreset on platforms that have it before launching postmaster subprocesses; perhaps this will fix portability problem just noted by Lockhart. Also, move test for bad permissions of DataDir to a more logical place. Tom Lane 2001-10-19 18:19:41 +00:00
  • 6430e6e283 Ensure that all startup paths (postmaster, standalone postgres, or bootstrap) check for a valid PG_VERSION file before looking at anything else in the data directory. This fixes confusing error report when trying to start current sources in a pre-7.1 data directory. Per trouble report from Rich Shepard 10/18/01. Tom Lane 2001-10-19 17:03:08 +00:00
  • 3d510653a4 Rename macro arg to avoid useless compiler warning when building plperl. Tom Lane 2001-10-19 15:38:57 +00:00
  • 2e65523f4f Without this patch I couldn't compile PostgreSQL on Solaris 8 x86 using Sun's compiler. May be it will be usefull for someone else? Bruce Momjian 2001-10-19 15:06:48 +00:00
  • ece1b67f54 > This stops the interface from leaking the row tuples (and thus the > results of every fetch). Bruce Momjian 2001-10-19 15:00:26 +00:00
  • 9590249e14 Update TODO list. Bruce Momjian 2001-10-19 14:59:04 +00:00
  • a535cd1f8b removed "not fully implemented" warning for nullif Michael Meskes 2001-10-19 14:31:44 +00:00
  • 8c3cb43bac Change SC_fetch() to not retrieve data in case the SQL_RETRIEVE_DATA option is SQL_RD_OFF. This would avoid a crash when scrolling Grid controls. Hiroshi Inoue 2001-10-19 05:39:14 +00:00
  • abbc95e5c6 Fix pltcl to update cached function def after CREATE OR REPLACE FUNCTION. Tom Lane 2001-10-19 02:43:46 +00:00
  • efd72ce376 Update TODO list. Bruce Momjian 2001-10-19 01:30:17 +00:00
  • 6b5aeb797f Typo. Tom Lane 2001-10-19 00:46:51 +00:00
  • eb133197b6 Move init_ps_display from postgres.c to postmaster.c, putting it just after receipt of the startup packet. Now, postmaster children that are waiting for client authentication response will show as 'postgres: user database host authentication'. Also, do an init_ps_display for startup/shutdown/checkpoint subprocesses, so that they are readily identifiable as well. Fix an obscure race condition that could lead to Assert failure in the postmaster --- attempting to start a checkpoint process before any connections have been received led to calling PostmasterRandom before setting random_seed. Tom Lane 2001-10-19 00:44:08 +00:00
  • 9047292725 Spell 'between' correctly, clean up spacing in error messages. Tom Lane 2001-10-18 23:16:09 +00:00
  • 43568d11ad Fix memory leakage when sending notice messages to client. Tom Lane 2001-10-18 23:07:29 +00:00
  • aed378e8d1 Fix authentication so that it doesn't record an extra 'Password authentication failed' and a 'send() failed: Broken pipe' message on every connection from psql in password auth mode. Problem is that psql doesn't ask user for a password until it sees a password challenge failure, and libpq just closes the connection unceremoniously if it's challenged for a password when it hasn't got one to send. Accordingly, EOF from the client after asking for a password is normal behavior and should not result in postmaster log entries. Tom Lane 2001-10-18 22:44:37 +00:00
  • 13e467f74f Add STATUS_EOF value needed for auth.c. Remove a bunch of unused STATUS_xxx macros to reduce clutter. Tom Lane 2001-10-18 22:40:52 +00:00
  • 4fec55af6c Fix several problems with simple_prompt() --- the nastiest being that the entered password would get echoed on some platforms, eg HPUX. We have enough copies of this code that I'm thinking it ought to be moved into libpq, but that's a task for another day. Tom Lane 2001-10-18 21:57:11 +00:00
  • f5a5b44c4d Change error code docs to use colons. Bruce Momjian 2001-10-18 20:43:05 +00:00
  • 278669e038 Document all the ecpg error codes. Bruce Momjian 2001-10-18 20:32:58 +00:00
  • b522ce0bcf Update for new expected results. Tom Lane 2001-10-18 20:10:31 +00:00
  • f9b6583747 Didn't compile on non-HAVE_TM_ZONE machines. Tom Lane 2001-10-18 19:54:59 +00:00
  • 369c9e3b6c Repair missing brace in HAVE_INT_TIMEZONE case. Tom Lane 2001-10-18 19:52:03 +00:00
  • 9310075a13 Accept an INTERVAL argument for SET TIME ZONE per SQL99. Modified the parser and the SET handlers to use full Node structures rather than simply a character string argument. Implement INTERVAL() YEAR TO MONTH (etc) syntax per SQL99. Does not yet accept the goofy string format that goes along with, but this should be fairly straight forward to fix now as a bug or later as a feature. Implement precision for the INTERVAL() type. Use the typmod mechanism for both of INTERVAL features. Fix the INTERVAL syntax in the parser: opt_interval was in the wrong place. INTERVAL is now a reserved word, otherwise we get reduce/reduce errors. Implement an explicit date_part() function for TIMETZ. Should fix coersion problem with INTERVAL reported by Peter E. Fix up some error messages for date/time types. Use all caps for type names within message. Fix recently introduced side-effect bug disabling 'epoch' as a recognized field for date_part() etc. Reported by Peter E. (??) Bump catalog version number. Rename "microseconds" current transaction time field from ...Msec to ...Usec. Duh! date/time regression tests updated for reference platform, but a few changes will be necessary for others. Thomas G. Lockhart 2001-10-18 17:30:21 +00:00
  • 6254465d06 Extend code that deduces implied equality clauses to detect whether a clause being added to a particular restriction-clause list is redundant with those already in the list. This avoids useless work at runtime, and (perhaps more importantly) keeps the selectivity estimation routines from generating too-small estimates of numbers of output rows. Also some minor improvements in OPTIMIZER_DEBUG displays. Tom Lane 2001-10-18 16:11:42 +00:00
  • 5045004958 Added Lee Kindness' patches. Michael Meskes 2001-10-18 11:01:35 +00:00
  • f8bcf12ed9 Update file for pgcrypto. Bruce Momjian 2001-10-17 00:48:24 +00:00
  • 8be02853b8 Add documentation about statistics collector and stats views & functions. Tom Lane 2001-10-16 23:57:06 +00:00
  • b207081056 Make sure to clean out old activity string when recycling a backend entry. Tom Lane 2001-10-16 22:35:27 +00:00
  • 70e6003c76 Use LEFT JOIN, not FULL JOIN, in statistical views. Tom Lane 2001-10-16 20:51:35 +00:00
  • bf737b859f Updated the list of encodings supported to match what the backend now supports Barry Lind 2001-10-16 20:07:17 +00:00
  • f50793c743 Added some additional comments in the code Barry Lind 2001-10-16 20:05:22 +00:00
  • 076026bba9 Python handle as string all int8 values from postgresql. This could be view when using the aggregate function count() and function nextval that returns an int8 value, but in python is represented like string: Bruce Momjian 2001-10-16 13:42:57 +00:00
  • cfe01796e6 Ok, here is the modified encoding table (column1 is the standard name, 2 is our "official" name, and 3 is alias). If there's no objection, I will change them. Tatsuo Ishii 2001-10-16 10:09:17 +00:00
  • 2bb6b98d5c Add a section about the planner's statistics, including a description of the new pg_stats view. Tom Lane 2001-10-16 01:13:44 +00:00
  • daf72bba91 Add note about pg_stats to pg_statistic entry; add sections for pg_largeobject, pg_listener, pg_rewrite, pg_trigger; miscellaneous small improvements. Tom Lane 2001-10-15 22:47:47 +00:00
  • e158670c1f Doesn't anyone test stuff before they commit it? Tom Lane 2001-10-15 20:15:09 +00:00
  • 77f27d5ec3 Fix some portability problems (get it to compile, at least, on HP's cc) Tom Lane 2001-10-15 19:15:18 +00:00
  • aa6970efff Fix some portability problems (get it to compile, at least, on HP's cc) Tom Lane 2001-10-15 18:56:30 +00:00
  • 1e2779117d Fix some portability problems (get it to compile, at least, on HP's cc) Tom Lane 2001-10-15 18:49:40 +00:00
  • 394925b60d > Uh, isn't the correct fix > ! $$ = cat_str(8, make_str("grant"), $2, make_str("on"), $4, $5, > make_str("to"), $7, $8); > ISTM your patch loses the opt_with_grant clause. (Of course the > backend doesn't currently accept that clause anyway, but that's no > reason for ecpg to drop it.) Bruce Momjian 2001-10-15 18:16:31 +00:00
  • b261cb9fa1 Updated regression test for tsearch, from Teodor Sigaev. Tom Lane 2001-10-15 17:41:33 +00:00
  • 66b77dbcd6 Prompt for password from /dev/tty and fall back to stdin/stderr. Bruce Momjian 2001-10-15 16:40:27 +00:00
  • cdce507053 Forgot to add this file... Tatsuo Ishii 2001-10-15 04:52:59 +00:00
  • 1c6bd04713 PG_DUMP NLS (Russian) Bruce Momjian 2001-10-15 02:50:16 +00:00
  • 8f6d72cb39 Suggest placing audit trail on pg_shadow, not its view pg_user. Tom Lane 2001-10-15 02:02:06 +00:00
  • df4cba68cf Commit Patrice's patches except: Tatsuo Ishii 2001-10-15 01:25:10 +00:00
  • d07bacd54a Add UTF-8 char >= 0x10000 check Tatsuo Ishii 2001-10-15 01:19:15 +00:00
  • 9bc15d499d Update examples of type coercion rules --- some of them no longer worked as the example claimed, because of changes elsewhere in the system. Tom Lane 2001-10-15 01:00:59 +00:00
  • e3b3eb20a4 Synchronize with main parser's keyword list (someone didn't check his last commit very carefully...) Tom Lane 2001-10-15 00:06:04 +00:00
  • 360e61e1f5 Update FAQ. Bruce Momjian 2001-10-14 23:27:31 +00:00
  • 1ebc028cbc - Fixed GRANT statement. - Synced preproc.y with gram.y. Michael Meskes 2001-10-14 12:07:57 +00:00
  • e482dcb0a4 Make selectivity routines cope gracefully with NaNs, infinities, and NUMERIC values that are out of the range of 'double'. Per trouble report from Mike Quinn. Tom Lane 2001-10-13 23:32:34 +00:00
  • d1c6983899 Fix logic in insert() function. Peter Eisentraut 2001-10-13 19:16:32 +00:00
  • 9ca41c0413 Fixing closed-path intersection logic causes this test to find more streets than it used to... Tom Lane 2001-10-13 17:41:11 +00:00
  • cf5dc330b9 path_inter, path_distance, path_length, dist_ppath now do the right things with closed paths --- ie, include the closing line segment in their calculations. Per bug report from Curtis Barrett 9-Oct-01. Tom Lane 2001-10-13 17:40:24 +00:00
  • 58dc94abac Add missing prototype to suppress gcc warning. Tom Lane 2001-10-13 16:34:08 +00:00
  • f42b88d1b4 Residual cleanup from making pltcl unknown support always enabled. Tom Lane 2001-10-13 15:24:23 +00:00
  • b2c37b4c51 Autoconf. Tom Lane 2001-10-13 15:20:51 +00:00
  • 657d0044b0 Update FAQ. Bruce Momjian 2001-10-13 05:27:05 +00:00
  • 46712990bd More keyword uppercasing. Bruce Momjian 2001-10-13 04:58:35 +00:00
  • 8123d8f150 Here are few more translated messages into Russian for the PG_DUMP component. Bruce Momjian 2001-10-13 04:25:27 +00:00
  • 1d3a47af0c Attached patch for unconditional enabling of pltcl-unknown support. Bruce Momjian 2001-10-13 04:23:50 +00:00
  • 36458b93e0 Update FAQ. Bruce Momjian 2001-10-13 03:53:45 +00:00
  • db7aa99fb9 Update FAQ. Bruce Momjian 2001-10-13 03:37:42 +00:00
  • dac9f40ba8 Mention createlang when language not installed, per problem report. Bruce Momjian 2001-10-13 01:35:25 +00:00
  • cdd4379394 Update FAQ. Bruce Momjian 2001-10-13 01:32:47 +00:00
  • 0818073894 More uppercasing. Bruce Momjian 2001-10-12 23:34:30 +00:00
  • 705869dd17 Uppercase keywords where appropriate. Bruce Momjian 2001-10-12 23:32:34 +00:00
  • b57705673d txtidx datatype for full text indexing with GiST. From Oleg Bartunov and Teodor Sigaev. Tom Lane 2001-10-12 23:19:09 +00:00
  • c24216bea8 Fix reverse FOR loop to work properly, uppercase cleanup in file. Bruce Momjian 2001-10-12 21:19:09 +00:00
  • ec614c9872 Remove locale/multibyte in HISTORY file, for Tatsuo. Bruce Momjian 2001-10-12 17:46:00 +00:00
  • c0b2bbf42e Add WAL mmap() mention. Bruce Momjian 2001-10-12 17:35:10 +00:00
  • 68966634b2 Update TODO list. Bruce Momjian 2001-10-12 17:34:36 +00:00
  • 6790f21441 Update TODO list. Bruce Momjian 2001-10-12 17:33:46 +00:00
  • 63a22cd2dd Update TODO list. Bruce Momjian 2001-10-12 17:28:41 +00:00
  • 129b19f685 Update TODO list. Bruce Momjian 2001-10-12 17:23:04 +00:00
  • d8f88f01f0 Update TODO list. Bruce Momjian 2001-10-12 16:29:36 +00:00
  • 010e8144cd Update TODO list. Bruce Momjian 2001-10-12 16:14:17 +00:00
  • 7d9d026323 Update TODO list. Bruce Momjian 2001-10-12 16:13:48 +00:00
  • 7bce3e95cf Remove mutex mention. Fixed now. Bruce Momjian 2001-10-12 16:10:51 +00:00
  • 182722f737 Update TODO list. Bruce Momjian 2001-10-12 16:07:34 +00:00
  • 0420342af1 Update the version of psqlodbc driver. Hiroshi Inoue 2001-10-12 09:41:49 +00:00
  • ffcad12769 Update TODO list. Bruce Momjian 2001-10-12 02:50:48 +00:00
  • f426465ba9 Add a new function "pg_client_encoding" which returns the current client side encoding name. This is necessary for client API's such as JDBC to perform correct encoding conversions. See my email "[HACKERS] pg_client_encoding" 10 Sep 2001. Tatsuo Ishii 2001-10-12 02:08:34 +00:00
  • 9d13fcf0af Fix the bug reported by Chris Lee. Hiroshi Inoue 2001-10-12 01:08:51 +00:00
  • f9e6e27c87 Break transformCreateStmt() into multiple routines and make transformAlterStmt() use these routines, instead of having lots of duplicate (not to mention should-have-been-duplicate) code. Adding a column with a CHECK constraint actually works now, and the tests to reject unsupported DEFAULT and NOT NULL clauses actually fire now. ALTER TABLE ADD PRIMARY KEY works, modulo having to have created the column(s) NOT NULL already. Tom Lane 2001-10-12 00:07:15 +00:00
  • e98476eb03 Document use of GEQO param in subquery pullups. Bruce Momjian 2001-10-11 21:16:26 +00:00
  • 9e642cd7ef Update TODO list. Bruce Momjian 2001-10-11 20:40:38 +00:00
  • c19ff887c6 Add documention for ecpg -209 error. Bruce Momjian 2001-10-11 20:25:42 +00:00
  • 97d0c8b219 Suppress gcc warnings. Tom Lane 2001-10-11 18:06:52 +00:00
  • 78f7ba13cb Tatsuo Ishii <t-ishii@sra.co.jp> writes: > As you can see, psql reconnect as any user if the password is same as > foo. Of course this is due to the careless password setting, but I > think it's better to prompt ANY TIME the user tries to switch to > another user. Comments? Bruce Momjian 2001-10-11 16:54:18 +00:00
  • b0c4598c66 Update TODO list. Bruce Momjian 2001-10-11 16:35:50 +00:00
  • 95c18db868 Remove mention of "pg_result -list" becuase it is not implemented, per Tatsuo. Bruce Momjian 2001-10-11 16:30:41 +00:00
  • 51053d3216 Add support for ISO-8859-6 to 16 Tatsuo Ishii 2001-10-11 14:20:35 +00:00
  • 371f49bf9f Remove gratuitous discrepancy between extract() and date_part(), regarding timezone_hour, timezone_minute vs. tz_hour, tz_minute. Document the former. Peter Eisentraut 2001-10-10 00:02:42 +00:00
  • ec5c62874d Allow optional () after current_user, session_user, user, current_time, current_timestamp, current_date for ODBC compatibility. Peter Eisentraut 2001-10-09 22:32:33 +00:00
  • 839b9bc011 This patch fixes a bug introduced in the jdbc bytea support patch. That patch broke the ability to read data from binary cursors. --Barry Lind Modified Files: pgsql/src/interfaces/jdbc/org/postgresql/Connection.java pgsql/src/interfaces/jdbc/org/postgresql/ResultSet.java pgsql/src/interfaces/jdbc/org/postgresql/core/QueryExecutor.java pgsql/src/interfaces/jdbc/org/postgresql/jdbc1/Connection.java pgsql/src/interfaces/jdbc/org/postgresql/jdbc1/ResultSet.java pgsql/src/interfaces/jdbc/org/postgresql/jdbc2/Connection.java pgsql/src/interfaces/jdbc/org/postgresql/jdbc2/ResultSet.java pgsql/src/interfaces/jdbc/org/postgresql/jdbc2/UpdateableResultSet.java Barry Lind 2001-10-09 20:47:35 +00:00
  • ffb8f73890 Bunch of copy fitting and style sheet tweakage to get decent looking print output (from pdfjadetex). Also updated instructions to install documentation processing toolchain. Peter Eisentraut 2001-10-09 18:46:00 +00:00
  • 2f1c24cb1c Change plpgsql compiler so that all elogs are trapped and a suitable NOTICE added about error location (same method already used by plpgsql executor). Add checking of pg_proc row xmin/cmin to ensure that plpgsql functions will be recompiled after they've been modified by CREATE OR REPLACE FUNCTION. Tom Lane 2001-10-09 15:59:56 +00:00