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

Commit Graph

  • 86210e9d39 Update sgmltools install instructions. Bruce Momjian 1999-10-05 18:55:45 +00:00
  • 00c85b44b8 Allow comment-only lines, and ;;; lines too. Bruce Momjian 1999-10-05 18:14:31 +00:00
  • d71ef47a70 Update TODO list. Bruce Momjian 1999-10-05 15:51:53 +00:00
  • dab3775329 Update sgmltools for docs. Bruce Momjian 1999-10-04 17:05:51 +00:00
  • ab35b0822b Expunge "UNIX" in favor of "Unix". A few other changes, but I forget what :( Thomas G. Lockhart 1999-10-04 15:18:54 +00:00
  • d0741fb42f As we now use lipq++.H which wasn't around when I first posted the 2 line GetIsNull diffs, we now need this too: Bruce Momjian 1999-10-04 15:17:06 +00:00
  • ee8d39a852 Add mention of transactions and large objects. Still need the code updated for LO examples. Thomas G. Lockhart 1999-10-04 15:16:35 +00:00
  • 0655b1500f Less noisy rule display... Tom Lane 1999-10-04 04:38:46 +00:00
  • 59844a65dd Fix typo in sgml source. Bruce Momjian 1999-10-04 04:37:46 +00:00
  • 3e21ecbbe6 Make the rule deparser a little less quote-happy, so that display of default expressions isn't quite so ugly. Tom Lane 1999-10-04 04:37:23 +00:00
  • 7cd67c800a Oops, DEFAULT processing wasn't doing type compatibility checking quite the same way that transformInsertStatement does, so that an expression could be accepted by CREATE TABLE and then fail when used. Also, put back check that CONSTRAINT expressions must yield boolean... Tom Lane 1999-10-04 02:12:26 +00:00
  • eabc714a91 Reimplement parsing and storage of default expressions and constraint expressions in CREATE TABLE. There is no longer an emasculated expression syntax for these things; it's full a_expr for constraints, and b_expr for defaults (unfortunately the fact that NOT NULL is a part of the column constraint syntax causes a shift/reduce conflict if you try a_expr. Oh well --- at least parenthesized boolean expressions work now). Also, stored expression for a column default is not pre-coerced to the column type; we rely on transformInsertStatement to do that when the default is actually used. This means "f1 datetime default 'now'" behaves the way people usually expect it to. BTW, all the support code is now there to implement ALTER TABLE ADD CONSTRAINT and ALTER TABLE ADD COLUMN with a default value. I didn't actually teach ALTER TABLE to call it, but it wouldn't be much work. Tom Lane 1999-10-03 23:55:40 +00:00
  • f29ccc8270 autoconf Bruce Momjian 1999-10-03 18:24:03 +00:00
  • c70c4e367d I hope this is what you had in mind: --enable-debug adds -g (unconditionally) --disable-debug removes -g (if it was already in there somehow) (giving neither does nothing) Bruce Momjian 1999-10-03 18:05:04 +00:00
  • 48049b4ce3 Update TODO list. Bruce Momjian 1999-10-03 17:22:21 +00:00
  • b65f3b089b Update TODO list. Bruce Momjian 1999-10-03 17:21:46 +00:00
  • b40ac42efb Teach parse_coerce about non-cachable functions (actually, make it call eval_const_expressions() so that it doesn't have to know). Tom Lane 1999-10-02 23:29:19 +00:00
  • 6eb8d255d2 Allow CREATE FUNCTION's WITH clause to be used for all language types, not just C, so that ISCACHABLE attribute can be specified for user-defined functions. Get rid of ParamString node type, which wasn't actually being generated by gram.y anymore, even though define.c thought that was what it was getting. Clean up minor bug in dfmgr.c (premature heap_close). Tom Lane 1999-10-02 21:33:33 +00:00
  • e23a2b1ea0 Document formerly-undocumented WITH clause of CREATE FUNCTION. Tom Lane 1999-10-02 21:27:49 +00:00
  • 1f122a7c4c Replace float.c's #ifdef finite check with a proper autoconf check, so it works if finite() is a function. Patch from Christof Petig. Tom Lane 1999-10-02 17:45:31 +00:00
  • 54204e6c78 Stick finger into a couple more holes in the leaky dike of modifyAggrefQual. This routine really, really needs to be retired, but until we have subselects in FROM there's no chance of doing the job right. In the meantime try to respond to unhandlable cases with elog rather than coredump. Tom Lane 1999-10-02 04:42:04 +00:00
  • fc43696d1a Fix make_clause and make_opclause to record valid type info in the Expr nodes they produce. This fixes a few cases of errors like 'typeidTypeRelid: Invalid type - oid = 0' caused by calling parser-related routines on expression trees that have already been processed by planner- related routines. Tom Lane 1999-10-02 04:37:52 +00:00
  • cd243d27ce Revise rule-printing routines to use expandable StringInfo buffers, so that they have no hardwired limit on the length of a rule's text. Fix a couple of minor bugs in passing --- deparsed UPDATE queries didn't have quotes around relation name, and quotes and backslashes in constant values weren't backslash-quoted. Tom Lane 1999-10-02 01:08:05 +00:00
  • 4e9073855c Update TODO list. Bruce Momjian 1999-10-01 15:46:39 +00:00
  • 996c52beff Refer to "name", rather than "table" as the replaceable parameter. Seems to read better this way... Thomas G. Lockhart 1999-10-01 15:26:29 +00:00
  • f74179cd8e Make a mention of the new TRUNCATE command. Thomas G. Lockhart 1999-10-01 15:24:46 +00:00
  • 66d17c3e26 Make TABLE an optional keyword, a la LOCK TABLE (gram.y fixes not yet committed, but will be within a week or two). Actually include the reference page into the docs... Thomas G. Lockhart 1999-10-01 15:24:09 +00:00
  • 03e5edb7e4 Add keywords from Jan's recent RI features. Thomas G. Lockhart 1999-10-01 15:21:08 +00:00
  • b14a465131 Remove xref's to reference pages since they are not available in the Programmer's Guide. Thomas G. Lockhart 1999-10-01 15:20:06 +00:00
  • 389af07cf0 Clean up rewriter routines to use expression_tree_walker and expression_tree_mutator rather than ad-hoc tree walking code. This shortens the code materially and fixes a fair number of sins of omission. Also, change modifyAggrefQual to *not* recurse into subselects, since its mission is satisfied if it removes aggregate functions from the top level of a WHERE clause. This cures problems with queries of the form SELECT ... WHERE x IN (SELECT ... HAVING something-using-an-aggregate), which would formerly get mucked up by modifyAggrefQual. The routine is still fundamentally broken, of course, but I don't think there's any way to get rid of it before we implement subselects in FROM ... Tom Lane 1999-10-01 04:08:24 +00:00
  • ce1f5ed547 Fixed opr_sanity regression test to ignore the new RI_FKey_... constrint triggers when looking for illegal pg_proc entries. Jan Wieck 1999-09-30 15:28:34 +00:00
  • ccecf1fa46 Added utils/adt/ri_triggers with empty shells for the FOREIGN KEY triggers. Jan Wieck 1999-09-30 14:54:24 +00:00
  • daaeafd9e1 Removed (useless) pg_proc_prosrc_index Jan Wieck 1999-09-30 10:31:47 +00:00
  • 2993f0c100 Reverse out getopt patch --- turns out it doesn't help on my platform, and there are at least some people it's not broken for. So undo change until we can discuss a more portable solution. Tom Lane 1999-09-30 02:45:17 +00:00
  • 1764d9579e Un-break optarg() call --- some peoples' optarg libraries don't like extraneous colons in the option list... Tom Lane 1999-09-30 02:17:23 +00:00
  • 5fc889fbea Hmm, guess I forgot to commit this file the other day ... just some cosmetic changes now, Vadim already fixed the heap_xxx calls. Tom Lane 1999-09-30 01:12:36 +00:00
  • 82b1f55239 Update TODO list. Bruce Momjian 1999-09-29 21:53:56 +00:00
  • bdd6c0a61f <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2 Final//EN"> <HTML> <HEAD> <TITLE>PostgreSQL TODO list</TITLE> <BODY BGCOLOR="#FFFFFF" TEXT="#000000" LINK="#FF0000" VLINK="#A00000"\ ALINK="#0000FF"> <META NAME="generator" CONTENT="txt2html v1.25"> </HEAD> <BODY> <H1><A NAME="section-1">TODO list for PostgreSQL</A></H1> Last updated: Tue Sep 28 00:34:21 EDT 1999 Bruce Momjian 1999-09-29 21:42:11 +00:00
  • b5c4b77283 Added nbtree operator class for NUMERIC Jan Wieck 1999-09-29 21:13:31 +00:00
  • a6528e08a5 Disable new FROM-clause warning. Bruce Momjian 1999-09-29 18:16:04 +00:00
  • 1547ee017c This is part #1 for of the DEFERRED CONSTRAINT TRIGGER support. Implements the CREATE CONSTRAINT TRIGGER and SET CONSTRAINTS commands. Jan Wieck 1999-09-29 16:06:40 +00:00
  • d810338d29 Add a few items to the reserved keyword lists. Clarify information on implicitly-typed constants. Thomas G. Lockhart 1999-09-29 05:22:25 +00:00
  • be18913532 Remove remnant garbage from former man pages. Thomas G. Lockhart 1999-09-29 05:21:11 +00:00
  • fe2f878173 Fix (mis)information about NULLIF() SQL function. Thanks to Tom Lane for pointing it out. Thomas G. Lockhart 1999-09-29 05:20:20 +00:00
  • f7e12db734 Strip out some cvs log info. Thomas G. Lockhart 1999-09-29 05:18:14 +00:00
  • cdd84ccd56 <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2 Final//EN"> <HTML> <HEAD> <TITLE>PostgreSQL TODO list</TITLE> <BODY BGCOLOR="#FFFFFF" TEXT="#000000" LINK="#FF0000" VLINK="#A00000"\ ALINK="#0000FF"> <META NAME="generator" CONTENT="txt2html v1.25"> </HEAD> <BODY> <H1><A NAME="section-1">TODO list for PostgreSQL</A></H1> Last updated: Tue Sep 28 00:34:21 EDT 1999 Bruce Momjian 1999-09-28 19:56:49 +00:00
  • 008f354af4 Add mention of pg_upgrade for release checklist. Bruce Momjian 1999-09-28 18:08:29 +00:00
  • 692b83730b Fix pg_upgrade so it vacuums all databases. Bruce Momjian 1999-09-28 18:04:18 +00:00
  • 008ef1de22 Add subquery mention in auto-create table entry. Bruce Momjian 1999-09-28 17:50:23 +00:00
  • 57d0ae5590 Fix for AIX dynaloader from Zeugswetter Andrea Bruce Momjian 1999-09-28 17:35:12 +00:00
  • 1e821d05f2 pg_upgrade reminder. Bruce Momjian 1999-09-28 16:02:28 +00:00
  • 165e2b6fb3 Recommend postmaster stop/start for pg_upgrade. Bruce Momjian 1999-09-28 15:59:10 +00:00
  • 8ccebab8bd More cleanup for | and ^. Bruce Momjian 1999-09-28 14:49:36 +00:00
  • 77bef41c7f More cleanup for | and ^. Bruce Momjian 1999-09-28 14:38:02 +00:00
  • f44c7bad6c Fix for creation of operator |. Bruce Momjian 1999-09-28 14:31:19 +00:00
  • 40771ca436 Update README.NT Bruce Momjian 1999-09-28 13:08:27 +00:00
  • 35a2e62c5b Update README.NT Bruce Momjian 1999-09-28 13:08:10 +00:00
  • f282b4ff4c libpq++ cleanup from Vince Vielhaber Bruce Momjian 1999-09-28 12:59:29 +00:00
  • 3fea625e9d Make tree compilable (+WAL). Vadim B. Mikheev 1999-09-28 11:41:09 +00:00
  • 539b6304b3 heap_close(rel, AccessShareLock); ^^^^^^^^^^^^^^^^^ need in Vadim B. Mikheev 1999-09-28 11:27:13 +00:00
  • a4d7c97712 Update FAQ. Bruce Momjian 1999-09-28 05:10:18 +00:00
  • 9d5affaaf2 Update FAQ. Bruce Momjian 1999-09-28 05:09:56 +00:00
  • 5bb6bb8dd6 Addition of CmdTuples(). Wraps PQcmdTuples. Bruce Momjian 1999-09-28 04:49:22 +00:00
  • b89044b275 <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2 Final//EN"> <HTML> <HEAD> <TITLE>PostgreSQL TODO list</TITLE> <BODY BGCOLOR="#FFFFFF" TEXT="#000000" LINK="#FF0000" VLINK="#A00000"\ ALINK="#0000FF"> <META NAME="generator" CONTENT="txt2html v1.25"> </HEAD> <BODY> <H1><A NAME="section-1">TODO list for PostgreSQL</A></H1> Last updated: Tue Sep 28 00:34:21 EDT 1999 Bruce Momjian 1999-09-28 04:35:18 +00:00
  • 9394d62c73 I have been working with user defined types and user defined c functions. One problem that I have encountered with the function manager is that it does not allow the user to define type conversion functions that convert between user types. For instance if mytype1, mytype2, and mytype3 are three Postgresql user types, and if I wish to define Postgresql conversion functions like Bruce Momjian 1999-09-28 04:34:56 +00:00
  • 63a85082e3 Reverse out last scan.l patch for minus handling.\ Bruce Momjian 1999-09-28 03:41:40 +00:00
  • bc0595f27f Update TODO list. Bruce Momjian 1999-09-28 02:57:55 +00:00
  • a55888ec9c Fix nodeAgg coredump in case where lower-level plan has an empty targetlist *and* fails to return any tuples, as will happen for example with 'SELECT COUNT(1) FROM table WHERE ...' if the where- clause selects no tuples. It's so nice to make a fix by diking out code, instead of adding more... Tom Lane 1999-09-28 02:03:19 +00:00
  • 1c575efdc1 Update NT readme. Bruce Momjian 1999-09-28 01:43:20 +00:00
  • 04f150e607 Update NT readme. Bruce Momjian 1999-09-28 01:43:00 +00:00
  • 341e360d67 Sorry, guys. Here is the ultimate patch which keeps the entire behavior as it was, apart from forbidding minus-terminated operators. Seems that I have to break the habit of doing before thinking properly :-/ The point is that my second patch breaks constructs like a & b or a ! b. This patch is to be applied instead of any of two other today's patches. Bruce Momjian 1999-09-27 21:02:54 +00:00
  • 283da86feb Irix fix from Mark Dalphin Bruce Momjian 1999-09-27 20:54:56 +00:00
  • d62a7ac6d3 Massimo's SET FSYNC and SHOW PG_OPTIONS changes, without SET QUERY_LIMIT. Bruce Momjian 1999-09-27 20:27:32 +00:00
  • 5a017b96ad Apply contrib patch from Massimo Bruce Momjian 1999-09-27 20:04:14 +00:00
  • 12a932251c Cancel query support from Massimo Bruce Momjian 1999-09-27 20:00:44 +00:00
  • 23e10804f0 Update TODO list. Bruce Momjian 1999-09-27 19:56:50 +00:00
  • 0b83859b63 Update README.NT Bruce Momjian 1999-09-27 19:56:02 +00:00
  • 15d1dfcf9a Update README.NT Bruce Momjian 1999-09-27 19:55:48 +00:00
  • 7d7fb02148 Following advice from Michael Ansley, I broke up the patch in two: one fixes uminus and other literal length. They are to be applied - uminus first, then possilbly literal on top of uminus. Bruce Momjian 1999-09-27 19:40:40 +00:00
  • 3f5a164387 Hello, Bruce Momjian 1999-09-27 19:16:29 +00:00
  • c67286ce5d Update README.NT with patch. Bruce Momjian 1999-09-27 18:33:21 +00:00
  • ebb618bc5d Update README.NT with patch. Bruce Momjian 1999-09-27 18:32:58 +00:00
  • 7b2a8e4e56 Currently,only the first column of multi-column indices is used to find start scan position of Indexscan-s. Bruce Momjian 1999-09-27 18:20:21 +00:00
  • 62045e67eb Emit warning on SELECT pg_language.* Bruce Momjian 1999-09-27 17:46:14 +00:00
  • 99fb237da2 Update TODO list. Bruce Momjian 1999-09-27 17:05:08 +00:00
  • 550a416fa9 New Solaris FAQ. Bruce Momjian 1999-09-27 16:54:01 +00:00
  • 74a263ed34 Fix to give super user and createdb user proper update catalog rights. Bruce Momjian 1999-09-27 16:44:56 +00:00
  • 30659d43eb Transaction log manager core code. It doesn't work currently but also don't break anything -:) Vadim B. Mikheev 1999-09-27 15:48:12 +00:00
  • 2902c4c640 Update TODO list. Bruce Momjian 1999-09-27 15:21:36 +00:00
  • 66270c94e1 *** empty log message *** Michael Meskes 1999-09-27 10:41:02 +00:00
  • 039e7a4791 new solaris faq. Bruce Momjian 1999-09-27 03:39:06 +00:00
  • d1d97a9185 New Solaris FAQ. Bruce Momjian 1999-09-27 03:34:54 +00:00
  • c35fedda79 Update TODO list. Bruce Momjian 1999-09-27 03:24:50 +00:00
  • 065a40f90c Add README.SSL Bruce Momjian 1999-09-27 03:16:09 +00:00
  • e0e7daef6d Lots of patches coming in from me today :-) Bruce Momjian 1999-09-27 03:13:16 +00:00
  • 3114f92122 Add bsdi sparc port. Bruce Momjian 1999-09-27 00:48:42 +00:00
  • 393ccc3993 Remove 'v' from #include line. Bruce Momjian 1999-09-27 00:33:46 +00:00
  • be09bc9ff2 Modify nodeAgg.c so that no rows are returned for a GROUP BY with no input rows, per pghackers discussions around 7/22/99. Clean up a bunch of ugly coding while at it; remove redundant re-lookup of aggregate info at start of each new GROUP. Arrange to pfree intermediate values when they are pass-by-ref types, so that aggregates on pass-by-ref types no longer eat memory. This takes care of a couple of TODO items... Tom Lane 1999-09-26 21:21:15 +00:00
  • 40f6524161 Implement constant-expression simplification per Bernard Frankpitt, plus some improvements from yours truly. The simplifier depends on the proiscachable field of pg_proc to tell it whether a function is safe to pre-evaluate --- things like nextval() are not, for example. Update pg_proc.h to contain reasonable cacheability information; as of 6.5.* hardly any functions were marked cacheable. I may have erred too far in the other direction; see recent mail to pghackers for more info. This update does not force an initdb, exactly, but you won't see much benefit from the simplifier until you do one. Tom Lane 1999-09-26 02:28:44 +00:00
  • 4efb2ff001 Fix the omitted declarations to allow '^' and '|' as math operators. Problem was introduced when precedence was added for these. How did *those* changes get into the stable tree in the first place?? Thomas G. Lockhart 1999-09-24 15:08:59 +00:00