- 03 Sep, 2006 8 commits
-
-
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 21 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
-
Bruce Momjian authored
Euler Taveira de Oliveira
-
- 31 Aug, 2006 5 commits
-
-
Tom Lane authored
didn't create a dependency from the new conversion to its schema. Back-patch to all supported releases.
-
Peter Eisentraut authored
-
Bruce Momjian authored
-
Bruce Momjian authored
COPY SELECT work done by Zoltan Boszormenyi
-
Bruce Momjian authored
< Last updated: Tue Aug 29 12:21:52 EDT 2006 > Last updated: Wed Aug 30 20:34:28 EDT 2006 < o Allow COPY (SELECT ...) TO 'filename' < < COPY should also be able to output views using COPY (SELECT < * FROM view) TO 'filename' internally. < http://archives.postgresql.org/pgsql-patches/2005-09/msg00148.php > o -Allow COPY (SELECT ...) TO 'filename'
-
- 30 Aug, 2006 3 commits
-
-
Tom Lane authored
Bernd Helmle
-
Bruce Momjian authored
-
Tom Lane authored
and other special flags on Windows. May fix intermittent 'Permission denied' errors. Magnus Hagander
-
- 29 Aug, 2006 3 commits
-
-
Tom Lane authored
the pager before reporting the error.
-
Tom Lane authored
queries via a cursor, fetching a limited number of rows at a time and therefore not risking exhausting memory. A disadvantage of the scheme is that 'aligned' output mode will align each group of rows independently leading to odd-looking output, but all the other output formats work reasonably well. Chris Mair, with some additional hacking by moi.
-
Bruce Momjian authored
Fix printing of NULL bind parameters, use "NULL".
-