Tom Lane [Sat, 8 Oct 2005 20:27:25 +0000 (20:27 +0000)]
Fix a thinko in description of krb_server_hostname.
Tom Lane [Sat, 8 Oct 2005 20:08:19 +0000 (20:08 +0000)]
Fix up grammar in variable description string.
Tom Lane [Sat, 8 Oct 2005 19:32:58 +0000 (19:32 +0000)]
Fix Kerberos authentication in wake of virtual-hosts changes --- need
to call krb5_sname_to_principal() always. Also, use krb_srvname rather
than the hardwired string 'postgres' as the appl_version string in the
krb5_sendauth/recvauth calls, to avoid breaking compatibility with PG
8.0. Magnus Hagander
Bruce Momjian [Sat, 8 Oct 2005 16:10:38 +0000 (16:10 +0000)]
Remove unnecessary ABORT commands in dblink regression tests.
Bruce Momjian [Sat, 8 Oct 2005 12:18:48 +0000 (12:18 +0000)]
Cosmetic improvements to dblink.
Bruce Momjian [Sat, 8 Oct 2005 12:12:29 +0000 (12:12 +0000)]
Cosmetic changes to dblink.
Bruce Momjian [Sat, 8 Oct 2005 11:33:45 +0000 (11:33 +0000)]
Cosmetic changes to dblink.
Bruce Momjian [Sat, 8 Oct 2005 02:39:27 +0000 (02:39 +0000)]
Add spacing around operators.
Tom Lane [Fri, 7 Oct 2005 21:42:38 +0000 (21:42 +0000)]
Fix LWLockAssign() so that it can safely be executed after postmaster
initialization. Add spinlocking, fix EXEC_BACKEND unsafeness.
Bruce Momjian [Fri, 7 Oct 2005 20:26:41 +0000 (20:26 +0000)]
Minor parentheses cleanup.
Bruce Momjian [Fri, 7 Oct 2005 20:13:16 +0000 (20:13 +0000)]
Add spaces around operator.
Tom Lane [Fri, 7 Oct 2005 20:11:03 +0000 (20:11 +0000)]
Allocate a few extra LWLocks for possible use by add-on modules.
Per request from Marc Munro.
Tom Lane [Fri, 7 Oct 2005 19:59:34 +0000 (19:59 +0000)]
Marginal performance improvement in aclmask(): don't bother with
testing ownership if the caller isn't interested in any GOPTION bits
(which is the common case). It did not matter in 8.0 where the ownership
test was just a trivial equality test, but it matters now.
Tom Lane [Fri, 7 Oct 2005 16:34:48 +0000 (16:34 +0000)]
Recognize ERROR_SHARING_VIOLATION (translate to EACCES), increase log
level for unrecognized win32 error codes to LOG, and make messages
conform to style guide. Per old suggestion from Qingqing Zhou, which
seems to have gotten lost in the shuffle.
Tom Lane [Fri, 7 Oct 2005 15:34:17 +0000 (15:34 +0000)]
(Apologies for fat-fingering cvs commit command...) Should have read:
Remove unportable use of tfind/tsearch in favor of bsearch. Fix up
random number generator to use random() not rand() and to actually honor
its min/max arguments properly. That wasn't so important before, but
with exposure of capability to ask for general ranges, it will be.
Tom Lane [Fri, 7 Oct 2005 15:31:49 +0000 (15:31 +0000)]
gni
Alvaro Herrera [Fri, 7 Oct 2005 14:55:36 +0000 (14:55 +0000)]
Remove an unused typedef.
Bruce Momjian [Fri, 7 Oct 2005 14:04:19 +0000 (14:04 +0000)]
Update:
< * Consider compressing indexes by storing key prefix values shared by
> * Consider compressing indexes by storing key values duplicated in
735a736,737
>
> This is difficult because it requires datatype-specific knowledge.
Bruce Momjian [Fri, 7 Oct 2005 02:43:59 +0000 (02:43 +0000)]
Add:
<
> * Consider compressing indexes by storing key prefix values shared by
> several rows as a single index entry
Tom Lane [Thu, 6 Oct 2005 23:05:22 +0000 (23:05 +0000)]
Minor dbf2pg fixes from Martin Pitt: check for failure when issuing
CREATE TABLE command, and translate dBase's 'M' field type to 'text'.
Tom Lane [Thu, 6 Oct 2005 22:43:16 +0000 (22:43 +0000)]
Marginal speedup in RelationIsVisible and TypeIsVisible: avoid a redundant
cache lookup in the success case. This won't help much for cases where
the given relation is far down the search path, but it does not hurt in
any cases either; and it requires only a little new code. Per gripe from
Jim Nasby about slowness of \d with many tables.
Neil Conway [Thu, 6 Oct 2005 21:30:39 +0000 (21:30 +0000)]
Minor API cleanup for async notifications: we can only register the
current backend in pg_listener, so there is little point in making
the PID to register part of async.c's public API. Other minor tweaks.
Neil Conway [Thu, 6 Oct 2005 20:51:20 +0000 (20:51 +0000)]
Minor tweaks for PL/PgSQL documentation.
Tom Lane [Thu, 6 Oct 2005 19:51:16 +0000 (19:51 +0000)]
When a function not returning RECORD has a single OUT parameter, use
the parameter's name (if any) as the default column name for SELECT FROM
the function, rather than the function name as previously. I still think
this is a bad idea, but I lost the argument. Force decompilation of
function RTEs to specify full aliases always, to reduce the odds of this
decision breaking dumped views.
Tom Lane [Thu, 6 Oct 2005 16:01:55 +0000 (16:01 +0000)]
Fix oversight in indexscan plan creation. I recently added code to use
predicate_implied_by() to detect redundant filter conditions, but forgot
that predicate_implied_by() assumes its first argument contains only
immutable functions. Add a check to guarantee that. Also, test to see
if filter conditions can be discarded because they are redundant with
the predicate of a partial index.
Peter Eisentraut [Thu, 6 Oct 2005 12:04:58 +0000 (12:04 +0000)]
pg_config should print an error message to stderr and exit if an
information item is not available.
Tom Lane [Thu, 6 Oct 2005 02:29:23 +0000 (02:29 +0000)]
Revise pgstats stuff to fix the problems with not counting accesses
generated by bitmap index scans. Along the way, simplify and speed up
the code for counting sequential and index scans; it was both confusing
and inefficient to be taking care of that in the per-tuple loops, IMHO.
initdb forced because of internal changes in pg_stat view definitions.
Neil Conway [Wed, 5 Oct 2005 23:46:06 +0000 (23:46 +0000)]
Code cleanup for log_disconnections(). Patch from Qingqing Zhou,
fixes by Neil Conway.
Bruce Momjian [Wed, 5 Oct 2005 19:52:22 +0000 (19:52 +0000)]
Improve wording of entry.
Tom Lane [Wed, 5 Oct 2005 17:19:19 +0000 (17:19 +0000)]
Make set_function_size_estimates() marginally smarter: per original
comment, it can at least test whether the expression returns set.
Tom Lane [Wed, 5 Oct 2005 17:11:45 +0000 (17:11 +0000)]
Add -Winline to the default CFLAGS for gcc, and remove
-Wold-style-definition, per recent discussion.
Michael Meskes [Wed, 5 Oct 2005 14:58:36 +0000 (14:58 +0000)]
Also synced the ecpg lexer with the backend lexer.
Bruce Momjian [Wed, 5 Oct 2005 12:16:28 +0000 (12:16 +0000)]
Fix pgxs for spaces in file names on Win32
Dave Page
Bruce Momjian [Wed, 5 Oct 2005 11:50:36 +0000 (11:50 +0000)]
Update Japanese FAQ.
Jun Kuwamura
Bruce Momjian [Wed, 5 Oct 2005 11:24:54 +0000 (11:24 +0000)]
Update FAQ for version number.
Peter Eisentraut [Tue, 4 Oct 2005 19:01:18 +0000 (19:01 +0000)]
Clean up some messages and fix missing translation support. Option --log
renamed to --log-file for clarity.
Teodor Sigaev [Tue, 4 Oct 2005 17:10:55 +0000 (17:10 +0000)]
Fix compile error
Tatsuo Ishii [Tue, 4 Oct 2005 13:46:52 +0000 (13:46 +0000)]
Oops. Partially saved file was committed.
Tatsuo Ishii [Tue, 4 Oct 2005 13:40:45 +0000 (13:40 +0000)]
Allow multiple -f options.
Make pgbench "script driven" to eliminate hard coded transaction
scenario. (Tatsuo Ishii)
Michael Meskes [Tue, 4 Oct 2005 13:28:21 +0000 (13:28 +0000)]
Somehow I missed some parser changes, so this commit comes pretty late. I just synced the parser of ecpg against the backend version, but still have to sync the lexer.
Also I fixed a bug in a bug fix I committed a few weeks ago. he check for a varchar pointer was incomplete.
Peter Eisentraut [Tue, 4 Oct 2005 11:14:03 +0000 (11:14 +0000)]
Add _ to gettext triggers. Must have been forgotten here when it was introduced.
Tom Lane [Tue, 4 Oct 2005 02:50:04 +0000 (02:50 +0000)]
Add an expected case to cover error message as spelled by python 2.2.3.
Per buildfarm results and Michael Fuhr.
Tom Lane [Mon, 3 Oct 2005 23:43:09 +0000 (23:43 +0000)]
COPY's test for read-only transaction was backward; it prohibited COPY TO
where it should prohibit COPY FROM. Found by Alon Goldshuv.
Tom Lane [Mon, 3 Oct 2005 22:55:56 +0000 (22:55 +0000)]
Add a trace_sort option to help with measuring resource usage of external
sort operations. Per recent discussion. Simon Riggs and Tom Lane.
Tom Lane [Mon, 3 Oct 2005 22:52:26 +0000 (22:52 +0000)]
Separate out the VacRUsage stuff as an independent module, in preparation
for using it for other things besides VACUUM.
Tom Lane [Mon, 3 Oct 2005 16:04:13 +0000 (16:04 +0000)]
Fix procedure for updating nextval() defaults so that it actually works.
Update release dates for pending back-branch releases.
Teodor Sigaev [Mon, 3 Oct 2005 14:41:42 +0000 (14:41 +0000)]
Optimize benchmark query and update benchmark's results.
Bruce Momjian [Mon, 3 Oct 2005 13:52:28 +0000 (13:52 +0000)]
Fix font of sequence header.
Bruce Momjian [Mon, 3 Oct 2005 02:49:31 +0000 (02:49 +0000)]
Fix null bytes at end of file (weird).
Bruce Momjian [Mon, 3 Oct 2005 02:46:43 +0000 (02:46 +0000)]
Update sequence docs.
Tom Lane [Mon, 3 Oct 2005 02:45:12 +0000 (02:45 +0000)]
Preserve tuple OIDs during ATRewriteTable. Per gripe from Duncan Crombie.
Bruce Momjian [Mon, 3 Oct 2005 02:21:16 +0000 (02:21 +0000)]
Merge Tom and my descriptions of new sequence behavior into one entry.
Bruce Momjian [Mon, 3 Oct 2005 01:57:59 +0000 (01:57 +0000)]
Update release notes to show how to upgrade a database to use the new
early binding for nextval() calls in default clauses.
Bruce Momjian [Mon, 3 Oct 2005 00:42:57 +0000 (00:42 +0000)]
Remove, 8.1 completed items already removed:
< * -Have sequence dependency track use of DEFAULT sequences
Bruce Momjian [Mon, 3 Oct 2005 00:42:28 +0000 (00:42 +0000)]
Done:
< * Have sequence dependency track use of DEFAULT sequences,
< seqname.nextval?
> * -Have sequence dependency track use of DEFAULT sequences
Tom Lane [Mon, 3 Oct 2005 00:28:43 +0000 (00:28 +0000)]
Expand pg_control information so that we can verify that the database
was created on a machine with alignment rules and floating-point format
similar to the current machine. Per recent discussion, this seems like
a good idea with the increasing prevalence of 32/64 bit environments.
Tom Lane [Sun, 2 Oct 2005 23:50:16 +0000 (23:50 +0000)]
Change nextval and other sequence functions to specify their sequence
argument as a 'regclass' value instead of a text string. The frontend
conversion of text string to pg_class OID is now encapsulated as an
implicitly-invocable coercion from text to regclass. This provides
backwards compatibility to the old behavior when the sequence argument
is explicitly typed as 'text'. When the argument is just an unadorned
literal string, it will be taken as 'regclass', which means that the
stored representation will be an OID. This solves longstanding problems
with renaming sequences that are referenced in default expressions, as
well as new-in-8.1 problems with renaming such sequences' schemas or
moving them to another schema. All per recent discussion.
Along the way, fix some rather serious problems in dbmirror's support
for mirroring sequence operations (int4 vs int8 confusion for instance).
Tom Lane [Sat, 1 Oct 2005 18:43:19 +0000 (18:43 +0000)]
_SPI_execute_plan failed to return result tuple table to caller in
the ProcessUtility case, resulting in an intratransaction memory leak
if a utility command actually did return any tuples, as reported by
Dmitry Karasik. Fix this and also make the behavior more consistent
for cases involving nested SPI operations and multiple query trees,
by ensuring that we store the state locally until it is ready to be
returned to the caller.
Bruce Momjian [Sat, 1 Oct 2005 01:42:43 +0000 (01:42 +0000)]
Adjust wording.
Bruce Momjian [Fri, 30 Sep 2005 22:38:44 +0000 (22:38 +0000)]
One of the web pages mentioned in dmetaphone.c has moved. Also fix
a few typos in comments.
The dictionaries I checked list "altho" as a variant of "although,"
but I didn't find any other instances of the former in the source
tree so I changed it.
Michael Fuhr
Peter Eisentraut [Fri, 30 Sep 2005 09:56:26 +0000 (09:56 +0000)]
Equalize wordings to avoid redundant translation work.
Peter Eisentraut [Fri, 30 Sep 2005 07:58:01 +0000 (07:58 +0000)]
Clean up the help displays.
Peter Eisentraut [Fri, 30 Sep 2005 07:13:54 +0000 (07:13 +0000)]
Change the option spelling to --connection-limit to be consistent with the
SQL option spelling.
Alvaro Herrera [Thu, 29 Sep 2005 22:04:36 +0000 (22:04 +0000)]
Fix confusion between relfilenode and Oid.
Also, make pg_total_relation_size include the size of the
TOAST index.
Tom Lane [Thu, 29 Sep 2005 16:18:26 +0000 (16:18 +0000)]
Fix unportable usages in new pgbench code (strndup, ctype macros)
Tatsuo Ishii [Thu, 29 Sep 2005 13:44:25 +0000 (13:44 +0000)]
Add -f option which enables to read SQL commands from a file.
Patches Contributed by Tomoaki Sato.
Peter Eisentraut [Thu, 29 Sep 2005 08:34:50 +0000 (08:34 +0000)]
Correct spelling
Bruce Momjian [Thu, 29 Sep 2005 02:29:48 +0000 (02:29 +0000)]
Remove acronym in one title.
Tom Lane [Wed, 28 Sep 2005 21:22:12 +0000 (21:22 +0000)]
Mention fix for bug #1916 in release notes for affected versions.
Tom Lane [Wed, 28 Sep 2005 21:17:02 +0000 (21:17 +0000)]
Repair planning bug introduced in 7.4: outer-join ON clauses that referenced
only the inner-side relation would be considered as potential equijoin clauses,
which is wrong because the condition doesn't necessarily hold above the point
of the outer join. Per test case from Kevin Grittner (bug#1916).
Bruce Momjian [Wed, 28 Sep 2005 18:40:28 +0000 (18:40 +0000)]
Fix typo.
Bruce Momjian [Wed, 28 Sep 2005 18:18:02 +0000 (18:18 +0000)]
Add section on reliable operation, talking about caching and storage
subsystem reliability.
Peter Eisentraut [Wed, 28 Sep 2005 13:11:26 +0000 (13:11 +0000)]
Improve messages
Bruce Momjian [Wed, 28 Sep 2005 11:45:52 +0000 (11:45 +0000)]
Update SQL conformance mention to 2003.
Bruce Momjian [Wed, 28 Sep 2005 11:32:49 +0000 (11:32 +0000)]
Update Russian FAQ.
Victor Vislobokov
Bruce Momjian [Tue, 27 Sep 2005 23:32:38 +0000 (23:32 +0000)]
Add attribution.
Bruce Momjian [Tue, 27 Sep 2005 18:04:34 +0000 (18:04 +0000)]
Done:
< * +Add options to pg_config to show the share_dir, sysconfdir,
< pkgincludedir, and localedir
Tom Lane [Tue, 27 Sep 2005 17:43:31 +0000 (17:43 +0000)]
Some marginal tweaks to make 'make installcheck' mostly work when
building contrib with USE_PGXS. To make it work all the way, the
pg_regress script would need to be included in the installation tree.
Tom Lane [Tue, 27 Sep 2005 17:39:35 +0000 (17:39 +0000)]
Fix problems with PGXS builds against an installation tree that was
relocated after installation. We can't trust the installation paths
inserted into Makefile.global by configure, so instead we must get the
paths from pg_config. This requires extending pg_config to support all
the separately-configurable path names, but that was on TODO anyway.
Bruce Momjian [Tue, 27 Sep 2005 17:28:51 +0000 (17:28 +0000)]
Release notes up to date as of today.
Bruce Momjian [Tue, 27 Sep 2005 17:16:08 +0000 (17:16 +0000)]
Suppress FAQ and TODO changes in pgcvslog output.
Tom Lane [Tue, 27 Sep 2005 17:13:14 +0000 (17:13 +0000)]
PGXS should be set with := not =, as specified in the documentation,
to avoid useless multiple executions of pg_config.
Bruce Momjian [Tue, 27 Sep 2005 16:30:25 +0000 (16:30 +0000)]
Fix incorrect psql \x memory allocation for numericlocale. Redesign API
to be less error-prone.
Bruce Momjian [Tue, 27 Sep 2005 15:18:13 +0000 (15:18 +0000)]
Add:
> o Improve signal handling,
> http://archives.postgresql.org/pgsql-patches/2005-06/msg00027.php
Bruce Momjian [Tue, 27 Sep 2005 13:39:32 +0000 (13:39 +0000)]
Novice:
< * Add options to pg_config to show the share_dir, sysconfdir,
> * +Add options to pg_config to show the share_dir, sysconfdir,
Tom Lane [Tue, 27 Sep 2005 04:53:23 +0000 (04:53 +0000)]
Fix our version of strdup() to adhere to the standard semantics for
out-of-memory --- that is, return NULL rather than dumping core.
Noted by Qingqing Zhou.
Tom Lane [Mon, 26 Sep 2005 21:44:04 +0000 (21:44 +0000)]
Create preliminary release notes for upcoming back-branch releases.
Bruce Momjian [Mon, 26 Sep 2005 18:09:57 +0000 (18:09 +0000)]
Rename variable for clarity.
Peter Eisentraut [Mon, 26 Sep 2005 17:49:09 +0000 (17:49 +0000)]
Don't need gettext calls around debug messages.
Bruce Momjian [Mon, 26 Sep 2005 16:48:28 +0000 (16:48 +0000)]
Prevent threaded python build on BSD's, where it fails.
Marko Kreen
Bruce Momjian [Mon, 26 Sep 2005 15:52:35 +0000 (15:52 +0000)]
Done:
< * Allow protocol-level EXECUTE that is actually a fetch to appear
< in the logs as a fetch rather than another execute
Bruce Momjian [Mon, 26 Sep 2005 15:51:12 +0000 (15:51 +0000)]
Log protocol-excute fetch operatation as fetch, rather than execute,
adjusted from a patch by Simon.
Bruce Momjian [Mon, 26 Sep 2005 02:44:28 +0000 (02:44 +0000)]
Add:
> * Allow protocol-level BIND parameter values to be logged
> * Allow protocol-level EXECUTE that is actually a fetch to appear
> in the logs as a fetch rather than another execute
Tom Lane [Sun, 25 Sep 2005 19:37:35 +0000 (19:37 +0000)]
The original patch to avoid building a hash join's hashtable when the
outer relation is empty did not work, per test case from Patrick Welche.
It tried to use nodeHashjoin.c's high-level mechanisms for fetching an
outer-relation tuple, but that code expected the hash table to be filled
already. As patched, the code failed in corner cases such as having no
outer-relation tuples for the first hash batch. Revert and rewrite.
Bruce Momjian [Sun, 25 Sep 2005 03:12:13 +0000 (03:12 +0000)]
Wording cleanup.
Bruce Momjian [Sun, 25 Sep 2005 03:06:41 +0000 (03:06 +0000)]
Document why PQtrace and ecpg debug() can crash the application if the
DLL compiles to not match the application.
Neil Conway [Sat, 24 Sep 2005 23:25:31 +0000 (23:25 +0000)]
Cleanups for recent addition to log_connections documentation.
Bruce Momjian [Sat, 24 Sep 2005 23:08:07 +0000 (23:08 +0000)]
Improve wording.
Tom Lane [Sat, 24 Sep 2005 23:07:18 +0000 (23:07 +0000)]
Clean up possibly-uninitialized-variable warnings reported by gcc 4.x.
Bruce Momjian [Sat, 24 Sep 2005 23:06:24 +0000 (23:06 +0000)]
Add mention of duplicate connection messages from psql, per Andrew.