OSDN Git Service
Neil Conway [Thu, 27 Jan 2005 01:32:00 +0000 (01:32 +0000)]
Add regression tests for recent cursor/savepoint bug fixed by Alvaro and
Tom.
Tom Lane [Wed, 26 Jan 2005 23:20:21 +0000 (23:20 +0000)]
Close all cursors created during a failed subtransaction. This is needed
to avoid problems when a cursor depends on objects created or changed in
the same subtransaction. We'd like to do better someday, but this seems
the only workable answer for 8.0.1.
Tom Lane [Wed, 26 Jan 2005 22:25:13 +0000 (22:25 +0000)]
Adjust Windows autovacuum service to retry for up to 5 minutes waiting
for the postmaster to start. Dave Page
Tom Lane [Wed, 26 Jan 2005 21:55:26 +0000 (21:55 +0000)]
On Windows, set the postmaster executable's stack size to 4MB, so that
it agrees with the default value of max_stack_depth.
Tom Lane [Wed, 26 Jan 2005 21:24:12 +0000 (21:24 +0000)]
Minor tweak to avoid unnecessary memory bloat when dumping extremely wide
column values in -d mode. Per report from Marty Scholes. This doesn't
completely solve the issue, because we still need multiple copies of the
field value, but at least one copy can be got rid of painlessly ...
Tom Lane [Wed, 26 Jan 2005 20:42:19 +0000 (20:42 +0000)]
Add docs for a couple of formerly-undocumented geometric conversion functions.
Tom Lane [Wed, 26 Jan 2005 19:44:43 +0000 (19:44 +0000)]
Make pg_dump and pg_restore handle binary archive formats correctly
when using stdout/stdin on Windows.
Tom Lane [Wed, 26 Jan 2005 19:24:03 +0000 (19:24 +0000)]
Use SHGetFolderPath instead of SHGetSpecialFolderPath to find the
APPDATA directory on Windows. Magnus Hagander
Tom Lane [Wed, 26 Jan 2005 18:49:39 +0000 (18:49 +0000)]
Avoid unnecessary dependence on u_int16_t, per buildfarm failure.
(It doesn't compile on HPUX either...)
Neil Conway [Wed, 26 Jan 2005 08:04:04 +0000 (08:04 +0000)]
The attached patch implements the soundex difference function which
compares two strings' soundex values for similarity, from Kris Jurka.
Also mark the text_soundex() function as STRICT, to avoid crashing
on NULL input.
Tom Lane [Tue, 25 Jan 2005 22:44:31 +0000 (22:44 +0000)]
Fix breakage created by addition of separate 'acl pass' in pg_dump.
Also clean up incredibly poor style in TocIDRequired() usage.
Peter Eisentraut [Tue, 25 Jan 2005 17:32:00 +0000 (17:32 +0000)]
Add missing "ko".
Teodor Sigaev [Tue, 25 Jan 2005 15:24:38 +0000 (15:24 +0000)]
improve support of agglutinative languages (query with compound words).
regression=# select to_tsquery( '\'fotballklubber\'');
to_tsquery
------------------------------------------------
'fotball' & 'klubb' | 'fot' & 'ball' & 'klubb'
(1 row)
So, changed interface to dictionaries, lexize method of dictionary shoud return
pointer to aray of TSLexeme structs instead of char**. Last element should
have TSLexeme->lexeme == NULL.
typedef struct {
/* number of variant of split word , for example
Word 'fotballklubber' (norwegian) has two varian to split:
( fotball, klubb ) and ( fot, ball, klubb ). So, dictionary
should return:
nvariant lexeme
1 fotball
1 klubb
2 fot
2 ball
2 klubb
*/
uint16 nvariant;
/* currently unused */
uint16 flags;
/* C-string */
char *lexeme;
} TSLexeme;
Michael Meskes [Tue, 25 Jan 2005 12:51:31 +0000 (12:51 +0000)]
Fixed segfault due to freeing a struct definition twice if it was a named struct used in a typedef.
Teodor Sigaev [Tue, 25 Jan 2005 12:36:25 +0000 (12:36 +0000)]
Change
typedef struct {} WordEntryPos;
to
typedef uint16 WordEntryPos
according to http://www.pgsql.ru/db/mw/msg.html?mid=
2035188
Require re-fill all tsvector fields and reindex tsvector indexes.
Neil Conway [Tue, 25 Jan 2005 03:22:19 +0000 (03:22 +0000)]
Regression tests for recent bugfix to ALTER TABLE ADD COLUMN: ensure that
constraints on domain types are properly enforced, even if the newly
added column has no default value. Per bug #1433.
Tom Lane [Mon, 24 Jan 2005 23:21:57 +0000 (23:21 +0000)]
Fix ALTER TABLE ADD COLUMN so that constraints of domain types are
enforced properly when there is no explicit default value for the new
column. Per report from Craig Perras.
Tom Lane [Mon, 24 Jan 2005 17:46:16 +0000 (17:46 +0000)]
Disallow LOAD to non-superusers. Per report from John Heasman.
Tom Lane [Mon, 24 Jan 2005 02:47:26 +0000 (02:47 +0000)]
Fix memory leak in rtdosplit, per report from Clive Page.
Neil Conway [Mon, 24 Jan 2005 00:17:33 +0000 (00:17 +0000)]
Fix typo.
Neil Conway [Mon, 24 Jan 2005 00:13:38 +0000 (00:13 +0000)]
pg_autovacuum fixes from Dave Page:
- Dependency services may not be correctly registered when installing as
a Windows Service.
- The sleep time is changed from milliseconds to seconds as it should
be.
- Error messages during service installation/removal are logged to
stderr.
Bruce Momjian [Sun, 23 Jan 2005 15:58:50 +0000 (15:58 +0000)]
Document why CREATE CONSTRAINT TRIGGER doesn't tab complete.
Tom Lane [Sun, 23 Jan 2005 02:21:36 +0000 (02:21 +0000)]
The result of a FULL or RIGHT join can't be assumed to be sorted by the
left input's sorting, because null rows may be inserted at various points.
Per report from Ferenc Lutischá¸n.
Bruce Momjian [Sun, 23 Jan 2005 00:30:59 +0000 (00:30 +0000)]
Add tools/find_gt_lt to find < and > in SGML source.
Lowercase some uppercase tags so tools is more reliable at finding
problems.
Tom Lane [Sun, 23 Jan 2005 00:30:26 +0000 (00:30 +0000)]
pg_dump dumped the wrong tablespace for an index (ie, the parent table's
tablespace instead of the index's own), except when the index was created
as a constraint. Report and fix by Tanida Yutaka.
Tom Lane [Sun, 23 Jan 2005 00:03:54 +0000 (00:03 +0000)]
New routine _getObjectDescription() failed to cope with some aspects of
pre-7.3 pg_dump archive files: namespace isn't there, and in some cases
te->tag may already be quotified. Per report from Alan Pevec and
followup testing.
Bruce Momjian [Sat, 22 Jan 2005 23:39:21 +0000 (23:39 +0000)]
Mention issue with < and > in docs.
Bruce Momjian [Sat, 22 Jan 2005 23:22:19 +0000 (23:22 +0000)]
More < and > changes to ampersands.
8.0.X and HEAD.
Bruce Momjian [Sat, 22 Jan 2005 22:56:36 +0000 (22:56 +0000)]
More < and > cleanups converted to ampersands.
Bruce Momjian [Sat, 22 Jan 2005 22:31:52 +0000 (22:31 +0000)]
More fixes for => and ->, use proper ampersand markups.
Bruce Momjian [Sat, 22 Jan 2005 22:14:14 +0000 (22:14 +0000)]
Update version restriction on xml2.
Bruce Momjian [Sat, 22 Jan 2005 22:06:27 +0000 (22:06 +0000)]
Change -> and <- to use proper ampersand markups.
HEAD and 8.0.X.
Bruce Momjian [Sat, 22 Jan 2005 21:21:34 +0000 (21:21 +0000)]
Fix README /contrib/xml2 reference in 8.0 and HEAD.
Bruce Momjian [Sat, 22 Jan 2005 20:05:23 +0000 (20:05 +0000)]
Update count(*) discussion ideas:
< BY col {DESC} LIMIT 1. Completing this item involves making this
> BY col {DESC} LIMIT 1. Completing this item involves doing this
< invalidated if anyone modifies the table.
<
> invalidated if anyone modifies the table. Another idea is to
> get a count directly from a unique index, but for this to be
> faster than a sequential scan it must avoid access to the heap
> to obtain tuple visibility information.
>
> * Allow data to be pulled directly from indexes
>
> Currently indexes do not have enough tuple tuple visibility
> information to allow data to be pulled from the index without
> also accessing the heap. One way to allow this is to set a bit
> to index tuples to indicate if a tuple is currently visible to
> all transactions when the first valid heap lookup happens. This
> bit would have to be cleared when a heap tuple is expired.
>
Neil Conway [Sat, 22 Jan 2005 05:12:33 +0000 (05:12 +0000)]
This patch updates the regression tests to allow "make installcheck" to
pass if "default_with_oids" is set to false. I took the approach of
explicitly adding WITH OIDS to the CREATE TABLEs where necessary, rather
than tweaking the default_with_oids GUC var.
Neil Conway [Thu, 20 Jan 2005 22:54:57 +0000 (22:54 +0000)]
Trivial fix: remove some stray leading whitespace.
Neil Conway [Wed, 19 Jan 2005 23:45:24 +0000 (23:45 +0000)]
Refactor transformExpr() by creating separate functions for most of the
expression types.
Bruce Momjian [Wed, 19 Jan 2005 19:45:52 +0000 (19:45 +0000)]
Document that Rekall is GPL now.
Bruce Momjian [Wed, 19 Jan 2005 14:17:48 +0000 (14:17 +0000)]
Add:
> * Add 'tid != tid ' operator for use in corruption recovery
Neil Conway [Wed, 19 Jan 2005 04:32:40 +0000 (04:32 +0000)]
Add some basic regression tests for refcursors in PL/PgSQL.
Bruce Momjian [Wed, 19 Jan 2005 03:13:07 +0000 (03:13 +0000)]
Fix typo.
Neil Conway [Tue, 18 Jan 2005 23:25:55 +0000 (23:25 +0000)]
This patch makes some improvements to the rtree index implementation:
(1) Keep a pin on the scan's current buffer and mark buffer. This
avoids the need to do a ReadBuffer() for each tuple produced by the
scan. Since ReadBuffer() is expensive, this is a significant win.
(2) Convert a ReleaseBuffer(); ReadBuffer() pair into
ReleaseAndReadBuffer(). Surely not a huge win, but it saves a lock
acquire/release...
(3) Remove a bunch of duplicated code in rtget.c; make rtnext() handle
both the "initial result" and "subsequent result" cases.
(4) Add support for index tuple killing
(5) Remove rtscancache(): it is dead code, for the same reason that
gistscancache() is dead code (an index scan ought not be invoked with
NoMovementScanDirection).
The end result is about a 10% improvement in rtree index scan perf,
according to contrib/rtree_gist/bench.
Neil Conway [Tue, 18 Jan 2005 22:59:32 +0000 (22:59 +0000)]
Replace the use of "0" with "NULL" where appropriate in dllist.c, for
good style and to satisfy sparse. From Alvaro Herrera.
Bruce Momjian [Tue, 18 Jan 2005 14:39:46 +0000 (14:39 +0000)]
Win32 8.1 stamp.
Bruce Momjian [Tue, 18 Jan 2005 05:23:36 +0000 (05:23 +0000)]
Stamp 8.1 in configure.
Bruce Momjian [Tue, 18 Jan 2005 05:00:35 +0000 (05:00 +0000)]
Update version stamps for 8.1 as listed in RELEASE_CHANGES.
Peter Eisentraut [Mon, 17 Jan 2005 21:21:18 +0000 (21:21 +0000)]
Translation updates
PostgreSQL Daemon [Mon, 17 Jan 2005 20:47:10 +0000 (20:47 +0000)]
its that time ... tag it for release
Peter Eisentraut [Mon, 17 Jan 2005 20:27:44 +0000 (20:27 +0000)]
Translation updates
Tom Lane [Mon, 17 Jan 2005 18:47:15 +0000 (18:47 +0000)]
Clarify that the --enable-integer-datetimes switch affects the time and
interval datatypes as well as timestamp.
Bruce Momjian [Mon, 17 Jan 2005 17:29:49 +0000 (17:29 +0000)]
Please find enclosed another patch that now (I hope) really is
correct. It's in addition to the previous patch.
David Fetter
Peter Eisentraut [Mon, 17 Jan 2005 14:55:34 +0000 (14:55 +0000)]
Translation updates
Peter Eisentraut [Mon, 17 Jan 2005 10:00:06 +0000 (10:00 +0000)]
Translation updates
Peter Eisentraut [Mon, 17 Jan 2005 09:06:31 +0000 (09:06 +0000)]
Fix format string error.
Neil Conway [Mon, 17 Jan 2005 04:30:37 +0000 (04:30 +0000)]
Fix minor thinko in pg_dump documentation of "-n" option.
Bruce Momjian [Mon, 17 Jan 2005 04:27:23 +0000 (04:27 +0000)]
Spelling fix.
Neil Conway [Mon, 17 Jan 2005 03:39:37 +0000 (03:39 +0000)]
This trivial patch adds a regression test for CASE expressions that use
an untyped literal in the CASE's test expression. This adds test
coverage for a bug that was fixed by Tom on January 12.
Peter Eisentraut [Mon, 17 Jan 2005 03:09:08 +0000 (03:09 +0000)]
Translation updates
Peter Eisentraut [Mon, 17 Jan 2005 03:05:37 +0000 (03:05 +0000)]
New translation
Bruce Momjian [Mon, 17 Jan 2005 03:04:17 +0000 (03:04 +0000)]
Please find enclosed a patch to the pl/perl documents that correctly
tells what arguments go to pl/perl triggers.
David Fetter
Bruce Momjian [Mon, 17 Jan 2005 03:02:56 +0000 (03:02 +0000)]
Mention ALTER COLUMN TYPE in FAQ.
Bruce Momjian [Mon, 17 Jan 2005 02:42:31 +0000 (02:42 +0000)]
Update German FAQ.
Ian Barwick
Peter Eisentraut [Mon, 17 Jan 2005 02:41:50 +0000 (02:41 +0000)]
Translation updates
Bruce Momjian [Mon, 17 Jan 2005 02:40:56 +0000 (02:40 +0000)]
Update to 8.0.0 for packaging.
Peter Eisentraut [Mon, 17 Jan 2005 02:29:23 +0000 (02:29 +0000)]
Update supported platforms list.
Tom Lane [Mon, 17 Jan 2005 01:29:02 +0000 (01:29 +0000)]
Some more copy-editing.
Bruce Momjian [Sat, 15 Jan 2005 22:51:10 +0000 (22:51 +0000)]
Remove </a>
Alvaro
Bruce Momjian [Sat, 15 Jan 2005 22:44:18 +0000 (22:44 +0000)]
Update TORA item.
Euler Taveira de Oliveira
Bruce Momjian [Sat, 15 Jan 2005 22:14:08 +0000 (22:14 +0000)]
Update Brazilian FAQ.
Euler Taveira de Oliveira
Tom Lane [Sat, 15 Jan 2005 21:11:46 +0000 (21:11 +0000)]
Some minor editing work on the release notes.
Tom Lane [Sat, 15 Jan 2005 07:53:04 +0000 (07:53 +0000)]
Minor improvements in descriptions of recent changes.
Bruce Momjian [Sat, 15 Jan 2005 05:59:44 +0000 (05:59 +0000)]
Update release notes for 8.0.0 final. Release date set as 2005-01-19!
Tom Lane [Sat, 15 Jan 2005 05:43:06 +0000 (05:43 +0000)]
Adjust warning message about Windows console code page to point to
the right place in the docs, and gettext()ify it.
Bruce Momjian [Sat, 15 Jan 2005 05:19:01 +0000 (05:19 +0000)]
Merge query of system objects FAQ items.
Tom Lane [Sat, 15 Jan 2005 04:15:51 +0000 (04:15 +0000)]
pg_regress now needs to know that Windows hasn't got unix sockets,
per Andrew Dunstan. Also, don't override the user's value of PGHOST
in the 'make installcheck' case. I think the latter was an ill-considered
workaround for the Windows code back when libpq didn't properly default
to localhost on Unix-socket-less platforms.
Tom Lane [Sat, 15 Jan 2005 03:38:44 +0000 (03:38 +0000)]
Simplify trigger example, per Mark Kirkwood.
Kris Jurka [Fri, 14 Jan 2005 21:46:09 +0000 (21:46 +0000)]
Add index entries for function volatilities.
Tom Lane [Fri, 14 Jan 2005 21:08:44 +0000 (21:08 +0000)]
postgres -boot would print the wrong program name in event of a
failure in SelectConfigFiles(). Cosmetic issue, but ...
Tom Lane [Fri, 14 Jan 2005 17:53:33 +0000 (17:53 +0000)]
Update obsolete comment, per Alvaro.
Tom Lane [Fri, 14 Jan 2005 17:47:49 +0000 (17:47 +0000)]
Add missing gettext() calls in find_my_exec(). It's probably too late
to get these strings translated, but we may as well have them be
translatable as not.
Tom Lane [Fri, 14 Jan 2005 16:25:42 +0000 (16:25 +0000)]
plperl trigger handler tried to fetch new/old tuples even when fired
as a statement trigger :-(. Per report from Sokolov Yura.
Peter Eisentraut [Fri, 14 Jan 2005 08:57:06 +0000 (08:57 +0000)]
Translation updates
Tom Lane [Fri, 14 Jan 2005 01:16:52 +0000 (01:16 +0000)]
Incorporate examples and doc patches from Mark Kirkwood and David Fetter.
Bruce Momjian [Fri, 14 Jan 2005 00:25:56 +0000 (00:25 +0000)]
Change Win32 client configuration files from *.txt to *.conf.
Tom Lane [Thu, 13 Jan 2005 23:07:34 +0000 (23:07 +0000)]
Change exec_eval_simple_expr's param list allocation call from
MemoryContextAllocZero back to MemoryContextAlloc, same as it was in 7.4.
The zeroing is unnecessary since all the meaningful fields are filled in
just below. I had made it do that out of neatnik-ism, but some testing
with an example provided by Pavel Stehule showed that the zeroing was
accounting for about 5% of the runtime in a compute-intensive plpgsql
function. That seems a bit high of a price for neatnik-ism...
Peter Eisentraut [Thu, 13 Jan 2005 21:24:40 +0000 (21:24 +0000)]
Translation updates
Peter Eisentraut [Thu, 13 Jan 2005 21:13:33 +0000 (21:13 +0000)]
Update supported platforms list.
Peter Eisentraut [Thu, 13 Jan 2005 19:06:37 +0000 (19:06 +0000)]
Translation updates
Tom Lane [Thu, 13 Jan 2005 18:23:22 +0000 (18:23 +0000)]
Adjust src/tutorial Makefile so that it can use pgxs. This allows the
tutorial to be used without necessarily having a configured source tree.
Tom Lane [Thu, 13 Jan 2005 17:19:10 +0000 (17:19 +0000)]
get_names_for_var didn't do recursion for unnamed JOIN vars quite right;
got it wrong when the JOIN was in an outer query level. Per example from
Laurie Burrow. Also fix same issue in markTargetListOrigin. I think the
latter is only a latent bug since we currently don't apply markTargetListOrigin
except at the outer level ... but should do it right anyway.
Bruce Momjian [Thu, 13 Jan 2005 03:08:14 +0000 (03:08 +0000)]
Update of Japanese FAQ.
Jun Kuwamura
Tom Lane [Thu, 13 Jan 2005 01:40:13 +0000 (01:40 +0000)]
Remove unportable assumption that it's okay to use the target buffer
of an sprintf() as a source string. Demonstrably does not work with
recent gcc and/or glibc on some platforms.
Tom Lane [Wed, 12 Jan 2005 21:37:54 +0000 (21:37 +0000)]
Add conditional inclusion of <com_err.h> to support old 'heimdal'
version of Kerberos. Per report from Reinhard Max.
Tom Lane [Wed, 12 Jan 2005 17:32:36 +0000 (17:32 +0000)]
Re-allow an untyped literal as the test expression of a CASE, ie
CASE 'a' WHEN 'a' THEN 1 ELSE 2 END. This worked in 7.4 and before
but had been broken due to premature freezing of the type of the test
expression. Per gripe from GÄbor SzÃcs.
Tom Lane [Wed, 12 Jan 2005 16:38:17 +0000 (16:38 +0000)]
Increase MAXLISTEN to a more generous value, and add an error message
telling when it has been exceeded. Per trouble report from
Jean-GÅrard Pailloncy.
Tom Lane [Wed, 12 Jan 2005 16:19:51 +0000 (16:19 +0000)]
Ensure that the test postmaster started by 'make check' listens to as
few 'listen_addresses' as possible --- on most systems, none at all,
just the Unix socket. This avoids spurious check failures due to bogus
DNS setups, and is probably a good idea from a security standpoint anyway.
Per trouble report from Jean-GÅrard Pailloncy.
Tom Lane [Tue, 11 Jan 2005 18:33:46 +0000 (18:33 +0000)]
interval_out failed to mention 'ago' for negative intervals in SQL and
GERMAN datestyles. Ancient bug reported by Terry Lee Tucker.
Tom Lane [Tue, 11 Jan 2005 17:55:25 +0000 (17:55 +0000)]
Fix tracking of dump-order dependencies for stand-alone composite types.
Per report from Robert Koepferl.
Teodor Sigaev [Tue, 11 Jan 2005 16:07:55 +0000 (16:07 +0000)]
Fixes:
1 Report error message instead of do nothing in case of error in regex
2 Malloced storage for mask, find and repl part of Affix. This parts may be
large enough in real life (for example in czech, thanks to moje <moje@kalhotky.net>)
Tom Lane [Tue, 11 Jan 2005 06:08:45 +0000 (06:08 +0000)]
plperl was not being quite paranoid enough about detecting 'undef' values
returned by Perl. Per report from Nicolas Addington.