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

Commit Graph

  • f91dd7880f Clean up minor compiler warnings. Tom Lane 2000-03-18 18:57:16 +00:00
  • f945f46193 Modify lexing of multi-char operators per pghackers discussion around 16-Mar-00: trailing + or - is not part of the operator unless the operator also contains characters not present in SQL92-defined operators. This solves the 'X=-Y' problem without unduly constraining users' choice of operator names --- in particular, no existing Postgres operator names become invalid. Tom Lane 2000-03-18 18:03:12 +00:00
  • 2b23e86447 Repair typos: <xb> EOF rule should be <xh>, likewise <xq> to <xd> Tom Lane 2000-03-18 05:44:21 +00:00
  • 15115344f0 Just noticed that the grammar actually has no provision for '+' as a prefix operator :-(. Bad enough that we have no implementation of unary plus, but at least with this fix the grammar will take it. Tom Lane 2000-03-18 04:32:35 +00:00
  • caa6fc1ba2 Add translation of timespan to interval. Bruce Momjian 2000-03-18 00:33:45 +00:00
  • 3faa9bab07 Patch possible portability problem: a few places had // style comments, which is not ANSI C, even though some compilers will take it... Tom Lane 2000-03-17 23:26:36 +00:00
  • 64ef5c82de Typo correction (// -> /) Tom Lane 2000-03-17 23:17:23 +00:00
  • 0e314d747e Add safety check on expression nesting depth. Default value is set by a config.h #define, and the runtime value can be controlled via SET. Tom Lane 2000-03-17 05:29:07 +00:00
  • 341b328b18 Fix a bunch of minor portability problems and maybe-bugs revealed by running gcc and HP's cc with warnings cranked way up. Signed vs unsigned comparisons, routines declared static and then defined not-static, that kind of thing. Tedious, but perhaps useful... Tom Lane 2000-03-17 02:36:41 +00:00
  • bc1f117094 Update config.guess and config.sub to latest versions available from the GNU Autoconf CVS server. Tom Lane 2000-03-16 20:41:17 +00:00
  • 6a4b7d83f3 Tweak horology regress test to ensure platform-independent ordering of results in conversions tests. Update horology-no-DST-before-1970.out. Tom Lane 2000-03-16 17:03:41 +00:00
  • a7e0ee9a0e Since it has been confirmed working on the bugs list, please apply the attached patch. Bruce Momjian 2000-03-16 15:35:34 +00:00
  • 3e4708c45c libpq++ Makefile uses -DDEBUG to turn on debugging trace to /tmp/trace.out. However, elog.h uses DEBUG as a log-level flag. As a result, tracing is turned on even if the libpq++.so is built with DEBUG commented out in the Makefile. Bruce Momjian 2000-03-16 15:34:36 +00:00
  • 1f3122e26d Fix typo (introduced by xemacs markup normalization) in the syntax summary. Thomas G. Lockhart 2000-03-16 14:39:30 +00:00
  • 9e7166096e Support full POSIX-style time zone: EST+3, PST-3, etc. We probably support a superset of the spec, but I don't have the spec to confirm this. Update regression tests to include tests for this format. Thomas G. Lockhart 2000-03-16 14:38:42 +00:00
  • 90c4bab7ea Support full POSIX-style time zone: EST+3, PST-3, etc. We probably support a superset of the spec, but I don't have the spec to confirm this. Update regression tests to include tests for this format. Update geometry.out with results from Linux RH 5.2 system (for last decimal place). Thomas G. Lockhart 2000-03-16 14:38:31 +00:00
  • ff0a420c92 Support full POSIX-style time zone: EST+3, PST-3, etc. We probably support a superset of the spec, but I don't have the spec to confirm this. Update regression tests to include tests for this format. Fix single-space typo in printed message in regress.sh. Thomas G. Lockhart 2000-03-16 14:37:33 +00:00
  • 0e1043b760 Fixes for char_length() change. Tatsuo Ishii 2000-03-16 11:55:43 +00:00
  • 805e0c4589 Fixes for char_length() changes. Tatsuo Ishii 2000-03-16 11:53:16 +00:00
  • d14c8aab99 Turns out that Mazurkiewicz's gripe about 'function inheritance' is actually a type-coercion problem. If you have a function defined on class A, and class B inherits from A, then the function ought to work on class B as well --- but coerce_type didn't know that. Now it does. Tom Lane 2000-03-16 06:35:07 +00:00
  • d4a2c86eaf Fix for char_length() changes Tatsuo Ishii 2000-03-16 05:07:21 +00:00
  • e64a331179 Fix some (more) problems with subselects in rules. Rewriter failed to mark query as having subselects if a subselect was added from a rule WHERE condition (as opposed to a rule action). Also, fix adjustment of varlevelsup so that it actually has some prospect of working when inserting an expression containing a subselect into a subquery. Tom Lane 2000-03-16 03:23:18 +00:00
  • 4a3a1e2cf1 Hi, Bruce Momjian 2000-03-16 01:35:41 +00:00
  • 6358e654ca Update comment obsoleted by Thomas's latest fixes. Tom Lane 2000-03-15 23:42:14 +00:00
  • 1763a7c1ea Tweak GROUP BY so that it will still accept result-column names, but only after trying to resolve the item as an input-column name. This allows us to be compliant with the SQL92 spec for queries that fall within the spec, while still accepting the same out-of-spec queries as 6.5 did. You'll only lose if there is an output column name that is the same as an input column name, but doesn't refer to the same value. 7.0 will interpret such a GROUP BY spec differently than 6.5 did. No way around that, because 6.5 was clearly not spec compliant. Tom Lane 2000-03-15 23:31:19 +00:00
  • 8e0790519a *** empty log message *** Michael Meskes 2000-03-15 19:09:10 +00:00
  • 77f4885393 Fix busted TRANSLATE() code --- it coredumped due to pfree()'ing the wrong pointer. Tom Lane 2000-03-15 17:24:18 +00:00
  • 795878d2dd Fix " to ' on lobj docs. Bruce Momjian 2000-03-15 17:07:41 +00:00
  • 84b9507f78 Remove another incorrect UserAbortTransactionBlock() call. Tom Lane 2000-03-15 07:02:56 +00:00
  • fe189063b8 Remove gratuitous and incorrect begin/commit transaction calls in CREATE DB/DROP DB. If you didn't think they were wrong, try what happens when you compile with -DCLOBBER_FREED_MEMORY --- database name displayed in error messages is trashed, because transaction abort freed it. Also, remove trailing periods in error messages, per our prevailing style. Tom Lane 2000-03-15 06:50:51 +00:00
  • c397e264db Fix a couple of missed changes in expected results. Tom Lane 2000-03-15 06:24:58 +00:00
  • ce3b489b97 Add 'datetime' -> 'timestamp' conversion to xlateSqlFunc() to ease the pain of updating apps to 7.0. Should we also translate some of the 'datetime_foo' functions that exist in 6.* ? Tom Lane 2000-03-15 05:31:55 +00:00
  • a50f2fd76e Repair unintentional damage to MULTIBYTE code. Tom Lane 2000-03-14 23:59:23 +00:00
  • 34235a295b Cache fmgr lookup data for index's getnext() function in IndexScanDesc, so that the fmgr lookup only has to happen once per index scan and not once per tuple. Seems to save 5% or so of CPU time for an indexscan. Tom Lane 2000-03-14 23:52:01 +00:00
  • 6456810078 Implement column aliases on views "CREATE VIEW name (collist)". Implement TIME WITH TIME ZONE type (timetz internal type). Remap length() for character strings to CHAR_LENGTH() for SQL92 and to remove the ambiguity with geometric length() functions. Keep length() for character strings for backward compatibility. Shrink stored views by removing internal column name list from visible rte. Implement min(), max() for time and timetz data types. Implement conversion of TIME to INTERVAL. Implement abs(), mod(), fac() for the int8 data type. Rename some math functions to generic names: round(), sqrt(), cbrt(), pow(), etc. Rename NUMERIC power() function to pow(). Fix int2 factorial to calculate result in int4. Enhance the Oracle compatibility function translate() to work with string arguments (from Edwin Ramirez). Modify pg_proc system table to remove OID holes. Thomas G. Lockhart 2000-03-14 23:06:59 +00:00
  • ce543b2121 Write up new TIME WITH TIME ZONE type. Thomas G. Lockhart 2000-03-14 22:52:53 +00:00
  • c40a0a1b52 Marginal performance improvement in LockBuffer --- calculate address of BufferLocks[] entry just once. Seems to save 10% or so of the routine's runtime, which'd not be worth worrying about if it weren't such a hotspot. Tom Lane 2000-03-14 22:46:27 +00:00
  • e02cde4b0a > I have improved the System V semaphore emulation of the QNX4 port. Please > apply the attached patch to > > backend/port/qnx4 > > Andreas Kardos > Bruce Momjian 2000-03-14 18:12:06 +00:00
  • e3fb902991 > To make PostgreSQL compilable on Digital Unix I had to modify the alpha_cc > template file. Patch attached. > > Andreas Kardos > Bruce Momjian 2000-03-14 16:00:22 +00:00
  • 5e3eda41db > Here is an extension of the regression test suite for Digital Unix (Alpha). > > Andreas Kardos Bruce Momjian 2000-03-14 15:59:39 +00:00
  • 27b3f7c4e0 > Here is an extension of the regression test suite for Digital Unix (Alpha). > Bruce Momjian 2000-03-14 15:55:54 +00:00
  • ab9b4d8086 > The snprintf stuff in interfaces/ecpg/preproc/Makefile.in is broken. Please > apply the attached patch. > > Andreas Kardos > > Bruce Momjian 2000-03-14 15:55:17 +00:00
  • 44a9639123 Detect postmaster being ready by calling psql -l rathern than checking postmaster.pid. It's not enough to check the existence of postmaster.pid since DB recovery might be running. Tatsuo Ishii 2000-03-14 08:34:47 +00:00
  • 6217a8c7ba Fix some bogosities in the code that deals with estimating the fraction of tuples we are going to retrieve from a sub-SELECT. Must have been half asleep when I did this code the first time :-( Tom Lane 2000-03-14 02:23:15 +00:00
  • a1642089bf Fixed deficiency where an unterminated (no semicolon) command at end of psql script would be dropped silently. Peter Eisentraut 2000-03-13 13:46:32 +00:00
  • e631df3c1b Extend numeric_round and numeric_trunc to accept negative scale inputs (ie, allow rounding to occur at a digit position left of the decimal point). Apparently this is how Oracle handles it, and there are precedents in other programming languages as well. Tom Lane 2000-03-13 02:31:13 +00:00
  • 57cf09591b Remove unnecessary limitations on lengths of bpchar and varchar constants. Since we detect oversize tuples elsewhere, I see no reason not to allow string constants that are 'too long' --- after all, they might never get stored in a tuple at all. Tom Lane 2000-03-13 01:54:07 +00:00
  • a84c95634e Performance improvement for lexing long strings: increase flex's YY_READ_BUF_SIZE, which turns out to have nothing to do with buffer size. It's just a totally arbitrary upper limit on how much data myinput() is asked for at one time. Tom Lane 2000-03-13 01:52:06 +00:00
  • 7cb253ed19 Somehow, the variant NATIONAL CHAR [ VARYING ] was missing from the set of SQL-standard type names that we accept. Tom Lane 2000-03-12 20:09:41 +00:00
  • 1879175b18 Fix performance bug in constant-expression simplifier. After finding that the inputs to a given operator can be recursively simplified to constants, it was evaluating the operator using the op's *original* (unsimplified) arg list, so that any subexpressions had to be evaluated again. A constant subexpression at depth N got evaluated N times. Probably not very important in practical situations, but it made us look real slow in MySQL's 'crashme' test... Tom Lane 2000-03-12 19:32:06 +00:00
  • ef3386affe Fix performance problem in fireRIRonSubselect: with nested subqueries, fireRIRonSubselect was invoked twice at each subselect, leading to an exponential amount of wasted effort. Tom Lane 2000-03-12 18:57:05 +00:00
  • 117fa25ae1 Clean up grammar's handling of NULL in expressions: a_expr_or_null is gone, replaced by plain a_expr. The few places where we needed to distinguish NULL from a_expr are now handled by tests inside the actions rather than by separate productions. This allows us to accept queries like 'SELECT 1 + NULL' without requiring parentheses around the NULL. Tom Lane 2000-03-12 00:39:52 +00:00
  • e8be8ffaf0 Further tweaking of logic that decides when to materialize an uncorrelated subplan: do it if subplan has subplans itself, and always do it if the subplan is an indexscan. (I originally set it to materialize an indexscan only if the indexqual is fairly selective, but I dunno what I was thinking ... an unselective indexscan is still expensive ...) Tom Lane 2000-03-11 23:53:41 +00:00
  • bbe1ff7404 Make TypeCategory think that NAME is a member of type category STRING. Also, if UNKNOWNOID is passed in, return UNKNOWN_TYPE not USER_TYPE. Tom Lane 2000-03-11 23:19:50 +00:00
  • c9f287e49b Further fixes for bogus list-slinging, scribbling on input, etc in type coercion code. I'm beginning to wonder why we have separate candidate selection routines for functions, operators, and aggregates --- shouldn't this code all be unified? But meanwhile, SELECT 'a' LIKE 'a'; finally works; the code for dealing with unknown input types for operators was pretty busted. Tom Lane 2000-03-11 23:17:47 +00:00
  • 1d75298176 Karel Zakr's revised patch to fix psql prompt for local host connections. Peter Eisentraut 2000-03-11 13:56:24 +00:00
  • 73f5b0847b exec_simple_check_plan() must not allow a plan having initPlans or subPlans to be considered 'simple'. This fixes reported problem with 'return exists (select 1 from foo);' in plpgsql function. Tom Lane 2000-03-11 06:19:00 +00:00
  • f3a9d75ebd Finish cleaning up backend's handling of /* ... */ and -- comments, per pghackers discussion around 20-Feb. Also add specific error messages for unterminated comments and unterminated quoted strings. These things are nonissues for input coming from psql, but they do matter for input coming from other front ends. Tom Lane 2000-03-11 05:14:06 +00:00
  • 370186e807 Update libpq documentation for PQconndefaults() change. Add section about thread-safeness of the library. Tom Lane 2000-03-11 03:09:28 +00:00
  • a71daab4b4 Change PQconndefaults() to return a malloc'd array, instead of a static array. This allows processing of conninfo strings to be made thread-safe, at the cost of a small memory leak in applications that use PQconndefaults() and are not updated to free the returned array via the new PQconninfoFree() function. But PQconndefaults() is probably not used very much, so this seems like a good compromise. Tom Lane 2000-03-11 03:08:37 +00:00
  • 773e84f52a Update perl5's self-test for changed spelling of connection failure error message. Tom Lane 2000-03-11 02:57:24 +00:00
  • 0f17e3faab Okay, this time I *really* added the bug reporting guidelines. Peter Eisentraut 2000-03-10 22:32:59 +00:00
  • 01a96710bd make sure that cvslog is workign right ... no changes but to remove a blank line Marc G. Fournier 2000-03-10 21:46:27 +00:00
  • 37ae1c0467 *** empty log message *** Michael Meskes 2000-03-10 06:48:46 +00:00
  • bbae7a9881 Update TODO list. Bruce Momjian 2000-03-09 23:22:18 +00:00
  • 2a55934926 Remove SHOW after datestyle reset. Bruce Momjian 2000-03-09 17:39:34 +00:00
  • de62329acd Fix for bsdi 4.1 shared libraries. Bruce Momjian 2000-03-09 17:07:32 +00:00
  • 16ace63c6b Added bug reporting guidelines Some corrections in installation procedure Peter Eisentraut 2000-03-09 12:00:08 +00:00
  • 8e7764d9c2 *** empty log message *** Michael Meskes 2000-03-09 09:17:16 +00:00
  • dad5bb01ba Redo permissions-checking code so that it does the right thing at APPEND nodes. The former version failed to check permissions of relations that were referenced in second and later clauses of UNIONs, and it did not check permissions of tables referenced via inheritance. Tom Lane 2000-03-09 05:15:33 +00:00
  • fd9ff86bd9 Trial implementation of ALTER DROP COLUMN. They are #ifdef'd. Add -D_DROP_COLUMN_HACK__ compile option to evaluate it. Hiroshi Inoue 2000-03-09 05:00:26 +00:00
  • 6513946cbb Extend #ifdef CLOBBER_FREED_MEMORY debugging option so that memory freed wholesale by AllocSetReset() is overwritten too. Tom Lane 2000-03-08 23:42:58 +00:00
  • 84a89e24ee Repair access-to-already-freed-memory error recently introduced into VACUUM. Tom Lane 2000-03-08 23:41:00 +00:00
  • d261adf6db Fix ==-instead-of-= typo that gcc does its level best to point out. Isn't anybody paying attention to warnings around here? Tom Lane 2000-03-08 22:03:12 +00:00
  • baeafa91f3 Clean up gmake warning caused by recent NetBSD patch. <grumble> Tom Lane 2000-03-08 22:00:19 +00:00
  • 791bc6838d Hi, Bruce Momjian 2000-03-08 19:36:19 +00:00
  • f43ec05d05 I've made a diff against the 7.0beta1 tree that accomplishes several things: Bruce Momjian 2000-03-08 01:58:46 +00:00
  • 26c953e373 Bruce and all: Here's a patch to fix the " '.' not allowed in db path" problem I ran into. I removed '.' from the set of illegial characters, but added backtick. I also included an explicit test for attempting include a reference to a parent dir. Bruce Momjian 2000-03-08 01:46:47 +00:00
  • ab7fd11846 Reversed out inet patch. Bruce Momjian 2000-03-08 01:44:37 +00:00
  • 326e2155d9 Hi Peter, Bruce Momjian 2000-03-08 01:38:59 +00:00
  • eae5184d11 Hi, Bruce Momjian 2000-03-08 01:34:41 +00:00
  • 0c5422912e Protects you from coredumps if you do eg. str::int4 where str is a text field. cf. Tom Lane's <19021.950544016@sss.pgh.pa.us> 14 Feb hackers message. Bruce Momjian 2000-03-07 23:58:38 +00:00
  • 8fa8f80c1a I've recently written to pgsql-ports about a problem with PG7.0 on NT (Subj: [PORTS] initdb problem on NT with 7.0). Since nobody helped me, I had to find out the reson. The difference between NT and Linux (for instance) is that "open( path, O_RDWR );" opens a file in text mode. So sometime less block can be read than required. Bruce Momjian 2000-03-07 23:49:31 +00:00
  • 9606f36210 Someone (probably me) forgot about handling of typecasts applied to parameters. Tom Lane 2000-03-07 23:30:53 +00:00
  • 91124a2f66 Fix problems with pg_upgrade found by Kardos, Dr. Andrea Bruce Momjian 2000-03-07 23:09:34 +00:00
  • 52d39d519a Sorting for the inet data type randomly returns the wrong result when you have networks with the same prefix, but different netmasks. Bruce Momjian 2000-03-07 23:01:43 +00:00
  • 5a197810c0 *** empty log message *** Michael Meskes 2000-03-07 15:11:03 +00:00
  • ad3db67e53 Add SQL_ASCII encoding test case Tatsuo Ishii 2000-03-06 01:29:54 +00:00
  • 3526017a59 Forgot to run autoconf. (Configure shouldn't really be in CVS ...) Peter Eisentraut 2000-03-05 14:14:15 +00:00
  • 8de482a847 Added configure test for readline's filename_completion_function Completed psql's \? help Peter Eisentraut 2000-03-05 13:30:20 +00:00
  • 3c71ed7e72 *** empty log message *** Michael Meskes 2000-03-03 14:39:26 +00:00
  • 1c7fad57d6 *** empty log message *** Michael Meskes 2000-03-03 13:24:06 +00:00
  • 3a81a1a462 *** empty log message *** Michael Meskes 2000-03-03 09:56:03 +00:00
  • 85b2875a3a *** empty log message *** Michael Meskes 2000-03-02 19:33:59 +00:00
  • 9309eac111 *** empty log message *** Michael Meskes 2000-03-02 12:13:32 +00:00
  • 0eb5ab8250 Apply a MATERIAL node to the result of an uncorrelated subplan, if it looks like it will save computation to do so. Tom Lane 2000-03-02 04:08:16 +00:00
  • 9f198423df Hmm, it seems nodeMaterial has been broken for a good long while; closing a relcache entry more times than you open it is not cool. Tom Lane 2000-03-02 04:06:39 +00:00
  • bd2d0983d4 Patch for Irix from Mark Dalphin. Bruce Momjian 2000-03-02 02:01:01 +00:00
  • c75adac757 More fixes for psql ^C handling, especially during copy. Still doesn't cope so well with copy to but that will have to wait for the next release. Peter Eisentraut 2000-03-01 21:10:05 +00:00
  • 19c29f9236 New plperl Makefile. Bruce Momjian 2000-03-01 19:13:08 +00:00