- 17 Feb, 2003 6 commits
-
-
Bruce Momjian authored
< o Allow CLUSTER to cluster all tables (Alvaro Herrera) > o -Allow CLUSTER to cluster all tables (Alvaro Herrera) 243c243 < * Allow pg_dump to dump a specific schema (Neil Conway) > * -Allow pg_dump to dump a specific schema (Neil Conway) 398c398 < * Make IN/NOT IN have similar performance to EXISTS/NOT EXISTS (Tom) > * -Make IN/NOT IN have similar performance to EXISTS/NOT EXISTS (Tom)
-
Bruce Momjian authored
-
Bruce Momjian authored
> o -Add ALTER TABLE tab SET WITHOUT OIDS (Rod) > o -Allow CLUSTER to cluster all tables (Alvaro Herrera) > * -Allow pg_dump to dump a specific schema (Neil Conway) > * -Make IN/NOT IN have similar performance to EXISTS/NOT EXISTS (Tom) > * Rod is Rod Taylor <pg@rbt.ca)>
-
Bruce Momjian authored
< * -Make a transaction-safe TRUNCATE > * -Make a transaction-safe TRUNCATE (Rod)
-
Bruce Momjian authored
> * -Make a transaction-safe TRUNCATE
-
Michael Meskes authored
-
- 16 Feb, 2003 3 commits
-
-
Tom Lane authored
in the case where the node immediately above the scan is a Hash, Sort, or Material node. In these cases it's better to do the projection so that we don't store unneeded columns in the hash/sort/materialize table. Per discussion a few days ago with Anagh Lal.
-
Tom Lane authored
that turn into CASE expressions. They evaluate their arguments at most once. Patch by Kris Jurka, review and (very light) editorializing by me.
-
Bruce Momjian authored
< * Disallow DROP COLUMN on a column that is part of a multi-column index > * Require DROP COLUMN CASCADE for a column that is part of a multi-column index
-
- 15 Feb, 2003 3 commits
-
-
Tom Lane authored
a bad choice between sorted and hashed aggregation.
-
Tom Lane authored
the outer query. (The implementation is a bit klugy, but it would take nontrivial restructuring to make it nicer, which this is probably not worth.) This avoids unnecessary sort steps in examples like SELECT foo,count(*) FROM (SELECT ... ORDER BY foo,bar) sub GROUP BY foo which means there is now a reasonable technique for controlling the order of inputs to custom aggregates, even in the grouping case.
-
Bruce Momjian authored
> * Disallow DROP COLUMN on a column that is part of a multi-column index
-
- 14 Feb, 2003 18 commits
-
-
Bruce Momjian authored
ps for multiple postmasters, for Kevin Brown.
-
Tom Lane authored
same type in a rule. Per bug report from Pavel Hanak.
-
Bruce Momjian authored
-
Bruce Momjian authored
> * Allow incremental backups
-
Michael Meskes authored
-
Bruce Momjian authored
> * Add schema option to createlang
-
Bruce Momjian authored
Change was actually made in a previous commit.
-
Bruce Momjian authored
-
Bruce Momjian authored
-
Bruce Momjian authored
-
Bruce Momjian authored
-
Michael Meskes authored
- More work on Informix compatibility.
-
Bruce Momjian authored
> * Cache last known per-tuple offsets to speed long tuple access
-
Bruce Momjian authored
-
Bruce Momjian authored
-
Bruce Momjian authored
-
Tom Lane authored
-
Tom Lane authored
SIGPIPE disabled, and does not need to waste two syscalls per I/O on it.
-
- 13 Feb, 2003 10 commits
-
-
Tom Lane authored
-
Tom Lane authored
-
Tom Lane authored
an ALTER TABLE ADD COLUMN command. Per bug #896.
-
Tom Lane authored
the table(s) modified by the original query would get checked for the type of write permission needed by a rule query.
-
Tom Lane authored
of the containing query (which really can only happen in a rule context). Per example from Brandon Craig Rhodes. Also, make the error message more specific for the similar case with sub-select in FROM. The revised coding should be easier to adapt to SQL99's LATERAL(), when we get around to supporting that.
-
Michael Meskes authored
-
Tom Lane authored
from Greg Stark. Also, twiddle the FuncCall case to not scribble on the input structure, which was the proximate cause of the problem. Someday we ought to fix things so that transformExpr() isn't called on already-transformed trees ...
-
Tom Lane authored
-
Tom Lane authored
-
Michael Meskes authored
- Started with an Informix compatibility option.
-