| Commit message (Collapse) | Author | Age |
|
|
|
|
| |
is not adequately tested yet, but let's get it into beta1 so it can be
tested. Magnus Hagander and Tom Lane.
|
|
|
|
|
|
| |
triggers exist but are all disabled. Problem noted by Gavin Sherry in
original discussion of enable/disable trigger patch, but was never
addressed.
|
| |
|
|
|
|
| |
> o Add sleep() to PL/PgSQL
|
| |
|
| |
|
| |
|
| |
|
|
|
|
| |
Jim C. Nasby
|
|
|
|
|
| |
< o Do VACUUM FULL if table is nearly empty?
> o Suggest VACUUM FULL if a table is nearly empty
|
|
|
|
|
|
|
| |
>
> Currently, if a variable is commented out, it keeps the
> previous uncommented value until a server restarted.
>
|
|
|
|
|
| |
- Remove stary character from string quoting.
- Fixed check to report missing varchar pointer implementation.
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
| |
< * Allow triggers to be disabled [trigger]
> * -Allow triggers to be disabled [trigger]
> * Allow triggers to be disabled in only the current session.
< Currently the only way to disable triggers is to modify the system
< tables.
> This is currently possible by starting a multi-statement transaction,
> modifying the system tables, performing the desired SQL, restoring the
> system tables, and committing the transaction. ALTER TABLE ...
> TRIGGER requires a table lock so it is not idea for this usage.
|
| |
|
|
|
|
|
|
| |
use these instead of its previous hack of changing pg_class.reltriggers.
Documentation is lacking, will add that later.
Patch by Satoshi Nagayasu, review and some extra work by Tom Lane.
|
| |
|
| |
|
| |
|
|
|
|
|
|
|
|
| |
Windows. The test itself is bypassed in configure as discussed, and
libpq has been updated appropriately to allow it to build in thread-safe
mode.
Dave Page
|
| |
|
|
|
|
|
| |
functional difference really, but make use of stuff added to the planner
since this code was touched last.
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
|
|
|
| |
Per Alvaro.
|
| |
|
|
|
|
|
|
|
|
|
| |
after the fact. Fix bug with incorrect test for whether we are at end
of logfile segment. Arrange for writes triggered by XLogInsert's
is-cache-more-than-half-full test to synchronize with the cache boundaries,
so that in long transactions we tend to write alternating halves of the
cache rather than randomly chosen portions of it; this saves one more
write syscall per cache load.
|
| |
|
| |
|
|
|
|
|
|
|
| |
erroring out as it has done for the last couple weeks. Document that this
form is now ignored because indexes can't usefully have different owners
from their parent tables. Fix pg_dump to not generate ALTER OWNER commands
for indexes.
|
|
|
|
|
|
| |
discussion of getting around this by relaxing the checks made for regular
users, but I'm disinclined to toy with the security model right now,
so just special-case it for superusers where needed.
|
|
|
|
| |
Also improve wording.
|
|
|
|
|
|
|
|
|
| |
not accepting queries).
errmsg("database is not accepting queries to avoid
wraparound data loss in database \"%s\"",
errhint("Stop the postmaster and use a standalone
backend to VACUUM database \"%s\".",
|
|
|
|
|
| |
chokes on IPv6 addresses, and comment out the IPv6 entry in the default
pg_hba.conf if so. Per Andrew Dunstan.
|
|
|
|
|
| |
indexes all be int, rather than variously int, uint16 and uint32;
add some casts where necessary to support large buffer arrays.
|
|
|
|
|
|
| |
in postgresql.conf.sample, mark custom_variable_classes as SIGHUP not
POSTMASTER to agree with the documentation (I can't see a reason it has
to be POSTMASTER so I think the docs are right).
|
|
|
|
| |
> * Fix problems with wrong runtime encoding conversion for NLS message files
|
|
|
|
| |
integer lists.
|
|
|
|
|
|
|
|
|
|
|
| |
to 'Size' (that is, size_t), and install overflow detection checks in it.
This allows us to remove the former arbitrary restrictions on NBuffers
etc. It won't make any difference in a 32-bit machine, but in a 64-bit
machine you could theoretically have terabytes of shared buffers.
(How efficiently we could manage 'em remains to be seen.) Similarly,
num_temp_buffers, work_mem, and maintenance_work_mem can be set above
2Gb on a 64-bit machine. Original patch from Koichi Suzuki, additional
work by moi.
|
|
|
|
|
| |
idea on consistency grounds, whether or not it really fixes bug #1831.
Michael Fuhr
|