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

Commit Graph

  • 609f71b760 Also an small change to the tab-complete feature of psql which allows to use tables and views interchangeably. Bruce Momjian 2002-03-07 04:45:53 +00:00
  • 9178b7fcea Fix syntax error introduced by patch. Bruce Momjian 2002-03-06 21:49:52 +00:00
  • 7ab7467318 I've attached a patch which implements Bob Jenkin's hash function for PostgreSQL. This hash function replaces the one used by hash indexes and the catalog cache. Hash joins use a different, relatively poor-quality hash function, but I'll fix that later. Bruce Momjian 2002-03-06 20:49:46 +00:00
  • 5b5cef9abd Enable ALTER TABLE ADD PRIMARY KEY for pg_dump, for performance reasons so index is not on table during COPY. Bruce Momjian 2002-03-06 20:48:42 +00:00
  • 62e6eb9bf7 alter table doc cleanups. Bruce Momjian 2002-03-06 20:42:38 +00:00
  • 0df1dc6aaf This simple patch fixes broken Makefile, broken ApplySnapshot and makes all utilities honour --verbose command line option. Bruce Momjian 2002-03-06 20:41:36 +00:00
  • c666d6fd41 Here is a diff of changes to the psql source code implementing a simple 'list domains' command '\dD'. This is the interface component of rbt@zort.ca's domain backend modifications. Bruce Momjian 2002-03-06 20:39:45 +00:00
  • 01c76f7411 Ok. Updated patch attached. Bruce Momjian 2002-03-06 20:35:02 +00:00
  • 3d9f865e94 Modify ALTER TABLE OWNER to change index ownership; code cleanup. Bruce Momjian 2002-03-06 19:58:26 +00:00
  • ade0fe5cb4 Update docs for new stored procedure error levels. Bruce Momjian 2002-03-06 19:05:58 +00:00
  • 7d5edf2ba7 Add new elog() levels to stored procedure languages. plperl DEBUG hack still needed because only removed in 7.4. Bruce Momjian 2002-03-06 18:50:33 +00:00
  • 9956c566e3 Add libpgeasy example file. Bruce Momjian 2002-03-06 14:40:05 +00:00
  • 5ca7c8e314 Synced parser with backend. Michael Meskes 2002-03-06 10:10:52 +00:00
  • 3c0d21a28e Update reference pages for new INFO, NOTICE, WARNING elog() levels. Bruce Momjian 2002-03-06 06:48:05 +00:00
  • 92b1ab75d4 Update docs for new INFO, NOTICE, WARNING elog() levels. Bruce Momjian 2002-03-06 06:44:33 +00:00
  • 4e15b9233d Improve elog descriptions. Bruce Momjian 2002-03-06 06:23:20 +00:00
  • e6227fd0ec Add missing Unicode multibyte files. Bruce Momjian 2002-03-06 06:12:59 +00:00
  • 92288a1cf9 Change made to elog: Bruce Momjian 2002-03-06 06:10:59 +00:00
  • 22ebad9e39 Add name: Bruce Momjian 2002-03-06 03:37:16 +00:00
  • 39c58b9065 changed Cancel to cancel Dave Cramer 2002-03-06 03:07:45 +00:00
  • ffe356b5dd backed out changes for cancel, no need to look for two 'Z' responses Dave Cramer 2002-03-05 20:11:57 +00:00
  • 29ea8ff9b1 Patch by Nicolas Verger to correctly propogate SQLWarning to the Statement and ResultSet Dave Cramer 2002-03-05 18:02:44 +00:00
  • ff2f9b663f fixed cancel query bug introduced by patch Dave Cramer 2002-03-05 18:01:27 +00:00
  • b7cc409f7f Autoconf for jdbc debug changes. Bruce Momjian 2002-03-05 17:55:45 +00:00
  • 0416641baa At this moment, --enable-debug adds debugging information to most of the parts o f postgresql. The jdbc drivers are never compiled with debugging support. This p atch make sure that debugging information is added to the jdbc jar when the --en able-debug is added. This was usefull for me for debugging some java jdbc poolin g objects but this might perhaps be usefull for other people too? Bruce Momjian 2002-03-05 17:55:23 +00:00
  • af41101a40 Prevent failed passwords from being echoed to server logs, for security. Bruce Momjian 2002-03-05 07:57:45 +00:00
  • 16d6615b41 Prevent failed passwords from being echoed to server logs, for security. Bruce Momjian 2002-03-05 06:52:05 +00:00
  • afc732e610 Update FAQ. Bruce Momjian 2002-03-05 06:28:26 +00:00
  • 590102c20b This version has been synchonized with English version at Mar 03. Bruce Momjian 2002-03-05 06:20:51 +00:00
  • 7bf7b0bd75 This trivial patch fixes a typo and improves the phrasing of a sentence in the docs. Bruce Momjian 2002-03-05 06:14:45 +00:00
  • ed5eb09cce Adds \du documentation line for \? in psqls help.c Bruce Momjian 2002-03-05 06:13:19 +00:00
  • 38b4088518 Please, apply attached patch for contrib/tsearch to 7.2.1 and current CVS. It fix english stemmer's problem with ending words like 'technology'. Bruce Momjian 2002-03-05 06:10:49 +00:00
  • 8fdc7814d0 Please, apply attached patch for contrib/tsearch to 7.2.1 and current CVS. It fix english stemmer's problem with ending words like 'technology'. Bruce Momjian 2002-03-05 06:10:28 +00:00
  • 6024ac1ba0 Back out old version and update with newer patch of: Bruce Momjian 2002-03-05 06:07:27 +00:00
  • 66cd6a0fb2 Currently, contrib/oid2name doesn't bother to free() the memory that it malloc()'s. This isn't too serious (because oid2name is a short-lived utility, so the memory will soon be returned to the OS on process termination), but I still think it's poor style. Bruce Momjian 2002-03-05 05:54:07 +00:00
  • a8bd7e1c6e > Tatsuo Ishii wrote: > > > > It was made to cope with encoding such as an Asian bloc in 7.2Beta2. > > > > > > > > Added ServerEncoding > > > > Korean (JOHAB), Thai (WIN874), > > > > Vietnamese (TCVN), Arabic (WIN1256) > > > > > > > > Added ClientEncoding > > > > Simplified Chinese (GBK), Korean (UHC) > > > > > > > > > > > > > http://www.sankyo-unyu.co.jp/Pool/postgresql-7.2b2.newencoding.diff.tar.gz > > > > (608K) > > > > > > Looks good. I need some people to review this for me. > > > > For me they look good too. The only missing part is a > > documentation. I will ask him to write it up. If he couldn't, I will > > do it for him. > > > The diff is 3mb > > > but appears to address only additions to multibyte. I have attached a > > > list of files it modifies. Also, look at the sizes of the mb/ > > > directory. It is getting large: > > > > > > 4 ./CVS > > > 6 ./Unicode/CVS > > > 3433 ./Unicode > > > 6197 . > > > > Yes. We definitely need the on-the-fly encoding addition capability: > > i.e. CREATE CHRACTER SET in the future... > > -- > > Tatsuo Ishii > > > > Bruce Momjian 2002-03-05 05:52:50 +00:00
  • 03194432de I attach a version of my toast-slicing patch, against current CVS (current as of a few hours ago.) Bruce Momjian 2002-03-05 05:33:31 +00:00
  • 276fc7ce82 I was digging through the GiST code, and figured I'd fix up some of the "bad smell" in that code. Stuff like function parameters that aren't used, typos in the comments, comparison between signed and unsigned ints, etc. Bruce Momjian 2002-03-05 05:30:40 +00:00
  • 33766e680d Here's a patch against 7.1.3 that fixes a problem with sending larger queries over non-blocking connections with libpq. "Larger" here basically means that it doesn't fit into the output buffer. Bruce Momjian 2002-03-05 05:20:12 +00:00
  • 68d813795a Previous patch to mark UNION outputs with common typmod (if any) breaks three-or-more-way UNIONs, as per example from Josh Berkus. Cause is a fragile assumption that one tlist's entries will exactly match another. Restructure code to make that assumption a little less fragile. Tom Lane 2002-03-05 05:13:36 +00:00
  • 944671820f Previous patch to mark UNION outputs with common typmod (if any) breaks three-or-more-way UNIONs, as per example from Josh Berkus. Cause is a fragile assumption that one tlist's entries will exactly match another. Restructure code to make that assumption a little less fragile. Tom Lane 2002-03-05 05:10:24 +00:00
  • 17b6baf17d Doug Fields patch to prevent exception being thrown on zero length arrays Dave Cramer 2002-03-05 03:46:03 +00:00
  • 06b3be1e48 A backport patch: Tatsuo Ishii 2002-03-05 03:45:44 +00:00
  • fe4e95f682 patch from Zhenbang Wei The errors_zh_TW.properties must be translated using native2ascii or it will raise an exception. Please replace the old file. Dave Cramer 2002-03-05 03:33:29 +00:00
  • bca7c57c79 Add: Bruce Momjian 2002-03-05 03:32:11 +00:00
  • 8f83590aa1 Patch from Ryouichi Matsuda An attached patch corrects problem of this bug and fractional second. Dave Cramer 2002-03-05 03:29:30 +00:00
  • 7aa6270fc7 patch from Mitchel Friedman to fix getTables Dave Cramer 2002-03-05 03:02:52 +00:00
  • 925d60ee53 Showing index details with \d on psql. Bruce Momjian 2002-03-05 02:42:56 +00:00
  • 521017c5d0 patch from Vicktor to fix Numeric decimal digits in getColumns Dave Cramer 2002-03-05 02:14:08 +00:00
  • fef790cc03 Back out python patch: Bruce Momjian 2002-03-05 02:01:44 +00:00
  • 14b05248cc This patch to the python bindings adds C versions of the often-used query args quoting routines, as well as support for quoting lists e.g. dbc.execute("SELECT * FROM foo WHERE blah IN %s", ([1,2,3],)) Bruce Momjian 2002-03-05 00:23:13 +00:00
  • 25b0b09fd3 Add \timing patch to psql. Times all queries. Bruce Momjian 2002-03-05 00:01:03 +00:00
  • 294f0d4bd6 Add PQunescapeBytea libpq function. Bruce Momjian 2002-03-04 23:59:14 +00:00
  • b2aade0e4b Improve libpgeasy API for multiple result sets, add example. Bruce Momjian 2002-03-04 18:50:21 +00:00
  • e7db8fa80e Add Assert check to catch vsnprintf overrunning its buffer. (Seen to occur on Solaris 7 in 64-bit mode, for one.) Tom Lane 2002-03-04 18:34:02 +00:00
  • ee93155748 Update FAQ_Solaris with info about gcc 2.95.1 problems and how to work around 64-bit vsnprintf bug. Tom Lane 2002-03-04 17:47:24 +00:00
  • aa39e9a80c Update FAQ_Solaris with info about gcc 2.95.1 problems and how to work around 64-bit vsnprintf bug. Tom Lane 2002-03-04 17:47:11 +00:00
  • dd178e37f0 Make port makefile slightly less crufty. Tom Lane 2002-03-04 17:43:32 +00:00
  • 6488c9d12f Modify: Bruce Momjian 2002-03-04 16:50:36 +00:00
  • 493d09802e Add: Bruce Momjian 2002-03-04 16:20:31 +00:00
  • 26c246036d Fix very ancient breakage in alter-table tests: apparently, there was a type named 'dt' back in Postgres 4.2, and the regression test wasn't updated when it was removed. Per report from Patricia Holben of Great Bridge. Tom Lane 2002-03-04 05:17:55 +00:00
  • 653556cc26 If presented db path has a trailing slash, remove it to avoid generating double slashes in generated filenames. This is not strictly necessary on standard Unixen, but I'm being a neatnik... Tom Lane 2002-03-04 04:45:27 +00:00
  • 3382fbb60d Fix bug in extract/date_part for milliseconds/miscroseconds and timestamp/timestamptz combo. Now extract/date_part returns seconds*1000 or 1000000 + fraction part as the manual stats. regression test are also fixed. Tatsuo Ishii 2002-03-04 03:55:50 +00:00
  • a616cbc5e3 Fix bogus error check in pg_execute, per report from lbayuk@mindspring.com. Tom Lane 2002-03-04 02:41:49 +00:00
  • 36f693ec69 Further work on elog cleanup: fix some bogosities in elog's logic about when to send what to which, prevent recursion by introducing new COMMERROR elog level for client-communication problems, get rid of direct writes to stderr in backend/libpq files, prevent non-error elogs from going to client during the authentication cycle. Tom Lane 2002-03-04 01:46:04 +00:00
  • 5ab02fd123 Update FAQ. Bruce Momjian 2002-03-03 18:35:46 +00:00
  • 26ac217173 Catcaches can now store negative entries as well as positive ones, to speed up repetitive failed searches; per pghackers discussion in late January. inval.c logic substantially simplified, since we can now treat inserts and deletes alike as far as inval events are concerned. Some repair work needed in heap_create_with_catalog, which turns out to have been doing CommandCounterIncrement at a point where the new relation has non-self-consistent catalog entries. With the new inval code, that resulted in assert failures during a relcache entry rebuild. Tom Lane 2002-03-03 17:47:56 +00:00
  • 592caa0897 Update FAQ. Bruce Momjian 2002-03-03 16:02:31 +00:00
  • 343e47c27d Default server_min_messages is NOTICE. Bruce Momjian 2002-03-03 02:11:09 +00:00
  • ce7a4f06a2 Cause regression tests to pass again after elog changes. Tom Lane 2002-03-03 01:05:22 +00:00
  • cfae62c476 Some kibitzing about appropriate elog levels for sinval messages. Tom Lane 2002-03-02 23:35:57 +00:00
  • a033daf566 Commit to match discussed elog() changes. Only update is that LOG is now just below FATAL in server_min_messages. Added more text to highlight ordering difference between it and client_min_messages. Bruce Momjian 2002-03-02 21:39:36 +00:00
  • 8d8aa931ef Add code to allow profiling of backends on Linux: save and restore the profiling timer setting across fork(). The correct way to build a profilable backend on Linux is now gmake PROFILE="-pg -DLINUX_PROFILE" Tom Lane 2002-03-02 20:46:12 +00:00
  • 78ab803402 Don't bother to request SSL connection over a Unix socket, since the postmaster won't accept the request anyway. (If your kernel can't be trusted, SSL will not help you.) Tom Lane 2002-03-02 00:49:22 +00:00
  • 608d843e61 Array slice extraction should produce a result array with index lower bounds of 1, not the lower bound subscripts of the original slice. Per bug report from Andre Holzner, 1-Feb-02. Tom Lane 2002-03-02 00:34:24 +00:00
  • 1aac2c852a User and database-specific session defaults for run-time configuration variables. New commands ALTER DATABASE ... SET and ALTER USER ... SET. Peter Eisentraut 2002-03-01 22:45:19 +00:00
  • 851f766115 array_ref() should set isNull to false explicitly if it's not going to return NULL. Peter Eisentraut 2002-03-01 22:17:10 +00:00
  • 54f7f62d4a Fix thinko: cost_mergejoin must pay attention to which side of the mergeclause is which when extracting selectivity info. Tom Lane 2002-03-01 20:50:20 +00:00
  • ed6986d3eb Revert quotes, 7.2 doesn't need them for CREATE FUNCTION. Bruce Momjian 2002-03-01 20:38:12 +00:00
  • a7ac26b759 Oops, we didn't have single quotes around 'langname' in CREATE FUNCTION manual page; pointed out by IRC user. Bruce Momjian 2002-03-01 19:01:22 +00:00
  • e1716475e4 Add files for Unicode support. Hiroshi Inoue 2002-03-01 07:18:34 +00:00
  • 8f0a9e85b3 Second thoughts dept: arrange to cache mergejoin scan selectivity in RestrictInfo nodes, instead of recomputing on every use. Tom Lane 2002-03-01 06:01:20 +00:00
  • f8c109528c Teach planner about the idea that a mergejoin won't necessarily read both input streams to the end. If one variable's range is much less than the other, an indexscan-based merge can win by not scanning all of the other table. Per example from Reinhard Max. Tom Lane 2002-03-01 04:09:28 +00:00
  • b233e5903a Back-patch fix for errors reported at transaction end. Tom Lane 2002-02-27 23:17:01 +00:00
  • fdc60bd9d9 Tweak pg_exec_query_string so that we close down transaction command before reporting command-complete message for the final command of a query string. This way, any errors detected during finish_xact_command (such as RI violations) will appear to be part of the final command, rather than coming out after the command is reported complete. This avoids confusing PQendcopy and other not-overly-bright clients. Per Lee Harr's bug report of 25-Feb-02. Tom Lane 2002-02-27 23:16:07 +00:00
  • 36addaff3d Some cleanups in CREATE/ALTER/DROP USER ref pages. Peter Eisentraut 2002-02-27 21:14:54 +00:00
  • af1b72d83b #ifdef out pg_dump's check on whether a sequence's sequence_name field matches the sequence name from pg_class. This fails if the sequence has been renamed, and seems rather pointless in any case. Also improve a couple of error messages about inconsistencies. Tom Lane 2002-02-27 20:59:05 +00:00
  • 04cb9a6a16 Paranoia about data structure lifetime ... Tom Lane 2002-02-27 19:52:41 +00:00
  • 6779c55c22 Clean up BeginCommand and related routines. BeginCommand and EndCommand are now both invoked once per received SQL command (raw parsetree) from pg_exec_query_string. BeginCommand is actually just an empty routine at the moment --- all its former operations have been pushed into tuple receiver setup routines in printtup.c. This makes for a clean distinction between BeginCommand/EndCommand (once per command) and the tuple receiver setup/teardown routines (once per ExecutorRun call), whereas the old code was quite ad hoc. Along the way, clean up the calling conventions for ExecutorRun a little bit. Tom Lane 2002-02-27 19:36:13 +00:00
  • e22c9c4475 Update FAQ. Bruce Momjian 2002-02-27 04:52:19 +00:00
  • 567f9d054f Back-patch fix for followings: Tatsuo Ishii 2002-02-27 01:47:31 +00:00
  • fc3726b4b9 Improve the handling of ODBC escape(a request from Marcelo Aceto). Change SQLGetFunctions() to reply not yet implemented ODBC 3.0 functions precisely. Hiroshi Inoue 2002-02-27 01:43:24 +00:00
  • 21f9a654f0 Fix bug in COPY FROM when DELIMITER is not in ASCII range. See pgsql-bugs/pgsql-hackers discussion "COPY FROM is not 8bit clean" around 2002/02/26 for more details -- Tatsuo Ishii Tatsuo Ishii 2002-02-27 01:34:41 +00:00
  • 75c07d5b4d Back-patch fix for command completion report handling. This is primarily needed so that INSERTing a row still reports the row's OID even when there are ON INSERT rules firing additional queries. Tom Lane 2002-02-26 23:48:47 +00:00
  • 56ee2ecba9 Restructure command-completion-report code so that there is just one report for each received SQL command, regardless of rewriting activity. Also ensure that this report comes from the 'original' command, not the last command generated by rewrite; this fixes 7.2 breakage for INSERT commands that have actions added by rules. Fernando Nasser and Tom Lane. Tom Lane 2002-02-26 22:47:12 +00:00
  • f71dc6d0e2 Correct typo noticed by Christopher Kings-Lynne. Tom Lane 2002-02-26 15:59:08 +00:00
  • 7776319a7e Implementation for cancelQuery by Grant Finnemore <grantf@guruhut.co.za> Dave Cramer 2002-02-26 02:15:55 +00:00
  • 29e3ef0fe9 Use quote-marks to try to clarify a plpgsql error message, per gripe from Dan Langille. Tom Lane 2002-02-26 00:00:08 +00:00
  • 5fb5066cb6 Tweak psql's \connect command to not downcase unquoted database and user names. This is a temporary measure to allow backwards compatibility with 7.2 and earlier pg_dump. 7.2.1 and later pg_dump will double-quote mixed case names in \connect. Once we feel that older dumps are not a problem anymore, we can revert this change and treat \connect arguments as normal SQL identifiers. Tom Lane 2002-02-25 21:37:47 +00:00
  • 86a07143d4 Tweak psql's \connect command to not downcase unquoted database and user names. This is a temporary measure to allow backwards compatibility with 7.2 and earlier pg_dump. 7.2.1 and later pg_dump will double-quote mixed case names in \connect. Once we feel that older dumps are not a problem anymore, we can revert this change and treat \connect arguments as normal SQL identifiers. Tom Lane 2002-02-25 21:37:42 +00:00