- 04 Sep, 2006 5 commits
-
-
Peter Eisentraut authored
Author: Victor Wagner <vitus@cryptocom.ru>
-
Peter Eisentraut authored
-
Bruce Momjian authored
-
Tom Lane authored
unportable elog(NOTICE) report, fix install/uninstall sequence. Itagaki Takahiro
-
Tom Lane authored
cascaded first to days and only what is leftover into seconds. This seems to satisfy the principle of least surprise given the general conversion to three-part interval values --- it was an oversight that these cases weren't dealt with in 8.1. Michael Glaesemann
-
- 03 Sep, 2006 15 commits
-
-
Tom Lane authored
of the syntax as this fundamentally dead-end approach can, in particular combinations of single and multi column assignments. Improve rather inadequate documentation and provide some regression tests.
-
Tom Lane authored
-
Tom Lane authored
-
Tom Lane authored
-
Tom Lane authored
is only invoked on completed WAL segments, period --- there's no 'by default' about it.
-
Tom Lane authored
PGPROC array into snapshots, and use this information to avoid visits to pg_subtrans in HeapTupleSatisfiesSnapshot. This appears to solve the pg_subtrans-related context swap storm problem that's been reported by several people for 8.1. While at it, modify GetSnapshotData to not take an exclusive lock on ProcArrayLock, as closer analysis shows that shared lock is always sufficient. Itagaki Takahiro and Tom Lane
-
Bruce Momjian authored
< * Change LIMIT/OFFSET and FETCH/MOVE to use int8
-
Michael Meskes authored
Added another regression test and fixed tcp test.
-
Bruce Momjian authored
multiplication/division queries like select '41 mon 10:00:00'::interval / 10 as "pos". Report from Michael Glaesemann
-
Bruce Momjian authored
< * -Change LIMIT/OFFSET and FETCH/MOVE to use int8 > * Change LIMIT/OFFSET and FETCH/MOVE to use int8
-
Bruce Momjian authored
fetch/move in scan.l.
-
Bruce Momjian authored
-
Bruce Momjian authored
Report from Josh Tolley.
-
Bruce Momjian authored
-
Bruce Momjian authored
-
- 02 Sep, 2006 20 commits
-
-
Bruce Momjian authored
> * Simplify ability to create partitioned tables > > This would allow creation of partitioned tables without requiring > creation of rules for INSERT/UPDATE/DELETE, and constraints for > rapid partition selection. Options could include range and hash > partition selection. > > * Allow auto-selection of partitioned tables for min/max() operations
-
Bruce Momjian authored
--- was part of autovacuum default 'on' patch that was reverted, but we want this part. Peter Eisentraut
-
Bruce Momjian authored
-
Bruce Momjian authored
possible autovacuum use.
-
-
Bruce Momjian authored
/contrib/tsearch2. Teodor Sigaev
-
Bruce Momjian authored
-
Joe Conway authored
Kai Londenberg, modified by Joe Conway
-
Bruce Momjian authored
-
Bruce Momjian authored
multiple columns Susanne Ebrecht
-
Bruce Momjian authored
< Last updated: Sat Sep 2 08:31:04 EDT 2006 > Last updated: Sat Sep 2 16:31:46 EDT 2006 < o Allow UPDATE tab SET ROW (col, ...) = (...) for updating multiple < columns > o -Allow UPDATE tab SET ROW (col, ...) = (val, ...) for updating > multiple columns > o Allow UPDATE tab SET ROW (col, ...) = (SELECT...) < A subselect can also be used as the value source.
-
Bruce Momjian authored
Dhanaraj M
-
Bruce Momjian authored
Suppress some NOTICE messages from REINDEX command. Euler Taveira de Oliveira
-
Bruce Momjian authored
overhead for every connection, per Tom.
-
Tom Lane authored
RETURNING play nice with views/rules. To wit, have the rule rewriter rewrite any RETURNING clause found in a rule to produce what the rule's triggering query asked for in its RETURNING clause, in particular drop the RETURNING clause if no RETURNING in the triggering query. This leaves the responsibility for knowing how to produce the view's output columns on the rule author, without requiring any fundamental changes in rule semantics such as adding new rule event types would do. The initial implementation constrains things to ensure that there is exactly one, unconditionally invoked RETURNING clause among the rules for an event --- later we might be able to relax that, but for a post feature freeze fix it seems better to minimize how much invention we do. Per gripe from Jaime Casanova.
-
Bruce Momjian authored
index page contents. Satoshi Nagayasu
-
Bruce Momjian authored
"server_version" but uses the handy PG_VERSION_NUM which allows apps to do things like if ($version >= 80200) without having to parse apart the value of server_version themselves. Greg Sabino Mullane greg@turnstep.com
-
Bruce Momjian authored
< o -Allow PL/python to composite types and result sets > o -Allow PL/python to return composite types and result sets
-
Bruce Momjian authored
Sven Suursoho
-
Bruce Momjian authored
o -Allow PL/python to composite types and result sets
-