Commits · 9e66243c357b4f742cdf7e752004c00f01c5457e · Abuhujair Javed / Postgres FD Implementation

13 Jan, 2003 3 commits

Fixes to pgcvslog for last narrive entry. · 9e66243c
Bruce Momjian authored Jan 13, 2003

9e66243c

Cause planner to account for evaluation costs in targetlists and · 8ac6d952

Tom Lane authored Jan 13, 2003

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.

8ac6d952

Recent changes in sublink representation require exprType() to accept · d1686b42
Tom Lane authored Jan 13, 2003
```
SubPlan nodes, else explaining queries containing sublinks may fail.
```
d1686b42

12 Jan, 2003 10 commits
- Revise cost_qual_eval() to compute both startup (one-time) and per-tuple · d4ce5a4f
  Tom Lane authored Jan 12, 2003
```
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.
```
  d4ce5a4f
- Fix wrong/misleading comments, be more consistent about where to call · d51260aa
  Tom Lane authored Jan 12, 2003
```
ExecAssignResultTypeFromTL().
```
  d51260aa
- Fix some minor grammatical errors. · b05204ac
  Tom Lane authored Jan 12, 2003
  
  b05204ac
- Update CHAR(). · 9392c405
  Bruce Momjian authored Jan 12, 2003
  
  9392c405
- Replace RelidGetNamespaceId() by get_rel_namespace(). · 13437d1e
  Peter Eisentraut authored Jan 12, 2003
  
  13437d1e
- Update CHAR() description. · 6f485584
  Bruce Momjian authored Jan 12, 2003
  
  6f485584
- Update date only. · d340e006
  Bruce Momjian authored Jan 12, 2003
  
  d340e006
- Improve CHAR() description. · 4976816b
  Bruce Momjian authored Jan 12, 2003
  
  4976816b
- First cut at implementing IN (and NOT IN) via hashtables. There is · 19b88633
  Tom Lane authored Jan 12, 2003
```
more to be done yet, but this is a good start.
```
  19b88633
- SGML build cleanups from Neil Conway. · 3e54e26b
  Bruce Momjian authored Jan 12, 2003
  
  3e54e26b
11 Jan, 2003 10 commits
- Fix capitalization. · 161c2a7b
  Bruce Momjian authored Jan 11, 2003
  
  161c2a7b
- Back out flockfile change for NetBSD. Giles Lean reports they are not · bb665255
  Bruce Momjian authored Jan 11, 2003
```
supported.
```
  bb665255
- Cause symlinks for shared-library versioning to run in the standard · 43057c7a
  Tom Lane authored Jan 11, 2003
```
direction on HP-UX; our former approach has been obsolete since HPUX 9.

Giles Lean
```
  43057c7a
- Fix markup problem in link to other SGML file. · 266eb6ad
  Bruce Momjian authored Jan 11, 2003
  
  266eb6ad
- Fix typo in an error message · 38535f8e
  Tatsuo Ishii authored Jan 11, 2003
  
  38535f8e
- > > This patch improves the documentation for the shared_buffers GUC param. · 3cd7edfe
  Bruce Momjian authored Jan 11, 2003
```
>
> I'd suggest that the runtime.sgml description explicitly say "values of
> at least a few thousand are recommended for production installations".

Neil Conway
```
  3cd7edfe
- Rewrite for-loop, because this is not the Obfuscated C Code Contest. · ef581f05
  Bruce Momjian authored Jan 11, 2003
```
Manfred Koizar
```
  ef581f05
- A tiny patch to fix a typo in configure.in and another one in · bcf7a35f
  Bruce Momjian authored Jan 11, 2003
```
RELEASE_CHANGES.

Manfred Koizar
```
  bcf7a35f
- Add doc links from SET to SET_CONSTRAINTS, SET_SESSION_AUTH, · ab74a932
  Bruce Momjian authored Jan 11, 2003
```
SET_TRANSACTION.
```
  ab74a932
- Fix markup. · 2650fba6
  Peter Eisentraut authored Jan 11, 2003
  
  2650fba6
10 Jan, 2003 7 commits
- Create a new file executor/execGrouping.c to centralize utility routines · 1afac129
  Tom Lane authored Jan 10, 2003
```
shared by nodeGroup, nodeAgg, and soon nodeSubplan.
```
  1afac129
- Add missing <limits.h> for INT64_IS_BUSTED case. · c8370260
  Tom Lane authored Jan 10, 2003
  
  c8370260
- Read-only transactions, as defined in SQL. · b65cd562
  Peter Eisentraut authored Jan 10, 2003
  
  b65cd562
- Do not shell-quote the name of the editor, so that the editor can be a · b7ca9bdf
  Peter Eisentraut authored Jan 10, 2003
```
command with arguments.
```
  b7ca9bdf
- Further tweaking of parsetree & plantree representation of SubLinks. · e69785de
  Tom Lane authored Jan 10, 2003
```
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.
```
  e69785de
- Add optional drop behavior clause to REVOKE command, for SQL conformance. · 36ea2679
  Peter Eisentraut authored Jan 10, 2003
```
Currently, only RESTRICT is allowed.
```
  36ea2679
- Clean ip.c. · 611278cc
  Peter Eisentraut authored Jan 10, 2003
  
  611278cc
09 Jan, 2003 10 commits
- Adjust parser so that 'x NOT IN (subselect)' is converted to · 6bc61fc0
  Tom Lane authored Jan 09, 2003
```
'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.
```
  6bc61fc0
- Add missing #include <getopt.h>. · 59779c81
  Tom Lane authored Jan 09, 2003
  
  59779c81
- Move new typedef AclId into c.h, so as to avoid cluttering namespace · 83b06823
  Tom Lane authored Jan 09, 2003
```
by having to include miscadmin.h into other header files.
```
  83b06823
- Fix IPv6 detection and IPv6 to 4 conversion to use only standard · 9df2c440
  Peter Eisentraut authored Jan 09, 2003
```
interfaces.
```
  9df2c440
- Call timestamp_in with proper arguments, per gripe from Mark Halliwell. · 2e98da52
  Tom Lane authored Jan 09, 2003
  
  2e98da52
- Fix indenting of log_min_error_statement. · 8e20b91e
  Bruce Momjian authored Jan 09, 2003
  
  8e20b91e
- Remove bit.c/h routines. Not used anymore. · 0481f3f4
  Bruce Momjian authored Jan 09, 2003
  
  0481f3f4
- Repair inconsistent rounding behavior for timestamp, time, interval, · fb715e05
  Tom Lane authored Jan 09, 2003
```
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.
```
  fb715e05
- add to threads discussion. · 2cd00f0b
  Bruce Momjian authored Jan 09, 2003
  
  2cd00f0b
- Add missing pg_proc entry for interval_scale(). The lack of this entry · 1c25c52c
  Tom Lane authored Jan 09, 2003
```
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.
```
  1c25c52c