aboutsummaryrefslogtreecommitdiff
Commit message (Collapse)AuthorAge
* Cause planner to account for evaluation costs in targetlists andTom Lane2003-01-13
| | | | | | | | HAVING quals. Normally this is an insignificant effect --- but it will not be insignificant when these clauses contain sub-selects. The added costs cannot affect the planning of the query containing them, but they might have an impact when the query is a sub-query of a larger one.
* Recent changes in sublink representation require exprType() to acceptTom Lane2003-01-13
| | | | SubPlan nodes, else explaining queries containing sublinks may fail.
* Revise cost_qual_eval() to compute both startup (one-time) and per-tupleTom Lane2003-01-12
| | | | | | costs for expression evaluation, not only per-tuple cost as before. This extension is needed in order to deal realistically with hashed or materialized sub-selects.
* Fix wrong/misleading comments, be more consistent about where to callTom Lane2003-01-12
| | | | ExecAssignResultTypeFromTL().
* Fix some minor grammatical errors.Tom Lane2003-01-12
|
* Update CHAR().Bruce Momjian2003-01-12
|
* Replace RelidGetNamespaceId() by get_rel_namespace().Peter Eisentraut2003-01-12
|
* Update CHAR() description.Bruce Momjian2003-01-12
|
* Update date only.Bruce Momjian2003-01-12
|
* Improve CHAR() description.Bruce Momjian2003-01-12
|
* First cut at implementing IN (and NOT IN) via hashtables. There isTom Lane2003-01-12
| | | | more to be done yet, but this is a good start.
* SGML build cleanups from Neil Conway.Bruce Momjian2003-01-12
|
* Fix capitalization.Bruce Momjian2003-01-11
|
* Back out flockfile change for NetBSD. Giles Lean reports they are notBruce Momjian2003-01-11
| | | | supported.
* Cause symlinks for shared-library versioning to run in the standardTom Lane2003-01-11
| | | | | | direction on HP-UX; our former approach has been obsolete since HPUX 9. Giles Lean
* Fix markup problem in link to other SGML file.Bruce Momjian2003-01-11
|
* Fix typo in an error messageTatsuo Ishii2003-01-11
|
* > > This patch improves the documentation for the shared_buffers GUC param.Bruce Momjian2003-01-11
| | | | | | | | > > I'd suggest that the runtime.sgml description explicitly say "values of > at least a few thousand are recommended for production installations". Neil Conway
* Rewrite for-loop, because this is not the Obfuscated C Code Contest.Bruce Momjian2003-01-11
| | | | Manfred Koizar
* A tiny patch to fix a typo in configure.in and another one inBruce Momjian2003-01-11
| | | | | | RELEASE_CHANGES. Manfred Koizar
* Add doc links from SET to SET_CONSTRAINTS, SET_SESSION_AUTH,Bruce Momjian2003-01-11
| | | | SET_TRANSACTION.
* Fix markup.Peter Eisentraut2003-01-11
|
* Create a new file executor/execGrouping.c to centralize utility routinesTom Lane2003-01-10
| | | | shared by nodeGroup, nodeAgg, and soon nodeSubplan.
* Add missing <limits.h> for INT64_IS_BUSTED case.Tom Lane2003-01-10
|
* Read-only transactions, as defined in SQL.Peter Eisentraut2003-01-10
|
* Do not shell-quote the name of the editor, so that the editor can be aPeter Eisentraut2003-01-10
| | | | command with arguments.
* Further tweaking of parsetree & plantree representation of SubLinks.Tom Lane2003-01-10
| | | | | | | Simplify SubLink by storing just a List of operator OIDs, instead of a list of incomplete OpExprs --- that was a bizarre and bulky choice, with no redeeming social value since we have to build new OpExprs anyway when forming the plan tree.
* Add optional drop behavior clause to REVOKE command, for SQL conformance.Peter Eisentraut2003-01-10
| | | | Currently, only RESTRICT is allowed.
* Clean ip.c.Peter Eisentraut2003-01-10
|
* Adjust parser so that 'x NOT IN (subselect)' is converted toTom Lane2003-01-09
| | | | | | | | | | | 'NOT (x IN (subselect))', that is 'NOT (x = ANY (subselect))', rather than 'x <> ALL (subselect)' as we formerly did. This opens the door to optimizing NOT IN the same way as IN, whereas there's no hope of optimizing the expression using <>. Also, convert 'x <> ALL (subselect)' to the NOT(IN) style, so that the optimization will be available when processing rules dumped by older Postgres versions. initdb forced due to small change in SubLink node representation.
* Add missing #include <getopt.h>.Tom Lane2003-01-09
|
* Move new typedef AclId into c.h, so as to avoid cluttering namespaceTom Lane2003-01-09
| | | | by having to include miscadmin.h into other header files.
* Fix IPv6 detection and IPv6 to 4 conversion to use only standardPeter Eisentraut2003-01-09
| | | | interfaces.
* Call timestamp_in with proper arguments, per gripe from Mark Halliwell.Tom Lane2003-01-09
|
* Fix indenting of log_min_error_statement.Bruce Momjian2003-01-09
|
* Remove bit.c/h routines. Not used anymore.Bruce Momjian2003-01-09
|
* Repair inconsistent rounding behavior for timestamp, time, interval,Tom Lane2003-01-09
| | | | | | per gripe from Csaba Nagy. There is still potential for platform-specific behavior for values that are exactly halfway between integers, but at least we now get the expected answer for all other cases.
* add to threads discussion.Bruce Momjian2003-01-09
|
* Add missing pg_proc entry for interval_scale(). The lack of this entryTom Lane2003-01-09
| | | | | | causes interval rounding not to work as expected in 7.3, for example SELECT '18:17:15.6'::interval(0) does not round the value. I did not force initdb, but one is needed to install the added row.
* Remove 'const' from secure_write, to prevent compiler warning.Bruce Momjian2003-01-08
|
* Guard against stopping when numberTuples=0 and counter wraps around.Tom Lane2003-01-08
|
* The second was that renegotiation was just plain broken. I can'tBruce Momjian2003-01-08
| | | | | | | | | | | believe I didn't notice this before -- once 64k was sent to/from the server the client would crash. Basicly, in 7.3 the server SSL code set the initial state to "about to renegotiate" without actually starting the renegotiation. In addition, the server and client didn't properly handle the SSL_ERROR_WANT_(READ|WRITE) error. This is fixed in the second patch. Nathan Mueller
* I was playing around with 7.3.1 and found some more SSL problems. TheBruce Momjian2003-01-08
| | | | | | | | | | | | | | first, that I missed when checking over 7.3.1, was that the client method was switched to SSLv23 along with the server. The SSLv23 client method does SSLv2 by default, but can also understand SSLv3. In our situation the SSLv2 backwords compatibility is really only needed on the server. This is the first patch. The last thing is that I found a way for the server to understand SSLv2 HELLO messages (sent by pre-7.3 clients) but then get them to talk SSLv3. This is the last one. Nathan Mueller
* Fix dumping of DEFERRABLE/INITIALLY DEFERRED:Bruce Momjian2003-01-08
| | | | | | | | | | | | | | | > The big problem is that while pg_dump's dump_trigger() looks at > tginitdeferred and dumps accordingly, pg_get_constraintdef doesn't look > at tginitdeferred, and therefore doesn't record the requirement as part > of ALTER TABLE ADD CONSTRAINT. pg_get_constraintdef should probably be looking at condeferrable and condeferred in the pg_constraint row it's looking at. Maybe something like the attached. (Added, output only non-default values.) Stephan Szabo
* Updated deferred trigger patch.Bruce Momjian2003-01-08
| | | | Neil Conway
* This trivial patch implements disabled, deferred triggers, per myBruce Momjian2003-01-08
| | | | | | | | | | | | | proposal on -hackers a couple days ago. The 'tgenabled' status of the trigger is consulted when the trigger is added to the deferred queue (i.e. when the event occurs that fires the trigger), not when the deferred event is executed. No regression tests, as another bug prevents them (the pg_trigger row for a trigger is only loaded once per session, so any changes to it are not noticed unless the client disconnects and reconnects). Neil Conway
* Enhanced error/help message for pg_controldata.Bruce Momjian2003-01-08
| | | | Serguei Mokhov
* Reconsider old decision to try to constant-fold default and constraintTom Lane2003-01-08
| | | | | expressions before they are stored. This seems like not such a hot idea, particularly now that the constant-folder will try to inline SQL functions.
* Repair bug noticed by Deepak Bhole: a shell type should have a dependencyTom Lane2003-01-08
| | | | on its namespace, so that it will go away if the schema is dropped.
* Fix pgpass to work with PQconnectDB().Bruce Momjian2003-01-08
| | | | | | Backpatch to 7.3.X. Report from ljb.