- 11 2月, 2005 6 次提交
-
-
由 Bruce Momjian 提交于
-
由 Bruce Momjian 提交于
SELECT CURRENT_TIMESTAMP; SELECT now(); SELECT TIMESTAMP 'now'; -- incorrect for use with DEFAULT
-
由 Bruce Momjian 提交于
more variables can be found in the libpq manual section. Mention .pgpass in the psql manual page section dealing with connection parameters and point to the libpq section for more details. Backpatch to 8.0.X.
-
由 Neil Conway 提交于
as valid input (it was previously treated as 0). This input was deprecated in 8.0 (and a warning was emitted). Regression tests updated.
-
由 Tom Lane 提交于
Per gripes from Mike Mascari and Bernd Heller.
-
由 Tom Lane 提交于
that return tuples (such as EXPLAIN). Per gripe from Michael Fuhr. Side effect: fix an old bug that unintentionally disabled backward scans for all SPI-created cursors.
-
- 10 2月, 2005 7 次提交
-
-
由 Michael Meskes 提交于
-
由 Michael Meskes 提交于
Yutaka <tanida@sra.co.jp>.
-
由 Neil Conway 提交于
suggestion from Rainer Brandt.
-
由 Neil Conway 提交于
FreeBSD. From Mark Kirkwood, editorializing by Neil Conway.
-
由 Neil Conway 提交于
Fetter and Ben Calvert.
-
-
由 Neil Conway 提交于
column with a default expression. In that situation, we need to rewrite the heap relation. To evaluate the new default expression, we use ExecEvalExpr(); however, this can allocate memory in the current memory context, and ATRewriteTable() does not switch out of the active portal's heap memory context. The end result is a rather large memory leak (on the order of gigabytes for a reasonably sized table). This patch changes ATRewriteTable() to switch to the per-tuple memory context before beginning the per-tuple loop. It also removes an explicit heap_freetuple() in the loop, since that is no longer needed. In an unrelated change, I noticed the code was scanning through the attributes of the new tuple descriptor for each tuple of the old table. I changed this to use precomputation, which should slightly speed up the loop. Thanks to steve@deefs.net for reporting the leak.
-
- 09 2月, 2005 1 次提交
-
-
由 Michael Meskes 提交于
-
- 08 2月, 2005 2 次提交
-
-
由 Bruce Momjian 提交于
< * Allow the PITR process to be debugged and data examined > * Allow the PITR process to be debugged and data examined
-
由 Bruce Momjian 提交于
the item: < o Automatic failover < < The proper solution to this will probably the use of a master/slave < replication solution like Sloney and a connection pooling tool like < pgpool. <
-
- 07 2月, 2005 3 次提交
-
-
由 Neil Conway 提交于
"incompatibilities" section of the release notes.
-
由 Tom Lane 提交于
-
由 Tom Lane 提交于
there are corner cases involving dropping toasted columns in which the previous coding would fail, too: the new version of the table might not have any TOAST table, but we'd still propagate possibly-wide values of dropped columns forward.
-
- 06 2月, 2005 2 次提交
- 04 2月, 2005 3 次提交
-
-
由 Neil Conway 提交于
from LockRelease() and LockReleaseAll() into it. From Heikki Linnakangas.
-
由 Tom Lane 提交于
database: aggregates should be dumped in the same pass as operators, not in the same pass as functions.
-
由 Tom Lane 提交于
This refactoring does not change any algorithms or data structures, just remove visibility of the ARC datastructures from other source files.
-
- 03 2月, 2005 7 次提交
-
-
由 Neil Conway 提交于
-
由 Tom Lane 提交于
two arguments. Per suggestions from A. Ogawa.
-
由 Tom Lane 提交于
form of CASE (eg, CASE 0 WHEN 1 THEN ...) can be constant-folded as it was in 7.4. Also, avoid constant-folding result expressions that are certainly unreachable --- the former coding was a bit cavalier about this and could generate unexpected results for all-constant CASE expressions. Add regression test cases. Per report from Vlad Marchenko.
-
由 Bruce Momjian 提交于
The 8.1 release will remove the <function>to_char()</> function for intervals.
-
由 Bruce Momjian 提交于
-
由 Bruce Momjian 提交于
< all temporary tables, removal of any NOTIFYs, etc. This could be used < for connection pooling. We could also change RESET ALL to have this < functionality. > all temporary tables, removal of any NOTIFYs, cursors, prepared > queries(?), currval()s, etc. This could be used for connection pooling. > We could also change RESET ALL to have this functionality.
-
由 Bruce Momjian 提交于
* Update inet/cidr data types with newest Bind patches
-
- 02 2月, 2005 7 次提交
-
-
由 Michael Meskes 提交于
-
由 Bruce Momjian 提交于
-
由 Neil Conway 提交于
tests. Contributed by Koju Iijima, review from Neil Conway, Gavin Sherry and Tom Lane. Also, fix error in description of WITH CHECK OPTION clause in the CREATE VIEW reference page: it should be "CASCADED", not "CASCADE".
-
由 Neil Conway 提交于
command counter more than necessary. Per report from Michael Fuhr.
-
由 Tom Lane 提交于
estimate to less than the number of values estimated for any one grouping Var, as suggested by Manfred. This is intuitively right, and what's more it puts the plan choices in the subselect regression test back the way they were before ...
-
由 Bruce Momjian 提交于
-
由 Tom Lane 提交于
initially NULL. For 8.0 we changed the main executor to have this behavior in an UPDATE of an array column, but plpgsql's equivalent case was overlooked. Per report from Sven Willenberger.
-
- 01 2月, 2005 2 次提交
-
-
由 Bruce Momjian 提交于
< * Change LIMIT/OFFSET to use int8 > * Change LIMIT/OFFSET and FETCH/MOVE to use int8
-
由 Bruce Momjian 提交于
> * Allow GRANT/REVOKE permissions to be inherited by objects based on > schema permissions
-