summaryrefslogtreecommitdiff
path: root/src
AgeCommit message (Collapse)Author
2000-03-23Hmm, absolute pathnames for the copy makes sense. I'll whip up thatBruce Momjian
patch in a second. Should be sufficent to just make sure the first character is a '/', right? Ross J. Reedstrom
2000-03-23Some points for portability improvements:Bruce Momjian
1. C++ style comments in C source for ecpg ( // comment ) 2. compiler finds wrong include file extern.h in ecpg/lib/descriptor.c from include path instead of workdir (rename it ?) 3. fe-connect getsockopt takes a socklen_t as fifth arg not int (use SOCKET_SIZE_TYPE instead) 4. char vs unsigned char in psql calls to libpq 5. empty define that results in an empty but terminated line ( ; ) Now for all but point 3 I can supply changes to the compiler flags, to make the compiler less pedantic. Or is someone interested in the complications ? in the meantime can someone apply the attached patch ? Andreas
2000-03-23Please apply the attached patch to interfaces/libpq/libpq-fe.h. This wouldBruce Momjian
allow to write applications which do not have a link to postgres_ext.h in their source directory. Andreas Kardos
2000-03-23*** empty log message ***Michael Meskes
2000-03-23subselect regress test was kind of silly; it claimed to test correlationTom Lane
cases but actually did no such thing. Make it test some more cases than before (including things that didn't work in 6.5).
2000-03-23Float-to-int conversion functions should return NULL when given NULLTom Lane
input, not throw a gratuitous elog().
2000-03-23Remove no-longer-necessary restriction against uplevel correlation varsTom Lane
outside WHERE clause. Fix a couple of places that didn't handle uplevel refs cleanly.
2000-03-23Hack parse_coerce so it won't try to constant-fold the dummy ConstTom Lane
nodes introduced by make_subplan(). It'd be better if we used a different node type for subplan result placeholders, but for now...
2000-03-23ExecSubPlan needs to be able to cope with RelabelType nodes atop theTom Lane
Const placeholder nodes for subplan result values.
2000-03-23Update HISTORY file for 7.0.Bruce Momjian
2000-03-23If we cannot get a real estimate for the selectivity of a range query,Tom Lane
use a default value that's fairly small. We were generating a result of about 0.1, but I think 0.01 is probably better --- want to encourage use of an indexscan in this situation.
2000-03-23Improve selectivity estimation involving string constants: pay attentionTom Lane
to more than one character, and try to do the right thing in non-ASCII locales.
2000-03-22Repair logic flaw in cost estimator: cost_nestloop() was estimating CPUTom Lane
costs using the inner path's parent->rows count as the number of tuples processed per inner scan iteration. This is wrong when we are using an inner indexscan with indexquals based on join clauses, because the rows count in a Relation node reflects the selectivity of the restriction clauses for that rel only. Upshot was that if join clause was very selective, we'd drastically overestimate the true cost of the join. Fix is to calculate correct output-rows estimate for an inner indexscan when the IndexPath node is created and save it in the path node. Change of path node doesn't require initdb, since path nodes don't appear in saved rules.
2000-03-22Update pg_dumpall again.Bruce Momjian
2000-03-22Fix pg_dumpall for new psql output.Bruce Momjian
2000-03-21Forgot that odbc had its own copies of config.sub/config.guess.Tom Lane
Update those to latest Autoconf sources, too.
2000-03-21Fix query for primary keys to reflect new DISTINCT ON () syntax.Thomas G. Lockhart
Reported by "Tibor Laszlo" <ltibor@mail.tiszanet.hu> and fix suggested by "Hiroshi Inoue" <Inoue@tpf.co.jp>.
2000-03-21Add syntax for BIT() and BIT VARYING(), but no underlying implementationThomas G. Lockhart
is available yet. Remove redundant call to xlateSqlType() in the character type handling code.
2000-03-21Update test for new ORDER BY clause from Tom Lane.Thomas G. Lockhart
2000-03-21Restructure planning code so that preprocessing of targetlist and qualsTom Lane
to simplify constant expressions and expand SubLink nodes into SubPlans is done in a separate routine subquery_planner() that calls union_planner(). We formerly did most of this work in query_planner(), but that's the wrong place because it may never see the real targetlist. Splitting union_planner into two routines also allows us to avoid redundant work when union_planner is invoked recursively for UNION and inheritance cases. Upshot is that it is now possible to do something like select float8(count(*)) / (select count(*) from int4_tbl) from int4_tbl group by f1; which has never worked before.
2000-03-21Correct typo in error message.Tom Lane
2000-03-20Reverse out BYTEA type coersion.Bruce Momjian
2000-03-20Turn XLOG off (do not create log file).Vadim B. Mikheev
2000-03-20Emit 'this operator is deprecated' warnings for ':' and ';'.Tom Lane
2000-03-20Convert float8 regress test to use exp() and ln() instead of ':' andTom Lane
';' operators.
2000-03-20Update for BYTEAOID.Bruce Momjian
2000-03-20Add compatiblity information for bytea.Bruce Momjian
2000-03-20Add FORCE keyword to ColIDHiroshi Inoue
2000-03-19Make use of pre-existing regexp match capability to eliminate redundantTom Lane
entries in template selection rules. Also, change alpha-dec-osf pattern to cope with version info attached to the 'alpha' part.
2000-03-19Autoconf runTom Lane
2000-03-19Change configure.in to note that since we are using expr(1)'s regex matchTom Lane
command, the entries in template/.similar can really be regular expressions. This isn't a new feature, just an observation of what the code already did.
2000-03-19cash_words_out function truncated its output by 1 character due toTom Lane
incorrect use of StrNCpy.
2000-03-19Several calls to StrNCpy incorrectly subtracted 1 from the length arg,Tom Lane
leading to postmaster accepting args 1 shorter than it had room for.
2000-03-19Change MemSet and StrNCpy to evaluate their arguments only once.Tom Lane
Fix inadequate parenthesization in several other macros.
2000-03-19Proper unpack de_DE.ISO-8859-1Bruce Momjian
2000-03-19Minor code rearrangement & doc improvement in eval_const_expressions().Tom Lane
2000-03-19*** empty log message ***Michael Meskes
2000-03-19transformExpr() did the Wrong Thing if applied to a SubLink node thatTom Lane
had already been transformed. This led to failure in examples like UPDATE table SET fld = (SELECT ...). Repair this, and revise the comments to explain that transformExpr has to be robust against this condition. Someday we might want to fix the callers so that transformExpr is never invoked on its own output, but that someday is not today.
2000-03-19it seems in the beta2 release DBUSERID in pg_dumpall is the _name_ of theBruce Momjian
user, so it doesn't need to be translated from the number to the name. also ``create database ...'' does not take numbers for the encoding, so the ENCODING variable does not need to be translated to a number, but left as the text representation. a patch is supplied to make the changes i have found to work. i was successful dumping and reloading my database after these changes. - John M. Flinchbaugh
2000-03-19Fix incorrect implementation of log(x) for numeric, as well asTom Lane
incorrect descriptions of a couple of log-related functions. I will not force an initdb for this, but log() on a numeric won't work until you do one...
2000-03-19Another go-round with resolution of ambiguous functions and operators.Tom Lane
In function parsing, try for an actual function of the given name and input types before trying to interpret the function call as a type coercion request, rather than after. Before, a function that had the same name as a type and operated on a binary-compatible type wouldn't get invoked. Also, cross-pollinate between func_select_candidates and oper_select_candidates to ensure that they use as nearly the same resolution rules as possible. A few other minor code cleanups too.
2000-03-19In can_coerce_type, verify that a possible type-coercion functionTom Lane
actually returns the type it is named for.
2000-03-18Fixed psql -c "\slashcmd"Peter Eisentraut
2000-03-18Update bytea type descriptionBruce Momjian
2000-03-18Improve error message wording in unary_op_error() --- suggest thatTom Lane
problem could be lack of parentheses. This addresses cases like X UserOp UserOp Y, which will be parsed as (X UserOp) UserOp Y, whereas what likely was wanted was X UserOp (UserOp Y).
2000-03-18Clean up minor compiler warnings.Tom Lane
2000-03-18Modify lexing of multi-char operators per pghackers discussion aroundTom Lane
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. Also, remove processing of // comments, as agreed in the same thread.
2000-03-18Repair typos: <xb> EOF rule should be <xh>, likewise <xq> to <xd>Tom Lane
2000-03-18Just noticed that the grammar actually has no provision for '+' as aTom Lane
prefix operator :-(. Bad enough that we have no implementation of unary plus, but at least with this fix the grammar will take it.
2000-03-18Add translation of timespan to interval.Bruce Momjian