| Age | Commit message (Collapse) | Author |
|---|
|
|
|
|
|
|
|
> * Teodor is Teodor Sigaev <teodor@sigaev.ru>
|
|
< * Claudio is Claudio Natoli <claudio.natoli@memetrics.com>
1166d1164
< * Hiroshi is Hiroshi Inoue <Inoue@tpf.co.jp>
|
|
DROP CONSTRAINT
This form drops constraints on a table. Currently, constraints on tables
are not required to have unique names, so there may be more than one
constraint matching the specified name. All matching constraints will be
dropped.
To my knowledge, it is no longer possible to create constraints with the
same name for the same relation. When you create a constraint and specify
the same name explictly, an error is raised. Implicit constraint creation
won't choose an existing name either and up to now you could not rename a
constraint. Renaming works with the patch I sent in a few hours ago but this
patch as well won't allow constraints with identical names on the same
relation.
The attached patch thus removes the note in the docs.
Joachim Wieland
|
|
|
|
Also, better mark section headings.
kdio@uenf.br
|
|
|
|
that are the same as column names used in the function.
|
|
< at initdb time or optionally later.
> at initdb time or optionally later. Consider O_SYNC when
> O_DIRECT exists.
|
|
|
|
|
|
|
|
|
|
> * Add GUC variable to run a command on database panic or
> smart/fast/immediate shutdown
|
|
|
|
|
|
file. Backpatch to 8.1.X.
Paul Lindner
|
|
non-ascii convert to & escapes
|
|
the latest release notes there is a latin1 character that shouldn't be
there so I made a patch to fix that. This patch also fixes some old
entries that uses o instead of ö (which is also wrong but not as
bad as including a latin1 character in the sgml file).
Dennis Bj?rklund
|
|
< Win32 API, and we have to make sure MinGW handles it.
> Win32 API, and we have to make sure MinGW handles it. Another
> option is to wait for the MinGW project to fix it, or use the
> code from the LibGW32C project as a guide.
|
|
> o Add long file support for binary pg_dump output
>
> While Win32 supports 64-bit files, the MinGW API does not,
> meaning we have to build an fseeko replacement on top of the
> Win32 API, and we have to make sure MinGW handles it.
|
|
> * Add SPI_gettypmod() to return the typemod for a TupleDesc
|
|
> o Consider logging activity either to the logs or a system view
|
|
--with-libedit-preferred prefer BSD Libedit over GNU Readline
|
|
Map them to a single day, so '30 hours' is 'AM'.
Have to_char(interval) and to_char(time) use "HH", "HH12" as 12-hour
intervals, rather than bypass and print the full interval hours. This
is neeeded because to_char(time) is mapped to interval in this function.
Intervals should use "HH24", and document suggestion.
Allow "D" format specifiers for interval/time.
|
|
< * Add function to return the thread safety status of libpq and ecpg
|
|
|
|
< * Change NUMERIC to enforce the maximum precision, and increase it
> * Change NUMERIC to enforce the maximum precision
|
|
< be cleared when a heap tuple is expired. Another idea is to maintain
< a bitmap of heap pages where all rows are visible to all backends,
< and allow index lookups to reference that bitmap to avoid heap
< lookups, perhaps the same bitmap we might add someday to determine
< which heap pages need vacuuming.
> be cleared when a heap tuple is expired.
>
> Another idea is to maintain a bitmap of heap pages where all rows
> are visible to all backends, and allow index lookups to reference
> that bitmap to avoid heap lookups, perhaps the same bitmap we might
> add someday to determine which heap pages need vacuuming. Frequently
> accessed bitmaps would have to be stored in shared memory. One 8k
> page of bitmaps could track 512MB of heap pages.
|
|
< the heap. One way to allow this is to set a bit to index tuples
> the heap. One way to allow this is to set a bit on index tuples
< be cleared when a heap tuple is expired.
<
> be cleared when a heap tuple is expired. Another idea is to maintain
> a bitmap of heap pages where all rows are visible to all backends,
> and allow index lookups to reference that bitmap to avoid heap
> lookups, perhaps the same bitmap we might add someday to determine
> which heap pages need vacuuming.
|
|
> [merge]
378a380
> [merge]
|
|
< * Add MERGE command that does UPDATE/DELETE, or on failure, INSERT (rules,
< triggers?)
> * Add SQL-standard MERGE command, typically used to merge two tables
>
> This is similar to UPDATE, then for unmatched rows, INSERT.
> Whether concurrent access allows modifications which could cause
> row loss is implementation independent.
>
> * Add REPLACE or UPSERT command that does UPDATE, or on failure, INSERT
|
|
|
|
< #A hyphen, "-", marks changes that will appear in the upcoming 8.1 release.#
> #A hyphen, "-", marks changes that will appear in the upcoming 8.2 release.#
|
|
< * Remove Win32 rename/unlink looping if unnecessary
|
|
|
|
and IFNULL.
Backpatch to 8.1.X.
|
|
> * Allow COMMENT ON to accept an expression rather than just a string
|
|
|
|
<
> o Add -f to pg_dumpall
|
|
> o -Allow NULLs in arrays
|
|
>
> * Add estimated_count(*) to return an estimate of COUNT(*)
>
> This would use the planner ANALYZE statistatics to return an estimated
> count.
|
|
|
|
|
|
|
|
|
|
|
|
|
