- Aug 08, 2006
-
-
Tom Lane authored
loaded libraries: call functions _PG_init() and _PG_fini() if the library defines such symbols. Hence we no longer need to specify an initialization function in preload_libraries: we can assume that the library used the _PG_init() convention, instead. This removes one source of pilot error in use of preloaded libraries. Original patch by Ralf Engelschall, preload_libraries changes by me.
-
Bruce Momjian authored
-
Bruce Momjian authored
> > A package would be a schema with its own variables, > private functions, and initialization functions >
-
Bruce Momjian authored
< o Add Oracle-style packages > o Add Oracle-style packages (Pavel) > * Pavel is Pavel Stehule <pavel.stehule@hotmail.com>
-
Bruce Momjian authored
< o Automatically force archiving of partially-filled WAL files when > o -Automatically force archiving of partially-filled WAL files when < < Doing this will allow administrators to know more easily when < the archive contains all the files needed for point-in-time < recovery. < http://archives.postgresql.org/pgsql-patches/2005-04/msg00121.php < < o Add reporting of the current WAL file and offset, perhaps as > o -Add reporting of the current WAL file and offset, perhaps as < < The offset allows parts of a WAL file to be archived using < an external program. <
-
Bruce Momjian authored
< * Allow protocol-level BIND parameter values to be logged < < http://archives.postgresql.org/pgsql-hackers/2006-02/msg00165.php > * -Allow protocol-level BIND parameter values to be logged, if text mode
-
Bruce Momjian authored
o print user name for all o print portal name if defined for all o print query for all o reduce log_statement header to single keyword o print bind parameters as DETAIL if text mode
-
- Aug 06, 2006
-
-
Tom Lane authored
to happen automatically during pg_stop_backup(). Add some functions for interrogating the current xlog insertion point and for easily extracting WAL filenames from the hex WAL locations displayed by pg_stop_backup and friends. Simon Riggs with some editorialization by Tom Lane.
-
- Aug 04, 2006
-
-
Bruce Momjian authored
-
- Aug 03, 2006
-
-
Tom Lane authored
the DROP pass rather than the ADD_CONSTR pass. On examining the code I think this was just an oversight rather than intentional, and it seems to satisfy the principle of least surprise better than the alternative solution that was discussed. Add an example to the ref page showing how to do ALTER TYPE and update the default in one command. Per gripe from Markus Bertheau that that wasn't possible.
-
- Aug 02, 2006
-
-
Tom Lane authored
as grantees, not PUBLIC ... and you can't say GROUP either. Noted by Brian Hurt.
-
Bruce Momjian authored
< o Add COPY TO STDIN / STDOUT handling > o Add COPY TO STDIN handling
-
Bruce Momjian authored
> o In rules, allow VALUES() to contain a mixture of 'old' and 'new' > references
-
Bruce Momjian authored
o -Allow INSERT INTO tab (col1, ..) VALUES (val1, ..), (val2, ..)
-
- Aug 01, 2006
-
-
Alvaro Herrera authored
of the text where appropiate.
-
Bruce Momjian authored
if table creation failed (the table already exists). Martin Pitt
-
Bruce Momjian authored
< o %Allow pg_dump to use multiple -t and -n switches [pg_dump] < < http://archives.postgresql.org/pgsql-patches/2006-01/msg00190.php < > o -Allow pg_dump to use multiple -t and -n switches, exclusion > ability, and regular expression object matching
-
Bruce Momjian authored
and -N options to exclude objects. Also support regular expressions for option object names. Greg Sabino Mullane
-
Bruce Momjian authored
Joshua D. Drake Robert Treat
-
Bruce Momjian authored
> * Consider compressed annealing to search for query plans > > This might replace GEQO, http://sixdemonbag.org/Djinni.
-
- Jul 31, 2006
-
-
Tom Lane authored
(table or index) before trying to open its relcache entry. This fixes race conditions in which someone else commits a change to the relation's catalog entries while we are in process of doing relcache load. Problems of that ilk have been reported sporadically for years, but it was not really practical to fix until recently --- for instance, the recent addition of WAL-log support for in-place updates helped. Along the way, remove pg_am.amconcurrent: all AMs are now expected to support concurrent update.
-
Tom Lane authored
created in the bootstrap phase proper, rather than added after-the-fact by initdb. This is cleaner than before because it allows us to retire the undocumented ALTER TABLE ... CREATE TOAST TABLE command, but the real reason I'm doing it is so that toast tables of shared catalogs will now have predetermined OIDs. This will allow a reasonably clean solution to the problem of locking tables before we load their relcache entries, to appear in a forthcoming patch.
-
Alvaro Herrera authored
-
- Jul 30, 2006
-
-
Bruce Momjian authored
> * Consider detoasting keys before sorting
-
- Jul 29, 2006
-
-
Bruce Momjian authored
> * Add column to pg_stat_activity that shows the progress of long-running > commands like CREATE INDEX and VACUUM
-
Bruce Momjian authored
> * Add support for SQL-standard GENERATED/IDENTITY columns > > http://archives.postgresql.org/pgsql-hackers/2006-07/msg00543.php
-
- Jul 28, 2006
-
-
Bruce Momjian authored
> * Allow DISTINCT to work in multiple-argument aggregate calls < o Allow UPDATE to handle complex aggregates [update]?
-
Tom Lane authored
the float8 versions of the aggregates, which is all that the standard requires. Sergey's original patch also provided versions using numeric arithmetic, but given the size and slowness of the code, I doubt we ought to include those in core.
-
Tom Lane authored
-
Tom Lane authored
server-side character set.
-
Bruce Momjian authored
< * Tatsuo is Tatsuo Ishii <t-ishii@sra.co.jp> of Software Research Assoc. > * Tatsuo is Tatsuo Ishii <ishii@sraoss.co.jp> of SRA OSS, Inc. Japan
-
Bruce Momjian authored
-
Bruce Momjian authored
> > A subselect can also be used as the value source.
-
- Jul 27, 2006
-
-
Tom Lane authored
the opportunity to treat COUNT(*) as a zero-argument aggregate instead of the old hack that equated it to COUNT(1); this is materially cleaner (no more weird ANYOID cases) and ought to be at least a tiny bit faster. Original patch by Sergey Koposov; review, documentation, simple regression tests, pg_dump and psql support by moi.
-
Bruce Momjian authored
Albe Laurenz
-
Peter Eisentraut authored
-
- Jul 26, 2006
-
-
Bruce Momjian authored
< o Allow point-in-time recovery to archive partially filled < write-ahead logs? [pitr] > o Add command to archive partially filled write-ahead logs? [pitr] < of a disk failure. This could be triggered by a user command or < a timer. > of a disk failure. < recovery. A function call to do this would also be useful. > recovery. > o Add reporting of the current WAL file and offset, perhaps as > part of partial log file archiving > > The offset allows parts of a WAL file to be archived using > an external program. > < o Add reporting of the current WAL file and offset, perhaps as < part of partial log file archiving < < The offset allows parts of a WAL file to be archived using < an external program.
-
Peter Eisentraut authored
upcoming units feature.
-
Bruce Momjian authored
> * -Change LIMIT/OFFSET and FETCH/MOVE to use int8
-