- Jun 12, 2003
-
-
Bruce Momjian authored
Nigel J. Andrews
-
- Jun 11, 2003
-
-
Bruce Momjian authored
* -Add config variable to prevent auto-adding missing FROM-clause tables
-
Bruce Momjian authored
Christopher Kings-Lynne
-
Tom Lane authored
not all SQL identifiers taken from command line arguments. We decided years ago that that was a bad idea: identifiers taken from the command line should be treated as literally correct. Remove the inconsistent code that has crept in recently. Also fix pg_dump so that the combination of --schema and --table does what you'd expect, namely dump exactly one table from exactly one schema. Per gripe from Deepak Bhole of Red Hat.
-
Tom Lane authored
-
Tom Lane authored
-
Tom Lane authored
-
Bruce Momjian authored
-
- Jun 07, 2003
-
-
Bruce Momjian authored
-
Bruce Momjian authored
-
Bruce Momjian authored
-
- Jun 06, 2003
-
-
Bruce Momjian authored
> o Have COPY return number of rows loaded/unloaded
-
Bruce Momjian authored
-
Bruce Momjian authored
> * Add checks for fclose() failure
-
Bruce Momjian authored
-
Tom Lane authored
extensions to support our historical behavior. An aggregate belongs to the closest query level of any of the variables in its argument, or the current query level if there are no variables (e.g., COUNT(*)). The implementation involves adding an agglevelsup field to Aggref, and treating outer aggregates like outer variables at planning time.
-
Peter Eisentraut authored
-
- Jun 05, 2003
-
-
Peter Eisentraut authored
-
- Jun 02, 2003
-
-
Bruce Momjian authored
> * Allow logging of only data definition(DDL), or DDL and modification statements
-
Bruce Momjian authored
> * Allow a single index to index multiple tables (for inheritance and subtables) 408a410 > * Improve the planner to use CHECK constraints to prune the plan (for subtables) 418a421 > * Allow partitioning of table into multiple subtables 419a423 > T
-
Bruce Momjian authored
-
Bruce Momjian authored
-
Bruce Momjian authored
> * Allow SET CONSTRAINTS to be qualified by schema/table
-
Bruce Momjian authored
-
Bruce Momjian authored
-
- Jun 01, 2003
-
-
Bruce Momjian authored
> * Add config variable to prevent auto-adding missing FROM-clause tables
-
- May 31, 2003
-
-
Bruce Momjian authored
> * Prevent whole-row references from leaking memory, e.g. SELECT COUNT(tab.*)
-
Bruce Momjian authored
> * Consider using MVCC to cache count(*) queries with no WHERE clause
-
Tom Lane authored
-
- May 29, 2003
-
-
Tom Lane authored
for grammar-detected problems. Revert Makefile hack that kept it looking like the pre-bison-1.875 output.
-
- May 28, 2003
-
-
Tom Lane authored
of an index can now be a computed expression instead of a simple variable. Restrictions on expressions are the same as for predicates (only immutable functions, no sub-selects). This fixes problems recently introduced with inlining SQL functions, because the inlining transformation is applied to both expression trees so the planner can still match them up. Along the way, improve efficiency of handling index predicates (both predicates and index expressions are now cached by the relcache) and fix 7.3 oversight that didn't record dependencies of predicate expressions.
-
Bruce Momjian authored
-
Bruce Momjian authored
-
- May 27, 2003
-
-
Bruce Momjian authored
docs that CLIENT/LOG_MIN_MESSAGES now controls debug_* output location. Doc changes included.
-
- May 26, 2003
-
-
Bruce Momjian authored
-
Tom Lane authored
-
Bruce Momjian authored
< * Add now("transaction|statement|clock") functionality > * Add transaction_timestamp(), statement_timestamp(), clock_timestamp() functionality
-
Bruce Momjian authored
modify passwords, per user confusion report. Also clean up wording that command line utils need database access.
-
Bruce Momjian authored
> * Allow UPDATE to use SET col = DEFAULT
-