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

Commit Graph

  • ea10ec1b69 Tweak labeling of plan qual conditions for more consistency. Tom Lane 2002-03-24 17:11:37 +00:00
  • 7100cbc1c4 Fix cut-and-paste-o. Tom Lane 2002-03-24 16:57:29 +00:00
  • 10d3995057 EXPLAIN output now comes out as a query result, not a NOTICE message. Also, fix debug logging of parse/plan trees so that the messages actually go through elog(), not directly to stdout. Tom Lane 2002-03-24 04:31:09 +00:00
  • a25b94c080 Create the pg_namespace system catalog. Doesn't do much yet, but it's there and CREATE SCHEMA will make entries in it... Tom Lane 2002-03-22 21:34:44 +00:00
  • 48c9164901 Improve catalog commentary. Tom Lane 2002-03-22 20:14:42 +00:00
  • b6ea172ace Spell checking and markup additions Peter Eisentraut 2002-03-22 19:20:45 +00:00
  • 108a0ec87d A little further progress on schemas: push down RangeVars into addRangeTableEntry calls. Remove relname field from RTEs, since it will no longer be a useful unique identifier of relations; we want to encourage people to rely on the relation OID instead. Further work on dumping qual expressions in EXPLAIN, too. Tom Lane 2002-03-22 02:56:37 +00:00
  • 56c9b73c1d Change the aclchk.c routines to uniformly use OIDs to identify the objects to be privilege-checked. Some change in their APIs would be necessary no matter what in the schema environment, and simply getting rid of the name-based interface entirely seems like the best way. Tom Lane 2002-03-21 23:27:25 +00:00
  • 6137ed1b59 Fix minor syntax error. Tom Lane 2002-03-21 18:28:07 +00:00
  • 95ef6a3448 First phase of SCHEMA changes, concentrating on fixing the grammar and the parsetree representation. As yet we don't *do* anything with schema names, just drop 'em on the floor; but you can enter schema-compatible command syntax, and there's even a primitive CREATE SCHEMA command. No doc updates yet, except to note that you can now extract a field from a function-returning-row's result with (foo(...)).fieldname. Tom Lane 2002-03-21 16:02:16 +00:00
  • 8c9c8ca2b5 Remove -mips2 flag, which breaks the build on some MIPS systems. Peter Eisentraut 2002-03-21 15:21:41 +00:00
  • 73b92d10c6 Added typedef patches and a new option '-c' to automatically create C typedefs from SQL ones. Michael Meskes 2002-03-21 09:42:52 +00:00
  • b2d05d58eb Remove long-dead 'fix for SELECT NULL' to stop current coredump. Tom Lane 2002-03-21 06:21:14 +00:00
  • a13ddd36b0 Remove long-dead 'fix for SELECT NULL' to stop current coredump. Tom Lane 2002-03-21 06:21:04 +00:00
  • c52670e8b2 Fix pg_dump help option alignment. Bruce Momjian 2002-03-21 05:47:14 +00:00
  • 78d40a2a2f Two versions of QueryExecutor, currently only version 2 works 100% these versions adhere to the backend protocol better than previous version fixes problem when an error occurs on the backend, and the connection is still used previous versions were throwing an exception half way through the protocol, leaving it indeterminate. also removes empty query code, should speed things up a bit Dave Cramer 2002-03-21 03:20:30 +00:00
  • 54cc549d8f modifications to the way the protocol is handled to be consistent with QueryExecutor. This includes: 1) only exit after we receive a 'Z' packet 2) append error messages to a buffer and throw the exception at the end Dave Cramer 2002-03-21 02:52:37 +00:00
  • 00923229c2 Part of Anders Bengtsson's patch to clean up Connection.java Dave Cramer 2002-03-21 02:40:03 +00:00
  • d96c29ab30 Applied Anders patch to move the startup code out of Connection into StartupPacket * Introduces a new class, StartupPacket. * Moves a lot of constants from Connection to StartupPacket. * Makes two instance variables in Connection into locals. Dave Cramer 2002-03-21 02:39:06 +00:00
  • 8e9b215fdf Just one more test case. Michael Meskes 2002-03-20 21:00:24 +00:00
  • 337b22cb47 Code review for DOMAIN patch. Tom Lane 2002-03-20 19:45:13 +00:00
  • 251282d4b7 Tweak behavior of array slicing operations: seems like it ought to be okay to omit low-order dimensions when accessing an array slice. Tom Lane 2002-03-20 19:41:47 +00:00
  • 861c336b51 PyGreSQL causes a segfault when used with a Python executable that was compiled with --with-pymalloc. This change fixes that. Thanks to Dave Wallace <dwallace@udel.edu> D'Arcy J.M. Cain 2002-03-20 14:36:06 +00:00
  • f1f222843e Put back development status section overwritten by Bruce. Tom Lane 2002-03-19 18:53:01 +00:00
  • f2842a969d Make CREATE DOMAIN emit CREATE DOMAIN on completion, per Peter E. Bruce Momjian 2002-03-19 16:10:48 +00:00
  • 94a4677a75 > > Users of contrib/tsearch needs after upgrading of module (compiling, installing) > > to perform sql command: > > update pg_amop set amopreqcheck = true where amopclaid = > > (select oid from pg_opclass where opcname = 'gist_txtidx_ops'); > > Oleg, sorry, I don't understand where this should appear. In the README > file, and if so, where? Is this something only for people upgrading > from 7.2? Bruce Momjian 2002-03-19 14:16:32 +00:00
  • 14d542bc67 > > Users of contrib/tsearch needs after upgrading of module (compiling, installing) > > to perform sql command: > > update pg_amop set amopreqcheck = true where amopclaid = > > (select oid from pg_opclass where opcname = 'gist_txtidx_ops'); > > Oleg, sorry, I don't understand where this should appear. In the README > file, and if so, where? Is this something only for people upgrading > from 7.2? Bruce Momjian 2002-03-19 14:15:55 +00:00
  • 99c8581f5a > > Users of contrib/tsearch needs after upgrading of module (compiling, installing) > > to perform sql command: > > update pg_amop set amopreqcheck = true where amopclaid = > > (select oid from pg_opclass where opcname = 'gist_txtidx_ops'); > > Oleg, sorry, I don't understand where this should appear. In the README > file, and if so, where? Is this something only for people upgrading > from 7.2? Bruce Momjian 2002-03-19 14:14:44 +00:00
  • b752788510 Bump version number to match tree. D'Arcy J.M. Cain 2002-03-19 13:21:14 +00:00
  • d6b4153f93 Fix name in comments and add info about this module's place in PyGreSQL. D'Arcy J.M. Cain 2002-03-19 13:20:52 +00:00
  • b292cafcd4 Just adds a regressions test suite for the ALTER TABLE/ADD PRIMARY KEY feature. Bruce Momjian 2002-03-19 12:59:08 +00:00
  • f5810bb8a5 Add missing trailing semicolons to ecpg rules. Bruce Momjian 2002-03-19 12:56:38 +00:00
  • b9c7b0a2ba Fix DOMAIN breakage. Bruce Momjian 2002-03-19 12:52:22 +00:00
  • bc2b786af0 Add Bruce Momjian 2002-03-19 03:05:38 +00:00
  • 714f7859d8 psql \? cleanups by Ian Barwick Bruce Momjian 2002-03-19 03:01:01 +00:00
  • a9819ca253 The attached patch cleans up the implementation of the TRUNCATE command; in the current code, the authentication logic (check user, check the relation we're operating on, etc) is done in tcop/utility.c, whereas the actual TRUNCATE command in done in TruncateRelation() in commands/createinh.c (which is really just a wrapper over heap_truncate() in catalog/heap.c). This patch moves the authentication logic into TruncateRelation(), as well as making some minor code cleanups. Bruce Momjian 2002-03-19 02:58:20 +00:00
  • d8e70cd829 Fix for trigger handling: Bruce Momjian 2002-03-19 02:57:15 +00:00
  • eb1fb8650f >Added ServerEncoding > Korean (JOHAB), Thai (WIN874), > Vietnamese (TCVN), Arabic (WIN1256) > >Added ClientEncoding > Simplified Chinese (GBK), Korean (UHC) > >Add PsqlODBC and document ...etc patch. Bruce Momjian 2002-03-19 02:48:45 +00:00
  • d3337c6e3f > I am backing out this patch. Please resubmit with this corrected. Thanks. > > I am running Python 1.5. Bruce Momjian 2002-03-19 02:47:57 +00:00
  • a7ade2bb6b Add psql \dD listing of domains, from Jonathan Eisler. Bruce Momjian 2002-03-19 02:32:21 +00:00
  • d3788c3305 Add DOMAIN support. Includes manual pages and regression tests, from Rod Taylor. Bruce Momjian 2002-03-19 02:18:25 +00:00
  • 525b19399c applied patch from Liam Stewart Dave Cramer 2002-03-19 01:32:48 +00:00
  • 1f0e5f6792 Comment patch: Bruce Momjian 2002-03-19 01:14:41 +00:00
  • 873a986cf8 Improve wording of bug fix: Bruce Momjian 2002-03-19 00:12:41 +00:00
  • 367856d912 Improve wording of bug fix: Bruce Momjian 2002-03-19 00:12:09 +00:00
  • 0d3abc019b Update for 7.2.1. Bruce Momjian 2002-03-18 23:04:11 +00:00
  • 658371fe9f Update for 7.2.1. Bruce Momjian 2002-03-18 23:03:13 +00:00
  • b6cb03c7ce Update FAQ. Bruce Momjian 2002-03-18 19:35:10 +00:00
  • 202a19e47b Fixes bug where query hangs if there is an error in the query, went back to code before QueryExecutor class was created and copied behaviour Dave Cramer 2002-03-18 04:16:33 +00:00
  • bbc1fb07c6 Backpatch array I/O code and documentation fixes, also array slice lower subscript bounds change. Tom Lane 2002-03-17 20:05:59 +00:00
  • 8a25ec84e1 Improve documentation about array I/O representation. Tom Lane 2002-03-17 19:59:57 +00:00
  • 0f2fbbbac1 Try to make array_in's behavior a tad less bizarre. Leading whitespace before a data item is now always skipped, rather than only sometimes. Backslashes not within double-quoted text are treated reasonably, as are multiple sequences of quoted text in a single data item. But it still seems rather prone to misbehavior if the input is not completely syntactically correct --- in particular, garbage following a right brace will be ignored. Tom Lane 2002-03-16 22:47:13 +00:00
  • 134fe5ec61 fixed QueryExecuter to deal with multiple errors previously it was throwing a SQLException as soon as the error message was received from the backend. This did not allow the protocol to finish properly now, simply collects error messages from the backend until the query is done and throws exception at the end Also added setLogLevel to Driver.java, and made the log levels public Dave Cramer 2002-03-16 02:15:23 +00:00
  • efec53adb3 Repair bad calculation in timetz_izone() which gave erroneous results. Will be patched separately but equivalently in HEAD for 7.3. Thomas G. Lockhart 2002-03-15 23:37:48 +00:00
  • efd45bc68f Manually clean up indenting of ecpg lex/yacc files, OK'ed by Michael Meskes. These files are not touched by pgindent so this has to be manually done. Bruce Momjian 2002-03-15 21:46:59 +00:00
  • 94a41d1326 Repair two problems with WAL logging of sequence nextvalI() ops, as per recent pghackers discussion: force a new WAL record at first nextval after a checkpoint, and ensure that xlog is flushed to disk if a nextval record is the only thing emitted by a transaction. Tom Lane 2002-03-15 19:20:47 +00:00
  • 01747692fe Repair two problems with WAL logging of sequence nextvalI() ops, as per recent pghackers discussion: force a new WAL record at first nextval after a checkpoint, and ensure that xlog is flushed to disk if a nextval record is the only thing emitted by a transaction. Tom Lane 2002-03-15 19:20:36 +00:00
  • 0b73fe14f1 Back out EXCEPT/DIFFERENCE patch. Seems I forgot the details of this. Bruce Momjian 2002-03-15 16:16:31 +00:00
  • 5c1dc0280e Fix for docs from Patrick Welche: Bruce Momjian 2002-03-15 15:55:58 +00:00
  • a2b5512929 patch from Alexey Slynko This patch solve problems with arrays in latest development JDBC driver Dave Cramer 2002-03-15 04:11:49 +00:00
  • 31effd10fe The attached patch changes ALTER TABLE OWNER to also change the ownership of any toast tables that belong to the table that is being operated upon (as suggested by Tom Lane). Bruce Momjian 2002-03-14 22:44:50 +00:00
  • 01e322652b 1) Internal improvements to handle updatable cursors(1st cut). 2) Fix a bug in SQLColAttribute(). Hiroshi Inoue 2002-03-14 05:42:04 +00:00
  • 44d7f153ae Update FAQ for 7.2.1. Bruce Momjian 2002-03-13 20:53:15 +00:00
  • f362dcec61 Move src/GNUmakefile.in to src/Makefile and src/backend/port/Makefile.in to src/backend/port/Makefile Peter Eisentraut 2002-03-13 00:05:06 +00:00
  • cf6a73dedc Change "head -1" to "sort q" as suggested for POSIX compatibility. Bruce Momjian 2002-03-12 21:44:18 +00:00
  • 6eeb95f0f5 Restructure representation of join alias variables. An explicit JOIN now has an RTE of its own, and references to its outputs now are Vars referencing the JOIN RTE, rather than CASE-expressions. This allows reverse-listing in ruleutils.c to use the correct alias easily, rather than painfully reverse-engineering the alias namespace as it used to do. Also, nested FULL JOINs work correctly, because the result of the inner joins are simple Vars that the planner can cope with. This fixes a bug reported a couple times now, notably by Tatsuo on 18-Nov-01. The alias Vars are expanded into COALESCE expressions where needed at the very end of planning, rather than during parsing. Also, beginnings of support for showing plan qualifier expressions in EXPLAIN. There are probably still cases that need work. initdb forced due to change of stored-rule representation. Tom Lane 2002-03-12 00:52:10 +00:00
  • 66b6bf67a1 More pgsql \? cleanup for Peter E. Bruce Momjian 2002-03-11 18:26:20 +00:00
  • 560a2c017c Correct optional args in psql \? as pointed out by Ian Barwick. Bruce Momjian 2002-03-11 18:22:03 +00:00
  • aaf52da649 Pleas apply it for 7.2.1 and current CVS. Bruce Momjian 2002-03-11 16:55:18 +00:00
  • cdfe4bb64f Pleas apply it for 7.2.1 and current CVS. Bruce Momjian 2002-03-11 16:54:27 +00:00
  • 0d2842468c Mention time() and interval() are also changed in 7.2. Bruce Momjian 2002-03-11 16:41:44 +00:00
  • 80bbfe76d5 Inlined a patch to add the libpq setNoticeProcessor capability to libpq++. Bruce Momjian 2002-03-11 15:08:18 +00:00
  • 9f9e3c9803 Changed the version numbers, but did not commit the Makefiles. Michael Meskes 2002-03-11 12:56:02 +00:00
  • dadb718b10 Bug fixes for the 2002-03-08 change. 1) Put back the error message for SQLError(). 2) Change Disallow premature to handle the SELECTed result. 3) Put back the behavior of AUTUCOMMIT mode change. 4) Fix SQLColumns for ODBC3.0. Hiroshi Inoue 2002-03-11 10:25:57 +00:00
  • d0d3ab5325 Fix markup Peter Eisentraut 2002-03-11 05:03:52 +00:00
  • 414550f438 Uppercase class selectors, to work with browsers that follow the standards. Peter Eisentraut 2002-03-11 05:02:04 +00:00
  • 29731df471 Back out this for Peter: Bruce Momjian 2002-03-11 04:39:14 +00:00
  • 7f7fb4e64c Fixed two bugs in define command in pgc.l Michael Meskes 2002-03-10 12:09:54 +00:00
  • a9f268dcb3 Update and remove items: Bruce Momjian 2002-03-10 06:12:23 +00:00
  • a35b6b6418 Add DEFAULT_INDEX_TYPE == "btree", for clarity. Bruce Momjian 2002-03-10 06:02:24 +00:00
  • ee27436f6c Disable brackets in multi-statement rules, as discussed. Bruce Momjian 2002-03-10 06:00:15 +00:00
  • 07ee72fc67 Guard against NULL strings in SET key=val constructs. Problem noted by Fernando Nasser. Thomas G. Lockhart 2002-03-09 17:41:04 +00:00
  • f20509551d Guard against NULL strings in SET key=val constructs. Problem noted by Fernando Nasser. Thomas G. Lockhart 2002-03-09 17:37:16 +00:00
  • ee2154829e Added a check for not calling next() before getting objects from the result set, moved the check for columnIndex into same call check at the top of all getXXX added appropriate error Dave Cramer 2002-03-09 17:36:14 +00:00
  • c422b5ca6b Code review for improved-hashing patch. Fix some portability issues (char != unsigned char, Datum != uint32); make use of new hash code in dynahash hash tables and hash joins. Tom Lane 2002-03-09 17:35:37 +00:00
  • 1eb31d197d Here is a small patch that cleans up some error reporting in the JDBC driver. PSQLExceptions are thrown instead of SQLExceptions and if a warning is received while waiting for the backend secret key, that warning is chained to the new Connection object instead of generating an exception. A couple new error messages have been added. Dave Cramer 2002-03-09 17:08:39 +00:00
  • fdcb8516d4 Wording improvements to runtime.sgml. Add mention in postgresql.conf file that SIGHUP or "pg_ctl reload" are required for changes to take affect on a running server. Bruce Momjian 2002-03-09 05:11:38 +00:00
  • db1d7a9ada Improve wording of pg_hba.conf file. Bruce Momjian 2002-03-08 20:36:58 +00:00
  • fc70104725 Remove compile errors. Hiroshi Inoue 2002-03-08 09:50:39 +00:00
  • 4b47467a6b 1) Implement SQLParamOptions(). 2) Handle Multiple results and implement SQLMoreResult(). 3) Improve multibyte handling thanks to Eiji Tokuya. 4) Add new options. LF <-> CR/LF converion. TRUE is -1 (for VB). 5) Introduce unicode(UCS-2) support. 6) Reduce the length of connection strings. 7) Improve SQLError, SQLGetDiagRec(ODBC 3.0). 8) Implement SQLTablePrivileges(). 9) Miscellaneous changes for ODBC 3.0 support. Hiroshi Inoue 2002-03-08 08:52:55 +00:00
  • 21f8aa396f analyze.o need not depend on parser.h. Tom Lane 2002-03-08 07:12:11 +00:00
  • 01fe40f5c5 Remove unnecessary inclusion. Tom Lane 2002-03-08 06:55:08 +00:00
  • cf68a686a6 Fix copying/equality-check bugs in GrantStmt and ConstraintsSetStmt, per reports from Fernando Nasser. Also, rearrange order of declarations in parsenodes.h as suggested by Fernando. Tom Lane 2002-03-08 04:37:18 +00:00
  • 54f4136aca Remove async TODO.detail file. Bruce Momjian 2002-03-08 04:34:37 +00:00
  • 405e0c9aac Update TODO items that are completed. Bruce Momjian 2002-03-08 04:33:53 +00:00
  • ee81126d1f TODO item done: Bruce Momjian 2002-03-08 04:29:01 +00:00
  • fd6b9f04a7 Mark as done: Bruce Momjian 2002-03-08 04:03:32 +00:00
  • 3239793e0d Add Bruce Momjian 2002-03-08 01:31:19 +00:00
  • 98b3ae7378 Add missing colon to getopt() arg. Tom Lane 2002-03-08 00:42:09 +00:00
  • 08e1664ab4 Add FULL in VACUUM psql completion. Bruce Momjian 2002-03-07 20:48:41 +00:00