]> granicus.if.org Git - postgresql/log
postgresql
17 years agoSynced parser and keyword list.
Michael Meskes [Wed, 10 Oct 2007 06:33:17 +0000 (06:33 +0000)]
Synced parser and keyword list.

17 years agoAdd mention of full text indexing for word searches.
Bruce Momjian [Tue, 9 Oct 2007 20:13:11 +0000 (20:13 +0000)]
Add mention of full text indexing for word searches.

17 years agoRemove FAQ item about temp tables in plpsql having invalid oid problems,
Bruce Momjian [Tue, 9 Oct 2007 20:08:04 +0000 (20:08 +0000)]
Remove FAQ item about temp tables in plpsql having invalid oid problems,
per suggestions from Pavel Stehule.

17 years agoUpdate sequence FAQ items, per suggestion from Pavel Stehule.
Bruce Momjian [Tue, 9 Oct 2007 19:55:36 +0000 (19:55 +0000)]
Update sequence FAQ items, per suggestion from Pavel Stehule.

17 years agoReplace a reference to "start_log_collector" with "logging_collector",
Neil Conway [Tue, 9 Oct 2007 18:14:01 +0000 (18:14 +0000)]
Replace a reference to "start_log_collector" with "logging_collector",
per Guillaume Lelarge.

17 years agoDon't try to free pgpassfile since it's a stack variable.
Magnus Hagander [Tue, 9 Oct 2007 15:03:27 +0000 (15:03 +0000)]
Don't try to free pgpassfile since it's a stack variable.

Martin Pitt

17 years agoUpdate Brazilian FAQ.
Bruce Momjian [Tue, 9 Oct 2007 03:21:00 +0000 (03:21 +0000)]
Update Brazilian FAQ.

Euler Taveira de Oliveira

17 years agoTypo fix.
Bruce Momjian [Tue, 9 Oct 2007 03:20:09 +0000 (03:20 +0000)]
Typo fix.

Euler Taveira de Oliveira

17 years agoAdd comment.
Bruce Momjian [Tue, 9 Oct 2007 02:56:44 +0000 (02:56 +0000)]
Add comment.

17 years agoAdd:
Bruce Momjian [Tue, 9 Oct 2007 02:31:40 +0000 (02:31 +0000)]
Add:

> * MONEY dumps in a locale-specific format making it difficult to
>   restore to a system with a different locale

17 years agoClarify user of "postmaster" vs. "server" in FAQs.
Bruce Momjian [Tue, 9 Oct 2007 01:28:24 +0000 (01:28 +0000)]
Clarify user of "postmaster" vs. "server" in FAQs.

Brendan Jurd

17 years agoFaster test for overflow in str2txid, from Marko.
Tom Lane [Mon, 8 Oct 2007 22:07:16 +0000 (22:07 +0000)]
Faster test for overflow in str2txid, from Marko.

17 years agoGet rid of dependency on strtoull() --- Marko Kreen.
Tom Lane [Mon, 8 Oct 2007 20:25:40 +0000 (20:25 +0000)]
Get rid of dependency on strtoull()  --- Marko Kreen.
Some additional minor editorializing by Tom.

17 years agoAdd:
Bruce Momjian [Mon, 8 Oct 2007 18:01:17 +0000 (18:01 +0000)]
Add:

>  o Have ALTER SEQUENCE RENAME rename the sequence name stored
>    in the sequence table
>
>    http://archives.postgresql.org/pgsql-bugs/2007-09/msg00092.php
>    http://archives.postgresql.org/pgsql-bugs/2007-10/msg00007.php
>

17 years agoAdded the Skytools extended transaction ID module to contrib as discussed
Jan Wieck [Sun, 7 Oct 2007 23:32:19 +0000 (23:32 +0000)]
Added the Skytools extended transaction ID module to contrib as discussed
on CORE previously.

This module offers transaction ID's containing the original XID and the
transaction epoch as a bigint value to the user level. It also provides
a special txid_snapshot data type that contains an entire transactions
visibility snapshot information, which is useful to determine if a
particular txid was visible to a transaction or not.

The module has been tested by porting Slony-I from using its original
xxid data type.

Jan

17 years agoA few improvements to analyze and vacuum sections in documentation: add "see
Alvaro Herrera [Sun, 7 Oct 2007 01:16:42 +0000 (01:16 +0000)]
A few improvements to analyze and vacuum sections in documentation: add "see
also" entries for autovacuum in analyze and vacuum reference pages, and
enhance usage of cross-references in the maintenance page.

17 years agoChange π to plain "pi" in index entry, to avoid double escaping issues.
Alvaro Herrera [Sun, 7 Oct 2007 01:13:30 +0000 (01:13 +0000)]
Change π to plain "pi" in index entry, to avoid double escaping issues.

17 years agoClean up the doc makefile for draft HTML generation. It no longer works
Alvaro Herrera [Sun, 7 Oct 2007 00:32:11 +0000 (00:32 +0000)]
Clean up the doc makefile for draft HTML generation.  It no longer works
to do "make DRAFT=Y html"; you need to use "make draft" (which was also
supported previously).

17 years agoRemove stylesheet.css file on "make clean", created only on VPATH builds.
Alvaro Herrera [Sun, 7 Oct 2007 00:23:21 +0000 (00:23 +0000)]
Remove stylesheet.css file on "make clean", created only on VPATH builds.

17 years agoFix missing parenthesis, per Guillaume Lelarge.
Alvaro Herrera [Sat, 6 Oct 2007 17:45:49 +0000 (17:45 +0000)]
Fix missing parenthesis, per Guillaume Lelarge.

17 years agoMake dumpcolors() have tolerable performance when using 32-bit chr,
Tom Lane [Sat, 6 Oct 2007 16:18:09 +0000 (16:18 +0000)]
Make dumpcolors() have tolerable performance when using 32-bit chr,
as we do (and upstream Tcl doesn't).  The loop limit might be subject
to negotiation if anyone ever tries to do regex debugging in Far
Eastern languages, but for now 1000 seems plenty.  CHR_MAX was right out :-(

17 years agoAdjust some regex debugging printouts to not give wrong-format-width
Tom Lane [Sat, 6 Oct 2007 16:05:54 +0000 (16:05 +0000)]
Adjust some regex debugging printouts to not give wrong-format-width
warnings on a 64-bit machine.  Noted while chasing a recent regex
bug report.

17 years agoAdjust regcustom.h so that all those assert() calls in the regex package
Tom Lane [Sat, 6 Oct 2007 16:01:51 +0000 (16:01 +0000)]
Adjust regcustom.h so that all those assert() calls in the regex package
are converted to Postgres Assert() macros, instead of using <assert.h>
as formerly.  No difference in production builds, but --enable-cassert
debug builds will get better coverage for regex testing.

17 years agoFix SGML markup, from Guillaume Lelarge.
Alvaro Herrera [Sat, 6 Oct 2007 15:50:43 +0000 (15:50 +0000)]
Fix SGML markup, from Guillaume Lelarge.

17 years agoAdd comment about cvs branch numbers.
Bruce Momjian [Fri, 5 Oct 2007 18:40:52 +0000 (18:40 +0000)]
Add comment about cvs branch numbers.

17 years agoFix plperl and pltcl to include the name of the current function when
Tom Lane [Fri, 5 Oct 2007 17:06:11 +0000 (17:06 +0000)]
Fix plperl and pltcl to include the name of the current function when
passing on errors from the language interpreter.  (plpython seems
fairly OK about this already.)  Per gripe from Robert Kleemann.

17 years agoAdd pgcvslog '-d' capability to allow stripping of commit messages that
Bruce Momjian [Fri, 5 Oct 2007 16:42:32 +0000 (16:42 +0000)]
Add pgcvslog '-d' capability to allow stripping of commit messages that
have back branch activity.  This will be useful for creating release
notes for major releases.

17 years agoRemove some cross-references that don't seem to work in HISTORY
Tom Lane [Fri, 5 Oct 2007 04:03:41 +0000 (04:03 +0000)]
Remove some cross-references that don't seem to work in HISTORY
generation ... we should figure this out later ...

17 years agotag it 8.3beta1 ... the beta cycle begins REL8_3_BETA1
Marc G. Fournier [Fri, 5 Oct 2007 02:55:41 +0000 (02:55 +0000)]
tag it 8.3beta1 ... the beta cycle begins

17 years agoFix distprep and maintainer-clean targets so that ecpg's .def files are
Tom Lane [Fri, 5 Oct 2007 01:51:40 +0000 (01:51 +0000)]
Fix distprep and maintainer-clean targets so that ecpg's .def files are
made and removed at the correct times.

17 years agoAdd .cvsignore files to suppress CVS gripes about ecpg .def files.
Tom Lane [Fri, 5 Oct 2007 01:35:55 +0000 (01:35 +0000)]
Add .cvsignore files to suppress CVS gripes about ecpg .def files.

17 years agoSome desultory markup improvements in the new release notes.
Tom Lane [Thu, 4 Oct 2007 22:55:49 +0000 (22:55 +0000)]
Some desultory markup improvements in the new release notes.

17 years agoResults from buildfarm show that ecpglib was depending on pg_strcasecmp,
Tom Lane [Thu, 4 Oct 2007 20:54:08 +0000 (20:54 +0000)]
Results from buildfarm show that ecpglib was depending on pg_strcasecmp,
which evidently it got as an unofficial export from pgtypeslib.

17 years agoKeep the planner from failing on "WHERE false AND something IN (SELECT ...)".
Tom Lane [Thu, 4 Oct 2007 20:44:47 +0000 (20:44 +0000)]
Keep the planner from failing on "WHERE false AND something IN (SELECT ...)".
eval_const_expressions simplifies this to just "WHERE false", but we have
already done pull_up_IN_clauses so the IN join will be done, or at least
planned, anyway.  The trouble case comes when the sub-SELECT is itself a join
and we decide to implement the IN by unique-ifying the sub-SELECT outputs:
with no remaining reference to the output Vars in WHERE, we won't have
propagated the Vars up to the upper join point, leading to "variable not found
in subplan target lists" error.  Fix by adding an extra scan of in_info_list
and forcing all Vars mentioned therein to be propagated up to the IN join
point.  Per bug report from Miroslav Sulc.

17 years agoStamp 8.3beta1, except in configure.in/configure.
Tom Lane [Thu, 4 Oct 2007 19:12:04 +0000 (19:12 +0000)]
Stamp 8.3beta1, except in configure.in/configure.

17 years agoUpdate timezone data files to release 2007h of the zic database.
Tom Lane [Thu, 4 Oct 2007 19:06:59 +0000 (19:06 +0000)]
Update timezone data files to release 2007h of the zic database.
Might as well have the latest when we wrap 8.3beta1.

17 years agoDLL_DEFFILE should be defined when PORTNAME is win32, not when it isn't,
Tom Lane [Thu, 4 Oct 2007 18:32:07 +0000 (18:32 +0000)]
DLL_DEFFILE should be defined when PORTNAME is win32, not when it isn't,
per the example of libpq/Makefile.

17 years agoReplaced tabs by white spaces
Michael Meskes [Thu, 4 Oct 2007 17:49:31 +0000 (17:49 +0000)]
Replaced tabs by white spaces

17 years agoRemoved newline at end of exports files.
Michael Meskes [Thu, 4 Oct 2007 16:29:33 +0000 (16:29 +0000)]
Removed newline at end of exports files.

17 years agoChange Assert() to a plain test and elog, just to see if that works
Tom Lane [Thu, 4 Oct 2007 15:37:44 +0000 (15:37 +0000)]
Change Assert() to a plain test and elog, just to see if that works
around the icc bug exhibited by buildfarm member dugong.

17 years agoAdded def-files to all: target so they are build everytime.
Michael Meskes [Thu, 4 Oct 2007 07:58:15 +0000 (07:58 +0000)]
Added def-files to all: target so they are build everytime.

17 years agoTwo fixes for the release notes from Guillaume Smet. In passing, make
Neil Conway [Thu, 4 Oct 2007 07:53:07 +0000 (07:53 +0000)]
Two fixes for the release notes from Guillaume Smet. In passing, make
a minor markup improvement.

17 years agoFirst pass at SGML-ifying the 8.3 release notes. Plenty of improvements
Neil Conway [Thu, 4 Oct 2007 03:53:58 +0000 (03:53 +0000)]
First pass at SGML-ifying the 8.3 release notes. Plenty of improvements
left to made, but this is a start.

17 years agoSecond pass at 8.3 release notes: put items in a bit more logical order
Tom Lane [Wed, 3 Oct 2007 23:02:16 +0000 (23:02 +0000)]
Second pass at 8.3 release notes: put items in a bit more logical order
where possible, add overview and incompatibilities lists, minor cleanups.
The SGML-ification still leaves much to be desired.

17 years agoVarious minor improvements to the 8.3 release notes.
Neil Conway [Wed, 3 Oct 2007 22:06:13 +0000 (22:06 +0000)]
Various minor improvements to the 8.3 release notes.

17 years agoTeach chklocale.c how to extract encoding info from Windows locale
Tom Lane [Wed, 3 Oct 2007 17:16:39 +0000 (17:16 +0000)]
Teach chklocale.c how to extract encoding info from Windows locale
names.  ITAGAKI Takahiro

17 years agoSome editorial improvements for recently-added ALTER SEQUENCE/VIEW
Tom Lane [Wed, 3 Oct 2007 16:48:43 +0000 (16:48 +0000)]
Some editorial improvements for recently-added ALTER SEQUENCE/VIEW
documentation.  Heikki and Tom

17 years agoSuppress compiler warning in non-threaded build.
Tom Lane [Wed, 3 Oct 2007 16:03:25 +0000 (16:03 +0000)]
Suppress compiler warning in non-threaded build.

17 years agoTweak recently-added tests to suppress scary-looking warnings on 64-bit
Tom Lane [Wed, 3 Oct 2007 15:59:13 +0000 (15:59 +0000)]
Tweak recently-added tests to suppress scary-looking warnings on 64-bit
machines about casts between pointers and integers of different sizes.
While they're harmless, we shouldn't expect users to have to go through
and figure that out for themselves.

17 years agoArgh, missing dll in filename
Michael Meskes [Wed, 3 Oct 2007 15:24:19 +0000 (15:24 +0000)]
Argh, missing dll in filename

17 years agoMinor improvements to hack for old OpenSSL libraries: avoid unused
Tom Lane [Wed, 3 Oct 2007 15:12:45 +0000 (15:12 +0000)]
Minor improvements to hack for old OpenSSL libraries: avoid unused
variable warning on Windows, improve comment.

17 years agoFix command for fetching snprintf.c.
Tom Lane [Wed, 3 Oct 2007 15:04:23 +0000 (15:04 +0000)]
Fix command for fetching snprintf.c.

17 years agoThis could be what's missing on some systems.
Michael Meskes [Wed, 3 Oct 2007 14:42:16 +0000 (14:42 +0000)]
This could be what's missing on some systems.

17 years agoStripped two symbols that are needed.
Michael Meskes [Wed, 3 Oct 2007 14:01:28 +0000 (14:01 +0000)]
Stripped two symbols that are needed.

17 years agoAttempt to open certificate file "manually" using fopen before
Magnus Hagander [Wed, 3 Oct 2007 13:57:52 +0000 (13:57 +0000)]
Attempt to open certificate file "manually" using fopen before
trying BIO functions.
Helps problem with older versions of OpenSSL that lacks error
stack functions and would show an incorrect error message for
file-not-found-or-not-openable. The problem may still exist for
other errors, but file open error is by far the most common one.

17 years agoBuild two more .DEF files for ecpg instead of using default ones.
Magnus Hagander [Wed, 3 Oct 2007 13:43:24 +0000 (13:43 +0000)]
Build two more .DEF files for ecpg instead of using default ones.

17 years agoAlso build snprintf from pgport if needed.
Michael Meskes [Wed, 3 Oct 2007 13:40:52 +0000 (13:40 +0000)]
Also build snprintf from pgport if needed.

17 years agoRemove exports.list in clean target.
Michael Meskes [Wed, 3 Oct 2007 13:24:54 +0000 (13:24 +0000)]
Remove exports.list in clean target.

17 years agoMore detailed error msg (with stack trace) if a file copy fails.
Magnus Hagander [Wed, 3 Oct 2007 13:20:40 +0000 (13:20 +0000)]
More detailed error msg (with stack trace) if a file copy fails.

17 years agoAlso created export list for pgytpeslib and compatlib.
Michael Meskes [Wed, 3 Oct 2007 13:20:19 +0000 (13:20 +0000)]
Also created export list for pgytpeslib and compatlib.
Set pgtypes library version to 3.0.
Set compat library version to 3.0.

17 years agoUse snprintf from libpgport in ecpg compatlib. Required since
Magnus Hagander [Wed, 3 Oct 2007 12:34:29 +0000 (12:34 +0000)]
Use snprintf from libpgport in ecpg compatlib. Required since
we restricted exports from ecpglib.

17 years agoFix commandlines for final two ECPG regression tests
Magnus Hagander [Wed, 3 Oct 2007 12:31:18 +0000 (12:31 +0000)]
Fix commandlines for final two ECPG regression tests

17 years agoFix typo
Magnus Hagander [Wed, 3 Oct 2007 12:11:37 +0000 (12:11 +0000)]
Fix typo

17 years agoBuild DEF file for libecpg instead of generating a default one.
Magnus Hagander [Wed, 3 Oct 2007 12:11:00 +0000 (12:11 +0000)]
Build DEF file for libecpg instead of generating a default one.

17 years agoMake ECPG regression tests run with -c only for array_of_struct.pgc
Magnus Hagander [Wed, 3 Oct 2007 11:57:36 +0000 (11:57 +0000)]
Make ECPG regression tests run with -c only for array_of_struct.pgc
on MSVC.

Fix strange nonstandard version of __stdcall specifyer in thread
tests on win32.

17 years agoFix typo
Magnus Hagander [Wed, 3 Oct 2007 11:34:11 +0000 (11:34 +0000)]
Fix typo

17 years agoCleaned up ecpglib and renamed functions that do not need to be exported.
Michael Meskes [Wed, 3 Oct 2007 11:11:12 +0000 (11:11 +0000)]
Cleaned up ecpglib and renamed functions that do not need to be exported.
Created export list for ecpglib.

17 years agoHopefully fixed some stuff that causes Windows builds to fail.
Michael Meskes [Wed, 3 Oct 2007 08:55:23 +0000 (08:55 +0000)]
Hopefully fixed some stuff that causes Windows builds to fail.

17 years agoFirst cut at 8.3 release notes. SGML markup is nonexistent, and
Tom Lane [Wed, 3 Oct 2007 03:32:31 +0000 (03:32 +0000)]
First cut at 8.3 release notes.  SGML markup is nonexistent, and
the 'overview' and 'incompatibilities' summary lists remain to be
written.  But I think all the raw info is there (indeed maybe too
verbose).

17 years agoFix a compiler warning on Win32. Hannes Eder.
Neil Conway [Tue, 2 Oct 2007 22:01:02 +0000 (22:01 +0000)]
Fix a compiler warning on Win32. Hannes Eder.

17 years agoDefault to thread safety on, and support more CPU options. Also
Magnus Hagander [Tue, 2 Oct 2007 19:01:45 +0000 (19:01 +0000)]
Default to thread safety on, and support more CPU options. Also
make sure that a CPU option is actually chosen.

Hiroshi Saito

17 years agoMade new test also work without threading enabled.
Michael Meskes [Tue, 2 Oct 2007 14:01:57 +0000 (14:01 +0000)]
Made new test also work without threading enabled.

17 years agoNo idea where this file came from.
Michael Meskes [Tue, 2 Oct 2007 09:51:41 +0000 (09:51 +0000)]
No idea where this file came from.

17 years agoITAGAKI Takahiro <itagaki.takahiro@oss.ntt.co.jp> added thread-safe
Michael Meskes [Tue, 2 Oct 2007 09:50:00 +0000 (09:50 +0000)]
ITAGAKI Takahiro <itagaki.takahiro@oss.ntt.co.jp> added thread-safe
descriptor handling

17 years agoCope with ERR_set_mark() and ERR_pop_to_mark() not existing in older
Tom Lane [Tue, 2 Oct 2007 00:25:20 +0000 (00:25 +0000)]
Cope with ERR_set_mark() and ERR_pop_to_mark() not existing in older
OpenSSL libraries --- just don't call them if they're not there.  This
might possibly lead to misleading error messages, but we'll just have
to live with that.

17 years agoAdd catalogs.sgml documentation for text search catalogs.
Tom Lane [Mon, 1 Oct 2007 21:10:40 +0000 (21:10 +0000)]
Add catalogs.sgml documentation for text search catalogs.

17 years agoUse BIO functions to avoid passing FILE * pointers to OpenSSL functions.
Magnus Hagander [Mon, 1 Oct 2007 20:30:06 +0000 (20:30 +0000)]
Use BIO functions to avoid passing FILE * pointers to OpenSSL functions.
This fixes potential crashes on old versions of OpenSSL and the requirement on
"Applink" in new versions when building with MSVC and using different
runtimes.

Dave Page with fixes from me.

17 years agoAdd some examples.
D'Arcy J.M. Cain [Mon, 1 Oct 2007 19:06:48 +0000 (19:06 +0000)]
Add some examples.

17 years agoAdd note warning against use of pre-8.4 multithreaded Tcl.
Tom Lane [Mon, 1 Oct 2007 16:43:28 +0000 (16:43 +0000)]
Add note warning against use of pre-8.4 multithreaded Tcl.

17 years agoAvoid assuming that struct varattrib_pointer doesn't get padded by the
Tom Lane [Mon, 1 Oct 2007 16:25:56 +0000 (16:25 +0000)]
Avoid assuming that struct varattrib_pointer doesn't get padded by the
compiler --- at least on ARM, it does.  I suspect that the varvarlena patch
has been creating larger-than-intended toast pointers all along on ARM,
but it wasn't exposed until the latest tweak added some Asserts that
calculated the expected size in a different way.  We could probably have
fixed this by adding __attribute__((packed)) as is done for ItemPointerData,
but struct varattrib_pointer isn't really all that useful anyway, so it
seems cleanest to just get rid of it and have only struct varattrib_1b_e.
Per results from buildfarm member quagga.

17 years agoBuild with /GS on 64-bit to work with modern Platform SDK.
Magnus Hagander [Mon, 1 Oct 2007 14:32:02 +0000 (14:32 +0000)]
Build with /GS on 64-bit to work with modern Platform SDK.

Hiroshi Saito

17 years agoUpdate pgcvslog text to simply "<branch>"
Bruce Momjian [Mon, 1 Oct 2007 13:04:55 +0000 (13:04 +0000)]
Update pgcvslog text to simply "<branch>"

17 years agoEnable __FUNCTION__ on MSVC builds.
Magnus Hagander [Mon, 1 Oct 2007 10:54:29 +0000 (10:54 +0000)]
Enable __FUNCTION__ on MSVC builds.

Hannes Eder

17 years agoFix a minor typo.
D'Arcy J.M. Cain [Mon, 1 Oct 2007 06:52:42 +0000 (06:52 +0000)]
Fix a minor typo.

17 years agoFixup for new pgcvslog feature.
Bruce Momjian [Mon, 1 Oct 2007 03:01:38 +0000 (03:01 +0000)]
Fixup for new pgcvslog feature.

17 years agoHave pgcvslog mark back-branch commits with "<back-patch>".
Bruce Momjian [Mon, 1 Oct 2007 02:59:03 +0000 (02:59 +0000)]
Have pgcvslog mark back-branch commits with "<back-patch>".

17 years agoAdd an extra header byte to TOAST-pointer datums to represent their size
Tom Lane [Sun, 30 Sep 2007 19:54:58 +0000 (19:54 +0000)]
Add an extra header byte to TOAST-pointer datums to represent their size
explicitly.  This means a TOAST pointer takes 18 bytes instead of 17 --- still
smaller than in 8.2 --- which seems a good tradeoff to ensure we won't have
painted ourselves into a corner if we want to support multiple types of TOAST
pointer later on.  Per discussion with Greg Stark.

17 years agoIn hopes of un-breaking the buildfarm, add missing file from
Tom Lane [Sun, 30 Sep 2007 17:50:56 +0000 (17:50 +0000)]
In hopes of un-breaking the buildfarm, add missing file from
ITAGAKI Takahiro's patch.

17 years agoAdjust recovery PS display as agreed with Simon: 'waiting for XXX'
Tom Lane [Sun, 30 Sep 2007 17:28:56 +0000 (17:28 +0000)]
Adjust recovery PS display as agreed with Simon: 'waiting for XXX'
while the restore_command does its thing, then 'recovering XXX' while
processing the segment file.  These operations are heavyweight enough
that an extra PS display set shouldn't bother anyone.

17 years agoProperly mark mergeable/hashable equality operators (found by opr_sanity
Tom Lane [Sun, 30 Sep 2007 17:13:19 +0000 (17:13 +0000)]
Properly mark mergeable/hashable equality operators (found by opr_sanity
testing).  Combine the formerly independent opclasses for the various
ISN types into opfamilies.  The latter causes some extra bleating from
opr_sanity, since the module doesn't provide complete sets of cross-type
operators, but it's still a good idea because it will give the planner
more information to work with.  The missing cross-type operators no longer
pose a risk of unexpected planner errors in 8.3, so there's no need to
insist on filling them in (and I gather it wouldn't be very sound
semantically to add them all).

17 years agoSupport functions for index opclasses should be immutable.
Tom Lane [Sun, 30 Sep 2007 15:52:06 +0000 (15:52 +0000)]
Support functions for index opclasses should be immutable.
Found by running opr_sanity on contrib modules.

17 years agoApplied another patch by ITAGAKI Takahiro <itagaki.takahiro@oss.ntt.co.jp>
Michael Meskes [Sun, 30 Sep 2007 11:38:48 +0000 (11:38 +0000)]
Applied another patch by ITAGAKI Takahiro <itagaki.takahiro@oss.ntt.co.jp>
to get memory allocation thread-safe. He also did some cleaning up.

17 years agoSupport functions for index opclasses should be immutable.
Tom Lane [Sun, 30 Sep 2007 00:03:47 +0000 (00:03 +0000)]
Support functions for index opclasses should be immutable.
Found by running opr_sanity on contrib modules.

17 years agoSupport functions for index opclasses should be immutable.
Tom Lane [Sat, 29 Sep 2007 23:48:22 +0000 (23:48 +0000)]
Support functions for index opclasses should be immutable.
Found by running opr_sanity on contrib modules.

17 years agoSupport functions for index opclasses should be immutable.
Tom Lane [Sat, 29 Sep 2007 23:43:18 +0000 (23:43 +0000)]
Support functions for index opclasses should be immutable.
Found by running opr_sanity on contrib modules.

17 years agoSupport functions for index opclasses should be immutable.
Tom Lane [Sat, 29 Sep 2007 23:38:17 +0000 (23:38 +0000)]
Support functions for index opclasses should be immutable.
Found by running opr_sanity on contrib modules.

17 years agoRemove bogus commutator marking --- the module doesn't actually supply
Tom Lane [Sat, 29 Sep 2007 23:32:42 +0000 (23:32 +0000)]
Remove bogus commutator marking --- the module doesn't actually supply
any commutator operator for =(chkpass,text), so this was creating a
shell operator that would fail on use.  Found by opr_sanity testing.

17 years agoSupport functions for index opclasses should be immutable.
Tom Lane [Sat, 29 Sep 2007 23:24:39 +0000 (23:24 +0000)]
Support functions for index opclasses should be immutable.
Found by running opr_sanity on contrib modules.

17 years agoMake recovery show the current input WAL segment name in the startup
Tom Lane [Sat, 29 Sep 2007 18:32:56 +0000 (18:32 +0000)]
Make recovery show the current input WAL segment name in the startup
process' PS display.  After a suggestion by Simon (not exactly his
patch though).

17 years agoDisallow CLUSTER using an invalid index (that is, one left over from a failed
Tom Lane [Sat, 29 Sep 2007 18:05:20 +0000 (18:05 +0000)]
Disallow CLUSTER using an invalid index (that is, one left over from a failed
CREATE INDEX CONCURRENTLY).  Such an index might not have entries for every
heap row and thus clustering with it would result in silent data loss.
The scenario requires a pretty foolish DBA, but still ...